Make Web Service in PHP for Android Application

Web services is one type of medium for accessing the data in different devices, here we take example like make service for the getting the list of the doctors, using this web service android developer can display doctor on android application.

1. Make table in my SQL for storing the doctor data,

CREATE TABLE IF NOT EXISTS `tbl_doctormaster` (
  `dm_Id` int(11) NOT NULL AUTO_INCREMENT,
  `dm_Name` varchar(50) NOT NULL,
  `dm_Address` varchar(1000) NOT NULL,
  `dm_MobileNo` varchar(25) NOT NULL,
  `dm_EmailAddress` varchar(50) NOT NULL,
  `dm_Password` varchar(100) NOT NULL,
  `dm_ActiveStatus` int(11) NOT NULL DEFAULT '1',
  `dm_CreatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dm_UpdatedDate` timestamp NOT NULL,
  PRIMARY KEY (`dm_Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

2. Now insert data in datable,

INSERTINTO `tbl_doctormaster`(`dm_Id`, `dm_Name`, `dm_Address`, `dm_MobileNo`, `dm_EmailAddress`, `dm_Password`, `dm_ActiveStatus`, `dm_CreatedDate`, `dm_UpdatedDate`)VALUES
(1,'kapil111','klklkl','89898898','[email protected]','sdfdsf', 2,'2016-01-11 17:09:51','2016-01-11 17:09:51'),
(2,'Nirav Daraniya','sdfsdfsdfdsf','899898989','[email protected]','sdfsdfsdfds', 1,'2016-01-11 17:10:33','2016-01-11 17:10:33'),
(3,'aaaaaa11','asss11','89898998911','[email protected]','989988', 2,'2016-01-11 17:14:37','2016-01-11 17:14:37'),
(4,'l','l','7777777778','[email protected]','7897987', 2,'2016-01-13 19:32:51','2016-01-13 19:32:51');

3. Now make One PHP file for service give its name “service_getdoctor.php”,

<?php
$servername = "localhost";
$username = "root or Username";
$password = "Your My SQL password";
$conn = new mysqli($servername, $username, $password);
mysqli_select_db($conn, "YourDatabaseName");
$getData = "SELECT `dm_Id`, `dm_Name`, `dm_Address`, `dm_MobileNo`, `dm_EmailAddress`, `dm_ActiveStatus`, `dm_CreatedDate`, `dm_UpdatedDate` FROM `tbl_doctormaster`";
$result = mysqli_query($conn, $getData);
$cnt = 0;

while ($r = mysqli_fetch_row($result))
    {
    $cnt = 1;
    $msg[] = array(
        "dm_Id" => $r[0],
        "dm_Name" => $r[1],
        "dm_Address" => $r[2],
        "dm_MobileNo" => $r[3],
        "dm_EmailAddress" => $r[4],
        "dm_ActiveStatus" => $r[5],
        "dm_CreatedDate" => $r[6]
    );
    }

$json = $msg;
header('content-type: application/json');

if ($cnt == 0)
    {
    $resp["status"] = "-1";
    $resp["message"] = "Data Not Found";
    }
  else
    {
    $resp["status"] = "1";
    $resp["data"] = $msg;
    }

$response["response"] = $resp;
echojson_encode($response);
@mysqli_close($conn);
?>

4. Now run this php file(service it give below output),

{"response":{"status":"1","data":[{"dm_Id":"1","dm_Name":"kapil111","dm_Address":"klklkl","dm_MobileNo":"89898898","dm_EmailAddress":"[email protected]","dm_ActiveStatus":"2","dm_CreatedDate":"2016-01-11 22:39:51"},{"dm_Id":"2","dm_Name":"Nirav Daraniya","dm_Address":"sdfsdfsdfdsf","dm_MobileNo":"899898989","dm_EmailAddress":"[email protected]","dm_ActiveStatus":"1","dm_CreatedDate":"2016-01-11 22:40:33"},{"dm_Id":"3","dm_Name":"aaaaaa11","dm_Address":"asss11","dm_MobileNo":"89898998911","dm_EmailAddress":"[email protected]","dm_ActiveStatus":"2","dm_CreatedDate":"2016-01-11 22:44:37"},{"dm_Id":"4","dm_Name":"l","dm_Address":"l","dm_MobileNo":"7777777778","dm_EmailAddress":"[email protected]","dm_ActiveStatus":"2","dm_CreatedDate":"2016-01-14 01:02:51"}]}}