Phpcrud/functions.php at master · Aditya51293/Phpcrud · 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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php include "db.php";?>

<?php


function showAll(){
    global $connection;
    $query= "SELECT * FROM users";

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

    if(!$result){
        die("query failed".mysqli_error);
    }

    while($row=mysqli_fetch_assoc($result)){
        $id=$row['id'];

        echo "<option value='$id'>$id</option>";

    }
}

function updateTable(){
    global $connection;
    if(isset($_POST['update'])){

        $username=$_POST['username'];
        $password=$_POST['password'];
        $id=$_POST['id'];
        $username=mysqli_real_escape_strings($connection,$username);
        $password=mysqli_real_escape_strings($connection,$password);
        $query1="UPDATE users SET ";
        $query1.="username='$username',password='$password'";
        $query1.="WHERE id=$id";

        $result=mysqli_query($connection,$query1);

        if(!$result){
            die("error".mysqli_error($connection));
        }
        else{
            echo "record updated";
        }

    }
}

function deleteTable(){
    global $connection;
    if(isset($_POST['delete'])){
        $username=$_POST['username'];
        $password=$_POST['password'];
        $id=$_POST['id'];
        $query1="DELETE FROM users ";
        $query1.="WHERE id=$id";

        $result=mysqli_query($connection,$query1);

        if(!$result){
            die("error".mysqli_error($connection));
        }
        else{
            echo "record Deleted";
        }

    }
}

function Create(){
    global $connection;
    if(isset($_POST['submit'])){
        $username=$_POST['username'];
        $password=$_POST['password'];

        $username=mysqli_real_escape_strings($connection,$username);
        $password=mysqli_real_escape_strings($connection,$password);

        $hashformat="$2y$10$";
        $salt="iusesomecrazystrings22";
        $hashandsalt=$hashformat.$salt;

        $encrypt=crypt($password,$hashandsalt);

        $query= "INSERT INTO users(username,password)";
        $query.="VALUES ('$username','$password')";

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

        if(!$result){
            die("query failed");
        }
        else{
            echo "record created";
        }


        /*if($username && $password){
            echo $username;
            echo $password;
        }
        else{
            echo "no username and password was submitted";
        }*/


    }
}

function readall(){

    global $connection;
    $query= "SELECT * FROM users";

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

    while($row=mysqli_fetch_assoc($result)){
        print_r($row);
    }

    if(!$result){
        die("query failed".mysqli_error);
    }

}


?>