public function insert_reply($bbs_id, $reply_user_name, $reply_user_sno, $reply_content) { //插入回复的内容 $sqlHelper = new SqlHelper(); $reply_content = str_replace("<", "\"", $reply_content); //除去c语言里面可能带有的会影响显示的符号 $reply_content = str_replace(">", "\"", $reply_content); $time = date('Y-m-d h:m:s'); $sql = "insert into reply(bbs_id,reply_user_name,reply_user_sno,reply_content,reply_time) VALUES ('{$bbs_id}','{$reply_user_name}','{$reply_user_sno}','{$reply_content}','{$time}')"; $res = $sqlHelper->dql($sql); $sqlHelper->close(); return $res; }
public function checksno($sno) { $sqlHelper = new SqlHelper(); $sql = "select count(*) from student where sno={$sno}"; $res = $sqlHelper->dql($sql); $row = $res->fetch_array(); $sqlHelper->close(); if ($row[0] == 1) { return 0; //检查到数据库已经存在用户 } else { return 1; //可以注册 } }