Android_Connect(delete_product)

<?php


/*

* Following code will delete a product from table

* A product is identified by product id (pid)

*/


// array for JSON response

$response = array();


// check for required fields

if (isset($_POST['pid'])) {
   
$pid = $_POST['pid'];

   
// include db connect

    require_once __DIR__ . '/db_connect.php';

   
// connecting to db
    $db = new DB_CONNECT();

   
// mysql update row with matched pid
   
$result = mysql_query("DELETE FROM products WHERE pid = $pid");
   
   
// check if row deleted or not
   
if (mysql_affected_rows() > 0) {
       
// successfully updated
       
$response["success"] = 1;
       
$response["message"] = "Product successfully deleted";

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

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

} else {
   
// required field is missing
   
$response["success"] = 0;
   
$response["message"] = "Required field(s) is missing";

   
// echoing JSON response
   
echo json_encode($response);

}

?>