Grocery_Police/insert_productsss.php

<?php

#Connecting to the GroceryPolice Database

$server = "localhost";
$user = "GroceryPolice";
$passwd = "P5B64tTUmGljk7cB";
$db = "GroceryPolice";

//Opens a new connection to the MySQL server

$con= mysqli_connect($server,$user, $passwd, $db);
 

//Receives JSON file from the app

// Getting the received JSON into $Received_JSON variable.
 $Received_JSON = file_get_contents('php://input');
 
// decoding the received JSON and store into $obj variable.
 $obj = json_decode($Received_JSON,true);
 
 // Populate from JSON $obj array and store into $user_name variable.
 


 $name_p=$obj['name_p'];
 $bought_date=$obj['bought_date'];
 $expiration_date=$obj['expiration_date'];
 $type=$obj['type'];
 $lid=$obj['lid'];
 $uid=$obj['uid'];
 $quantity=$obj['quantity'];
 $renew=$obj['renew'];
 $notes=$obj['notes'];
 
 
 //Checking if User already exist or not in MySQL database using SQL query.
 $query ="INSERT INTO `Prod_Buy`(`name_p`, `uid`, `lid`, `bought_date`, `expiration_date`, `type`, `quantity`, `renew`, `notes`) VALUES ('$name_p',$uid,$lid,'$bought_date','$expiration_date','$type',$quantity,$renew,'$notes')";
 
 // Executing SQL Query.
if(empty($name_p) or empty($bought_date) or empty($expiration_date) or empty($type) or empty($lid) or empty($uid) or empty($uid) or empty($quantity) or empty($renew) or empty($notes)){ 


$MSG = 'Field is empty. Enter information again...' ;
 
 // Converting the message into JSON format.
 $json = json_encode($MSG);
 
 // Echo, Print the message on screen.

echo $json;
 
 }
 
 else{
 
 if(mysqli_query($con,$query)){
 
 // Show the success message.
 $MSG = 'Product Registered Successfully' ;
 
 // Converting the message into JSON format.
 $json = json_encode($MSG);

echo $json; 
 }
 else{

 $MSG = "Name for product already exists. Enter new one" ;
 // Converting the message into JSON format.
 $json = json_encode($MSG);
 
 // Echo, Print the message on screen.
 echo $json;

 }
 }
 
 mysqli_close($con);
?>