We are going see how to make a very simple Android app (in our case, a product inventory app) that will call a PHP script to perform basic CRUD(Create, Read, Update, Delete) operations. To brief you on the architecture, this is how it works. First your android app calls a PHP script in order to perform a data operation, lets say “create”. The PHP script then connects to your MySQL database to perform the operation.
So the data flows from your Android app to PHP script then finally is stored in your MySQL database. Allright, lets dig deeper.
1. What is WAMP Server
WAMP is acronym for Windows, Apache, MySQL and PHP, Perl, Python. WAMP software is one click installer which creates an environment for developing PHP, MySQL web application. By installing this software you will be installing Apache, MySQL and PHP. Alternatively you can use XAMP Server also.
2. Installing and Running WAMP Server
Download & Install WAMP server from www.wampserver.com/en/. Once you have installed wamp server, launch the program from Start -> All Programs -> WampServer -> StartWampServer.
You can test your server by opening the address http://localhost/ in your browser.
Also you can check phpmyadmin by opening http://localhost/phpmyadmin
Following is a screen cast of Downloading and Installing WAMP Server.
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 test.php and try out simple php code. After placing following code try to open http://localhost/android_connect/test.php and you should see a message called “Welcome, I am connecting Android to PHP, MySQL“.
test.php
<?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 http://localhost/phpmyadmin/ in 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
<?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
<?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(); } } ?>
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.
<?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', '$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); } ?>
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.
<?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); } } 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.
<?php /* * Following code will list all the products */ // 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", "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.
<?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 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', 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); } ?>
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.
<?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 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
{ "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 AndroidManifest.xml 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.
<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.example.androidhive" 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="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> <!-- All Product Activity --> <activity android:name=".AllProductsActivity" android:label="All Products" > </activity> <!-- Add Product Activity --> <activity android:name=".NewProductActivity" android:label="Add New Product" > </activity> <!-- Edit Product Activity --> <activity android:name=".EditProductActivity" android:label="Edit Product" > </activity> </application> <!-- Internet Permissions --> <uses-permission android:name="android.permission.INTERNET" /> </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.
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="vertical" android:gravity="center_horizontal"> <!-- Sample Dashboard screen with Two buttons --> <!-- Button to view all products screen --> <Button android:id="@+id/btnViewProducts" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="View Products" android:layout_marginTop="25dip"/> <!-- Button to create a new product screen --> <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 MainScreenActivity.java and write click events for two button which are mentioned in main_screen.xml layout.
package com.example.androidhive; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.Button; public class MainScreenActivity extends Activity{ Button btnViewProducts; Button btnNewProduct; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main_screen); // Buttons btnViewProducts = (Button) findViewById(R.id.btnViewProducts); btnNewProduct = (Button) findViewById(R.id.btnCreateProduct); // view products click event btnViewProducts.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { // Launching All products Activity Intent i = new Intent(getApplicationContext(), AllProductsActivity.class); startActivity(i); } }); // view products click event btnNewProduct.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { // Launching create new product activity Intent i = new Intent(getApplicationContext(), NewProductActivity.class); 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
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="vertical"> <!-- Main ListView Always give id value as list(@android:id/list) --> <ListView android:id="@android:id/list" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout>
list_item.xml
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="vertical" > <!-- Product id (pid) - will be HIDDEN - used to pass to other activity --> <TextView android:id="@+id/pid" android:layout_width="fill_parent" android:layout_height="wrap_content" android:visibility="gone" /> <!-- Name Label --> <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 AllProductsActivity.java. 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.
package com.example.androidhive; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import org.apache.http.NameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.ListActivity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.TextView; 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 = "https://api.androidhive.info/android_connect/get_all_products.php"; // 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) { super.onCreate(savedInstanceState); setContentView(R.layout.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 lv.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { // getting values from selected ListItem String pid = ((TextView) view.findViewById(R.id.pid)).getText() .toString(); // Starting new intent Intent in = new Intent(getApplicationContext(), EditProductActivity.class); // sending pid to next activity in.putExtra(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) { super.onActivityResult(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() { super.onPreExecute(); pDialog = new ProgressDialog(AllProductsActivity.this); pDialog.setMessage("Loading products. Please wait..."); pDialog.setIndeterminate(false); pDialog.setCancelable(false); pDialog.show(); } /** * getting All products from url * */ protected String doInBackground(String... args) { // Building Parameters List<NameValuePair> params = new ArrayList<NameValuePair>(); // getting JSON string from URL JSONObject json = jParser.makeHttpRequest(url_all_products, "GET", params); // Check your log cat for JSON reponse Log.d("All Products: ", json.toString()); try { // Checking for SUCCESS TAG int success = json.getInt(TAG_SUCCESS); if (success == 1) { // products found // Getting Array of Products products = json.getJSONArray(TAG_PRODUCTS); // looping through All Products for (int i = 0; i < products.length(); i++) { JSONObject c = products.getJSONObject(i); // Storing each json item in variable String id = c.getString(TAG_PID); String name = c.getString(TAG_NAME); // creating new HashMap HashMap<String, String> map = new HashMap<String, String>(); // adding each child node to HashMap key => value map.put(TAG_PID, id); map.put(TAG_NAME, name); // adding HashList to ArrayList productsList.add(map); } } else { // no products found // Launch Add New product Activity Intent i = new Intent(getApplicationContext(), NewProductActivity.class); // Closing all previous activities i.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP); startActivity(i); } } catch (JSONException e) { e.printStackTrace(); } return null; } /** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog after getting all products pDialog.dismiss(); // updating UI from Background Thread runOnUiThread(new Runnable() { public void run() { /** * Updating parsed JSON data into ListView * */ ListAdapter adapter = new SimpleAdapter( AllProductsActivity.this, productsList, R.layout.list_item, new String[] { TAG_PID, TAG_NAME}, new int[] { R.id.pid, R.id.name }); // updating listview setListAdapter(adapter); } }); } } }
Adding a New Product (Write)
7. Create a new view and acivity 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
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" > <!-- Name Label --> <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"/> <!-- Input Name --> <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"/> <!-- Price Label --> <TextView android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="Price" android:paddingLeft="10dip" android:paddingRight="10dip" android:paddingTop="10dip" android:textSize="17dip"/> <!-- Input Price --> <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"/> <!-- Description Label --> <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"/> <!-- Input description --> <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 Create Product --> <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 NewProductActivity.java 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.
package com.example.androidhive; import java.util.ArrayList; import java.util.List; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.EditText; 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 = "https://api.androidhive.info/android_connect/create_product.php"; // JSON Node names private static final String TAG_SUCCESS = "success"; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.add_product); // Edit Text inputName = (EditText) findViewById(R.id.inputName); inputPrice = (EditText) findViewById(R.id.inputPrice); inputDesc = (EditText) findViewById(R.id.inputDesc); // Create button Button btnCreateProduct = (Button) findViewById(R.id.btnCreateProduct); // button click event btnCreateProduct.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { // creating new product in background thread new CreateNewProduct().execute(); } }); } /** * 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() { super.onPreExecute(); pDialog = new ProgressDialog(NewProductActivity.this); pDialog.setMessage("Creating Product.."); pDialog.setIndeterminate(false); pDialog.setCancelable(true); pDialog.show(); } /** * Creating product * */ protected String doInBackground(String... args) { String name = inputName.getText().toString(); String price = inputPrice.getText().toString(); String description = inputDesc.getText().toString(); // Building Parameters List<NameValuePair> params = new ArrayList<NameValuePair>(); params.add(new BasicNameValuePair("name", name)); params.add(new BasicNameValuePair("price", price)); params.add(new BasicNameValuePair("description", description)); // getting JSON Object // Note that create product url accepts POST method JSONObject json = jsonParser.makeHttpRequest(url_create_product, "POST", params); // check log cat fro response Log.d("Create Response", json.toString()); // check for success tag try { int success = json.getInt(TAG_SUCCESS); if (success == 1) { // successfully created product Intent i = new Intent(getApplicationContext(), AllProductsActivity.class); startActivity(i); // closing this screen finish(); } else { // failed to create product } } catch (JSONException e) { e.printStackTrace(); } return null; } /** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog once done pDialog.dismiss(); } } }
Reading, Updating and Deleting a Single Product
9. If you notice the AllProductsActivity.java, In listview i am launching EditProductAcivity.java 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
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" > <!-- Name Label --> <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"/> <!-- Input Name --> <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"/> <!-- Price Label --> <TextView android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="Price" android:paddingLeft="10dip" android:paddingRight="10dip" android:paddingTop="10dip" android:textSize="17dip"/> <!-- Input Price --> <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"/> <!-- Description Label --> <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"/> <!-- Input description --> <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 Create Product --> <Button android:id="@+id/btnSave" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="Save Changes" android:layout_weight="1"/> <!-- Button Create Product --> <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 EditProductActivity.java and fill it with following code. In the following code
-> 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.
package com.example.androidhive; import java.util.ArrayList; import java.util.List; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.EditText; 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 = "https://api.androidhive.info/android_connect/get_product_details.php"; // url to update product private static final String url_update_product = "https://api.androidhive.info/android_connect/update_product.php"; // url to delete product private static final String url_delete_product = "https://api.androidhive.info/android_connect/delete_product.php"; // 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) { super.onCreate(savedInstanceState); setContentView(R.layout.edit_product); // save button btnSave = (Button) findViewById(R.id.btnSave); btnDelete = (Button) findViewById(R.id.btnDelete); // getting product details from intent Intent i = getIntent(); // getting product id (pid) from intent pid = i.getStringExtra(TAG_PID); // Getting complete product details in background thread new GetProductDetails().execute(); // save button click event btnSave.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View arg0) { // starting background task to update product new SaveProductDetails().execute(); } }); // Delete button click event btnDelete.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View arg0) { // deleting product in background thread new DeleteProduct().execute(); } }); } /** * Background Async Task to Get complete product details * */ class GetProductDetails extends AsyncTask<String, String, String> { /** * Before starting background thread Show Progress Dialog * */ @Override protected void onPreExecute() { super.onPreExecute(); pDialog = new ProgressDialog(EditProductActivity.this); pDialog.setMessage("Loading product details. Please wait..."); pDialog.setIndeterminate(false); pDialog.setCancelable(true); pDialog.show(); } /** * 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>(); params.add(new BasicNameValuePair("pid", pid)); // getting product details by making HTTP request // Note that product details url will use GET request JSONObject json = jsonParser.makeHttpRequest( url_product_detials, "GET", params); // check your log for json response Log.d("Single Product Details", json.toString()); // json success tag success = json.getInt(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 = productObj.getJSONObject(0); // product with this pid found // Edit Text txtName = (EditText) findViewById(R.id.inputName); txtPrice = (EditText) findViewById(R.id.inputPrice); txtDesc = (EditText) findViewById(R.id.inputDesc); // display product data in EditText txtName.setText(product.getString(TAG_NAME)); txtPrice.setText(product.getString(TAG_PRICE)); txtDesc.setText(product.getString(TAG_DESCRIPTION)); }else{ // product with pid not found } } catch (JSONException e) { e.printStackTrace(); } } }); return null; } /** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog once got all details pDialog.dismiss(); } } /** * 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() { super.onPreExecute(); pDialog = new ProgressDialog(EditProductActivity.this); pDialog.setMessage("Saving product ..."); pDialog.setIndeterminate(false); pDialog.setCancelable(true); pDialog.show(); } /** * Saving product * */ protected String doInBackground(String... args) { // getting updated data from EditTexts String name = txtName.getText().toString(); String price = txtPrice.getText().toString(); String description = txtDesc.getText().toString(); // Building Parameters List<NameValuePair> params = new ArrayList<NameValuePair>(); params.add(new BasicNameValuePair(TAG_PID, pid)); params.add(new BasicNameValuePair(TAG_NAME, name)); params.add(new BasicNameValuePair(TAG_PRICE, price)); params.add(new BasicNameValuePair(TAG_DESCRIPTION, description)); // sending modified data through http request // Notice that update product url accepts POST method JSONObject json = jsonParser.makeHttpRequest(url_update_product, "POST", params); // check json success tag try { int success = json.getInt(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) { e.printStackTrace(); } return null; } /** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog once product uupdated pDialog.dismiss(); } } /***************************************************************** * Background Async Task to Delete Product * */ class DeleteProduct extends AsyncTask<String, String, String> { /** * Before starting background thread Show Progress Dialog * */ @Override protected void onPreExecute() { super.onPreExecute(); pDialog = new ProgressDialog(EditProductActivity.this); pDialog.setMessage("Deleting Product..."); pDialog.setIndeterminate(false); pDialog.setCancelable(true); pDialog.show(); } /** * Deleting product * */ protected String doInBackground(String... args) { // Check for success tag int success; try { // Building Parameters List<NameValuePair> params = new ArrayList<NameValuePair>(); params.add(new BasicNameValuePair("pid", pid)); // getting product details by making HTTP request JSONObject json = jsonParser.makeHttpRequest( url_delete_product, "POST", params); // check your log for json response Log.d("Delete Product", json.toString()); // json success tag success = json.getInt(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) { e.printStackTrace(); } return null; } /** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog once product deleted pDialog.dismiss(); } } }
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.
package com.example.androidhive; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.UnsupportedEncodingException; import java.util.List; import org.apache.http.HttpEntity; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.ClientProtocolException; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.client.utils.URLEncodedUtils; import org.apache.http.impl.client.DefaultHttpClient; import org.json.JSONException; import org.json.JSONObject; import android.util.Log; 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); httpPost.setEntity(new UrlEncodedFormEntity(params)); HttpResponse httpResponse = httpClient.execute(httpPost); HttpEntity httpEntity = httpResponse.getEntity(); is = httpEntity.getContent(); }else if(method == "GET"){ // request method is GET DefaultHttpClient httpClient = new DefaultHttpClient(); String paramString = URLEncodedUtils.format(params, "utf-8"); url += "?" + paramString; HttpGet httpGet = new HttpGet(url); HttpResponse httpResponse = httpClient.execute(httpGet); HttpEntity httpEntity = httpResponse.getEntity(); is = httpEntity.getContent(); } } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (ClientProtocolException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } try { BufferedReader reader = new BufferedReader(new InputStreamReader( is, "iso-8859-1"), 8); StringBuilder sb = new StringBuilder(); String line = null; while ((line = reader.readLine()) != null) { sb.append(line + "\n"); } is.close(); json = sb.toString(); } catch (Exception e) { Log.e("Buffer Error", "Error converting result " + e.toString()); } // try parse the string to a JSON object try { jObj = new JSONObject(json); } catch (JSONException e) { Log.e("JSON Parser", "Error parsing data " + e.toString()); } // 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.
Hi there! I am Founder at androidhive and programming enthusiast. My skills includes Android, iOS, PHP, Ruby on Rails and lot more. If you have any idea that you would want me to develop? Let’s talk: ravi@androidhive.info
How did you get the URL? and does your codes are available to android version 4.4 above?
yourservername/databasename/filename.php
everything is working fine but not able to fetch records in android
when i test the php file this message is shown “”Oops! An error occurred.” .. i can’t insert any row,, how i fix that ??
Check Log Cat or apache log cat for php errors
Error parsing data org.json.JSONException: Value <!DOCTYPE of type java.lang.String cannot be converted to JSONObject
07-30 01:03:49.048: E/JSON Parser(12422): Error parsing data org.json.JSONException: Value <!DOCTYPE of type java.lang.String cannot be converted to JSONObject
07-30 01:03:49.048: E/JSON Parser(12422): Error parsing data org.json.JSONException: Value <!DOCTYPE of type java.lang.String cannot be converted to JSONObject
07-30 01:03:49.048: W/dalvikvm(12422): threadid=12: thread exiting with uncaught exception (group=0x41707bc0)
07-30 01:03:49.048: E/AndroidRuntime(12422): FATAL EXCEPTION: AsyncTask #1
07-30 01:03:49.048: E/AndroidRuntime(12422): Process: com.example.androidhive, PID: 12422
07-30 01:03:49.048: E/AndroidRuntime(12422): java.lang.RuntimeException: An error occured while executing doInBackground()
07-30 01:03:49.048: E/AndroidRuntime(12422): at android.os.AsyncTask$3.done(AsyncTask.java:300)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.util.concurrent.FutureTask.setException(FutureTask.java:222)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.util.concurrent.FutureTask.run(FutureTask.java:242)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
07-30 01:03:49.048: E/AndroidRuntime(12422): at java.lang.Thread.run(Thread.java:841)
07-30 01:03:49.048: E/AndroidRuntime(12422): Caused by: java.lang.NullPointerException
07-30 01:03:49.048: E/AndroidRuntime(12422): at com.example.androidhive.NewProductActivity$CreateNewProduct.doInBackground(NewProductActivity.java:99)
07-30 01:03:49.048: E/AndroidRuntime(12422): at com.example.androidhive.NewProductActivity$CreateNewProduct.doInBackground(NewProductActivity.java:1)
Seems you have php errors. Ht the urls from postman to see the errors (php error reporting)
Hi Ravi.. after using the postman on create_product file postman say’s {“success”: 0, “message” : “Required field(S) is missing”}
On my logcat it points out
Error Parsing data.org.json.JSONException: Value<!DOCTYPE of type java.lang.String cannot be converted to JSONObject
It points out on CreateNewProduct.doInBackground in line 99
Which is
Log.d("Create Response", json.toString());
I think almost everyone got the same issue on the CreateNewProduct as well as the GetAllProducts
Check raw response in postman. There might be php errors.
Ive seen the problem Ravi, thats why the parser returns<!Doctype because the response in postman is this:
the warning causes the response to throw an error,..
It say Deprecated mysql functions
What will we place at the place of URL
// single product url
private static final String url_product_detials = “https://api.androidhive.info/android_connect/get_product_details.php”;
// url to update product
private static final String url_update_product = “https://api.androidhive.info/android_connect/update_product.php”;
// url to delete product
private static final String url_delete_product = “https://api.androidhive.info/android_connect/delete_product.php”;
use your IPV4 Address instead of androidhive.inf…
example: http://192.168.4.123/android_connect/.php
Hi Ravi! I got a question. Instead of displaying at listview, can I display the data in a textview?can you share the code to do so?
Hello Ravi, i found this tutorial extremely useful. I have a question, what are the asyncTask String parameters for? Has to do anything with the name, price, description?
I’ve got another problem. In the create_product file, the isset condition for the variables in the if loop are never true. I get {“success”:0,”message”:”Required field(s) is missing”}.
Actually, none of the fields are missing, but it seems that i can’t successfully set the values for the variables.
I tried print_r ($_POST); but all i get is: Array(), i saw a lot of people had this problem, but i couldn’t get anything helpful to solve the problem. I’ve been stacked with this a lot of time. I hope you can help me! Thanks!
Hello. I have the same problem. Did you find the solution?
Hello Antigoni, after some google searches i was able to make it work. Here’s the code:
$response = array();
$response[“success”] = 0;
$response[“message”] = “No products found”;
require_once __DIR__ . ‘/db_connect.php’;
$name = $_POST[‘name’];
$price = $_POST[‘price’];
$description = $_POST[‘description’];
$db = new DB_CONNECT();
$dbh = $db->connect(); // here you get the connection
$query = “INSERT INTO products (name, price, description) VALUES(‘$name’, ‘$price’, ‘$description’)”;
$stmt = $dbh->prepare($query);
$stmt->bindParam(‘:name’, $name, PDO::PARAM_STR);
$stmt->bindParam(‘:price’, $price, PDO::PARAM_STR);
$stmt->bindParam(‘:description’, $description, PDO::PARAM_STR);
$dbh = $stmt->execute(array(“:name”=>$name,”:price”=>$price,”:description”=>$description));
if($dbh){
$response[“success”] = 1;
}else {
}
?>
Note that i’m using pdo because the mysql functions are deprecated, so you have to modify the db_connect file, otherwise this won’t work either.
Hello, the app closes instantly after opening it, any idea why? i get no errors when i try start the app. Thanks
PS: I try to start the app on my Phone (HTC One M9)
Thanks again for well written article.
This is exactly I need for. After fix some errors, finally I can run it in AVD.
But application just crash everytime sistem call any function, such as view products or add new products.
With dummy data I’ve added to the table, still the app crash when click on view products button.
Any Idea?
Since the mysql functions were deprecated the response would be html type thats why everybody got those errors
can you plz mention here which codes need to change
Do you mean the errors in the JParser? If so, why would there be an error if i’m encoding the responses as JSON in the PHP files.
Hi Mr. Ravi,
Actually i wanted to learn database connectivity using php and mysql in android so tried the above code but i am getting errors in the following activities 1.NewProductActivity.java and 2.EditProductActivity.java
(in doInBackground method) it is saying that
Method getText must be called from the UI thread, currently inferred thread is worker
Here is the code EditProductActivity.java
class SaveProductDetails extends AsyncTask{
@Override
protected void onPreExecute() {
super.onPreExecute();
super.onPreExecute();
pDialog = new ProgressDialog(EditProductActivity.this);
pDialog.setMessage(“Saving product …”);
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();
}
@Override
protected String doInBackground(String… args) {
String name = txtName.getText().toString();
String price = txtPrice.getText().toString();
String description = txtDesc.getText().toString();
List params = new ArrayList();
params.add(new BasicNameValuePair(TAG_PID,pid));
params.add(new BasicNameValuePair(TAG_NAME,name));
params.add(new BasicNameValuePair(TAG_PRICE,price));
params.add(new BasicNameValuePair(TAG_DESCRIPTION,description));
JSONObject json = JSONParser.makeHttpRequest(url_update_product,”POST”,params);
try {
int success = json.getInt(TAG_SUCCESS);
if (success == 1){
Intent i = getIntent();
setResult(100,i);
finish();
}else{
Toast.makeText(getApplicationContext(),”Failed to save product details, Try Again!!!”,Toast.LENGTH_LONG).show();
}
} catch (JSONException e) {
e.printStackTrace();
}
return null;
}
__________________________________________________________________________________________________________________________________________________________________________
NewProductActivity.java
class CreateNewProduct extends AsyncTask{
@Override
protected void onPreExecute() {
super.onPreExecute();
pDialog = new ProgressDialog(NewProductActivity.this);
pDialog.setMessage(“Creating Product..”);
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();
}
@Override
protected String doInBackground(String… args) {
String name = inputName.getText().toString();
String price = inputPrice.getText().toString();
String description = inputDesc.getText().toString();
List params = new ArrayList();
params.add(new BasicNameValuePair(“name”,name));
params.add(new BasicNameValuePair(“price”,price));
params.add(new BasicNameValuePair(“description”,description));
JSONObject json = jsonParser.makeHttpRequest(url_create_product,”POST”,params);
Log.d(“Create Responnce”,json.toString());
try {
int success = json.getInt(TAG_SUCCESS);
if (success == 1){
Intent i = new Intent(getApplicationContext(),AllProductsActivity.class);
startActivity(i);
finish();
}else {
Toast.makeText(getApplicationContext(),”Failed to create product,Try Again”,Toast.LENGTH_LONG).show();
}
} catch (JSONException e) {
e.printStackTrace();
}
return null;
}
how to resolve this error.
Thanks in Advance.
Swapnil Janrao.
you can find me at swapneel.janrao@gmail.com
Okay. Call whatever UI methods used, in runOnUiThread method or move them to onPostExecute method. Basically you can’t update the UI from background thread.
https://stackoverflow.com/questions/11140285/how-to-use-runonuithread
Thank you. Can u suggest any tutorial for PDO because I am a beginner? Thanks!
Mmm… didn’t use any specific tutorial to make that file, just the PDO documentation from the PHP website.
But there are a lot of tutorials and documentation available searching in google.
Hi Pau, can you post your connect.php code that uses PDO? thanks,
Dear,
i tried above code into android studio. and list product and add product is work. but the get product detail can’t run. i think the problem is allproductactivity can’t send the “pid” to editproductactivity. i tried create new activity for receive the “pid”. But still fail. So i think the “pid” is not send to editproductactivity.
You can echo the post / get params in php script to see if they are actually received or not.
i tried use toast show the “pid” into listproduct activity is ok. and then, i tried create new activity to receive the “pid”. but still fail.
http://localhost/phpmyadmin/ wants to be login,what can i do
if you’re using wampp it’s probably because you need to use the username: root and no password. this is the DEFAULT login unless you change it.
by deafult the username is ‘ root ‘ and it has no password.
Hola que tal mi nombre es leo castro soy diseñador de aplicaciones android novato y solicito de tu ayuda para una aplicacion basada en coordenas lo que necesito es que me muestre mi ubicacion actual y queme permita gusrdar los datos en un grid para poderlos posteriormente pasarlos a google map y tener mi ruta de clientes georeferenciada me podrias ayudar mi correo es leopoldo.ernestoc@gmail.com whatsapp +50377486783
Check your code. You are calling some node by using
'product'
node name which is not there. I am assuming its'products'
Thanks.. is now woking
Alright.
Hi Pau, can you post your connect.php code that uses PDO? thanks, Also I got syntax error in your code, thanks btw
getMessage();
}
return $conn;
}
}
?>
thank you paul, 😀
Mmm, it won’t let post the full code…
Hi Ravi, can you post the php with PDO functions since mysql is deprecated… thanks
hi,
i want to know 2 things.
1. instead of setting up php on my own lappy i want to do it completely on my website , can you please guide me which code i need to change
2. if i do all in android studio which things i need to do.
thanks 🙂
You need to host the php services onto cloud hosting so that it will be publicly available. Go through the below articles.
More advanced way of building the php / mysql services – rest api
https://www.androidhive.info/2014/01/how-to-create-rest-api-for-android-app-using-php-slim-and-mysql-day-12-2/
Hosting the services online
https://www.androidhive.info/2015/03/android-hosting-php-mysql-restful-services-to-digitalocean/
hi,
i tryed to signup on digitalocean but on the time of payment they said they are not accepting debit card , what should i do ? i dont have any credit card nor paypal and even paypal is block in pakistan.
You can’t do much without Credit Card. Contact the support team.
Hello, i would like to know if i can run the same code on netbeans and android studio?
thanks in advance 🙂
Why you want to use Netbeans for this?
Because im more comfortable working with netbeans over eclipes. But it’s okay, android studio?
Android Studio is strongly suggested for android. Netbeans is not good for android development.
okay thank you
You are welcome 🙂
hello,
how to send data messages of having any changes in mysql database can send notification to android app without using firebase console and php backend
You can use nodejs and socket io to send notifications.
can u please send me the code of how to send data messages of having any changes in mysql database can send notification to android app without using firebase console and php coding.
can u send the code of node js and socket io
I would appreciate a guide on this if it is more efficient that draining user device resource for checking over and over again.
Thanks in advance
-2
down vote
favorite
how to send notification to app background when the database value changes,it means I tried notification and firebase cm ,firebase console and php server side coding and node js but can’t get solution,please anybody help me sending push notifications automatically to android app(in background) when the database value changes i used mysql database server
android
how to send notification to app background when the database value changes,it means I tried notification and firebase cm ,firebase console and php server side coding and node js but can’t get solution,please anybody help me sending push notifications automatically to android app(in background) when the database value changes i used mysql database server
android
MySQL database not realtime. Have you considered using Firebase Realtime Db?
sir,
i am creating “dekado coin” app,in that any changes in dekado server then notification can sends to android app,in this I tried so many firebase console and normal notification but how to send notification can mail me the code.
can u please send me the code of how to send data messages of having any changes in mysql database can send notification to android app without using firebase console and php coding.
can u send the code of node js and socket io
Plz send me the updated code for the error as “Method getText must be called from the UI thread, currently inferred thread is worker” in your code.
at akshaygayale@gmail.com
I’m just starting off with android and your tutorials has been helpful… Thanks alot..
I tried using this tutorial and a couple of classes in the JSONParser are deprecated without any hint on alternatives.. I would appreciate if you could review the class an make recommendations.
Thanks in Advance!
Have you tried using Volley or Retrofit.
https://www.androidhive.info/2014/05/android-working-with-volley-library-1/
Not yet!
Thanks for the prompt response, let me look through it
Hello Mukul, i’ve used a HashMap instead, works great!
sir i getting this error while adding a new product in the database. i am using a godaddy webhosting.
my error is.
Attempt to invoke virtual method ‘java.lang.String org.json.JSONObject.toString()’ on a null object reference
you are trying to convert the object to string that is yet not available… make these lines of code to happen after receiving the data
Why listing all products no description ?
cant add, save or edit description, always empty
hello
i have some problems in JSONParser class
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.utils.URLEncodedUtils;
import org.apache.http.impl.client.DefaultHttpClient;
these are not imported i tried to add dependencies. i can’t understand please help….Thanks in advance
Add this to your gradle
android {
useLibrary ‘org.apache.http.legacy’
}
Just import http_core.jar and http_client.jar and check.
Great tutorial! By the way, is there any chance you could update the code so we don’t have deprecated functions in the parser?
Value <br of type java.lang.String cannot be converted to JSONObject
“Value <br of type java.lang.String cannot be converted to JSONObject"
any one help me when i given text in search box ListView has stop
Add this to your gradle.
android {
useLibrary ‘org.apache.http.legacy’
}
Hi
I’m having issue with log below:
10-20 19:42:39.788 D/Starting doInBackground( 1650): NO RETURN
10-20 19:42:39.957 W/EGL_emulation( 1650): eglSurfaceAttrib not implemented
10-20 19:42:39.957 W/OpenGLRenderer( 1650): Failed to set EGL_SWAP_BEHAVIOR on surface 0xe9bfe2e0, error=EGL_SUCCESS
10-20 19:42:40.639 I/Choreographer( 1650): Skipped 35 frames! The application may be doing too much work on its main thread.
10-20 19:42:44.700 E/JSON Parser( 1650): Error parsing data org.json.JSONException: Value <br of type java.lang.String cannot be converted to JSONObject
10-20 19:42:44.756 E/AndroidRuntime( 1650): FATAL EXCEPTION: AsyncTask #4
10-20 19:42:44.756 E/AndroidRuntime( 1650): Process: com.example.my.phpandmysql, PID: 1650
10-20 19:42:44.756 E/AndroidRuntime( 1650): java.lang.RuntimeException: An error occurred while executing doInBackground()
10-20 19:42:44.756 E/AndroidRuntime( 1650): at android.os.AsyncTask$3.done(AsyncTask.java:309)
10-20 19:42:44.756 E/AndroidRuntime( 1650): at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:354)
10-20 19:42:44.756 E/AndroidRuntime( 1650): at java.util.concurrent.FutureTask.setException(FutureTask.java:223)
10-20 19:42:44.756 E/AndroidRuntime( 1650): at java.util.concurrent.FutureTask.run(FutureTask.java:242)
10-20 19:42:44.756 E/AndroidRuntime( 1650): at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:234)
10-20 19:42:44.756 E/AndroidRuntime( 1650): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
Seem the issue come from doInBackground method :
please give me advice, I'm in the middle of troubleshoot for this kind
Your json is not proper. Make the call from Postman and see the php errors.
here the result from Postman:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:xampphtdocsmyhousedb_connect.php:28
Stack trace:
#0 C:xampphtdocsmyhousedb_connect.php(11): DB_CONNECT->connect()
#1 C:xampphtdocsmyhousecreate_product.php(22): DB_CONNECT->__construct()
#2 {main}
thrown in
C:xampphtdocsmyhousedb_connect.php on line
28
I’m not sure if mysql_connect still exist. Some forum said this function wasn’t exist anymore.
it should be your address to access all products php.
like this : http://127.0.0.1/myapp/all_products.php
Disable PHP warnings or use mysqli statements.
Dear Ravi,
Thanks for your answer. I have disabled PHP warning using “error_reporting(E_ERROR);” in first lines of php and it starts working.
Thanks and Regards,
Dev
Cool. But it’s better to clear any warnings it’s suggesting. Also remember this article is just to understand the basic workflow, you shouldn’t use this in production.
Consider reading the below articles next.
https://www.androidhive.info/2014/01/how-to-create-rest-api-for-android-app-using-php-slim-and-mysql-day-12-2/
Thanks Ravi 🙂
Hi
I am having a problem. I have created the database on a local server which have an IP address. I am using Xamp server. I have created a folder in htdocs folder and saved all php file there.
In Android Studio how should I call the php files.
Usually the IP address of wifi router is used instead of localhost. Try replacing the localhost with ip and try accessing the url via android app.
Hi
I run the app on an emulator. I get the main screen with the two buttons view products and add new products. When click on add new products, input the required field and then click button create product, got the message “Unfortunately, MyMainActiviry has stopped.” When click on View products button also same message.Can you please help.
Also where are the other layout use.
Check the LogCat for errors.
Thanks Ravi.
In fact I am new to android. Can you tell me how to use logcat. Thanks in advance
In Android Studio you can find the LogCat. If you open it and run the app, you can see the possible errors in LogCat.
Hello Ravi,
I am trying your application ! and I meet the same
bugs that were said here : create OK it is good, viewlist also OK but
when I click on a detail , it close the application and you have to
launch again and the edit detail does not appear !
It makes tree days that I try to do it !!!!! Please can you help me ?
Thanks
My Logcat :at com.example.mwalter.myapplication.JSONParser.makeHttpRequest(JSONParser.java:62)
com.example.mwalter.myapplication.EditProductActivity$GetProductDetails$1.run(EditProductActivity.java:136)
Pls paste the complete error log.
Hi
I am still having problem. I am trying only one button the View Products. When click on the button, it give a blank page.
Hi
How can I get the string URL entered in Create_new_product_activity java file from my database and not of android hive?
Hello! I’ve got the same JSONParser class and is retrieving just one JSONObject like this:
{“product”:[{“id”:”1″,”name”:”Prueba”}]}{“product”:[{“id”:”2″,”name”:”Prueba2″}]} How can i separate the two table rows as two different JSONObjects?
Hi.. I used only the code to be able to create a new product. After entering the details, and on pressing the submit button, I get ‘App has stopped’ ‘Open app again’. I used an emulator. Did someone else encounter the same issue? I did not get any errors in the Android monitor in Android studio.
Please comment, if there are any suggestions.
Thanks!
Have you checked the LogCat for errors?
Yes I did. There are no errors in logcat.
Hi Ravi!
“Skipped 544 frames! The application may be doing too much work on its main thread.”
can you help me out here buddy?
Hi @Ravi ,
You have mentioned this code is not secure. Is it not secure in the server side code? If yes
what about the front end code in Android?
Is it secure?
Reply please
Hi Savari
This is just beginner article just to understand the app to server communication. You need to build more proper REST API. Follow the below articles
https://www.androidhive.info/2014/01/how-to-create-rest-api-for-android-app-using-php-slim-and-mysql-day-12-2/
https://www.androidhive.info/2016/05/android-working-with-retrofit-http-library/
Super.
Thanks for the quick answer.
You are welcome 🙂
Dear Ravi Tamada
Can u help me i got problem on view product detail force close aplication
best regards
Hendri
Hi.. I am facing the same issue. Were you able to resolve it?
Check your LogCat for error when the app crashing.
I had a few minor errors in my php files and not in the android studio. Fixed them and it worked!!
I would suggest checking Apache error log if someone else has similar issue of App crash with no errors in LogCat..
Thanks Suhas for your tips.
What would i need to do in order to allow an image of the product to be inserted with the product information and have it save to database as well?
Like they take a picture with camera of the product and add it to the product information.
Normally we shouldn’t store the images in database. Instead store the image on hard disk on a path and store the path / image name in the db. While retrieving, get the image name from db, construct the final path (the url which can be accessed in a browser) and respond that in json.
Here is an example of json with image urls.
https://api.androidhive.info/json/menu.json
Can you please add a listview that can view image and text inside the website’s database. Thanks
You need to generate json data from the database and use the json to render the listview. If you understood this article correctly, I suggest read the below article to improve further.
https://www.androidhive.info/2014/01/how-to-create-rest-api-for-android-app-using-php-slim-and-mysql-day-12-2/
This article explains how to display the list view from the json
https://www.androidhive.info/2017/09/android-recyclerview-swipe-delete-undo-using-itemtouchhelper/
How can i get the link of the images in my database and put it inside listview along with the text? Is it possible? Thanks.
You have to generate the image url from the database something like below.
https://api.androidhive.info/json/contacts.json
can you show me the code for these.
You need to learn writing REST API. It’s need some knowledge in PHP and MySQL.
https://www.androidhive.info/2014/01/how-to-create-rest-api-for-android-app-using-php-slim-and-mysql-day-12-2/
Using the above code. Can you show me a tip on how i can do it? Thanks
Bro really respect your work
Thanks
You are welcome bro 🙂
Dear Ravi,
I am following your tutorials, it is really nice work. But I wanna to request to make tutorials on basic components of Android also i.e on Service(Bound, Unbound , Within app and outside app invoking service) , Content-Provider and on BroadcastReciever. I did not find tutorials on these topics in Beginners section. I am still struggling to get some good tutorial and handson explaining these topics. Kindly consider that.
Thanks and Regards,
Dev
Hi Dev
Thanks for your suggestions. It will take sometime to publish these articles as other articles are in queue. It’s also my mistake that the basic concepts not published yet.
Check on youtube, there are good tutorials about services.