MySQL Date search in PHP?

Asked By adilakhlaq 10 points N/A Posted on - 11/03/2011

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

• Status: Open
• Question Views: 1352
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: PHP

Best Answer by Johnstoon Leen

Go To Solution

Answered By Debra labito 15 points N/A #97574

MySQL Date search in PHP?

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:

• http://www.richardlord.net/blog/php/dates-in-php-and-mysql.html

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

• https://stackoverflow.com/questions/4458503/php-mysql-date-search
• http://www.daniweb.com/web-development/php/threads/107737

Thanks.

About Debra labito

Questions
1

Answers
199

Best Answers
51

• Vote Up 0 Vote Down

• Posted on - 09/25/2012
• Question Category: PHP

Answered By Molina Kevin 0 points N/A #197416

MySQL Date search in PHP?

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.

About Molina Kevin

Questions
3

Answers
55

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 01/17/2013
• Question Category: PHP

Best Answer

Best Answer

Answered By Johnstoon Leen 0 points N/A #197418

MySQL Date search in PHP?

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

About Johnstoon Leen

Questions
4

Answers
102

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 01/18/2013
• Question Category: PHP