service

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);
}
}

$board_code= “{$_POST[“board_code”]}%”;
$material= “{$_POST[“material”]}%”;
$thickness=”{$_POST[“thickness”]}%”;

if(empty($board_code) && empty($material) && empty($thickness)){
echo “Input atleast one”;
}else{
if(!empty($_POST[“board_code”])){
$sql_stamp= “SELECT * FROM new_jobs WHERE board_code LIKE ?”;
$query = $conn->prepare($sql_stamp);
$query->bind_param(“s”,$board_code);
}else if(!empty($_POST[“material”])){
$sql_stamp= “SELECT * FROM new_jobs WHERE material LIKE ?”;
$query = $conn->prepare($sql_stamp);
$query->bind_param(“s”,$material);
}else{
$sql_stamp= “SELECT * FROM new_jobs WHERE thickness LIKE ?”;
$query = $conn->prepare($sql_stamp);
$query->bind_param(“s”,$thickness);
}
$query->execute();
bind_array($query,$row);
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;

while($query->fetch()){
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;
//echo “

“;
//echo “

“;
//echo “

“;
//echo “

“;

//echo “Information: $row[“status”].”,”.$row[“code”].”,”.$row[“date_assigned”].”,”.$row[“variable”].”
“;

//echo “

“;
}//End of While
echo “

Board NoNumbershortMaterial Descriptionvariable
“.$row[“board_code”]. ““.$row[“status”]. ““.$row[“code”]. “:”.$row[“material”]. ““.$row[“stable”]. “
” . Board Code:”.$row[“board_code”] . Number:”.$row[“status”] . ““. Number:”.$row[“status”] . “” . Board Code:”.$row[“board_code”] .” Number:”.$row[“status”] . “

“;
}
}// ENd of Isset Submit

[/insert_php]