FM / drivers

/home/desid573/public_html/angel/drivers/

/home/desid573/public_html/angel/drivers

Name	Size	Mode	Actions
twilio-php-master/	-	0755	rm
avail.php	19359	0644	edit dl rm
cancel_booking.php	4537	0644	edit dl rm
checkDetails.php	1050	0644	edit dl rm
create.php	2332	0644	edit dl rm
createbilling.php	7335	0644	edit dl rm
createdriver.php	4708	0644	edit dl rm
daily.php	9342	0644	edit dl rm
default.php	16383	0644	edit dl rm
delete.php	942	0644	edit dl rm
deletedriver.php	3508	0644	edit dl rm
error_log	193375	0644	edit dl rm
getDailyAvailability.php	3065	0644	edit dl rm
getDefaultAvailability.php	1102	0644	edit dl rm
getDriverAvailability.php	1642	0644	edit dl rm
home.php	5517	0644	edit dl rm
login.php	7782	0644	edit dl rm
loginDriver.php	1214	0644	edit dl rm
new.php	835	0644	edit dl rm
off.php	3502	0644	edit dl rm
register.php	8676	0644	edit dl rm
setDefaultAvailability.php	3257	0644	edit dl rm
setDriverAvailability.php	3365	0644	edit dl rm
setDriverPin.php	2189	0644	edit dl rm
smsregister.php	1564	0644	edit dl rm
updateDetails.php	3350	0644	edit dl rm

Edit: /home/desid573/public_html/angel/drivers/getDriverAvailability.php (1642B)

<?php

$driver = $_POST['driver'];
$date = $_POST['date'];

error_log($driver." ".$date);

if($driver != "" && $date != "") {

$dbhost = "localhost";
	    $dbuser = "desid573_famcab";
	    $dbpass = "C]+6wQySxov(";
	    $dbname = "desid573_eway_codes";
	    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    
	    $query   = "SELECT * FROM driver_avail WHERE driver = '".$driver."' AND week_ending = '".$date."'";
	    $success = $conn->query($query);
 
	    if (!$success) {
    		error_log("Couldn't get data: ".$conn->error);
    		}
    		
    	if($success->num_rows > 0) {
    	    
    	    $success = $conn->query($query);
	        $row = $success->fetch_assoc();
	        $row["status"] = "OK";
            $row["message"] = "Availability found";
    	    
    	} else {
    	    
    	    
    	    
    	    $query   = "SELECT * FROM driver_default_avail WHERE driver = '".$driver."'";
	        $success = $conn->query($query);
	        
	        if (!$success) {
    		error_log("Couldn't enter data: ".$conn->error);
    		}
	        
	        if($success->num_rows > 0) {
	        $row = $success->fetch_assoc();
	        $row["status"] = "OK";
            $row["message"] = "Default availability found";
	        } else {
	            
	          $row["status"] = "none";
            $row["message"] = "Default availability found";  
	            
	        }
	        
    	}
    		
    		
} else {
    $row["status"] = "error";
    $row["message"] = "Not enough data";
    
}

echo json_encode($row, true);
    		
    		?>

connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query = "SELECT * FROM driver_avail WHERE driver = '".$driver."' AND week_ending = '".$date."'"; $success = $conn->query($query); if (!$success) { error_log("Couldn't get data: ".$conn->error); } if($success->num_rows > 0) { $success = $conn->query($query); $row = $success->fetch_assoc(); $row["status"] = "OK"; $row["message"] = "Availability found"; } else { $query = "SELECT * FROM driver_default_avail WHERE driver = '".$driver."'"; $success = $conn->query($query); if (!$success) { error_log("Couldn't enter data: ".$conn->error); } if($success->num_rows > 0) { $row = $success->fetch_assoc(); $row["status"] = "OK"; $row["message"] = "Default availability found"; } else { $row["status"] = "none"; $row["message"] = "Default availability found"; } } } else { $row["status"] = "error"; $row["message"] = "Not enough data"; } echo json_encode($row, true); ?>