/home/desid573/public_html/drivers
Edit: /home/desid573/public_html/drivers/smsregister.php (1564B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query1 = "SELECT * FROM `desid573_eway_codes`.`drivers` WHERE `driver` != 'Ben' AND `city` = 'perth'";
$success1 = $conn->query($query1);
if (!$success1) {
error_log("Couldn't get driver data: ".$conn->error);
}
while($driver_details = $success1->fetch_assoc()) {
$phone = $driver_details['driver_phone'];
$message = "Hi ".$driver_details['driver']."\nPlease use our new availability tool to let Lewis/Michael/Ben know when you can work. Set default availability for the same days/times each week and/or set each week manually\nhttps://desidrivers.com.au/drivers/register.php?driver=".urlencode($driver_details['driver']);
$account_sid = 'AC1b4db66d86197058950ad349a2327a85';
$auth_token = '053ae80d10eac3b60c92179d3492badf';
$client = new Client($account_sid, $auth_token);
$messages = $client->messages->create("$phone", array('From' => "DesiDrivers", 'body' => "$message"));
echo $driver_details['driver']." ".$messages."
";
}
?>