thegame/functions.php at master · CppCoder1/thegame · 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
<?php

    error_reporting(0);
    function get_or_post($variable_name, $default)
    {
        if(key_exists($variable_name, $_GET))
            return $_GET[$variable_name];
        else if (key_exists($variable_name, $_POST))
            return $_POST[$variable_name];
        else
            return $default;
    }

    function sql_req($query)
    {

        $conn = mysqli_connect('localhost', 'root', '', 'dbname');
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }
        mysqli_set_charset($conn, 'utf8');

        $result = mysqli_query($conn, $query);

        if (gettype($result) == "boolean")
        {
            return $result;
        }

        mysqli_close($conn);

        $userinfo = array();

        while($row_user = mysqli_fetch_array($result)){
                $row_id = $row_user["id"];
                $row_name = $row_user["name"];
                $row_race_id = $row_user["race_id"];
                $row_score = $row_user["score"];
                $userinfo[] = array("id"=> $row_id , "name"=> $row_name, "race_id"=> $row_race_id, "score" => $row_score);
            }

        return $userinfo;
    }
?>