PHP DatabaseConnection::queryWithoutResult Exemples

Exemple #1

Fichier : test_data_teachers.php Projet : PumpkinSeed/beadando

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

Exemple #2

Fichier : test_data_students.php Projet : PumpkinSeed/beadando

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

Exemple #3

Fichier : test_data_marks.php Projet : PumpkinSeed/beadando

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

Exemple #4

Fichier : test_data_subjects.php Projet : PumpkinSeed/beadando

function addSubjects($name)
{
    $sql = "INSERT INTO subjects VALUES ('', ?)";
    $string = array($name);
    $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school");
    $db->queryWithoutResult($sql, $string, true, "s");
}

Exemple #5

Fichier : model.php Projet : PumpkinSeed/beadando

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