PHP回显问题

Question

$today = date('D, d M, Y');
$sql = "SELECT * FROM programs 
        WHERE day1 = '$today' OR day2 = '$today' OR day3 = '$today' OR day4 = '$today' 
        OR day5 = '$today' OR day6 = '$today' OR day7 = '$today' OR day8 = '$today' 
        OR day9 = '$today' OR day10 = '$today'";
if($_POST != "") {
  $mydate = mysql_real_escape_string($_POST['datepicker']);
  if($mydate != "") {   
     $sql = "SELECT * FROM programs 
         WHERE day1 = '$mydate' OR day2 = '$mydate' OR day3 = '$mydate' OR day4 = '$mydate' 
           OR day5 = '$mydate' OR day6 = '$mydate' OR day7 = '$mydate' OR day8 = '$mydate' 
           OR day9 = '$mydate' OR day10 = '$mydate'";
  }
}

$mydate与日历结合在一起...

我怎么回显日期？

Answer 1

如果你使用双引号，你的$mydate会被php自动转换:你只是在查询的末尾漏掉了一个双引号：

$sql = "SELECT * FROM programs WHERE day1 = '$mydate' OR day2 = '$mydate' OR day3 = '$mydate' OR day4 = '$mydate' OR day5 = '$mydate' OR day6 = '$mydate' OR day7 = '$mydate' OR day8 = '$mydate' OR day9 = '$mydate' OR day10 = '$mydate'";//Missing double quotes

Answer 2

你忘记了“在sql查询中。

$today = date('D, d M, Y');
$sql = "SELECT * FROM programs WHERE day1 = '$today' OR day2 = '$today' OR day3 = '$today' OR day4 = '$today' OR day5 = '$today' OR day6 = '$today' OR day7 = '$today' OR day8 = '$today' OR day9 = '$today' OR day10 = '$today'";

if($_POST!=""){
$mydate = mysql_real_escape_string($_POST['datepicker']);
    if($mydate!=""){    
    $sql = "SELECT * FROM programs WHERE day1 = '$mydate' OR day2 = '$mydate' OR day3 = '$mydate' OR day4 = '$mydate' OR day5 = '$mydate' OR day6 = '$mydate' OR day7 = '$mydate' OR day8 = '$mydate' OR day9 = '$mydate' OR day10 = '$mydate'";
}
}

Answer 3

您忘记使用双引号，应该是这样的$sql = "SELECT * FROM programs WHERE day1 = '$mydate' OR day2 = '$mydate' OR day3 = '$mydate' OR day4 = '$mydate' OR day5 = '$mydate' OR day6 = '$mydate' OR day7 = '$mydate' OR day8 = '$mydate' OR day9 = '$mydate' OR day10 = '$mydate'";