-
Notifications
You must be signed in to change notification settings - Fork 2
/
init.php
37 lines (30 loc) · 1.16 KB
/
init.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
include(".htconfig.php");
define("VIEW_DIR", __DIR__."/views/");
include("views.inc.php");
define("PRODID_CASHPAYMENT", 1);
define("PRODID_WIRETRANSFER", 2);
set_view_var("action", $_SERVER["PHP_SELF"]."?".$_SERVER["QUERY_STRING"]);
set_view_var("title", "KDV");
try {
$db = new PDO(DATABASE_URI, DATABASE_USER, DATABASE_PASSWORD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(Exception $ex) {
// avoid the default error message as it might display the db password
die("<H2>Eile mit Weile</H2>Database connection failed!");
}
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
function sql($query, $args, $noquery = false) {
global $db;
$q = $db->prepare($query);
$q->execute($args);
if ($noquery === true) return $q->rowCount(); elseif ($noquery === 1) return $q->fetch(); else return $q->fetchAll();
}
function get_login_user($email) {
$user = sql("SELECT * FROM users WHERE email = ?", [$email], 1);
if ($user && !$user["apitoken"]) {
$user["apitoken"] = bin2hex(openssl_random_pseudo_bytes(25));
sql("UPDATE users SET apitoken=? WHERE id=? ", [$user["apitoken"], $user["id"]], true);
}
return $user;
}