MySQL Date search in PHP?

Asked By 10 points N/A Posted on -
qa-featured

Mysql Date search in PHP how i can do this. Any help appreciated.

SHARE
Best Answer by Johnstoon Leen
Answered By 0 points N/A #97574

MySQL Date search in PHP?

qa-featured

MySQL is one of the better systems for pc web. This helps to settle PHP on a site. You tried to make date search in PHP. That means many things. However, I think you meant to find and change the date in PHP. Try this link to know more:

Without that article, you may also find these links more useful:

Thanks.

Answered By 0 points N/A #197416

MySQL Date search in PHP?

qa-featured

Hi. 

MySQL is widely use in programming or managing of database, where in you create tables where you can put different kinds of information.

There are many ways on how you can search for Date in PHP MySQL you can try this link http://www.sql-server-performance.com/2002/date-time-search/ You can also learn how to search for time.

Best Answer
Best Answer
Answered By 0 points N/A #197418

MySQL Date search in PHP?

qa-featured

Hi Adilakhlaq

You can do this in many ways depending upon which method is you like the most

Method 1
  1. When you want to search a date through PHP in MySQL
  2. Follow this way e.g, $date = mysql_query (“select * from your_table where start like ‘”.date (“y.m.d”).”%’”);
  3. The % sign I used after your date and be sure that there should be something in your database after your MySQL date
Still if you don’t find your way then go to Method 2
Method 2
  1. Another way to search your MySQL date through PHP
  2. $date = mysql_query (“select * from your_table where DATE_FORMAT (‘start’, ‘%y-%m-%d’) = ‘”.date (“y-m-d”).”’”);
Try both methods it’ll surely helps you a lot.
 
Regard's
 
Johnstoon Leen

Login/Register to Answer

Related Questions