Getting records from range of dates from MYSQL - PHP

Question

I have a MYSQL table below and I am trying to retrieve the number of records between specific dates.

I am getting the following error:

'Trying to get property 'num_rows' of non-object in /var/www/html/dev/timeTest.php on line 18'

date column of MySQL table:

PHP:

 $date1 = '2018-07-01';
 $date2 = '2018-07-30';

 $sql = "SELECT * FROM scanUploads WHERE dateUpload BETWEEN {$date1} AND {$date2}";
 $result = $mysqli -> query($sql);
 $count = $result -> num_rows; // LINE 18
 echo 'records: '.$count;

use $date1 = '2018-07-01 00:00:00'; $date1 = '2018-07-30 23:59:59'; — Devsi Odedra
– Devsi Odedra, Commented Jul 30, 2018 at 9:54
@DevsiI, am not sure that I have the correct SQL syntax? I have tried add '00:00:00' to the search dates but the error message is the same. — johnDoe
– johnDoe, Commented Jul 30, 2018 at 9:58
Is it allowed to put spaces after you want an object class? $result -> num_rows; should it be this? $result->num_rows; — Gobbin
– Gobbin, Commented Jul 30, 2018 at 10:10
you code is unsecure, try php.net/manual/en/pdostatement.rowcount.php — kallosz
– kallosz, Commented Jul 30, 2018 at 10:15

Martin Zeitler · Accepted Answer · 2018-07-30 10:27:35Z

2

you are lacking quotation marks, which breaks the syntax.

and also the curly brackets appear rather strange to me.

there's two ways how one can formulate it, either delimiting the query-string with ' or with ":

$sql = 'SELECT * FROM scanUploads WHERE dateUpload BETWEEN "'.$date1.'" AND "'.$date2.'"';
$sql = "SELECT * FROM scanUploads WHERE dateUpload BETWEEN \"$date1\" AND \"$date2\"";

// whenever wondering about the validity of generated SQL:
// die($sql);

// and whenever wondering about the result-set returned:
// die(print_r($result, true));

escaped double-quotes \" will always be treated literally, but only within " " double-quotes.

edited Jul 30, 2018 at 10:27

answered Jul 30, 2018 at 10:04

Martin Zeitler

79.6k20 gold badges169 silver badges243 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kishan · Accepted Answer · 2018-07-30 10:02:20Z

2

$date1 = '2018-07-01';
 $date1 = '2018-07-30';

 $sql = "SELECT * FROM scanUploads WHERE 
DATE_FORMAT(dateUpload,'%Y-%m-%d') >= '".$date1."' AND DATE_FORMAT(dateUpload,'%Y-%m-%d') <= '".$date2."' ";
 $result = $mysqli -> query($sql);
 $count = $result -> num_rows; // LINE 18
 echo 'records: '.$count;

answered Jul 30, 2018 at 10:02

Kishan

7934 silver badges10 bronze badges

Collectives™ on Stack Overflow

Getting records from range of dates from MYSQL - PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related