PHP query::execute 예제들

<?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

파일 보기

파일: collected.php 프로젝트: Norrbrinken/DHS16

<?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']);