-
Notifications
You must be signed in to change notification settings - Fork 0
/
register.php
53 lines (46 loc) · 1.33 KB
/
register.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
<?php
session_start();
require('firstimport.php');
if(isset($_SESSION['name'])){}
else{
header("location:login1.php");
}
$tbl_name="users"; // Table name
mysqli_select_db($conn,"$db_name")or die("cannot select DB");
$uname=$_POST['uname'];
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$pass=$_POST['psd'];
$mail=$_POST['eid'];
$gender=$_POST['gnd'];
$marital=$_POST['mrt'];
$dob=$_POST['dob'];
$mobile=$_POST['mobile'];
$ques=$_POST['ques'];
$ans=$_POST['ans'];
$sql2="select u_name from $tbl_name";
$result2=mysqli_query($conn,$sql2);
$flag=0;
while($row=mysqli_fetch_array($result2)){
printf($row);
if($row['u_name']==$uname){
echo ""."matched";
$flag=1;
break;
}
}
if($flag==1){
echo ("<script language='javaScript'>
window.location.href='signup.php?value=1';
</script>");
die("");
}
else{
$sql="INSERT INTO $tbl_name(u_name,f_name,l_name,password,email,gender,marital,dob,mobile,ques,ans,usertype)
VALUES ('$uname','$fname','$lname','$pass','$mail','$gender','$marital','$dob','$mobile','$ques','$ans','user')";
$result=mysqli_query($conn,$sql);
$_SESSION['name']=$uname;
header("location:index.php");
}
//echo "f_name ".$f_name."... ".$l_name."... ".$email.".... ".$password.",,, ".$gender.",,,,".$marital."..... ".$dob.".... ".$mobile."....".$ques.",,,,".$ans;
?>