PHP echo problem

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 is incorporated with a calendar....

How I php echo the date?

May be worth a mention that you forgot to close double quotes on line 2. — Marty
– Marty, Commented Jun 9, 2011 at 8:10
Perhaps it's also time to read a little something about database normalisation, it's almost never a good idea to have numbered columns in a table; that reeks of denormalisation, which generally makes your life a lot harder. — Berry Langerak
– Berry Langerak, Commented Jun 9, 2011 at 9:00

Nicola Peluchetti · Accepted Answer · 2011-06-09 08:16:08Z

5

Your $mydate is automatically converted by php if you use double quotes: you just missed a double quote at the end of the query:

$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

answered Jun 9, 2011 at 8:16

Nicola Peluchetti

77k32 gold badges151 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

red eyes dev · Accepted Answer · 2011-06-09 08:14:28Z

3

You forgot " in sql query.

$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'";
}
}

answered Jun 9, 2011 at 8:14

red eyes dev

3983 silver badges11 bronze badges

Comments

user5299698 · Accepted Answer · 2017-07-13 08:56:39Z

0

you forgot to use double quotes it should belike this $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'";

answered Jul 13, 2017 at 8:56

user5299698

Collectives™ on Stack Overflow

PHP echo problem

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related