web-dev-class/add.php at master · ankitvats4717/web-dev-class · 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
<?php
include 'config1.php';
?>
<?php
if(isset($_POST['submit']))
{
   $USER_NAME=$_POST['USERNAME'];
   $EMAIL=$_POST['EMAIL'];
   $CONTACT=$_POST['CONTACT'];
   $CITY=$_POST['city'];


   $sql = "INSERT INTO `users` ( `user_name`, `email`, `contact`, `city`) VALUES ('$USER_NAME', '$EMAIL', '$CONTACT', '$CITY')";
   mysqli_query($conn,$sql);
}
else
{
    echo "No input";
}
?>
<html>
<head>
	<title>html form</title>
</head>
<body>
      <form method="post" action="add.php">
      	  USER NAME:<input type="text" name="USERNAME" placeholder="name" required><br>
      	  EMAIL:<input type="EMAIL" name="EMAIL" placeholder="email" required><br>
              CONTACT:<input type="text" name="CONTACT" placeholder="CONTACT" required><br>
      	  Select city:<select name="city">
      	   	<option>dehradun</option>
      	   	<option>delhi</option>
      	   	<option>hisar</option>
      	   	<option>tehri</option>
      	   	<option>none</option>
      	   </select><br>
      	  <input type="submit" value="click here to submit" name="submit">
      </form>
</body>
</html>