-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_core.php
68 lines (59 loc) · 1.37 KB
/
db_core.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
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
<?php
$MYSQL_CODE_DUPLICATE_KEY = 1062;
//This file contains the core database details and connects to the database
$host = "localhost";
$un = 'rvnd';
$pass = 'rvnd';
$db = 'fabric';
$con = mysqli_connect($host,$un,$pass,$db) or die('Something went wrong, please try again later');
ob_start();
session_start();
function Fetch($query)
{
Global $con;
if($r = mysqli_query($con,$query))
{
return $r;
}
else
{
Global $MYSQL_CODE_DUPLICATE_KEY;
if(strcmp(mysqli_errno($con),$MYSQL_CODE_DUPLICATE_KEY)==0)
{
return $MYSQL_CODE_DUPLICATE_KEY;
}
return mysqli_error($con);
}
}
function getFileName()
{
return basename($_SERVER['PHP_SELF'],'.php');
}
function isLoggedIn()
{
return (!(!isset($_SESSION['user_id']) || empty($_SESSION['user_id'])));
}
function getUserInfo($username,$field)
{
$result = Fetch("SELECT $field FROM users WHERE fab_username='$username' ORDER BY fab_id");
return mysqli_fetch_array($result)[$field];
}
function Read($filename)
{
$handle = fopen($filename, 'r');
$con = fread($handle,filesize($filename));
return $con;
}
function Write($filename,$content)
{
$handler = fopen($filename,'w');
fwrite($handler,$content);
fclose($handler);
}
function LogOut()
{
ob_flush();
session_destroy();
header("Location: http://localhost/Fabric");
}
?>