本文整理匯總了PHP中DatabaseConnection::queryWithoutResult方法的典型用法代碼示例。如果您正苦於以下問題:PHP DatabaseConnection::queryWithoutResult方法的具體用法?PHP DatabaseConnection::queryWithoutResult怎麽用?PHP DatabaseConnection::queryWithoutResult使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DatabaseConnection
的用法示例。
在下文中一共展示了DatabaseConnection::queryWithoutResult方法的5個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: addNewStudent
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;
}
示例2: addNewStudent
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;
}
示例3: insertItems
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");
}
示例4: addSubjects
function addSubjects($name)
{
$sql = "INSERT INTO subjects VALUES ('', ?)";
$string = array($name);
$db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school");
$db->queryWithoutResult($sql, $string, true, "s");
}
示例5: addMiss
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");
}