<?php $p = $_POST; $res = 'fail'; switch ($p['method']) { case 'book': $res = book($p); break; case 'getBookingInfo': $res = getBookingInfo($p); break; case 'startCall': $res = startCall($p); break; case 'generateToken': $res = generateToken($p); break; case 'updateToken': $res = updateToken($p); break; default: break; } echo $res; function book($p) { mysql_connect("localhost", "videodesk", "ju87gtS") or die("Impossible de se connecter : " . mysql_error()); mysql_select_db("simplybook"); $code = $p['codeid']; $token = $p['token']; $confirmed = true;
<?php require_once '../model/db.php'; $userID = $_GET['id']; $row = getBookingInfo($userID); $outp = "["; foreach ($row as $r) { if ($outp != "[") { $outp .= ","; } $DOB = strtotime($r['date_of_booking']); $DOB = date("d M, Y", $DOB); $DOP = strtotime($r['order_date']); $DOP = date("d M, Y", $DOP); $outp .= '{"DoB":"' . $DOB . '",'; $outp .= '"DoP":"' . $DOP . '",'; $outp .= '"purpose":"' . $r['order_purpose'] . '",'; $outp .= '"totalCost":"' . $r['total_cost'] . '",'; $outp .= '"paidCost":"' . $r['paid_cost'] . '",'; $outp .= '"keyID":"' . $r['order_id'] . '"}'; } $outp .= "]"; echo $outp;