Android_Connect(update_product)

<?php


/*

* Following code will update a product information

* A product is identified by product id (pid)

*/


// array for JSON response

$response = array();


// check for required fields

if (isset($_POST['pid']) && isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) {
   
   
$pid = $_POST['pid'];
   
$name = $_POST['name'];
   
$price = $_POST['price'];
   
$description = $_POST['description'];

   
// 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("UPDATE products SET name = '$name', price = '$price', description = '$description' WHERE pid = $pid");

   
// check if row inserted or not
   
if ($result) {
       
// successfully updated
       
$response["success"] = 1;
       
$response["message"] = "Product successfully updated.";
       
       
// echoing JSON response
       
echo json_encode($response);
   
} else {
       
   
       }

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

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

}

?>