Seperate some of the php files

1 files changed, 4 insertions, 26 deletions

diff --git a/signup/verify/verify.php b/signup/verify/verify.php
index 471251d..592915f 100755
--- a/signup/verify/verify.php
+++ b/signup/verify/verify.php
@@ -20,6 +20,7 @@
 define('ROOT', rtrim($_SERVER['DOCUMENT_ROOT'], '/') . '/');
 
 require_once ROOT . '/php/session.php';
+require_once ROOT . '/php/database.php';
 
 if ($_SERVER["REQUEST_METHOD"] == "POST") {
     $code    = $_POST['code'];
@@ -30,33 +31,11 @@ if ($_SERVER["REQUEST_METHOD"] == "POST") {
         exit;
     }
 
-    $host    = '127.0.0.1';
-    $db      = 'gnufaultdb';
-    $db_user = 'gnufaultdb_user';
-    $pass    = trim(file_get_contents('/etc/gnufault.d/password'));
-
-    $charset = 'utf8mb4';
-    $dsn     = "mysql:host=$host;dbname=$db;charset=$charset";
-
-    $options = [
-        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
-        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
-        PDO::ATTR_EMULATE_PREPARES   => false,
-    ];
-
-    try {
-        $pdo = new PDO($dsn, $db_user, $pass, $options);
-    } catch (\PDOException $e) {
-        throw new \PDOException($e->getMessage(), (int)$e->getCode());
-    }
-
     try {
         $sql = "SELECT verification_code FROM users WHERE id = :id";
-        $stmt = $pdo->prepare($sql);
 
-        $stmt->execute(['id' => $user_id]);
+        $user = fetch_row($sql, ['id' => $user_id]);
 
-        $user = $stmt->fetch();
         if (!$user) {
             echo "User not found.";
             exit;
@@ -80,14 +59,13 @@ if ($_SERVER["REQUEST_METHOD"] == "POST") {
 
     try {
         $sql = "UPDATE users SET verification_code = :code WHERE id = :id";
-        $stmt = $pdo->prepare($sql);
 
-        $stmt->execute([
+        $statement = query($sql, [
             'code' => '0001',
             'id'   => $user_id
         ]);
 
-        if ($stmt->rowCount() == 0) {
+        if ($statement->rowCount() == 0) {
             echo "User not found.";
         }
     } catch (\PDOException $e) {