New Service

Job No:
Client Ref :

[insert_php]

if(isset($_POST[“submit”])){
$servername=”localhost”;
$username = “abpgroup_root”;
$password = “Laptop14”;
$dbname = “abpgroup_13shop”;

$conn = new mysqli($servername,$username,$password,$dbname);
if(!$conn){
die(‘Not connected : ‘ . mysql_error());
}
if (!function_exists(‘bind_array’)) {
function bind_array($stmt, &$row) {
$md = $stmt->result_metadata();
$params = array();
while($field = $md->fetch_field()) {
$params[] = &$row[$field->name];
}

call_user_func_array(array($stmt, ‘bind_result’), $params);
}
}

$job_no = $_POST[“job_no”];
$client_ref = $_POST[“client_ref”];

if(empty($job_no) && empty($client_ref)){
echo “Input atleast one data”;
}else if(empty($client_ref)){
$sql = “SELECT datPromisedDelivery FROM abp_jobs WHERE nJobNumber=?”;
$query = $conn->prepare($sql);
$query->bind_param(“i”,$job_no);
if($query->execute()){
bind_array($query,$row);
while($query->fetch()){
echo “The Promised Date is “.$row[“datPromisedDelivery”];
}
}
}else{
$sql = “SELECT datPromisedDelivery FROM abp_jobs WHERE strClientReference=?”;
$query = $conn->prepare($sql);
$query->bind_param(“s”,$client_ref);
if($query->execute()){
bind_array($query,$row);
while($query->fetch()){
echo “The Promised Date is “.$row[“datPromisedDelivery”];
}
}
}

}

[/insert_php]