PHP Explode using inside of database

Question

In my database the date is like this 24 june 2016, 09:17. And there are many data in my db. I am gonna use this code in my web site.

$query = mysql_query("SELECT * FROM siparisler where tarih='$nwdate' ");

echo $numrows = mysql_num_rows($query);

I am checking today's date. But only date not time. However my database has time and date. I want this; If the date of today same with my any dates in my db, show me how many data in my db. For example my new data is like this 3 june 2016 but in my db like this 3 june 2016, 09:17. How can it work.

I want something like this

$query = mysql_query("SELECT * FROM siparisler where explode(",", date[0])='$nwdate' ");

try using `CURDATE()` native mysql function to get today's data like this : `mysql_query("SELECT * FROM siparisler where date=CURDATE() ")` — Afsar, Aug 03 '16 at 07:49
`$t2 = date($t);` is absolute nonsense. What's that supposed to do? — deceze, Aug 03 '16 at 07:59
What type is your `date` column in your database? `DATETIME`? `VARCHAR`? — deceze, Aug 03 '16 at 08:04

von Oak · Answer 1 · 2016-08-03T07:57:02.137

0

You have to add the comma to the date format and then use only first part of exploded array, so part of code is:

$t    =   date("Y-m-d, H:i:s");

$nwdate   = explode(",", $t)[0];

Moreover you don't need this row, is useless. Delete it and use only variable $t.

$t2   =   date($t);

edited Aug 03 '16 at 07:57

answered Aug 03 '16 at 07:45

von Oak

823
5
14

Or, you know… just do `date('Y-m-d')` to begin with...!? – deceze Aug 03 '16 at 08:00
Yes, exactly. This is the most straightforward solution. – von Oak Aug 03 '16 at 08:01
Ok I will change my db. Normally date and time together. And I need those together. I am gonna change. It will not together. Thanks for helping. – Sinan Sarıkaya Aug 03 '16 at 09:29

score 0 · Answer 2 · answered Aug 03 '16 at 08:05

0

You have to use $t = date("Y-m-d");

answered Aug 03 '16 at 08:05

PHP Explode using inside of database

2 Answers2