Advertisement
Guest User

Untitled

a guest
Oct 8th, 2012
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.07 KB | None | 0 0
  1. <?php
  2. require_once('config.php');
  3. $query = "SELECT * FROM lol";
  4. $sql = mysql_query($query);
  5. if (mysql_errno() == 1022) {    print 'no way!';}
  6. if (isset($_GET["boka"])) {
  7. $sql = "INSERT INTO lol (id, teamname, player1, player2, player3) VALUES ('','$_POST[teamname]','$_POST[player1]','$_POST[player2]','$_POST[player3]')";
  8. mysql_query($sql) or die(mysql_error());
  9. }
  10.  
  11. ?>
  12. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  13. <html xmlns="http://www.w3.org/1999/xhtml">
  14. <head>
  15. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  16. <title>Xodia</title>
  17. <body>
  18. <form action="?boka" Method="POST">
  19. <label style="float:left; font-family: Lucida Grande, Geneva, Arial, Verdana, Helvetica, sans-serif; font-size: 11px; color: #cccccc;">Lagnamn:</label>         <input type="text" name="teamname" style="margin-left:25px;"><br><br>
  20. <label style="float:left; font-family: Lucida Grande, Geneva, Arial, Verdana, Helvetica, sans-serif; font-size: 11px; color: #cccccc;">Spelare1:</label>        <input type="text"  name="player1" style="margin-left:25px;"><br><br>
  21. <label style="float:left; font-family: Lucida Grande, Geneva, Arial, Verdana, Helvetica, sans-serif; font-size: 11px; color: #cccccc;">Spelare2:</label>        <input type="text"  name="player2" style="margin-left:25px;"><br><br>
  22. <label style="float:left; font-family: Lucida Grande, Geneva, Arial, Verdana, Helvetica, sans-serif; font-size: 11px; color: #cccccc;">Spelare3:</label>        <input type="text"  name="player3" style="margin-left:25px;"><br><br>
  23. <input type="submit" value="Registrera">
  24. </form>
  25. </body>
  26. </html>
  27. <?php
  28. $query = mysql_query("SELECT * FROM lol ORDER BY id ASC") or die(mysql_error());
  29. if (mysql_num_rows($query)) {
  30.     while ($text = mysql_fetch_assoc($query)){
  31.     echo '<lable style="font-family: Lucida Grande, Geneva, Arial, Verdana, Helvetica, sans-serif; font-size: 15px; color: #cccccc;"><b>Lagnamn</b>: <u>'.$text['teamname'].'</u> - Lineup: '.$text['player1'].' .:. '.$text['player2'].' .:. '.$text['player3'].'</lable><br>';
  32.     }
  33. }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement