<?php header("content-type:text/html; charset=utf-8"); define("IN", true); require "fun.inc.php"; $name = $_POST['game_name']; $num = $_POST['num']; $score = $_POST['score']; $query = "update block_charts set score = '{$score}',name='{$name}' where uid = {$num}"; echo _mysql($query, 'update');
<?php header("content-type:text/html; charset=utf-8"); define("IN", true); require "fun.inc.php"; $query = "select * from block_charts order by uid"; echo json_encode(_mysql($query, 'search'));
<?php header("content-type:text/html; charset=utf-8"); define("IN", true); /** *由于fun.inc.php包含数据库账号密码配置,所以没有给出,在本地留言可能会出现问题,在服务端正常,下面介绍以下_mysql函数 * _mysql() 数据库处理函数 * @param $query mysql处理语句 * @param $kind 处理类型 * (1)$kind等于count,则返回符合查询语句的条数 * (2)$kind等于search,则返回符合语句的二维数组,第二维为数据库详细信息,键为数据库表名 * (3)$kind等于其他,如果操作成功则返回成功操作行数,否则返回零 */ require "fun.inc.php"; $content = $_POST['content']; $username = $_POST['username']; $email = $_POST['email']; $url = $_POST['url']; $query = "insert into dy_feedback (name,content,time,url,email) value ('{$username}','{$content}',NOW(),'{$url}','{$email}')"; echo _mysql($query, 'insert');