/home/desid573/public_html
Edit: /home/desid573/public_html/job_index_results.php (6939B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT SQL_CALC_FOUND_ROWS * FROM jobs ORDER BY id DESC LIMIT 10");
if(!$result) {
error_log($conn->error);
}
while($row = mysqli_fetch_assoc($result)) {
$quote = $row['job_quote'];
$quote_km = $row['quote_km'];
$quote_time = $row['quote_time'];
$name = $row['job_name'];
$email = $row['job_email'];
$pickup = $row['job_pickup'];
$dropoff = $row['job_dropoff'];
$ref = $row['reference'];
$code = "DD";
$mins_to = "";
$flightNum = "";
$phone = $row['job_phone'];
$token = $row['token'];
if($token == "" && $_GET['token'] != ""){
$token = $_GET['token'];
}
$xero = $row['xero_inv'];
$spatula_id = $row['spat_ref'];
$booking_date = $row['job_date'];
$booking_time = $row['job_time'];
$luggage = "";
$user=array('name'=> $name,"date"=> $booking_date." ".$booking_time,'pickup'=> $pickup, "ref"=> $ref, "type"=> $code);
$array[] = $user;
}
}
if($type=="FC" ) {
$dbhost = "localhost";
$dbuser = "desid573_famcab";
$dbpass = "C]+6wQySxov(";
$dbname = "desid573_familycab";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT SQL_CALC_FOUND_ROWS * FROM jobs ORDER BY id DESC LIMIT 10");
while($row = mysqli_fetch_assoc($result)){
$quote = $row['job_quote'];
$quote_km = $row['quote_km'];
$quote_time = $row['quote_time'];
$name = $row['job_name'];
$email = $row['job_email'];
$phone = $row['job_phone'];
$pickup = $row['job_pickup'];
$dropoff = $row['job_dropoff'];
$ref = $row['reference'];
$job_city = $row["job_city"];
if($job_city == "perth") {
$code = "FC";
} else if ($job_city == "queensland") {
$code = "BF";
} else if($job_city == "sydney") {
$code = "SF";
} else if($job_city == "melbourne") {
$code = "MF";
}
$mins_to = $row['mins_post'];
$flightNum = $row['flight_num'];
$xero = $row['xero_inv'];
$spatula_id = $row['spat_ref'];
$booking_date = $row['job_date'];
$booking_time = $row['job_time'];
$bookPax = $row['job_pax'];
$bookRF = $row['job_rf'];
$bookFF = $row['job_ff'];
$bookB = $row['job_boost'];
$luggage = $row['job_luggage'];
$user=array('name'=> $name,"date"=> $booking_date." ".$booking_time,'pickup'=> $pickup, "ref"=> $ref, "type"=> $code);
$array[] = $user;
}
}
if($type=="HK" OR $type=="SI") {
$dbhost = "localhost";
$dbuser = "desid573_inquiri";
$dbpass = "@G&{)0*&Ts^V";
$dbname = "desid573_new_pro_api";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT SQL_CALC_FOUND_ROWS * FROM booking ORDER BY id DESC LIMIT 10");
while($row = mysqli_fetch_assoc($result)) {
$spatula_id = $row['spatula_id'];
$quote_km = $row['quote_km'];
$quote_time = $row['quote_time'];
$pickup = $row['pickup_addr'];
$dropoff = $row['pickoff_addr'];
$ref = $row['reference'];
$code = $row['type'];
$mins_to = "";
$flightNum = "";
$booking_date = $row['booking_date'];
$booking_time = $row['booking_time'];
$quote = $row['quote'];
$cid = $row['cid'];
$result1 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
$row1 = mysqli_fetch_assoc($result1);
$name = $row1['name'];
$email = $row1['email'];
$phone = $row1['mobile'];
error_log($conn->error);
$user=array('name'=> $name,"date"=> $booking_date." ".$booking_time,'pickup'=> $pickup, "ref"=> $ref, "type"=> $code);
$array[] = $user;
}
}
if($type=="FA" or $type=="SA") {
$item = "FA";
$dbhost = "localhost";
$dbuser = "desid573_fam_app";
$dbpass = "TW#7CCqKReDn";
$dbname = "desid573_famcab_api";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$result = mysqli_query($conn, "SELECT SQL_CALC_FOUND_ROWS * FROM booking ORDER BY id DESC LIMIT 10");
while($row = mysqli_fetch_assoc($result)){
$spatula_id = $row['spatula_id'];
$quote_km = $row['quote_km'];
$quote_time = $row['quote_time'];
$pickup = $row['pickup_addr'];
$dropoff = $row['pickoff_addr'];
$xero = $row['xero_inv'];
$ref = $row['reference'];
$code = $row['type'];
if($xero == "") {
$xero = "none";
}
$booking_date = $row['booking_date'];
$booking_time = $row['booking_time'];
$mins_to = $row['mins_to'];
$flightNum = $row['flight_num'];
$bookPax = $row['book_pax'];
$bookRF = $row['book_rf'];
$bookFF = $row['book_ff'];
$bookB = $row['book_b'];
$luggage = $row['luggage'];
$quote = $row['quote'];
$cid = $row['cid'];
$result2 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
$row1 = mysqli_fetch_assoc($result2);
$name = $row1['name'];
$email = $row1['email'];
$phone = $row1['mobile'];
$user=array('name'=> $name,"date"=> $booking_date." ".$booking_time,'pickup'=> $pickup, "ref"=> $ref, "type"=> $code);
$array[] = $user;
}
}
return $array;
}
