/
ajaxsubmit.php
37 lines (25 loc) · 931 Bytes
/
ajaxsubmit.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
<?php
require('connection.php');
// Established connection with server ^_^
//Fetching Values from URL
$name = strtoupper($_POST['name']);
$roll = strtoupper($_POST['roll']);
$email = $_POST['email'];
$mobile= $_POST['mobile'];
$batch = $_POST['batch'];
$class = $_POST['class'];
$fName = strtoupper($_POST['fName']);
$fNumber=$_POST['fNumber'];
$mName =strtoupper($_POST['mName']);
$mNumber=$_POST['mNumber'];
//Insert query
mysqli_query($connection,"SELECT * FROM information");
$insertQuery= "
INSERT INTO information(name,roll, batch,class, number,email, fatherName,fatherNumber, motherName,motherNumber)
VALUES ('$name','$roll', '$batch','$class', '$mobile','$email', '$fName','$fNumber', '$mName','$mNumber')
";
if( !($connection->query($insertQuery)) )
echo "error";
//closinG connectioN
mysqli_close($connection);
?>