PHP回声问题 - PHP echo problem

PHP echo problem

本文关键字：问题回声 PHP | 更新日期: 2023-09-27

$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与日历结合在一起。。。。

我如何php回显日期？

如果您使用双引号，您的$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

You forget"在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'";
}
}

如果忘记使用双引号，它应该像这个$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'";