T21-Hack-Overflow/config.php at main · Hackdotslash/T21-Hack-Overflow · GitHub

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?php
session_start();
class Database
{
	private $host;
	private $user;
	private $pass;
	private $db;
	public $mysqli;

	public function __construct()
	{
		$this->db_connect();
	}

	public function db_connect()
	{

		$this->host = 'localhost';
		$this->user = 'root';
		$this->pass = '';
		$this->db = 'Goclean';
		$this->mysqli = new mysqli($this->host, $this->user, $this->pass, $this->db);
		return $this->mysqli;
	}

	public function db_num($sql)
	{
		$result = $this->mysqli->query($sql);
		return $result->num_rows;
	}

	public function runQuery($query)
	{
		$result = $this->mysqli->query($query);
		while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
			$resultset[] = $row;
		}
		if (!empty($resultset))
			return $resultset;
	}

	public function SinglerunQuery($query)
	{
		$result = $this->mysqli->query($query);
		$row = $result->fetch_array(MYSQLI_ASSOC);
		$resultest = $row;
		if (!empty($resultest))
			return $resultest;
	}

	public function updateQuery($query)
	{
		$result = $this->mysqli->query($query);
		if (!$result) {
			die('Invalid query: ' . mysql_error());
		} else {
			return $result;
		}
	}

	public function insertQuery($query)
	{
		$result = $this->mysqli->query($query);
		$last_insert_id = $this->mysqli->insert_id;
		if (!$result) {
			die('Invalid query: ' . mysql_error());
		} else {
			return $last_insert_id;
		}
	}

	public function deleteQuery($query)
	{
		$result = $this->mysqli->query($query);
		if (!$result) {
			die('Invalid query: ' . mysql_error());
		} else {
			return $result;
		}
	}
}