JSON Web Service Integration in Android

JSON Web Service Integration in Android

JSON Web Service Using PHP MYSQL

----------------------------------------------------------------------

<?php

$mysql_db_hostname = "localhost";

$mysql_db_user = "Database Username";

$mysql_db_password = "Database Password";

$mysql_db_database = "Name of Your Database";

$con = @mysqli_connect($mysql_db_hostname, $mysql_db_user, $mysql_db_password,

 $mysql_db_database);

if (!$con) {

 trigger_error('Could not connect to MySQL: ' . mysqli_connect_error());

}

$var = array();

 $sql = "SELECT * FROM tblusers";

$result = mysqli_query($con, $sql);

while($obj = mysqli_fetch_object($result)) {

$var[] = $obj;

}

echo '{"users":'.json_encode($var).'}';

?>