1、创建聊天消息表,其表的字段有消息内容,发送时间和发送者的名称;
SQL:
CREATE TABLE `guanhui`.`message` (
`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '消息ID' ,
`content` VARCHAR(255) NOT NULL COMMENT '消息内容' ,
`sender` VARCHAR(60) NOT NULL COMMENT '发送者' ,
`send_time` INT(10) NOT NULL COMMENT '发送时间' ,
PRIMARY KEY (`id`)
) ENGINE = MyISAM;
2、创建php文件将聊天消息查询出来,并以json格式输出;
$con = mysql_connect("localhost","","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("chat", $con);
mysql_query("set names 'utf8'");
$sql = "SELECT * FROM `message`";
$result = mysql_query($sql);
if(isset($result)){
json_encode(array(
'code' => 0,
'msg' =>