Guest User

Untitled

a guest
Apr 10th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. <?php
  2. $dbaddr = "localhost:3306";
  3. $user="root";
  4. $pass ="";
  5. $con = mysqli_connect($dbaddr,$user,$pass,"student");
  6. if(!$con){ echo "cannot connect to server";}
  7. else{ echo"server connected";}
  8.  
  9. $name =$_POST["name"];
  10. $enroll =$_POST["e_no"];
  11. $sem =$_POST["sem"];
  12. $year =$_POST["year"];
  13. echo $name ."". $enroll."".$sem."".$year;
  14. $q1 ="INSERT INTO stud VALUES($name,$enroll,$sem,$year)";
  15. if(mysqli_query($con,$q1)){echo"query executed";}
  16. else{ echo "not executed";}
  17. $res = mysqli_query($con,"SELECT * FROM stud");
  18. $r = $res->fetch_assoc();
  19. echo "<html>
  20. <body>
  21. <table>
  22. <tr>
  23. <th>name</th>
  24. <th>enroll</th>
  25. <th>sem</th>
  26. <th>year</th>
  27. </tr>
  28. <tr>
  29. <td>{$r['name']}</td>
  30. <td>{$r['enrollment']}</td>
  31. <td>{$r['semester']}</td>
  32. <td>{$r['year']}</td>
  33. </tr>
  34. </table>
  35. </body>
  36. </html>
  37. ";
  38.  
  39.  
  40. ?>
Add Comment
Please, Sign In to add comment