-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql.php
40 lines (37 loc) · 975 Bytes
/
mysql.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
38
39
40
<?php
class Database
{
private $host = "localhost:3306";
private $username = "root";
private $pasword = "Abcd!234";
private $database = "student_management_system_php";
private $connection;
public function __construct()
{
$this->connection = new mysqli($this->host, $this->username, $this->pasword);
if ($this->connection->connect_error) {
die("Connection failed: " . $this->connection->connect_error);
}
}
public function query($sql)
{
$result = $this->connection->query($sql);
if (!$result) {
die("Query failed: " . $this->connection->error);
}
return $result;
}
public function fetch($result)
{
return $result->fetch_assoc();
}
public function escapeString($string)
{
return $this->connection->real_escape_string($string);
}
public function close()
{
$this->connection->close();
}
}
?>