StudiousMe/registration.php at master · akshaytambe/StudiousMe · 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
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Studious Me</title>
<style>
body {
    background-image: url("library.jpg");
	background-size: 1366px 768px;
    background-repeat: no-repeat;
}
h1 {
    font-family: Gill Sans, Verdana;
	font-size: 60px;
	color: #2266FF;
}
p{
	font-family: 'Open Sans', Arial, Helvetica, sans-serif;
	color: #FFFFFF;
}
#header {
    background-color:white;
    color:white;
    text-align:left;
	padding: 5px;
}

#footer {
    color:black;
    clear:both;
    text-align:center;
    padding:5px;
    margin-top: 30px;
}

</style>
</head>
<body>
<div id="header">
<pre><h1><img src="images\librarysymbol.gif" alt="Logo"
  style="float:left;width:100px;height:100px;border-radius: 20px 20px 20px 20px;"> STUDIOUS ME</h1></pre>
</div>
<div style="background-color:white; color:black; padding:20px;margin-left:175px;margin-top:20px; width:450px; height: 525px;border-radius: 20px 20px 20px 20px;">

<p style="color:black;text-align:center;font-size: 30px"><b>Create your Library Account</b></p>
<pre><form id='register' action='registration.php' method='post' accept-charset='UTF-8' style="font-size:20px;color:black">
<input type='hidden' name='submitted' id='submitted' value='1'/>
<label for='name' >Your Full Name*  : </label><input type='text' name='name'  style="height: 22px;font-size: 18px;"/><br>
<label for='gender'>Gender*          : </label><input type="radio" name="sex" value="male">Male <input type="radio" name="sex" value="female">Female<br>
<label for='username' >UserID*          : </label><input type='text' name='id'   style="height: 22px;font-size: 18px;"/><br>
<label for='password' >Password*        : </label><input type='password' name='pass1'  style="height: 22px;font-size: 18px;"/><br>
<label for='password' >Confirm Password*: </label><input type='password' name='pass2'   style="height: 22px;font-size: 18px;"/><br>
<pre style="color:black;font-size: 16px;font-family: 'Open Sans', Arial, Helvetica, sans-serif;"><input type="checkbox" name="con" value="Bike"><b> I agree to the Library Terms of Service and Privacy Policy</b><br></pre>
<input type='submit' name='submit' value=""  style="border-style: none; background: url('images/signup.jpg') no-repeat; width: 111px; height: 30px;float:right;"/>
</form>
</div>
<div id="footer">
Copyright (TM) 2014 | Team Ozil 11
</div>

</body>

</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("library");
   if(isset($_POST['submit'])){
    $name = $_POST['name'];
    $password1 = $_POST['pass1'];
	$password2 = $_POST['pass2'];
	error_reporting(0);
	$sex=$_POST['sex'];
	$id = $_POST['id'];
	error_reporting(0);
	$check=$_POST['con'];

	if($name==''){
	echo "<script>alert('Please enter your name!')</script>";
	exit();
   }

   if($password1==''){
	echo "<script>alert('Please enter your password1!')</script>";
	exit();
   }

   if($id==''){
	echo "<script>alert('Please enter your Roll no!')</script>";
	exit();
   }
   if($sex==''){
	echo "<script>alert('Please select your Gender!')</script>";
	exit();
   }
   if(empty($check)){
   echo"<script>alert('Please agree the terms to continue')</script>";
   }else{
    if($password1==$password2)
   {
     $que=mysql_query("SELECT * FROM  `user` WHERE  `rno` LIKE  '$id'");
	 $res=mysql_num_rows($que);
	 if($res==1){
   echo"<script>alert('Already Registered')</script>";
	 exit();

   }else{
   $query = "INSERT INTO  `library`.`user` (`id` ,`name` ,`rno` ,`pass` ,`gender`)VALUES (NULL ,  '$name',  '$id',  '$password1',  '$sex')";
	if(mysql_query($query))
	 header("Location:thank.html");
   } }
   else{
    echo "<script>alert('Password not match')</script>";
     exit();
   }
 }  }


?>