01.<?php
02.if(isset($_GET['id']))
03.{
04. $id = $_GET['id'];
05. $con = mysql_connect("localhost","root","root");
06. mysql_select_db("****",$con);
07. $s = array();
08. $result = mysql_query("SELECT CONCAT(fname,' ',lname) AS name,FORMAT(money,0) money,DATE_FORMAT(date,'%d-%m-%Y %h:%i %p') date FROM username WHERE id='$id'");
09. while ($r=mysql_fetch_array($result,MYSQL_NUM))
10. {
11. $s = $r;
12. }
13. $data["login"] = $s;
14.}
15.echo json_encode($data);
16.?>
