i2QbAPEA

1<?php
2    require_once 'login.php';
3    require_once 'error.php';
4    require_once 'salt.php';
5    require_once 'security.php';
6 
7    function create_table() {
8        global $hn, $un, $pw, $db;
9        $conn = new mysqli($hn, $un, $pw, $db);
10        if($conn->connect_error) die(mysqli_fatal_error());
11 
12        $q1 = "CREATE TABLE IF NOT EXISTS malware (
13           Id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
14           Name VARCHAR(32) NOT NULL,
15           Identifier CHAR(20) NOT NULL,
16           PRIMARY KEY (Id)
17   )";
18 
19        $q2 = "CREATE TABLE IF NOT EXISTS admin (
20           Id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
21           Username VARCHAR(32) NOT NULL,
22           Password CHAR(32) NOT NULL,
23           PRIMARY KEY (Id)
24   )";
25 
26        // Creating admin with username - maan, password - salted version of 'maan'.
27        $user = 'root';
28        $pass = 'root';
29 
30        $username = mysql_entities_fix_string($conn, $user);
31        $password = saltit(mysql_entities_fix_string($conn, $pass));
32 
33        $q3 = "INSERT INTO admin VALUES (NULL, '$username', '$password')";
34 
35        $r1 = $conn->query($q1);
36        $r2 = $conn->query($q2);
37        $r3 = $conn->query($q3);
38        if (!$r1 || !$r2 || !$r3) die(mysqli_fatal_error());
39 
40        // Error: While closing, as both $r1 and $r2 have boolean values.
41        // Error thrown by PHP: Fatal error: Uncaught Error: Call to a member function close() on bool in /Applications/XAMPP/xamppfiles/htdocs/table.php:30
42        // Stack trace: #0 /Applications/XAMPP/xamppfiles/htdocs/admin.php(6): create_table() #1 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/table.php on line 30
43        if (!$r1) $r1->close();
44        if (!$r2) $r2->close();
45        if (!$r3) $r3->close();
46        $conn->close();
47    }