本文整理匯總了PHP中query::execute方法的典型用法代碼示例。如果您正苦於以下問題:PHP query::execute方法的具體用法?PHP query::execute怎麽用?PHP query::execute使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類query
的用法示例。
在下文中一共展示了query::execute方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: query
<?php
require_once '../../../resources/php/sql.php';
$results = new query("SELECT * FROM dhs16_user WHERE social = '" . $_POST['social'] . "';");
$user_exists = false;
foreach ($results->get() as $row) {
$user_exists = true;
}
if (!$user_exists) {
$sqlUser = new query("INSERT INTO dhs16_user (id, name, phone, seat, social) VALUES (NULL,'" . strtolower($_POST['name']) . "','" . $_POST['phone'] . "','" . $_POST['seat'] . "','" . $_POST['social'] . "');");
$sqlUser->execute();
}
$checkIn = date("Y-m-d H:i:s");
$sqlProblem = new query("INSERT INTO dhs16_problem (id, header, description, parts, name, social, check_in) VALUES (NULL,'" . $_POST['problem'] . "','" . $_POST['problemDesc'] . "','" . $_POST['parts'] . "','" . $_POST['name'] . "','" . $_POST['social'] . "','" . $checkIn . "');");
$sqlProblem->execute();
header('Location: ../../receipt.php?social=' . $_POST['social']);
//var_dump($sqlProblem->get());
示例2: query
<?php
require_once '../../../resources/php/sql.php';
$sql = new query("UPDATE dhs16_problem SET collected = 1 WHERE id = '" . $_GET['id'] . "';");
$sql->execute();
header('Location: ../../receipt.php?social=' . $_GET['checkOut']);