Sconnect-PHP/sa.php at master · taherm/Sconnect-PHP · 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
<?php
$mysqli=new mysqli("localhost","root","","sc");

	$userName = $_POST['log'];

if ($userName==NULL)
{
    ?>

<script>
	alert('USN Cannot Be Empty');
	window.location='admin.php';
</script>
<?php

}


	$s = $_POST['sem'];
if ($s==NULL)
{
    ?>

<script>
	alert('Semester Cannot Be Empty');
	window.location='admin.php';
</script>
<?php

}


$password =  $_POST['pass'];

if ($password==NULL)
{
    ?>

<script>
	alert('DOB Cannot Be Empty');
	window.location='admin.php';
</script>
<?php

}


function isItValidDate($date) {
 if(preg_match("/^(\d{2})-(\d{2})-(\d{4})$/", $date, $matches))
  {
  if(checkdate($matches[2], $matches[1], $matches[3]))
   {
    return true;
   }
  }
 }

if(isItValidDate($password))
{
}
else
{
    ?>

<script>
	alert('DOB is Invalid');
	window.location='admin.php';
</script>
<?php

}

$sql1="select * from student where usn='$userName'";
$data1 = $mysqli->query($sql1);
$row=$data1->fetch_array();
if($row==0)
{

$sql = "INSERT INTO student (usn,semester,dob) VALUES ('$userName','$s','$password')";
	$data = $mysqli->query($sql);
	if ($data)
	  {
          ?>
<script>
	alert('Registration Successful');
	window.location='admin.php';
</script>

<?php
      }
}
	  else
	  {

      ?>
<script>
	alert('Registration Failed USN already exist');
	window.location='admin.php';
</script>

<?php
}

	?>