<?php
$DB_hostname = "localhost";
$DB_Name = "root";
$DB_pass = "";



if(isset($_REQUEST["id"])){
        $ID = $_REQUEST["id"];

        $camTime = date('Y-m-d G:i:s', strtotime($_REQUEST["ct"]));
        $loc = $_REQUEST["coord"];
        //$picFile = $_REQUEST["pf"];
        $base= $_REQUEST['pf'];
        $buffer = base64_decode($base);
        $buffer = mysql_real_escape_string($buffer);

}



$con = mysql_connect($DB_Hostname,$DB_Name,$DB_pass) or die(mysql_error());

//echo "test";
mysql_select_db("test_db", $con);


$sql = "UPDATE vessel_wms_out SET PicFile = '$buffer', GPSLocation = '$loc', PicTakenDate = '$camTime' WHERE WDRAW_NO = '$ID'";
$res = mysql_query($sql);
if ($res) {
    echo "Package status update is successful";
}else{
    echo "Package already delivered.";
}

mysql_close($con);
// end else

?>