<?php
    //Use the machine name and instance if multiple instances are used
    $server = '****';
    $user = '****';
    $pass = '****';
    //Define Port
    $port='Port=1433';
    $database = 'cargo_web';

    $number = '161280104';
    $trackcode = '6923';

    $connection_string = "DRIVER={SQL Server};SERVER=$server;$port;DATABASE=$database";
    $conn = odbc_connect($connection_string,$user,$pass);
    if ($conn) {
        echo "Connection established.";
    } else{
        die("Connection could not be established.");
    }

    $sql = "
    SELECT tbl_booking_master.sender_name, dbo.tbl_booking_master.receiver_name, convert(varchar, dbo.tbl_booking_master.booking_datetime, 100) as DT,
    dbo.view_terminal_master.terminal_name +' - '+ dbo.view_terminal_master.ccp_name as STC,
    view_terminal_master_1.terminal_name +' - '+ view_terminal_master_1.ccp_name AS DTC

    FROM dbo.tbl_booking_master
    INNER JOIN dbo.view_terminal_master
    ON dbo.tbl_booking_master.source_terminal_id = dbo.view_terminal_master.terminal_id
    AND dbo.tbl_booking_master.source_ccp_id = dbo.view_terminal_master.ccp_id
    INNER JOIN dbo.view_terminal_master AS view_terminal_master_1
    ON dbo.tbl_booking_master.destination_terminal_id = view_terminal_master_1.terminal_id
    AND dbo.tbl_booking_master.destination_ccp_id = view_terminal_master_1.ccp_id

    WHERE (dbo.tbl_booking_master.web_track_code = " & $number & " )  AND (dbo.tbl_booking_master.booking_id = " & $trackcode & " )";

    $result = odbc_exec($conn,$sql);

    if(!$result)
    {
        echo "No result";
        return false;
    }
    else{
        // Get Data From Result
        while ($data[] = odbc_fetch_array($result));

        // Free Result
        odbc_free_result($result);

        // Close Connection
        odbc_close($conn);

        // Show data
        print_r($data);


    }


?>