public function addstudent($sno, $usernc, $truename, $pwd, $email, $tel, $major)
{
$SqlHelper = new SqlHelper();
$img = rand(1, 4) . ".png";
$sql = "insert into student values ('{$sno}','{$usernc}','{$truename}','{$pwd}','{$email}','{$tel}','{$major}','{$img}')";
$res = $SqlHelper->dml($sql);
$SqlHelper->close();
return $res;
}
public function insert_correct_question($correct_name, $correct_code, $true_code, $run_answer, $paper_id)
{
$sqlHelper = new SqlHelper();
$correct_code = str_replace("<", "\"", $correct_code);
$correct_code = str_replace(">", "\"", $correct_code);
$sql = "INSERT INTO `weike`.`correct` ( `correct_name`, `correct_code`, `true_code`, `run_answer`, `paper_id`) VALUES ( '{$correct_name}', '{$correct_code}', '{$true_code}', '{$run_answer}', '{$paper_id}')";
$res = $sqlHelper->dml($sql);
return $res;
}
public function register($user)
{
$sqlHelper = new SqlHelper();
$username = $user->getUsername();
$password = md5($user->getPassword());
$tel = $user->getTel();
$sql = "insert into user(username,password,tel) values ('{$username}','{$password}','{$tel}')";
$res = $sqlHelper->dml($sql);
$sqlHelper->close_connect();
return $res;
}
public function insert_question($content, $username, $sno)
{
$sqlHelper = new SqlHelper();
$content = str_replace("<", "\"", $content);
$content = str_replace(">", "\"", $content);
$time = date('Y-m-d h:m:s');
$sql = "insert into bbs(content,username,date) values ('{$content}','{$username}','{$time}','{$sno}')";
$res = $sqlHelper->dml($sql);
$sqlHelper->close();
return $res;
}
public function deleteallArticle($arr)
{
$id = "";
$sqlHelper = new SqlHelper();
for ($i = 0; $i < count($arr); $i++) {
if ($i < count($arr) - 1) {
$id .= $arr[$i] . ",";
} else {
$id .= $arr[$i];
}
}
$sql = "delete from lavender_article where id in ({$id})";
$res = $sqlHelper->dml($sql);
$sqlHelper->close_connect();
return $res;
}
