Android MySQL :
Android MySQL, In this part of tutorial we will be dealing with the fetching values into MYSQL database with the help of php. php is the open source server side scripting language which is utilized for creating an api.
In the previous part of the tutorial we have dealt with the insert of values into the database.Now let’s go through how we can fetch the data from android mysql database.
As you may have already know the CRUD operations if not please refer my previous tutorial.
https://androidcoding.in/2019/01/26/insert-into-php/
So let’s get started now
Step 1:
Connect.php
This is first step of connecting to the database here we provide the details required
- Hostname is the place where the database is.
- Username for the user access.
- Password is required for maintaining security for local host this will be empty.
- DBName this will select the database out of all your databases present on your server
define('Hostname','localhost'); //db host define('Username','root'); // db username define('Password',''); //db password define('DBName','userS'); // db name
Using all these parameters will help us connect android mysql db
$con = mysqli_connect(Hostname,Username,Password,DBName) or die('Cannot Connect');
With the help of the connect file we can establish a connection to database and from there execute transactions by passing query’s like insert, delete, update etc.,
Step 2:
Fetch.php
The first step is to connect to database using the above mentioned process by specifying the file at start
require_once('connect.php');
Then accept the inputs from the user via API i.e., the key parameter by which we can search the table to find the exact record we need to fetch.
Save the value and save it to variable as below
$name = $_POST['name'];
Now write a SQL query to select the values from table using the key parameter as the constraint.
$sql = "select * from user_table where name = '$name'";
Now call the connection and thereby execute the SQL query as
$res = mysqli_query($con,$sql);
Create an array to store the result accordingly
$result = array();
fetch the data from tables according to the row wise as
'name'=>$row[1], 'age'=>$row[2], 'phone'=>$row[3], 'email'=>$row[4]
echo the encoded array list
echo json_encode(array("result"=>$result));
finally close the database
mysqli_close($con);
For full detailed android mysql video tutorial visit the link below
If you have any query’s in this tutorial on android mysql do let us know in the comment section below.If you like this android mysql tutorial do like and share for more interesting updates.