service
[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 “
Board No | Number | short | Material Description | variable |
---|
“;
}
}// ENd of Isset Submit
[/insert_php]