01.<?php
02.header("Content-type:application/json; charset=UTF-8");
03.header("Cache-Control: no-store, no-cache, must-revalidate");
04.header("Cache-Control: post-check=0, pre-check=0", false);
05.
06.
07.$name = "physics";
08.
09.mysql_connect("localhost","root","") or die("Cannot connect the Server");
10.mysql_select_db("server_guru") or die("Cannot select database");
11.mysql_query("set character set utf8");
12.?>
13.<?php
14.$q="SELECT * FROM chat WHERE whochat ='$name' ORDER BY id";
15.$qr=mysql_query($q);
16.while($rs=mysql_fetch_array($qr)){
17. $json_data[]=array(
18. "province_id"=>$rs['whochat'],
19. "province_name"=>$rs['withchat'],
20. );
21.}
22.$json= json_encode($json_data);
23.echo $json;
24.?>
