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