-
Notifications
You must be signed in to change notification settings - Fork 0
/
Connection.php
43 lines (35 loc) · 1.19 KB
/
Connection.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
41
42
43
<?php
require_once 'config.php';
class Connection{
private $link;
//Öppnar databasen om det blir new
public function __construct(){
$this->openDB();
}
// //Stänger databasen när classen slutas användas
// public function __destruct() {
// $this->closeDB();
// }
// connect to dB();
private function openDB(){
$this->link=mysql_connect(MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD)
or die('Kunde inte ansluta till mysql servern '.mysql_error());
mysql_select_db(MYSQL_DATABASE)
or die('Kunde inte ansluta till databasen ' .mysql_error());
return $this->link;
}
// // Stänger databasen
// private function closeDB(){
// mysql_close($this->link)
// or die(mysql_error());
// }
public function runSqlQuery($query){
$result = mysql_query($query) or die ("Something is wrong with:" . $query . "Place ERROR: " . mysql_error());
return mysql_insert_id();
}
public function runSqlQueryWithResult($query){
$result = mysql_query($query) or die ("Something is wrong with:" . $query . "Place ERROR: " . mysql_error());
return $result;
}
}
?>