URSThpvz

1<?php
2    $sql_servername = "localhost:3306";
3    $sql_username = "root";
4    $sql_password = "";
5    $sql_database = "3519DB";
6    
7    $usr = $_GET["usrKey"];
8    $pass = $_GET["passKey"];
9    $action = $_GET["actionKey"];
10    
11    // Create connection
12    $conn = new mysqli($sql_servername, $sql_username, $sql_password);
13    
14    // Check connection
15    if ($conn->connect_error)
16    {
17        echo("Connection failed: " . $conn->connect_error);
18        echo "</br>";
19    } 
20    echo "Connected successfully";
21    echo "</br>";
22
23    $sql = "CREATE DATABASE IF NOT EXISTS " . $sql_database;
24        
25        if($conn->query($sql) === TRUE)
26        {
27            echo "Database created or accessed succesfully";
28            echo "</br>";
29            if($conn -> select_db($sql_database))
30            {
31                echo "connected to database";
32                echo "</br>";
33            }
34            else
35            {
36                echo "database connection failed " . $conn -> error;
37                echo "</br>";
38            }
39        }
40        else
41        {
42            echo "Error creating database: " . $conn->error;
43            echo "</br>";
44        }
45    
46    if($action === "'NewUser'")
47    {
48            
49       // $usr = $conn -> real_escape_string($usr);
50       // $pass = $conn -> real_escape_string($pass);
51        echo "New User";
52        echo "</br>";
53        NewUser($conn,$usr,$pass);
54    }
55    
56    if($action === "'FindPassword'")
57    {
58        echo "Find Password";
59        echo "</br>";
60        FindPassword($conn, $usr);
61    }
62    
63    if($action === "'LogIn'")
64    {
65        echo "LogIn";
66        echo "</br>";
67        LogIn($conn,$usr,$pass);
68    }
69    
70    function NewUser($conn, $usr,$pass)
71    {
72        
73        
74        
75        #Check if table exsits
76        $sql = "SELECT USERNAME FROM USERS";
77        
78        if($conn -> query($sql))
79        {
80            echo "Table Exists";
81            echo "</br>";
82        }
83        else
84        {
85            echo ($conn -> error);
86            echo "</br>";
87            
88            $sql = "CREATE TABLE USERS (
89                USERNAME varchar(255),
90                PASSWORD varchar(255),
91                PRIMARY KEY (USERNAME)
92            )";
93            
94            if($conn -> query($sql) === TRUE)
95            {
96                echo "Table created";
97                echo "</br>";
98            }
99            else
100            {
101                echo ("table creation failed " . $conn -> error);
102                echo "</br>";
103            }
104        }
105        
106        $sql = "INSERT INTO USERS
107            (USERNAME, PASSWORD) VALUES
108            ($usr, $pass)";
109        
110        if($conn -> query($sql) === TRUE)
111        {
112            echo "Record inserted";
113            echo "</br>";
114            echo "<b>User created!<b/>";
115    
116        }
117        else
118        {
119            echo ($conn -> error);
120            echo "</br>";
121            echo "<b>User already exists!<b/>";
122        }
123    }
124    
125    
126    
127
128    function FindPassword($conn, $usr)
129    {
130        $sql = "SELECT * FROM USERS WHERE USERNAME = $usr";
131        $result = $conn -> query($sql);
132        
133        if($result === FALSE)
134        {
135            echo $conn -> error;
136        }
137        
138        if( $result -> num_rows > 0)
139        {
140            while($row = $result -> fetch_assoc())
141            {
142                echo "<b>Username = " . $row["USERNAME"] . ", Password = " . $row["PASSWORD"] . "<b/>";
143                echo "</br>";
144            }
145        }
146        else
147        {
148            echo "Username not found";   
149        }
150    }
151    
152    function LogIn($conn,$usr,$pass)
153    {
154        $sql = "SELECT PASSWORD FROM USERS WHERE USERNAME = $usr";
155        
156        $result = $conn -> query($sql);
157        
158        if($result === FALSE)
159        {
160            echo $conn -> error;
161        }
162        
163        if( $result -> num_rows > 0)
164        {
165            while($row = $result -> fetch_assoc())
166            {
167                if("'" . $row["PASSWORD"]  ."'" === $pass)
168                {
169                    echo "Login Sucessful";
170                    echo "</br>";
171                }
172                else
173                {
174                    echo "Login Unsucessful";
175                    echo "</br>";
176                }
177            }
178        }
179        else
180        {
181            echo "User Not Found";
182            echo "</br>";
183        }
184    }
185?>