dbController/dbLink.php at master · PhathomComputing/dbController · GitHub

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
69
70
71
72
73
74
75
76
77
78
<?php
include_once("functions.php");
function dbLink($host,$user,$pass,$db)
{
    $dblink = mysqli_connect($host,$user,$pass,$db);
    if(!$dblink)
    {
        die("dbLink failed with error code [".mysqli_connect_errno()."]:".mysqli_connect_error());
    }

    return $dblink;
}

function confirmQuery($query)
{
    if(!$query)
    {

        echo ("Query Failed => [".mysqli_connect_errno()."]:".mysqli_connect_error());
    }
}

function dbPrint($dblink,$query)
{
    if(!$query)
     {
        $query = "SELECT * ";
        $query .="FROM admins";
    }
    $result = mysqli_query($dblink,$query);
    confirmQuery($result);
    while($row = mysqli_fetch_row($result))
    {
            var_dump($row);
            echo "<hr />";
    }
}

function dbInsert($dblink,$query,$box, $table)
{
    if(!$query)
     {
        $query = "INSERT INTO {$table} ";
        $query .= "(username,password) ";
        $query .="VALUES ('{$box['username']}','{$box['password']}')";
    }
    $result = mysqli_query($dblink,$query);
    confirmQuery($result);
}

function dbRemove($dblink,$query,$box,$table)
{
    if(!$query)
     {
        $query = "DELETE FROM {$table} ";
        $query .="WHERE {$box['col']}='{$box['value']}'";
    }
    $result = mysqli_query($dblink,$query);
    confirmQuery($result);
}


function dbUpdate($dblink,$query,$box,$table)
{
    if(!$query)
     {
        $query = "UPDATE {$table} ";
        $query .= "SET {$box['col'][1]}='{$box['value'][1]}' ";
        $query .="WHERE {$box['col'][0]}='{$box['value'][0]}' ";
    }
    echo $query;
    $result = mysqli_query($dblink,$query);
    confirmQuery($result);
}


?>