Page 30 - 3-2

echo json_encode($response);
}
mysqli_close($con);
?>
----------------*del_all.php*-------------
<?php
$response = array();
//Importing Database Script
require_once __DIR__ . '/db_connect.php';

//Creating sql query
$result = mysqli_query($con, "DELETE FROM mdp_table1 ");

if($result){
$response["success"] = 1;
$response["message"] = "Product successfully deleted";

// echoing JSON response
echo json_encode($response);
}else{
$response["success"] = 0;
$response["message"] = "No product found";

// echo no users JSON
echo json_encode($response);
}

//closing connection
mysqli_close($con);

?>
----------------*del_table2_3_4.php*-------------
<?php
$response = array();
//Importing Database Script
require_once __DIR__ . '/db_connect.php';

//Creating sql query
$result1 = mysqli_query($con, "DELETE FROM mdp_table2 ");

$result2 = mysqli_query($con, "DELETE FROM mdp_table3 ");

$result3 = mysqli_query($con, "DELETE FROM mdp_table4 ");

if($result1&&result2&&result3){

- 30 -