Advertisement
Guest User

emp_form.php

a guest
Jul 4th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <?php
  2. $server="localhost";
  3. $user="root";
  4. $password="";
  5. $db="emp";
  6. $con=mysqli_connect($server,$user,$password,$db);
  7. if(!$con)
  8. die("Not connected".mysqli_error());
  9. else
  10. echo "connection done";
  11. if(isset($_POST['submit']))
  12. {
  13. $e_name=$_POST['name'];
  14. $e_city=$_POST['street'];
  15. $e_street=$_POST['city'];
  16.  
  17. $query="INSERT INTO employee(employee_name,street,city) VALUES ('$e_name','$e_street','$e_city')";
  18. $result=mysqli_query($con,$query);
  19. if($result)
  20. echo"Record added successfully <br>";
  21. }
  22. mysqli_close($con);
  23. ?>
  24.  
  25. <!DOCTYPE html>
  26. <html>
  27. <head>
  28. <title> Bank Database </title>
  29. </head>
  30. <body>
  31.  
  32. <h2>Employee</h2>
  33.  
  34. <form action="Form_emp.php" method="post">
  35. Name:<br>
  36. <input type="text" name="name">
  37. <br>
  38. Street:<br>
  39. <input type="text" name="street">
  40. <br>
  41. City:<br>
  42. <input type="text" name="city">
  43. <br>
  44. <input type="submit" name="submit" value="submit">
  45.  
  46. </form>
  47. </body>
  48. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement