Guest User

Untitled

a guest
Oct 20th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.16 KB | None | 0 0
  1. <table width="1%" border="0">
  2. <tbody>
  3. <tr>
  4. <td>
  5. <form name="all" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
  6. <input type="submit" name="all" id="all" value="List all!" />
  7. </form>
  8. </td>
  9. <td>
  10. <form name="random" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
  11. <input type="submit" name="random" id="random" value="Random!" />
  12. </form>
  13. </td>
  14. <td>
  15. <form name="clear" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
  16. <input type="submit" name="clear" id="random" value="Clear!" />
  17. </form>
  18. </td>
  19. </tr>
  20. </tbody>
  21. </table>
  22. <!--?php
  23. mysql_connect("localhost", "benjwilk_gm", "123") or die(mysql_error());
  24. mysql_select_db("benjwilk_gm") or die(mysql_error());
  25. if(isset($_POST['random']))
  26. {
  27. echo "
  28. <table width='100%' border='0'--> <u><strong>Account</strong></u> <u><strong>Goal</strong></u> <u><strong>Proof</strong></u>"; $result = mysql_query("SELECT * FROM data ORDER BY RAND() LIMIT 1") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $id = $row['id']; $name = $row['name']; $goal = $row['goal']; $proof = $row['proof']; echo" $name $goal $proof "; } echo" "; } else if(isset($_POST['clear'])) { $sql = "TRUNCATE TABLE data;"; if (!mysql_query($sql)); echo "Cleared"; } else if(isset($_POST['all'])) { echo ""; $result = mysql_query("SELECT * FROM data") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $id = $row['id']; $name = $row['name']; $goal = $row['goal']; $proof = $row['proof']; echo" "; } echo"
  29. <table width="100%" border="0">
  30. <tbody>
  31. <tr>
  32. <td width="30%"><u><strong>Account</strong></u></td>
  33. <td width="30%"><u><strong>Goal</strong></u></td>
  34. <td width="30%"><u><strong>Proof</strong></u></td>
  35. </tr>
  36. <tr>
  37. <td>$name</td>
  38. <td>$goal</td>
  39. <td>$proof</td>
  40. </tr>
  41. </tbody>
  42. </table>
  43. "; } else { echo ""; $result = mysql_query("SELECT * FROM data") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $id = $row['id']; $name = $row['name']; $goal = $row['goal']; $proof = $row['proof']; echo" "; } echo"
  44. <table width="100%" border="0">
  45. <tbody>
  46. <tr>
  47. <td width="30%"><u><strong>Account</strong></u></td>
  48. <td width="30%"><u><strong>Goal</strong></u></td>
  49. <td width="30%"><u><strong>Proof</strong></u></td>
  50. </tr>
  51. <tr>
  52. <td>$name</td>
  53. <td>$goal</td>
  54. <td>$proof</td>
  55. </tr>
  56. </tbody>
  57. </table>
  58. "; } ?>
Add Comment
Please, Sign In to add comment