$inst = $instruction[0]; } $specinst = "Special instruction by customer:" . $inst; } if ($restuarant_id == '61111') { echo "hells kitchen"; $to = 'Djamel Omari'; $to_email = '*****@*****.**'; $text_msg = 'Hells kitchen:It looks like ' . $fname . '(phone:' . $phone . ') has booked a table for ' . $people_count . ' on ' . $date . ' at ' . $time . "." . $specinst; } else { echo "west village"; $to = 'Philippe Thienard'; $to_email = '*****@*****.**'; $text_msg = 'West Village:It looks like ' . $fname . '(phone:' . $phone . ') has booked a table for ' . $people_count . ' on ' . $date . ' at ' . $time . "." . $specinst; } $mm = substr($date, 0, 2); $dd = substr($date, 3, 2); $yy = substr($date, 6, 4); $format_date = $yy . '-' . $mm . '-' . $dd; echo $date . "\n"; echo $format_date . "\n"; $InsQuery = "Insert into Booking_details (fname, lname, phone, email, instruction, reservation_id, receipt_no, people_count, time,date,restuarant_id,flag_reminder)VALUES ('{$fname}', '{$lname}', '{$phone}', '{$emailid}', '{$inst}', '{$reservation_id}', '{$receipt_no}', '{$people_count}', '{$time}','{$format_date}','{$restuarant_id}','0') "; mysql_query($InsQuery); send_mail($fname, $people_count, $date, $time, $receipt_no, $to, $to_email, $phone, $emailid, $specinst); $obj = new Clickatell(); $obj->sendSms("16465957373", $text_msg); ?>
$varHour = substr($varTime, 0, 2); $varMin = substr($varTime, 3, 2); if ($varHour < 12) { $varHour = $varHour + 12; } $varRowTime = $varHour . ":" . $varMin; $time_diff = get_timedifference($time1, $varRowTime); echo $row["id"] . "time diff is" . $time_diff . "\n"; if ($time_diff <= 40) { echo "reminder sent" . $row["id"] . "\n"; $obj = new Clickatell(); $phone_number_temp = $row["phone"]; $phone_number = preg_replace("/[^0-9]/", "", $phone_number_temp); if (strlen($phone_number) == 10) { $phone_number = "1" . $phone_number; } else { $phone_number = $phone_number; } $obj->sendSms($phone_number, $text_msg); send_reminder($row["fname"], $row["email"]); $sql = "UPDATE Booking_details SET flag_reminder ='1' WHERE id='" . $row['id'] . "'"; mysql_query($sql) or die("I cannot run , reason : " . mysql_error()); } } } else { echo "inside else"; } ?>