Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table width="1%" border="0">
- <tbody>
- <tr>
- <td>
- <form name="all" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
- <input type="submit" name="all" id="all" value="List all!" />
- </form>
- </td>
- <td>
- <form name="random" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
- <input type="submit" name="random" id="random" value="Random!" />
- </form>
- </td>
- <td>
- <form name="clear" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
- <input type="submit" name="clear" id="random" value="Clear!" />
- </form>
- </td>
- </tr>
- </tbody>
- </table>
- <!--?php
- mysql_connect("localhost", "benjwilk_gm", "123") or die(mysql_error());
- mysql_select_db("benjwilk_gm") or die(mysql_error());
- if(isset($_POST['random']))
- {
- echo "
- <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"
- <table width="100%" border="0">
- <tbody>
- <tr>
- <td width="30%"><u><strong>Account</strong></u></td>
- <td width="30%"><u><strong>Goal</strong></u></td>
- <td width="30%"><u><strong>Proof</strong></u></td>
- </tr>
- <tr>
- <td>$name</td>
- <td>$goal</td>
- <td>$proof</td>
- </tr>
- </tbody>
- </table>
- "; } 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"
- <table width="100%" border="0">
- <tbody>
- <tr>
- <td width="30%"><u><strong>Account</strong></u></td>
- <td width="30%"><u><strong>Goal</strong></u></td>
- <td width="30%"><u><strong>Proof</strong></u></td>
- </tr>
- <tr>
- <td>$name</td>
- <td>$goal</td>
- <td>$proof</td>
- </tr>
- </tbody>
- </table>
- "; } ?>
Add Comment
Please, Sign In to add comment