· 10 years ago · May 07, 2016, 12:30 AM
1<!doctype html>
2<html>
3<head>
4<title>Register</title>
5</head>
6<body>
7
8<p><a href="register.php">Register</a> | <a href="login.php">Login</a></p>
9<h3>Registration Form</h3>
10<form action="" method="POST">
11Username: <input type="text" name="user"><br />
12Password: <input type="password" name="pass"><br />
13<input type="submit" value="Register" name="submit" />
14</form>
15<?php
16if(isset($_POST["submit"])){
17
18if(!empty($_POST['user']) && !empty($_POST['pass'])) {
19 $user=$_POST['user'];
20 $pass=$_POST['pass'];
21
22 $con=mysqli_connect('localhost','root','') or die(mysqli_error());
23 mysqli_select_db('database') or die("cannot select DB");
24
25 $query=mysqli_query("SELECT * FROM login WHERE username='".$user."'");
26 $numrows=mysqli_num_rows($query);
27 if($numrows==0)
28 {
29 $sql="INSERT INTO login(username,password) VALUES('$user','$pass')";
30
31 $result=mysqli_query($sql);
32
33
34 if($result){
35 echo "Account Successfully Created";
36 } else {
37 echo "Failure!";
38 }
39
40 } else {
41 echo "That username already exists! Please try again with another.";
42 }
43
44} else {
45echo "All fields are required!";
46}
47}
48?>
49
50</body>
51</html>
52
53CREATE TABLE IF NOT EXISTS `login` (
54 `username` varchar(200) NOT NULL,
55 `password` varchar(200) NOT NULL,
56 PRIMARY KEY (`username`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8_general_ci;