Advertisement
Guest User

Untitled

a guest
Oct 18th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. <form action="" method="post">
  2. First name: <input type="text" name="first"><br />
  3. Last name: <input type="text" name="last"><br />
  4. Address: <input type="text" name="address"><br />
  5. Age (must be number): <input type="text" name="age">
  6. <input type="submit" name="submit" value="submit">
  7. </form>
  8. <?php
  9.  
  10. $hostname="localhost";
  11. $username="root";
  12. $password="zRx181962";
  13. $link = mysqli_connect ($hostname,$username,$password);
  14.  
  15. mysqli_select_db($link, "bethcustomers");
  16.  
  17. if(isset($_POST["first"])){
  18. $first = mysqli_real_escape_string($link,$_POST["first"]);
  19. $last = mysqli_real_escape_string($link,$_POST["last"]);
  20. $address = mysqli_real_escape_string($link,$_POST["address"]);
  21. $age = mysqli_real_escape_string($link,$_POST["age"]);
  22. $query = "INSERT INTO customers(first,last,address,age) VALUES('$first','$last','$address',$age)";
  23. $result = mysqli_query($link,$query);
  24. }
  25.  
  26. ?>
  27.  
  28. <table cellspacing=1 cellpadding=3 border=1>
  29. <tr><th><a href="?sort=first">First</a></th><th><a href="?sort=last">Last</a></th><th><a href="?sort=address">Address</a></th><th><a href="?sort=age">Age</a></th></tr>
  30. <?php
  31. $query = "SELECT * FROM customers ORDER BY last";
  32. $result = mysqli_query($link,$query);
  33. while($r=mysqli_fetch_array($result,MYSQLI_ASSOC)){
  34. echo "<tr><td>".$r["first"]."</td><td>".$r["last"]."</td><td>".$r["address"]."</td><td>".$r["age"]."</td></tr>\n";
  35. }
  36. ?>
  37. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement