-
Notifications
You must be signed in to change notification settings - Fork 0
/
createuser.php
107 lines (102 loc) · 4.73 KB
/
createuser.php
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
<!DOCTYPE html>
<html>
<head>
<title>Create Account</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.1.1/css/all.css" integrity="sha384-O8whS3fhG2OnA5Kas0Y9l3cfpmYjapjI0E4theH4iuMD+pLhbf6JI0jIMfYcK3yZ" crossorigin="anonymous">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
</head>
<body>
<header>
<nav>
<ul>
<li>
<a href="index.html" title="About ME">Home</a>
</li>
<li>
<a href="resume.html" title="RESUME!">Resume!</a>
</li>
<li>
<a href="blog.html" title="My Blog">BLOG</a>
</li>
<li>
<a href="gallery.html" title="Gallery">Gallery</a>
</li>
<li>
<a href="contact.html" title="Contact">Contact</a>
</li>
</ul>
</nav>
</header>
<body>
<?php
require_once 'php/functions.php';
if($_POST) {
$username = $_POST('user');
$name = $_POST('name');
$mobile = $_POST('mobile');
$email = $_POST('email');
$rollno = $_POST('rollno');
$pass =$_POST('pass');
if(!empty($rollno)&&!empty($name)&&!empty($email)&&!empty($mobile)&&!empty($user)&&!empty($pass)){
$link=mysqli_connect('localhost','root','root','aiktc');
if(!$link){
echo '<br>Unable to connect to Database.'
.mysqli_connect_error();
}
$query="Insert into users values('$username','$name','$mobile','$email','$rollno','$pass')";
$result=mysqli_query($link,$query);
if(!$result){
echo "<br>".mysqli_error($link);
}
else{
echo '<br><h4>Your data is successfully Inserted.</h4>';
}
}
}
?>
<div class="container">
<form role="form" method="post" action="createuser.php">
<h1> Create Account</h1>
<fieldset class="form-group">
<label for="name">Your Full Name</label>
<input class="form-control" type="text" maxlenght="50" id="name" name="name" required>
</fieldset>
<fieldset class="form-group">
<label for="mobile">Mobile Number</label>
<input class="form-control" type="number" maxlenght="10" id="mobile" name="mobile" required>
</fieldset>
<fieldset class="form-group">
<label for="email">Email</label>
<input class="form-control" type="email" id="email" name="email" maxlenght="50" required>
</fieldset>
<fieldset class="form-group">
<label for="rollno">Roll No(if applicable)</label>
<input class="form-control" type="text" id="rollno" name="rollno" maxlenght="8">
</fieldset>
<fieldset class="form-group">
<label for="user">Enter Username</label>
<input class="form-control" type="text" placeholder="Min 5 characters" maxlength="25" id="user" name="user" required><br>
<span id="usererr"></span>
</fieldset>
<fieldset class="form-group">
<label for="pass">Enter Password</label>
<input class="form-control" type="password" placeholder="Min 8 char, 1 Lowercase,1 Uppercase, 1 Special Charcter" pattern="(?=^.{8,}$)((?=.*\d)|(?=.*\W+))(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$" id="pass" name="pass" required>
</fieldset>
<fieldset class="form-group">
<label for="cpass">Confirm Password</label>
<input class="form-control" type="password" id="cpass" placeholder="Repeat Password" pattern="(?=^.{8,}$)((?=.*\d)|(?=.*\W+))(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$" name="cpass" required><br><span id="cpasserr"></span>
</fieldset>
<input type="hidden" name="usertype" id="usertype" value="1" required>
<input type="submit" class="btn btn-primary" value="Create Account">
</form><br><br>
</div>
<footer>
<div>
© All rights reserved - Mohd Salman Ansari
</div>
</footer>
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<script src="js/misc.js" type="text/javascript"></script>
</body>
</html>