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;
//可以注册
}
}
