Advertisement
Guest User

Untitled

a guest
Sep 7th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. <head>
  2. <style>
  3. table {
  4. font-family: arial, sans-seriif;
  5. border-collapse: collapse;
  6. width:100%;
  7. }
  8.  
  9. td, th {
  10. border: 1px solid #dddddd;
  11. tezt-align: left;
  12. padding: 8px;
  13. }
  14.  
  15. tr:nth-child(even) {
  16. background-color: #dddddd
  17. }
  18. </style>
  19. </head>
  20. <?php
  21. $x=$_POST['firstname'];
  22. $y=$_POST['lastname'];
  23. $servername = "localhost";
  24. $username = "root";
  25. $password = "";
  26. $dbname="db1";
  27. // Create connection
  28. $conn = new mysqli($servername, $username, $password,$dbname);
  29.  
  30. //Check connection
  31. if ($conn->connect_error) {
  32. die("Connection failed: " . $conn->connect_error);
  33. }
  34. echo "Connected succesfully";
  35. $sql = "INSERT INTO `user` (`fname`, `lname`) VALUES ('$x',' $y')";
  36.  
  37. if ($conn->query($sql) === TRUE) {
  38. echo "New record created succesfully";
  39. } else {
  40. echo "Error: " . $sql . "<br>" . $conn->error;
  41. }
  42. $sql = "SELECT id, fname, lname FROM user";
  43. $result = $conn->query($sql);
  44.  
  45. if ($result->num_rows > 0) {
  46. // output data of each row
  47. echo"<table>";
  48. while($row = $result->fetch_assoc()) {
  49. echo "<tr><td> id: " . $row["id"]. " </td><td> Name: " . $row["fname"]. " " . $row["lname"]. "</td></tr";
  50. }
  51. echo "</table>";
  52. } else {
  53. echo "0 results";
  54. }
  55. $conn->close();
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement