本文整理汇总了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");
}