0% found this document useful (0 votes)

52 views33 pages

Android PHP MySQL Connection Guide

This document provides instructions for connecting an Android application to a PHP/MySQL backend. It discusses: 1. Setting up a local development environment with WAMP server. 2. Creating a PHP project directory and basic test file to confirm the server is running properly. 3. Using phpMyAdmin to create a database and table to store product data. 4. Writing PHP classes to connect to the MySQL database and perform basic CRUD operations like inserting, retrieving, and listing products. 5. Examples of JSON responses returned by the PHP scripts for different operations like creating a product or getting product details by ID.

Uploaded by

MaestroUTN

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

52 views33 pages

Android PHP MySQL Connection Guide

Uploaded by

MaestroUTN

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

[Link]

com/members/website/pruebasutn/files
[Link]

3. Creating and Running PHP Project

Now you have the environment ready to develop a PHP & MySQL project. Go to the
location where you installed WAMP server (In my case i installed in C:\wamp\) and go
to www folder and create a new folder for your project. You have to place all your
project files inside this folder.
Create a folder called android_connect and create a new php file called [Link] and try
out simple php code. After placing following code try to
open [Link] you should see a message called
“Welcome, I am connecting Android to PHP, MySQL“.
[Link]
<?php
echo "Welcome, I am connecting Android to PHP, MySQL";
?>
Following is a screen cast of Creating and Running a simple PHP project.

4. Creating MySQL Database and Tables

In this tutorial i am creating a simple database with one table. Through out this tutorial i
am using same table to perform example operations. Now open phpmyadmin by
opening the address [Link] your browser. You can use the
PhpMyAdmin tool to create a database and a table.
I am creating a database named androidhive and a table called products.

CREATE DATABASE androidhive;

CREATE TABLE products(
pid int(11) primary key auto_increment,
name varchar(100) not null,
price decimal(10,2) not null,
description text,
created_at timestamp default now(),
updated_at timestamp
);
Following is a screen cast of Creating database and tables in phpmyadmin

5. Connecting to MySQL database using PHP

Now the actual server side coding starts. Create a PHP class to connect to MySQL
database. The main purpose of this class is to open a connection to database and
close the connection whenever its not needed. So create two files
called db_config.php and db_connect.php
db_config.php – will have database connection variables
db_connect.php – a class file to connect to database
Following is code for two php files

db_config.php
db_config.php
[Link]
[Link]
<?php

/*
* All database connection variables
*/

define('DB_USER', "root"); // db user
define('DB_PASSWORD', ""); // db password (mention your db password here)
define('DB_DATABASE', "androidhive"); // database name
define('DB_SERVER', "localhost"); // db server
?>
db_connect.php
db_connect.php
<?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
[Link]
[Link]
        mysql_close();
    }

}

?>
Usage: When ever you want to connect to MySQL database and do some operations
use the db_connect.php class like this
$db = new DB_CONNECT(); // creating class object(will open database connection)

6. Basic MySQL CRUD Operations using PHP

In this tutorial i am covering basic CRUD (Create, Read, Update, Delete) operations on
MySQL database using PHP.
If you are a novice in PHP and MySQL, I suggest you go through PHP, SQL and A
Beginner’s Guide to SQL to get the basic knowledge.

6.a) Creating a row in MySQL (Creating a new product row)

In your PHP project create a new php file called create_product.php and place the
following code. This file is mainly for creating a new product in products table.
In the following code i am reading product data via POST and storing them in products
table. At the end i am echoing appropriate JSON as response.

create_product.php
<?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 class
    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',
[Link]
[Link]

    // 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);
}
?>
For the above code JSON response will be like

When POST param(s) is missing

{
"success": 0,
"message": "Required field(s) is missing"
}
When product is successfully created

{
"success": 1,
"message": "Product successfully created."
}
When error occurred while inserting data

{
"success": 0,
"message": "Oops! An error occurred."
}

6.b) Reading a Row from MySQL (Reading product details)

Create a new php file called get_product_details.php and write the following code. This
file will get single product details by taking product id (pid) as post parameter.
[Link]
[Link]

get_product_details.php
<?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 class
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);
[Link]
[Link]
        }
    } 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);
}
?>
The json response for the above file will be

When successfully getting product details

{
    "success": 1,
    "product": [
        {
            "pid": "1",
            "name": "iPHone 4S",
            "price": "300.00",
            "description": "iPhone 4S white",
            "created_at": "2012-04-29 01:41:42",
            "updated_at": "0000-00-00 00:00:00"
        }
    ]
}
When no product found with matched pid

{
"success": 0,
"message": "No product found"
}

6.c) Reading All Rows from MySQL (Reading all products)

We need a json to list all the products on android device. So create a new php file
named get_all_products.php and write following code.
get_all_products.php
<?php

/*
* Following code will list all the products
*/
[Link]
[Link]

// array for JSON response
$response = array();

// include db connect class
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["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);
}
?>
And the JSON response for above code

Listing all Products

{
    "products": [
        {
            "pid": "1",
[Link]
[Link]
            "name": "iPhone 4S",
            "price": "300.00",
            "created_at": "2012-04-29 02:04:02",
            "updated_at": "0000-00-00 00:00:00"
        },
        {
            "pid": "2",
            "name": "Macbook Pro",
            "price": "600.00",
            "created_at": "2012-04-29 02:04:51",
            "updated_at": "0000-00-00 00:00:00"
        },
        {
            "pid": "3",
            "name": "Macbook Air",
            "price": "800.00",
            "created_at": "2012-04-29 02:05:57",
            "updated_at": "0000-00-00 00:00:00"
        },
        {
            "pid": "4",
            "name": "OS X Lion",
            "price": "100.00",
            "created_at": "2012-04-29 02:07:14",
            "updated_at": "0000-00-00 00:00:00"
        }
    ],
    "success": 1
}
When products not found

{
"success": 0,
"message": "No products found"
}

6.d) Updating a Row in MySQL (Updating product details)

Create a php file named update_product.php to update product details. Each product is
identified by pid.
update_product.php
<?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($_PO

[Link]
[Link]
    $pid = $_POST['pid'];
    $name = $_POST['name'];
    $price = $_POST['price'];
    $description = $_POST['description'];

    // include db connect class
    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', descript

    // 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);
}
?>
The json reponse of above code, when product is updated successfully

{
"success": 1,
"message": "Product successfully updated."
}

6.e) Deleting a Row in MySQL (Deleting a product)

The last operation is deletion on database. Create a new php file called
delete_product.php and paste the following code. The main functionality of this file is to
delete a product from database.

delete_product.php
<?php

/*
* Following code will delete a product from table
[Link]
[Link]
* 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 class
    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);
}
?>
When product successfully deleted

{
"success": 1,
"message": "Product successfully deleted"
}
When product not found

{
[Link]
[Link]
"success": 0,
"message": "No product found"
}
Until now, we built a simple api for our products table. We are now done with the
server side coding (PHP) and its time to take a break and start our actual android
application coding.

7. Creating Android Application

Create a new project in your Eclipse IDE by filling the required details.

1. Create new project in Eclipse IDE by going to File ⇒ New ⇒ Android Project and
name the Activity class name as MainScreenActivity.
2. Open your [Link] file and add following code. First i am adding all the
classes i am creating to manifest file. Also i am adding INTERNET Connect
permission.
[Link]
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="[Link]
    package="[Link]"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk android:minSdkVersion="8" />

    <application
        android:configChanges="keyboardHidden|orientation"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name" >

        <activity
            android:name=".MainScreenActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="[Link]" />

                <category android:name="[Link]" />
            </intent-filter>
        </activity>

        
        <activity
            android:name=".AllProductsActivity"
            android:label="All Products" >
        </activity>

        
        <activity
            android:name=".NewProductActivity"
            android:label="Add New Product" >
        </activity>

[Link]
[Link]
        
        <activity
            android:name=".EditProductActivity"
            android:label="Edit Product" >
        </activity>
    </application>

    
    <uses-permission android:name="[Link]" />

</manifest>
3. Now create a new xml file under res ⇒ layout folder and name it
as main_screen.xml This layout file contains two simple buttons to view all products
and add a new product.
main_screen.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical"
    android:gravity="center_horizontal">

    
    
    <Button android:id="@+id/btnViewProducts"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="View Products"
        android:layout_marginTop="25dip"/>

    
    <Button android:id="@+id/btnCreateProduct"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Add New Products"
        android:layout_marginTop="25dip"/>

</LinearLayout>

4. Open you main activity class which is [Link] and write click events
for two button which are mentioned in main_screen.xml layout.
[Link]
package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class MainScreenActivity extends Activity{

Button btnViewProducts;
Button btnNewProduct;
[Link]
[Link]

    @Override
    public void onCreate(Bundle savedInstanceState) {
        [Link](savedInstanceState);
        setContentView([Link].main_screen);

        // Buttons
        btnViewProducts = (Button) findViewById([Link]);
        btnNewProduct = (Button) findViewById([Link]);

        // view products click event
        [Link](new [Link]() {

            @Override
            public void onClick(View view) {
                // Launching All products Activity
                Intent i = new Intent(getApplicationContext(), [Link])
                startActivity(i);

            }
        });

        // view products click event
        [Link](new [Link]() {

            @Override
            public void onClick(View view) {
                // Launching create new product activity
                Intent i = new Intent(getApplicationContext(), [Link]);
                startActivity(i);

            }
        });
    }
}

Displaying All Products in ListView (Read)

5. Now we need an Activity display all the products in list view format. As we know list
view needs two xml files, one for listview and other is for single list row. Create two xml
files under res ⇒ layout folder and name it as all_products.xml and list_item.xml
all_products.xml
all_products.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical">
    
    <ListView
        android:id="@android:id/list"
[Link]
[Link]
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"/>

</LinearLayout>
list_item.xml
list_item.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:orientation="vertical" >

    
    <TextView
        android:id="@+id/pid"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:visibility="gone" />

    
    <TextView
        android:id="@+id/name"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:paddingTop="6dip"
        android:paddingLeft="6dip"
        android:textSize="17dip"
        android:textStyle="bold" />

</LinearLayout>
6. Create a new class file and name it as [Link]. In the following
code
-> First a request is send to get_all_products.php file using a Background Async task
thread.
-> After getting JSON from get_all_products.php, i parsed it and displayed in a listview.
-> If there are no products found AddNewProductAcivity is launched.
[Link]
package [Link];

import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
[Link]
[Link]
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class AllProductsActivity extends ListActivity {

    // Progress Dialog
    private ProgressDialog pDialog;

    // Creating JSON Parser object
    JSONParser jParser = new JSONParser();

    ArrayList<HashMap<String, String>> productsList;

    // url to get all products list
    private static String url_all_products = "[Link]

    // JSON Node names
    private static final String TAG_SUCCESS = "success";
    private static final String TAG_PRODUCTS = "products";
    private static final String TAG_PID = "pid";
    private static final String TAG_NAME = "name";

    // products JSONArray
    JSONArray products = null;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        [Link](savedInstanceState);
        setContentView([Link].all_products);

        // Hashmap for ListView
        productsList = new ArrayList<HashMap<String, String>>();

        // Loading products in Background Thread
        new LoadAllProducts().execute();

        // Get listview
        ListView lv = getListView();

        // on seleting single product
        // launching Edit Product Screen
        [Link](new OnItemClickListener() {

            @Override
            public void onItemClick(AdapterView<?> parent, View view,
                    int position, long id) {
                // getting values from selected ListItem
                String pid = ((TextView) [Link]([Link])).getText()
                        .toString();
[Link]
[Link]

                // Starting new intent
                Intent in = new Intent(getApplicationContext(),
                        [Link]);
                // sending pid to next activity
                [Link](TAG_PID, pid);

                // starting new activity and expecting some response back
                startActivityForResult(in, 100);
            }
        });

    }

    // Response from Edit Product Activity
    @Override
    protected void onActivityResult(int requestCode, int resultCode, Intent data) {
        [Link](requestCode, resultCode, data);
        // if result code 100
        if (resultCode == 100) {
            // if result code 100 is received
            // means user edited/deleted product
            // reload this screen again
            Intent intent = getIntent();
            finish();
            startActivity(intent);
        }

    }

    /**
     * Background Async Task to Load all product by making HTTP Request
     * */
    class LoadAllProducts extends AsyncTask<String, String, String> {

        /**
         * Before starting background thread Show Progress Dialog
         * */
        @Override
        protected void onPreExecute() {
            [Link]();
            pDialog = new ProgressDialog([Link]);
            [Link]("Loading products. Please wait...");
            [Link](false);
            [Link](false);
            [Link]();
        }

        /**
         * getting All products from url
         * */
        protected String doInBackground(String... args) {
            // Building Parameters
            List<NameValuePair> params = new ArrayList<NameValuePair>();
            // getting JSON string from URL
[Link]
[Link]
            JSONObject json = [Link](url_all_products, "GET", params);

            // Check your log cat for JSON reponse
            Log.d("All Products: ", [Link]());

            try {
                // Checking for SUCCESS TAG
                int success = [Link](TAG_SUCCESS);

                if (success == 1) {
                    // products found
                    // Getting Array of Products
                    products = [Link](TAG_PRODUCTS);

                    // looping through All Products
                    for (int i = 0; i < [Link](); i++) {
                        JSONObject c = [Link](i);

                        // Storing each json item in variable
                        String id = [Link](TAG_PID);
                        String name = [Link](TAG_NAME);

                        // creating new HashMap
                        HashMap<String, String> map = new HashMap<String, String>();

                        // adding each child node to HashMap key => value
                        [Link](TAG_PID, id);
                        [Link](TAG_NAME, name);

                        // adding HashList to ArrayList
                        [Link](map);
                    }
                } else {
                    // no products found
                    // Launch Add New product Activity
                    Intent i = new Intent(getApplicationContext(),
                            [Link]);
                    // Closing all previous activities
                    [Link](Intent.FLAG_ACTIVITY_CLEAR_TOP);
                    startActivity(i);
                }
            } catch (JSONException e) {
                [Link]();
            }

            return null;
        }

        /**
         * After completing background task Dismiss the progress dialog
         * **/
        protected void onPostExecute(String file_url) {
            // dismiss the dialog after getting all products
            [Link]();
            // updating UI from Background Thread
[Link]
[Link]
            runOnUiThread(new Runnable() {
                public void run() {
                    /**
                     * Updating parsed JSON data into ListView
                     * */
                    ListAdapter adapter = new SimpleAdapter(
                            [Link], productsList,
                            [Link].list_item, new String[] { TAG_PID,
                                    TAG_NAME},
                            new int[] { [Link], [Link] });
                    // updating listview
                    setListAdapter(adapter);
                }
            });

        }

    }
}

Adding a New Product (Write)

7. Create a new view and activity to add a new product into mysql database. Create a
simple form which contains EditText for product name, price and description.
Create a new xml file and name it as add_product.xml and paste the following code to
create a simple form.
add_product.xml
add_product.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Product Name"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputName"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"/>

    
    <TextView android:layout_width="fill_parent"
[Link]
[Link]
        android:layout_height="wrap_content"
        android:text="Price"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputPrice"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"
        android:inputType="numberDecimal"/>

    
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Description"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputDesc"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:lines="4"
        android:gravity="top"/>

    
    <Button android:id="@+id/btnCreateProduct"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Create Product"/>

</LinearLayout>

8. Now create new Activity to insert a new product into mysql database. Create a class
file and name it as [Link] and type the following code. In the
following code
-> First new product data is read from the EditText form and formatted into a basic
params.
-> A request is made to create_product.php to create a new product through HTTP
post.
-> After getting json response from create_product.php, If success bit is 1 then list view
is refreshed with newly added product.
[Link]
package [Link];

[Link]
[Link]
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class NewProductActivity extends Activity {

    // Progress Dialog
    private ProgressDialog pDialog;

    JSONParser jsonParser = new JSONParser();
    EditText inputName;
    EditText inputPrice;
    EditText inputDesc;

    // url to create new product
    private static String url_create_product = "[Link]

    // JSON Node names
    private static final String TAG_SUCCESS = "success";

    @Override
    public void onCreate(Bundle savedInstanceState) {
        [Link](savedInstanceState);
        setContentView([Link].add_product);

        // Edit Text
        inputName = (EditText) findViewById([Link]);
        inputPrice = (EditText) findViewById([Link]);
        inputDesc = (EditText) findViewById([Link]);

        // Create button
        Button btnCreateProduct = (Button) findViewById([Link]);

        // button click event
        [Link](new [Link]() {

            @Override
            public void onClick(View view) {
                // creating new product in background thread
                new CreateNewProduct().execute();
[Link]
[Link]
            }
        });
    }

    /**
     * Background Async Task to Create new product
     * */
    class CreateNewProduct extends AsyncTask<String, String, String> {

        /**
         * Before starting background thread Show Progress Dialog
         * */
        @Override
        protected void onPreExecute() {
            [Link]();
            pDialog = new ProgressDialog([Link]);
            [Link]("Creating Product..");
            [Link](false);
            [Link](true);
            [Link]();
        }

        /**
         * Creating product
         * */
        protected String doInBackground(String... args) {
            String name = [Link]().toString();
            String price = [Link]().toString();
            String description = [Link]().toString();

            // Building Parameters
            List<NameValuePair> params = new ArrayList<NameValuePair>();
            [Link](new BasicNameValuePair("name", name));
            [Link](new BasicNameValuePair("price", price));
            [Link](new BasicNameValuePair("description", description));

            // getting JSON Object
            // Note that create product url accepts POST method
            JSONObject json = [Link](url_create_product,
                    "POST", params);

            // check log cat fro response
            Log.d("Create Response", [Link]());

            // check for success tag
            try {
                int success = [Link](TAG_SUCCESS);

                if (success == 1) {
                    // successfully created product
                    Intent i = new Intent(getApplicationContext(), [Link]
                    startActivity(i);

                    // closing this screen
                    finish();
[Link]
[Link]
                } else {
                    // failed to create product
                }
            } catch (JSONException e) {
                [Link]();
            }

            return null;
        }

        /**
         * After completing background task Dismiss the progress dialog
         * **/
        protected void onPostExecute(String file_url) {
            // dismiss the dialog once done
            [Link]();
        }

    }
}

Reading, Updating and Deleting a Single Product

9. If you notice the [Link], In listview i am launching
[Link] once a single list item is selected. So create xml file
called edit_product.xml and create a form which is same as create_product.xml.
edit_product.xml
edit_product.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Product Name"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputName"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"/>

    
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
[Link]
[Link]
        android:text="Price"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputPrice"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"
        android:inputType="numberDecimal"/>

    
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Description"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    
    <EditText android:id="@+id/inputDesc"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:lines="4"
        android:gravity="top"/>

    <LinearLayout android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal">
        
    <Button android:id="@+id/btnSave"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Save Changes"
        android:layout_weight="1"/>

    
    <Button android:id="@+id/btnDelete"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Delete"
        android:layout_weight="1"/>
    </LinearLayout>

</LinearLayout>
10. Create a class file for edit_product.xml and name it as [Link] and
fill it with following code. In the following code
[Link]
[Link]

-> First product id (pid) is read from the intent which is sent from listview.
-> A request is made to get_product_details.php and after getting product details in
json format, I parsed the json and displayed in EditText.
-> After displaying product data in the form if user clicks on Save Changes Button,
another HTTP request is made to update_product.php to store updated product data.
-> If the user selected Delete Product Button, HTTP request is made
to delete_product.php and product is deleted from mysql database, and listview is
refreshed with new product list.
[Link]
package [Link];

import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class EditProductActivity extends Activity {

    EditText txtName;
    EditText txtPrice;
    EditText txtDesc;
    EditText txtCreatedAt;
    Button btnSave;
    Button btnDelete;

    String pid;

    // Progress Dialog
    private ProgressDialog pDialog;

    // JSON parser class
    JSONParser jsonParser = new JSONParser();

    // single product url
    private static final String url_product_detials = "[Link]

    // url to update product
    private static final String url_update_product = "[Link]

[Link]
[Link]
    // url to delete product
    private static final String url_delete_product = "[Link]

    // JSON Node names
    private static final String TAG_SUCCESS = "success";
    private static final String TAG_PRODUCT = "product";
    private static final String TAG_PID = "pid";
    private static final String TAG_NAME = "name";
    private static final String TAG_PRICE = "price";
    private static final String TAG_DESCRIPTION = "description";

    @Override
    public void onCreate(Bundle savedInstanceState) {
        [Link](savedInstanceState);
        setContentView([Link].edit_product);

        // save button
        btnSave = (Button) findViewById([Link]);
        btnDelete = (Button) findViewById([Link]);

        // getting product details from intent
        Intent i = getIntent();

        // getting product id (pid) from intent
        pid = [Link](TAG_PID);

        // Getting complete product details in background thread
        new GetProductDetails().execute();

        // save button click event
        [Link](new [Link]() {

            @Override
            public void onClick(View arg0) {
                // starting background task to update product
                new SaveProductDetails().execute();
            }
        });

        // Delete button click event
        [Link](new [Link]() {

            @Override
            public void onClick(View arg0) {
                // deleting product in background thread
                new DeleteProduct().execute();
            }
        });

    }

    /**
     * Background Async Task to Get complete product details
     * */
[Link]
[Link]
    class GetProductDetails extends AsyncTask<String, String, String> {

        /**
         * Before starting background thread Show Progress Dialog
         * */
        @Override
        protected void onPreExecute() {
            [Link]();
            pDialog = new ProgressDialog([Link]);
            [Link]("Loading product details. Please wait...");
            [Link](false);
            [Link](true);
            [Link]();
        }

        /**
         * Getting product details in background thread
         * */
        protected String doInBackground(String... params) {

            // updating UI from Background Thread
            runOnUiThread(new Runnable() {
                public void run() {
                    // Check for success tag
                    int success;
                    try {
                        // Building Parameters
                        List<NameValuePair> params = new ArrayList<NameValuePair>();
                        [Link](new BasicNameValuePair("pid", pid));

                        // getting product details by making HTTP request
                        // Note that product details url will use GET request
                        JSONObject json = [Link](
                                url_product_detials, "GET", params);

                        // check your log for json response
                        Log.d("Single Product Details", [Link]());

                        // json success tag
                        success = [Link](TAG_SUCCESS);
                        if (success == 1) {
                            // successfully received product details
                            JSONArray productObj = json
                                    .getJSONArray(TAG_PRODUCT); // JSON Array

                            // get first product object from JSON Array
                            JSONObject product = [Link](0);

                            // product with this pid found
                            // Edit Text
                            txtName = (EditText) findViewById([Link]);
                            txtPrice = (EditText) findViewById([Link]);
                            txtDesc = (EditText) findViewById([Link]);

                            // display product data in EditText
[Link]
[Link]
                            [Link]([Link](TAG_NAME));
                            [Link]([Link](TAG_PRICE));
                            [Link]([Link](TAG_DESCRIPTION));

                        }else{
                            // product with pid not found
                        }
                    } catch (JSONException e) {
                        [Link]();
                    }
                }
            });

            return null;
        }

        /**
         * After completing background task Dismiss the progress dialog
         * **/
        protected void onPostExecute(String file_url) {
            // dismiss the dialog once got all details
            [Link]();
        }
    }

    /**
     * Background Async Task to Save product Details
     * */
    class SaveProductDetails extends AsyncTask<String, String, String> {

        /**
         * Before starting background thread Show Progress Dialog
         * */
        @Override
        protected void onPreExecute() {
            [Link]();
            pDialog = new ProgressDialog([Link]);
            [Link]("Saving product ...");
            [Link](false);
            [Link](true);
            [Link]();
        }

        /**
         * Saving product
         * */
        protected String doInBackground(String... args) {

            // getting updated data from EditTexts
            String name = [Link]().toString();
            String price = [Link]().toString();
            String description = [Link]().toString();

            // Building Parameters
            List<NameValuePair> params = new ArrayList<NameValuePair>();
[Link]
[Link]
            [Link](new BasicNameValuePair(TAG_PID, pid));
            [Link](new BasicNameValuePair(TAG_NAME, name));
            [Link](new BasicNameValuePair(TAG_PRICE, price));
            [Link](new BasicNameValuePair(TAG_DESCRIPTION, description));

            // sending modified data through http request
            // Notice that update product url accepts POST method
            JSONObject json = [Link](url_update_product,
                    "POST", params);

            // check json success tag
            try {
                int success = [Link](TAG_SUCCESS);

                if (success == 1) {
                    // successfully updated
                    Intent i = getIntent();
                    // send result code 100 to notify about product update
                    setResult(100, i);
                    finish();
                } else {
                    // failed to update product
                }
            } catch (JSONException e) {
                [Link]();
            }

            return null;
        }

        /**
         * After completing background task Dismiss the progress dialog
         * **/
        protected void onPostExecute(String file_url) {
            // dismiss the dialog once product uupdated
            [Link]();
        }
    }

    /*****************************************************************
     * Background Async Task to Delete Product
     * */
    class DeleteProduct extends AsyncTask<String, String, String> {

        /**
         * Before starting background thread Show Progress Dialog
         * */
        @Override
        protected void onPreExecute() {
            [Link]();
            pDialog = new ProgressDialog([Link]);
            [Link]("Deleting Product...");
            [Link](false);
            [Link](true);
            [Link]();
[Link]
[Link]
        }

        /**
         * Deleting product
         * */
        protected String doInBackground(String... args) {

            // Check for success tag
            int success;
            try {
                // Building Parameters
                List<NameValuePair> params = new ArrayList<NameValuePair>();
                [Link](new BasicNameValuePair("pid", pid));

                // getting product details by making HTTP request
                JSONObject json = [Link](
                        url_delete_product, "POST", params);

                // check your log for json response
                Log.d("Delete Product", [Link]());

                // json success tag
                success = [Link](TAG_SUCCESS);
                if (success == 1) {
                    // product successfully deleted
                    // notify previous activity by sending code 100
                    Intent i = getIntent();
                    // send result code 100 to notify about product deletion
                    setResult(100, i);
                    finish();
                }
            } catch (JSONException e) {
                [Link]();
            }

            return null;
        }

        /**
         * After completing background task Dismiss the progress dialog
         * **/
        protected void onPostExecute(String file_url) {
            // dismiss the dialog once product deleted
            [Link]();

        }

    }
}
[Link]
[Link]
[Link]
[Link]

JSON Parser Class

I used a JSON Parser class to get JSON from URL. This class supports two http
request methods GET and POST to get json from url.

[Link]
package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
[Link]
[Link]
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

public class JSONParser {

    static InputStream is = null;
    static JSONObject jObj = null;
    static String json = "";

    // constructor
    public JSONParser() {

    }

    // function get json from url
    // by making HTTP POST or GET mehtod
    public JSONObject makeHttpRequest(String url, String method,
            List<NameValuePair> params) {

        // Making HTTP request
        try {

            // check for request method
            if(method == "POST"){
                // request method is POST
                // defaultHttpClient
                DefaultHttpClient httpClient = new DefaultHttpClient();
                HttpPost httpPost = new HttpPost(url);
                [Link](new UrlEncodedFormEntity(params));

                HttpResponse httpResponse = [Link](httpPost);
                HttpEntity httpEntity = [Link]();
                is = [Link]();

            }else if(method == "GET"){
                // request method is GET
                DefaultHttpClient httpClient = new DefaultHttpClient();
                String paramString = [Link](params, "utf-8");
                url += "?" + paramString;
                HttpGet httpGet = new HttpGet(url);
[Link]
[Link]

                HttpResponse httpResponse = [Link](httpGet);
                HttpEntity httpEntity = [Link]();
                is = [Link]();
            }

        } catch (UnsupportedEncodingException e) {
            [Link]();
        } catch (ClientProtocolException e) {
            [Link]();
        } catch (IOException e) {
            [Link]();
        }

        try {
            BufferedReader reader = new BufferedReader(new InputStreamReader(
                    is, "iso-8859-1"), 8);
            StringBuilder sb = new StringBuilder();
            String line = null;
            while ((line = [Link]()) != null) {
                [Link](line + "\n");
            }
            [Link]();
            json = [Link]();
        } catch (Exception e) {
            Log.e("Buffer Error", "Error converting result " + [Link]());
        }

        // try parse the string to a JSON object
        try {
            jObj = new JSONObject(json);
        } catch (JSONException e) {
            Log.e("JSON Parser", "Error parsing data " + [Link]());
        }

        // return JSON String
        return jObj;

    }
}
Run your project and test the application. You might get lot of errors. Always use Log
Cat to debug your application, and if you couldn’t solve your errors please do comment
here.

Common questions

PHP scripts handle CRUD operations for the MySQL database and return JSON responses. Android applications communicate with these scripts over HTTP to perform operations like creating, reading, updating, and deleting products. Each operation typically involves sending data to a specific PHP endpoint and processing the JSON response to update the UI or handle errors .

Handling errors ensures that applications provide clear feedback to users and maintain data integrity. For example, if a product insertion fails, the JSON response indicates an error, guiding developers and users to investigate issues. Consistent error handling prevents undefined behaviors and helps maintain a stable user experience .

JSON responses are crucial for communicating the results of database operations to the front-end. They provide a structured format to relay success messages, product details, or error information, facilitating easy parsing and handling in client-side applications like those built with JavaScript or Android .

The JSON structure includes a 'success' key with a value of 1 and a 'product' key that contains an array of objects. Each object contains the product's 'pid', 'name', 'price', 'description', 'created_at', and 'updated_at' values .

PHP checks if the query result is non-empty and verifies the number of rows returned using mysql_num_rows(). If the result set contains more than zero rows, it fetches and processes data for successful JSON responses. Otherwise, it signals that no matching entries were found .

The example uses mysql_affected_rows() to check if any row was deleted. If so, it sets a 'success' flag in the JSON response to 1 and provides a success message. If no rows were affected, it indicates that no product was found, setting 'success' to 0 .

Asynchronous tasks prevent blocking the main UI thread, thus maintaining application responsiveness during network operations. By structuring code to handle HTTP requests asynchronously, apps can provide feedback to users via progress dialogs, handle partial operations, and ensure a smooth user experience, even if network latencies occur .

JSON parsing in Android allows developers to decode server responses and translate them into manageable data objects within the application. This ensures data integrity across various operations like displaying lists or updating records, facilitating seamless interaction between the app UI and backend services .

Updating a product involves collecting new values for fields via POST and executing an SQL UPDATE query. However, without prepared statements, directly concatenating input into SQL queries poses a significant security risk as it allows for SQL injection attacks . Prepared statements separate SQL code from data input, which would mitigate this risk and enhance security.

To create a new product, first, ensure required fields like 'name', 'price', and 'description' are set via POST request. Use the db_connect.php class to establish a database connection. Use an SQL INSERT query to add a new row in the products table. Finally, return a JSON response indicating success or failure .

PHP & MySQL CRUD Operations Guide
No ratings yet
PHP & MySQL CRUD Operations Guide
4 pages
Android-PHP-MySQL Connection Guide
100% (1)
Android-PHP-MySQL Connection Guide
48 pages
Android MySQL CRUD Operations Guide
100% (3)
Android MySQL CRUD Operations Guide
24 pages
Android MySQL Integration Guide
No ratings yet
Android MySQL Integration Guide
23 pages
Database Helper
100% (3)
Database Helper
8 pages
SQLite Student Data Management App
No ratings yet
SQLite Student Data Management App
5 pages
Android Database CRUD Operations
No ratings yet
Android Database CRUD Operations
7 pages
Info Power Manual
No ratings yet
Info Power Manual
337 pages
PHP Basics: Variables, Functions, and Arrays
No ratings yet
PHP Basics: Variables, Functions, and Arrays
50 pages
XML and DataWindow in PowerBuilder 9.0
No ratings yet
XML and DataWindow in PowerBuilder 9.0
35 pages
Android Image Upload with PHP MySQL
100% (2)
Android Image Upload with PHP MySQL
23 pages
SQL vs MySQL: Key Differences Explained
No ratings yet
SQL vs MySQL: Key Differences Explained
30 pages
Android SQLite CRUD Operations Guide
No ratings yet
Android SQLite CRUD Operations Guide
20 pages
Django CRUD Function-Based Views Guide
No ratings yet
Django CRUD Function-Based Views Guide
8 pages
PHP MySQL Integration Guide
No ratings yet
PHP MySQL Integration Guide
44 pages
Firebase CRUD App with Kotlin Guide
No ratings yet
Firebase CRUD App with Kotlin Guide
11 pages
JavaScript Cache API for PWAs
No ratings yet
JavaScript Cache API for PWAs
7 pages
Android Persistent Data Storage Overview
No ratings yet
Android Persistent Data Storage Overview
74 pages
Sqlite PHP: Installation
No ratings yet
Sqlite PHP: Installation
8 pages
Firebase Database Overview and CRUD Guide
No ratings yet
Firebase Database Overview and CRUD Guide
12 pages
SQLite Database Management in Android
No ratings yet
SQLite Database Management in Android
8 pages
Android SQLite Database Tutorial
No ratings yet
Android SQLite Database Tutorial
11 pages
MySQL Database Management Overview
No ratings yet
MySQL Database Management Overview
43 pages
SQLite With Xamarin Forms Step by Step Guide
No ratings yet
SQLite With Xamarin Forms Step by Step Guide
14 pages
Building an Event Management App with Firebase
No ratings yet
Building an Event Management App with Firebase
68 pages
Simple Android CRUD Application Guide
No ratings yet
Simple Android CRUD Application Guide
19 pages
Understanding Android Architecture and DVM
No ratings yet
Understanding Android Architecture and DVM
8 pages
Android Toast Examples and Usage
No ratings yet
Android Toast Examples and Usage
119 pages
Connecting To Your Database For PB
No ratings yet
Connecting To Your Database For PB
422 pages
MySQL PDO Scripting with PHP Guide
No ratings yet
MySQL PDO Scripting with PHP Guide
11 pages
Yi I 2 For Beginners
0% (1)
Yi I 2 For Beginners
695 pages
Konseptual Database Struktur dan Relasi
No ratings yet
Konseptual Database Struktur dan Relasi
3 pages
Student Registration CRUD Example
No ratings yet
Student Registration CRUD Example
20 pages
SQLite3 Command Line Cheat Sheet
No ratings yet
SQLite3 Command Line Cheat Sheet
2 pages
Database Basics: SQL and Tables Guide
No ratings yet
Database Basics: SQL and Tables Guide
169 pages
PHP MySQL CRUD Operations Example
No ratings yet
PHP MySQL CRUD Operations Example
18 pages
PLSQL Manual
No ratings yet
PLSQL Manual
150 pages
GlideRecord JavaScript API Overview
No ratings yet
GlideRecord JavaScript API Overview
178 pages
JSP Servlet CRUD Operations Guide
100% (1)
JSP Servlet CRUD Operations Guide
10 pages
IBM I DB2 Web Query For I Version 2.1 Implementation Guide
100% (2)
IBM I DB2 Web Query For I Version 2.1 Implementation Guide
880 pages
Kotlin SQLite Database Example
No ratings yet
Kotlin SQLite Database Example
10 pages
Adding Subcollections in Firestore
No ratings yet
Adding Subcollections in Firestore
9 pages
PostgreSQL Database Partitioning Guide
No ratings yet
PostgreSQL Database Partitioning Guide
8 pages
Android Application Project Report
No ratings yet
Android Application Project Report
66 pages
ASP.NET 2.0 Web Development Guide
No ratings yet
ASP.NET 2.0 Web Development Guide
43 pages
Upgrading to SQL Server 2016 Features
No ratings yet
Upgrading to SQL Server 2016 Features
27 pages
Messagemedia SMS PHP API Guide
No ratings yet
Messagemedia SMS PHP API Guide
15 pages
SQLite Usage in Android Apps
No ratings yet
SQLite Usage in Android Apps
9 pages
PostgreSQL Stored Procedures Overview
No ratings yet
PostgreSQL Stored Procedures Overview
15 pages
ORM vs ODM: Key Differences Explained
No ratings yet
ORM vs ODM: Key Differences Explained
77 pages
SQL Server Database Mirroring Overview
No ratings yet
SQL Server Database Mirroring Overview
4 pages
JDBC: Connecting Java to Databases
No ratings yet
JDBC: Connecting Java to Databases
39 pages
Flutter-Laravel Authentication Guide
No ratings yet
Flutter-Laravel Authentication Guide
28 pages
Unity 3.0 and MySQL Integration Guide
No ratings yet
Unity 3.0 and MySQL Integration Guide
30 pages
Android MySQL Integration Example
No ratings yet
Android MySQL Integration Example
63 pages
Integrating PHP & MySQL in Android Apps
No ratings yet
Integrating PHP & MySQL in Android Apps
15 pages
PHP MySQL Database Connection Guide
No ratings yet
PHP MySQL Database Connection Guide
32 pages
Unit 3 Notes
No ratings yet
Unit 3 Notes
126 pages
Form and Table
No ratings yet
Form and Table
4 pages
Salesforce Migration Guide
No ratings yet
Salesforce Migration Guide
44 pages
IPXACT-2022 User Guide
No ratings yet
IPXACT-2022 User Guide
71 pages
SOA Components and Cloud BPM Insights
No ratings yet
SOA Components and Cloud BPM Insights
14 pages
Perl SAX XML Parsing Techniques
No ratings yet
Perl SAX XML Parsing Techniques
14 pages
zenon Import-Export Manual v8.20
No ratings yet
zenon Import-Export Manual v8.20
62 pages
XSLT Guide for SAP CPI Users
No ratings yet
XSLT Guide for SAP CPI Users
9 pages
Aveva Engineer Setup Guide by Scaringi
No ratings yet
Aveva Engineer Setup Guide by Scaringi
58 pages
Understanding Meta Data
100% (1)
Understanding Meta Data
20 pages
ACOPOS Error Codes and Troubleshooting Guide
No ratings yet
ACOPOS Error Codes and Troubleshooting Guide
283 pages
ServiceNow Web Services Integration Guide
No ratings yet
ServiceNow Web Services Integration Guide
5 pages
Social Thought in Indic Civilization 1st Edition Himanshu Roy (Editor) Ebook Pro Digital Version
100% (2)
Social Thought in Indic Civilization 1st Edition Himanshu Roy (Editor) Ebook Pro Digital Version
61 pages
Upgrading from FOP 0.20.5 Guide
No ratings yet
Upgrading from FOP 0.20.5 Guide
3 pages
Agri Help: Mobile App for Farmers
No ratings yet
Agri Help: Mobile App for Farmers
151 pages
Magento Request Flow Basics
100% (1)
Magento Request Flow Basics
170 pages
Android User Interface Elements Guide
No ratings yet
Android User Interface Elements Guide
23 pages
CWAAP: Web App & API Security Guide
No ratings yet
CWAAP: Web App & API Security Guide
66 pages
Understanding XML Structure and Schema
No ratings yet
Understanding XML Structure and Schema
29 pages
DBMS Question Bank for CS3492
No ratings yet
DBMS Question Bank for CS3492
26 pages
Excel Functions and Features Quiz
No ratings yet
Excel Functions and Features Quiz
47 pages
SOAP and WSDL in Web Service Integration
No ratings yet
SOAP and WSDL in Web Service Integration
12 pages
ADM Broadcast Production Profile Overview
No ratings yet
ADM Broadcast Production Profile Overview
26 pages
Eplan Eldons
No ratings yet
Eplan Eldons
10 pages
SAP PI Currency Update Interface Spec
No ratings yet
SAP PI Currency Update Interface Spec
10 pages
HFM 11.1.2.2.300 Bug Inquiry
No ratings yet
HFM 11.1.2.2.300 Bug Inquiry
30 pages
Amazon STT Style Guide for Spanish
100% (1)
Amazon STT Style Guide for Spanish
21 pages
Bysoft CAM Interface Specification
No ratings yet
Bysoft CAM Interface Specification
24 pages
XML Data Model & Three-Tier Architecture
No ratings yet
XML Data Model & Three-Tier Architecture
27 pages
Modding Framework Initialization Log
No ratings yet
Modding Framework Initialization Log
6 pages
Module 10 Cloud Automation
No ratings yet
Module 10 Cloud Automation
28 pages
Zen Cart
No ratings yet
Zen Cart
6 pages

Android PHP MySQL Connection Guide

Uploaded by

Android PHP MySQL Connection Guide

Uploaded by

[Link]

3. Creating and Running PHP Project

4. Creating MySQL Database and Tables

CREATE DATABASE androidhive;

5. Connecting to MySQL database using PHP

6. Basic MySQL CRUD Operations using PHP

6.a) Creating a row in MySQL (Creating a new product row)

When POST param(s) is missing

6.b) Reading a Row from MySQL (Reading product details)

When successfully getting product details

6.c) Reading All Rows from MySQL (Reading all products)

Listing all Products

6.d) Updating a Row in MySQL (Updating product details)

6.e) Deleting a Row in MySQL (Deleting a product)

7. Creating Android Application

Displaying All Products in ListView (Read)

Adding a New Product (Write)

Reading, Updating and Deleting a Single Product

JSON Parser Class

Common questions

Describe the integration between PHP scripts and Android applications for CRUD operations on a MySQL database.

Discuss how handling errors in MySQL operations can improve application reliability for CRUD processes?

Explain the role that JSON responses play in PHP applications interacting with MySQL databases?

What is the JSON structure of the response when fetching details of a successfully found product by its ID from a MySQL database using PHP?

In the context of the provided documentation, how does PHP handle conditional logic to verify the existence of MySQL query results?

How does the provided PHP example ensure that a product deletion from MySQL returns accurate feedback?

What are the advantages of structuring mobile application code to handle multiple HTTP requests in separate asynchronous tasks, as demonstrated in Android development?

How does the use of JSON parsing in Android contribute to effective data handling in CRUD applications?

How does the process of updating a product in a MySQL database highlight the importance of using prepared statements to avoid SQL injection?

What are the key steps involved in creating a new product in a MySQL database using PHP?

You might also like