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; }