FM / lib

/home/desid573/public_html/angel/lib

Name	Size	Mode	Actions
config.php	1740	0644	edit dl rm

Edit: /home/desid573/public_html/angel/lib/config.php (1740B)

<?php
$dbhost = "localhost";
$dbuser = "desid573_angel_d";
$dbpass = 'X+$zPAefH2e6';
$dbname = "desid573_angel_drivers";

// Create connection
$conn = new mysqli($dbhost , $dbuser , $dbpass , $dbname );
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    error_log($conn->connect_error);
} 
//echo "Connected successfully";

if(isset($type) && isset($ref)) {

if($type != "" AND $ref != "") {
    
    $sql = "SELECT * FROM booking WHERE reference = '".$ref."'";
    $result = $conn->query($sql);
    
    if(!$result) {
        
        error_log($conn->error);
        
    }
    if($result->num_rows > 0) {
        
        $row = $result->fetch_assoc();
        
        $cid = $row["cid"];
        $booking_date = $row["booking_date"];
        $booking_time = $row["booking_time"];
        $pickup = $row["pickup_addr"];
        $pick_lat = $row["pickup_lat"];
        $pick_long = $row["pickup_long"];
        $dropoff = $row["pickoff_addr"];
        $drop_lat = $row["pickoff_lat"];
        $drop_long = $row["pickoff_long"];
        $spat_ref = $row["spatula_id"];
        $spat_link = $row["spatula_link"];
        $quote = $row["quote"];
        $quote_km = $row["quote_km"];
        $quote_time = $row["quote_time"];
        $token = $row["token"];
        $status = $row["status"];
        $driver = $row["driver"];
        $instructions = $row["instructions"];
        
        $query = "SELECT * FROM customers WHERE id = ".$cid;
        error_log($query);
        $result = $conn->query($query);
        $cust = $result->fetch_assoc();
        
        $name = $cust["name"];
        $phone = $cust["mobile"];
        
        
        
        
    }
    
}
}
	    
?>

cmd: