根据今天的日子从数据库 mysql 中获取数据？.php

Question

数据库条目

In Database Row Day = {Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday}

PHP代码

$today = date('l');
$result = mysql_query("SELECT * FROM alert WHERE Day = '$today' ");

我想知道如何根据今天的日期从MySQL数据库中获取数据?

Answer 1

try this

$result = mysql_query("SELECT * FROM alert WHERE  FORMAT(Now(),'YYYY-MM-DD') AS PerDate =  FORMAT(your_col,'YYYY-MM-DD') ");  

Answer 2

try

mysql_query("SELECT * FROM alert WHERE Day = DAYNAME('2008-05-15')"); 

查看更多信息http://www.w3resource.com/mysql/date-and-time-functions/mysql-dayname-function.php

Answer 3

试试这个-

<?php

$jd=cal_to_jd(CAL_GREGORIAN,date("m"),date("d"),date("Y"));
$today=jddayofweek($jd,1);
$result = mysql_query("SELECT * FROM alert WHERE Day = '$today' ");
?>

Answer 4

Try

<?php
$today = date('l'); // get day of week today;(its 'L' in lowercase)
$result = mysql_query("SELECT * FROM alert WHERE Day = '{$today}' ");
?>