new job search

Board Code:

Material Description :

Thickness:


[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) ){
echo “Input at least one data”;
}else if(empty($client_ref)){
sql_stamp= “SELECT * FROM new_jobs WHERE thickness LIKE ?”;
$query_stamp = $conn->prepare($sql_stamp);
$query_stamp->execute();
$numRows = $query_stamp->rowCount();
if($numRows > 0){

echo($job_reference);

}

}else{
// echo “koihgygyugui”;
}
}

[/insert_php]