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.

  • Answer Accepted: Yes
  • Question Category:
SHARE
Best Answer by Johnstoon Leen
Go To Solution
Answered By 15 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.

About Debra labito
Questions
1
Answers
199
Best Answers
51
  • Posted on -
  • Question Category:
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.

About Molina Kevin
Questions
3
Answers
55
Best Answers
25
  • Posted on -
  • Question Category:
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
About Johnstoon Leen
Questions
4
Answers
102
Best Answers
64
  • Posted on -
  • Question Category:

I have problem installing Quicken 2012

Previous

How to access win 2000 file from win 98

Next

Related Questions