public function __construct($owner)
{
$this->owner = $owner;
$query = new query();
$query->Select("name", "value")->From("option")->Where("site", "=", $owner)->exec("all");
while ($query->next()) {
switch ($query->get('value')) {
case "true":
$this->option[$query->get('name')] = true;
break;
case "false":
case "":
$this->option[$query->get('name')] = false;
break;
default:
$this->option[$query->get('name')] = $query->get('value');
break;
}
}
}
static function get_globals($get, $post)
{
self::$get = self::clean_globals($get, array());
self::$post = self::clean_globals($post, array());
if (isset($post['remember'])) {
$md5 = md5(serialize($post));
if (obj::db()->sql('select id from input_filter where md5 = "' . $md5 . '"', 2)) {
unset($post);
} else {
obj::db()->insert('input_filter', array($md5, time()));
}
}
unset($_GET, $_POST);
return array(self::$get, self::$post);
}
<?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());
<?php
require_once '../../resources/php/sql.php';
$sql = new query("SELECT * FROM dhs16_problem;");
$queue = 0;
//queue
foreach ($sql->get() as $row) {
if ($row["check_out"] == "0000-00-00 00:00:00") {
$queue++;
}
}
//problem
$sql = new query("SELECT * FROM dhs16_issue ORDER BY id ASC;");
foreach ($sql->get() as $row) {
$type = $row["type"];
$dhrow = $row["row"];
}
echo json_encode(array("queue" => $queue, "problem" => array("type" => $type, "row" => $dhrow)));
/**
*
* Description : Retourne ou modifie les paramètres personnalisés de l'utilisateur.
* Paramètres :
* [$key] - (string) : Nom de l'option
* [$value] - (string) : Valeur de l'option.
* Retour :
* - (bool) "true" : l'option a été créée
* - (bool) "false" : l'option n'existe pas
* - (array) : Tableau associatif de toutes les fonctions si la méthode est appelée sans aucun paramètre
* - (string) : Valeur l'option dans la BDD si le paramètre $value n'est pas renseignée lors de l'appel de la méthode.
*/
public function option($key = false, $value = false)
{
if (count($this->option) == 0) {
$req = new query();
$req->select('key', 'value')->from("user_option")->where('owner', '=', $this->get('id'))->exec("ALL");
while ($result = $req->next()) {
$this->option[$req->get("key")] = $req->get("value");
}
}
if (!$key) {
return $this->option;
} elseif (!$value) {
if (isset($this->option[$key])) {
return $this->option[$key];
} else {
return false;
}
} else {
if (!isset($this->option[$key])) {
$this->create[] = $key;
$this->option[$key] = $value;
return true;
} elseif ($this->option[$key] != $value) {
$this->change[] = $key;
$this->option[$key] = $value;
return true;
} else {
return false;
}
}
}
/**
* @param array $columns
* @return mixed
*/
public function all($columns = array('*'))
{
return $this->query->get($columns);
}
echo "SSN: " . substr($row['social'], 0, 8) . "-XXXX";
?>
</li>
<li><?php
echo "Seat: " . $row['seat'];
?>
</li>
<li class=""><?php
echo "Phonenumber: " . $row['phone'];
?>
</li>
<li class="no-print"><button id="print" class="button">Print</button></li>
</ul>
</div>
<?php
foreach ($sqlProblem->get() as $rowProblem) {
?>
<?php
if ($rowProblem['check_out'] == "0000-00-00 00:00:00") {
echo '<div class="column medium-6">';
} else {
echo '<div class="column medium-6 no-print">';
}
?>
<ul class="pricing-table no-bullet text-left">
<li class="title"><?php
echo $rowProblem['header'];
?>
</li>
<li><?php
