Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host_name = "db690172471.db.1and1.com";
- $database = "db690172471";
- $user_name = "dbo690172471";
- $password = "JrJsmpXH5SM24Z4R";
- $connect = mysqli_connect($host_name, $user_name, $password, $database);
- if ($connect) {
- // Stuff to do when connected to DB
- // Retrieves the username value from post
- $username=$_POST["email"];
- $pwh=$_POST["pwh"];
- // Checks to see if the username exists...
- $sql="SELECT email FROM Users WHERE email='$username'";
- $sql=mysqli_real_escape_string($connect, $sql);
- $query = mysqli_query($connect,$sql);
- if (mysqli_num_rows($query) != 0) {
- // User already exists so check pw and set session varb to logged in
- echo "user exists";
- } else {
- // Need to create user.
- echo "user $username does not exist";
- // Adds the details to the db?
- $sql="INSERT INTO Users (email, password) VALUES ('$username', '$pwh');";
- $sql=mysqli_real_escape_string($connect, $sql);
- $query2=mysqli_query($connect,$sql);
- if ($query2) {
- echo "New record created successfully";
- } else {
- //echo "Error: " . $sql . "<br>" . $connect->error;
- echo "error" ;
- }
- }
- }
- else
- {
- // Stuff to do when not connected...
- echo "problemo";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement