/home/desid573/public_html
Edit: /home/desid573/public_html/dispatch.php (2326B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM `desid573_eway_codes`.`drivers` WHERE id = ".$driver_id;
$result = mysqli_query($conn, $query);
if(!$result) {
error_log("driver number lookup error ".$conn->error);
}
$row = mysqli_fetch_assoc($result);
$driver_name = $row["driver"];
$query = "SELECT * FROM jobs WHERE spat_ref = '".$spat_ref."'";
$result = mysqli_query($conn, $query);
if(!$result) {
error_log("spat ref lookup error ".$conn->error);
}
$row = mysqli_fetch_assoc($result);
$id = $row['id'];
$query = "UPDATE jobs SET `driver` ='".$driver_name."' WHERE `id` = ".$id;
error_log($query);
$result = mysqli_query($conn, $query);
if(!$result){
echo "error";
error_log($conn->error);
} else {
echo "OK";
}
error_log("Driver details ".$driver_id." ".$driver);
} else {
echo "error";
}
}