Android Insert MYSQL :
This tutorial android insert MYSQL deals with the PHP integrating MYSQL database to insert a values using api and this api is called from android app.
Before going any further let us know the basic operations we can perform like CRUD operations
1) Create
2) Read
3) Update
4) Delete
So let’s get started now with android insert MYSQL tutorial
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
And can be defined as
define('Hostname','localhost'); //db host define('Username','root'); // db username define('Password',''); //db password define('DBName','userS'); // db name
and finally using all these values we will try to connect with server to establish a connection first leter on we can perform fetch, insert, update or delete.
$con = mysqli_connect(Hostname,Username,Password,DBName)
Step 2:
Insert.php
The first step in insert.php is to connect to a server so
require_once('connect.php');
And then accept the values thus coming from api and save them in local variables
here the local variables are –> $name , $age, $phone, $email
$name = $_POST['name']; $age = $_POST['age']; $phone = $_POST['phone']; $email = $_POST['email'];
Now run the MYSQL query for inserting the values
"insert into user_table (name, age, phone, email) values ('$name','$age','$phone','$email')"
Now lets query with the help of connect class and the query written above
$res = mysqli_query($con,$sql);
then after processing it will return success or failure and again this will have many barriers to be passed like
- Database should exists
- Table should be created and
- Field name should be matched exactly
check condition to finalize the result using a array (array may not be required)
$check = mysqli_fetch_array($res);
then a if else condition to validate result
if(isset($check)){ echo 'success'; }else{ echo 'failure'; }
Step 3:
At last close the connection i am mentioning this as a step because its important to do so and good practice too.
mysqli_close($con);
insert.php
This page helps us to insert MySql data.
<?php require_once('connect.php'); $name = $_POST['name']; $age = $_POST['age']; $phone = $_POST['phone']; $email = $_POST['email']; $sql = "insert into user_table (name, age, phone, email) values ('$name','$age','$phone','$email')"; $res = mysqli_query($con,$sql); $check = mysqli_fetch_array($res); if(isset($check)){ echo 'success'; }else{ echo 'failure'; } mysqli_close($con); ?>
If you have any query’s on this tutorial on android insert MySql do let us know in the comment section below.If you like this tutorial do like and share us for more interesting updates.
For more detailed explanation on android insert MYSQL view the video tutorial below.