How to write a webservices using php with json format

Hi friends, In this post i would like to explain about how to write a web services using php with the json format. Now a days mobile applications are more popular. Most of mobile applications are implementing for existing websites. To isplay information from database to mobile one mediator is require. So that mediator implementing using php and the output as JSON format to easy to retrieve.

How to write a webservices using php with json format | Anil Labs

Web service for login method. Code is continue with user class which i mentioned in my previous post object oriented programming in php

Login Method Code

1
2
3
4
5
6

function login($username,$password){
$query = "select * from users where username='".$username."' AND password='".$password."'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
return $num_rows;
}

In the web service page.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

<?php
/**********************************************************************
* Author : Anil Kumar Panigrahi
* E-mail : kumaranil21@gmail.com
* Created on : 14th June 2011
* Version : 1.0
* Project : Wevservices
* Page : Login Webservice
* Company : Anil Labs (http://www.anil2u.info)
* Modified on :
* Modified by :
*************************************************************************/
// Includes the class which have the all functions
ini_set('display_errors', '1');
include_once("user.class.php");

/* Created object for User class*/
$web = new users();
/* This file return the sucess or failure with provided details ( username, password ) */

// USER NAME - user_name
// PASSWORD - password

if(isset($_REQUEST) && ($_REQUEST['user_name'] != "") && ($_REQUEST['password']!="") ){

$result = $web->login($_REQUEST['user_name'],$_REQUEST['password']);
echo json_encode(array('results'=>$result));
}

/* Provided output in the json encoded format */
// Call the database disconnection method
$web->connection_close();

?>