function addNewStudent($login_code, $name, $birth, $pass, $email, $pn, $city, $subj) { $sql = "INSERT INTO teachers VALUES ('', ?, ?, ?, ?, ?, ?, ?)"; $string = array($login_code, $name, $birth, $pass, $email, $pn, $city); $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school"); $db->queryWithoutResult($sql, $string, true, "sssssss"); $sql = 'SELECT id FROM teachers WHERE code = ?'; $string = array($login_code); $res = $db->select($sql, $string, true, 's'); $sql = "INSERT INTO teacher_subj VALUES (?,?)"; $string = array($res[0]['id'], $subj); $db->queryWithoutResult($sql, $string, true, "is"); return true; }
function addNewStudent($login_code, $name, $birth, $resi, $pass, $email, $ppn, $year, $class, $s_hostel, $allowance) { $sql = "INSERT INTO students VALUES ('', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; $string = array($login_code, $name, $birth, $resi, $s_hostel, $allowance, $pass, $email, $ppn, $year, strtolower($class)); $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school"); $db->queryWithoutResult($sql, $string, true, "ssssiisssis"); $sql = 'SELECT id FROM students WHERE login_code = ?'; $string = array($login_code); $res = $db->select($sql, $string, true, 's'); $zero = mt_rand(0, 18); $sql = "INSERT INTO misses VALUES (?,?)"; $string = array($res[0]['id'], $zero); $db->queryWithoutResult($sql, $string, true, "ii"); return true; }
function insertItems($student, $mark, $year, $month, $subject, $teacher) { $sql = "INSERT INTO marks VALUES (?, ?, ?, ?, ?, ?)"; $string = array($student, $mark, $year, $month, $subject, $teacher); $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school"); $db->queryWithoutResult($sql, $string, true, "iiiiii"); }
function addSubjects($name) { $sql = "INSERT INTO subjects VALUES ('', ?)"; $string = array($name); $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school"); $db->queryWithoutResult($sql, $string, true, "s"); }
public function addMiss($num) { $num = $this->getMisses() + $num; $sql = "UPDATE misses SET number = ? WHERE id = ?"; $string = array($num, $this->getId()); $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school"); $db->queryWithoutResult($sql, $string, true, "ii"); }