Page 31 - 3-2
P. 31
$response["success"] = 1;
$response["message"] = "Product successfully deleted_2";
// echoing JSON response
echo json_encode($response);
}else{
$response["success"] = 0;
$response["message"] = "No product found_2";
// echo no users JSON
echo json_encode($response);
}
//closing connection
mysqli_close($con);
?>
----------------*delete_product_table1.php*-------------
<?php
/*
* Following code will delete a product from table
* A product is identified by product id (pid)
*/
// array for JSON response
$code = $_GET['code'];
echo $code;
echo ' 코드';
require_once __DIR__ . '/db_connect.php';
$sql2 = "DELETE FROM mdp_table1 WHERE code = $code";
//Executing query to database
if(mysqli_query($con,$sql2)){
echo 'mdp_table1 deleted Successfully';
}else{
echo 'Could Not delete mdp_table1';
}
mysqli_close($con);
?>
----------------*get_all_product.php*-------------
<?php
- 31 -