-
Notifications
You must be signed in to change notification settings - Fork 3
/
Db.class.php
37 lines (26 loc) 路 957 Bytes
/
Db.class.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
<?php
class Db {
function connect(){
$username = ""; // Put your MySQL Username here
$password = ""; // Put your MySQL Password here
$hostname = "localhost"; // The address to your MySQL server
$database = "asykes_quiz"; // The name of the database to use
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
$selected = mysql_select_db($database,$dbhandle)
or die("Could not select examples");
}
function query($query){
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
$returnResult = array();
while( $row = mysql_fetch_assoc( $result)){
$returnResult[] = $row; // Inside while loop
}
return $returnResult;
}
}