phpdatabseconnection/form.php at main · naivedya2607/phpdatabseconnection · 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
<?php
include('config.php')
?>

<?php

if(isset($_POST['submit'])){
$username = $_POST['name'];
$branch = $_POST['branch'];
$year = $_POST['year'];
$city = $_POST['city'];
$gender = $_POST['gender'];
$email = $_POST['email'];

$sql = "INSERT INTO `users` (`username`, `email`, `gender`, `city`) VALUES ('$username', '$email', '$gender', '$city')";
mysqli_query($conn, $sql);
$sql = "INSERT INTO `studentinfo` (`username`, `branch`, `year`) VALUES ('$username', '$branch', '$year')";
mysqli_query($conn, $sql);
}
else{
echo "Please Enter the Details";
}

?>

<!DOCTYPE html>
<head>
</head>
<html>
  <body>
    <form method="POST" action="form.php">
        Name <input type="text" name="name" required ><br>
        E-mail <input type="email" name="email" required ><br>
        Branch <input type="text" name="branch" required><br>
        Year <input type="text" name="year" required><br>
        City <input type="text" name="city" required><br>
        Gender:
        Male <input type="radio" value="male" name="gender">
        Female <input type="radio" value="female" name="gender"><br>
        <input type="submit" value="submit" name="submit"><br>
    </form>
  </body>
</html>