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);

}

?>

Android_Connect(get_product_details)

<?php


/*

* Following code will get single product details

* A product is identified by product id (pid)

*/


// array for JSON response

$response = array();



// include db connect

require_once __DIR__ . '/db_connect.php';


// connecting to db

$db = new DB_CONNECT();


// check for post data
if (isset($_GET["pid"])) {
   
$pid = $_GET['pid'];

   
// get a product from products table
   
$result = mysql_query("SELECT *FROM products WHERE pid = $pid");

   
if (!empty($result)) {
       
// check for empty result
       
if (mysql_num_rows($result) > 0) {

           
$result = mysql_fetch_array($result);

           
$product = array();
           
$product["pid"] = $result["pid"];
           
$product["name"] = $result["name"];
           
$product["price"] = $result["price"];
           
$product["description"] = $result["description"];
           
$product["created_at"] = $result["created_at"];
           
$product["updated_at"] = $result["updated_at"];
           
// success
           
$response["success"] = 1;

           
// user node
           
$response["product"] = array();

           
array_push($response["product"], $product);

           
// 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 {
     
 // 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);

}

?>

Android_Connect(get_all_products)

<?php


/*

* Following code will list all the products

*/


// array for JSON response

$response = array();



// include db connect
require_once __DIR__ . '/db_connect.php';


// connecting to db

$db = new DB_CONNECT();


// get all products from products table

$result = mysql_query("SELECT *FROM products") or die(mysql_error());


// check for empty result

if (mysql_num_rows($result) > 0) {
    // looping through all results
   
// products node
   
$response["products"] = array();
   
   
while ($row = mysql_fetch_array($result)) {
       
// temp user array
       
$product = array();
       
$product["pid"] = $row["pid"];
       
$product["name"] = $row["name"];
       
$product["price"] = $row["price"];
       
$product["description"] = $row["description"];
       
$product["created_at"] = $row["created_at"];
       
$product["updated_at"] = $row["updated_at"];



       
// push single product into final response array
       
array_push($response["products"], $product);
   
}
   
// success
   
$response["success"] = 1;

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

} else {
   
// no products found
   
$response["success"] = 0;
   
$response["message"] = "No products found";

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

}

?>

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);

}

?>

android_connect(db_connect)

<?php


/**

 * A class file to connect to database

 */

class DB_CONNECT {

   
// constructor
   
function __construct() {
 // connecting to database
       
$this->connect();
   
}

   
// destructor
   
function __destruct() {
       
// closing db connection
       
$this->close();
   
}

   
/**
   
* Function to connect with database
   
*/
   
function connect() {
 // import database connection variables
       
require_once __DIR__ . '/db_config.php'; // Connecting to mysql database
       
$con = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die(mysql_error());

 // Selecing database
       
$db = mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());

 // returing connection cursor
       
return $con;
   
}

   
/**
   
* Function to close db connection
   
*/
   
function close() {
 // closing db connection
       
mysql_close();
   
}


}


?>

Android_Connect(db_config)

<?php


/*
 * All database connection variables

 */


define('DB_USER', "root");// db user

define('DB_PASSWORD', "");// db password(mention your db password here)

define('DB_DATABASE', "androidcommunication");// database name

define('DB_SERVER', "localhost");// db server

?>

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);

}

?>