Cannot Select table where Timestamp = GET

Question

I am so confused here, how can i select table where schedule_date_time = $_GET['date_time'];

<?php

require 'core/init.php';

$schedule_id            =  $_GET['id'];
$schedule_date_time     =  $_GET['date_time'];
$session_id             =  $_GET['session'];
$user_id                =  $_GET['user'];
$user_email             =  $_GET['email'];
$user_name              =  $_GET['username'];
$registry_id            =  $_GET['registry'];

$check1 = DB::getInstance()->query("SELECT * FROM chat_schedule WHERE     schedule_date_time = $schedule_date_time");

if ($check1->count()) {

$insert = DB::getInstance()->insert('chat_booked', array(
        'schedule_id'           => $schedule_id,
        'schedule_date_time'    => $schedule_date_time,
        'session_id'            => $session_id,
        'user_id'               => $user_id,
        'user_email'            => $user_email,
        'user_name'             => $user_name, 
        'registry_id'           => $registry_id
    ));
if ($insert = true) {
    echo "Insert was Successful";
}

} else {
echo "No Match Found, INSERT FAILED!";
}

Do i need to parse the date or something. I can not figure this out :(

score 1 · Answer 1 · answered May 14 '15 at 21:01

1

change the $schedule_date_time to '$schedule_date_time' like:

"SELECT * FROM chat_schedule WHERE     schedule_date_time = '$schedule_date_time' "

answered May 14 '15 at 21:01

mdodong

316
3
11

Cannot Select table where Timestamp = GET

1 Answers1