-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.php
38 lines (36 loc) · 1007 Bytes
/
database.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
<?php
function dbConnect()
{
// $servername = "sql201.infinityfree.com";
// $username = "if0_36172615";
// $password = "gM16WXUkJJUtcmI";
// $database = "if0_36172615_sep_site";
// $port = "3306";
$servername = "localhost";
$username = "root";
$password = "";
$database = "sep_site";
$port = "3306";
$mysqli = new mysqli($servername,
$username,
$password,
$database
,$port
);
if ($mysqli->connect_error) {
die("Connection failed: " . $mysqli->connect_error);
}
else
{
return $mysqli;
// die("Connected successfully");
}
}
function loadTable($mysqli, $tableName)
{
mysqli_set_charset($mysqli, 'utf8mb4');
$queryStatement = 'SELECT * FROM ' . $tableName . ' ORDER BY id ASC';
$result = $mysqli->query($queryStatement);
return $result;
}
?>