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"];
        
        
        
        
    }
    
}
}
	    
?>

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"]; } } } ?>