android_connect(create_product)

<?php


/*

* Following code will create a new product row

* All product details are read from HTTP Post Request

*/


// array for JSON response

$response = array();


// check for required fields

if (isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) {
   
   
$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 inserting a new row
   
$result = mysql_query("INSERT INTO products(name, price, description) VALUES('$name', '$price', '$description')");

   
// check if row inserted or not
   
if ($result) {
       
// successfully inserted into database
       
$response["success"] = 1;
       
$response["message"] = "Product successfully created.";

       
// echoing JSON response
       
echo json_encode($response);
   
}
else {
       
// failed to insert row
       
$response["success"] = 0;
       
$response["message"] = "Oops! An error occurred.";
       
       
// echoing JSON response
       
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);

}

?>