PHPEdit.net Community
   
1 2 3 4
Tutorials Tips Pasties Code Snippets
 

Home > Pasties > Pastie #13e

Created on 21/04/2010 07:03 by Anonymous 

  1. <?php session_start(); ?>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  3.    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  4. <html xmlns="http://www.w3.org/1999/xhtml">
  5.     <head>
  6.               <title>Register a Username and Password</title>
  7.      </head>
  8.     <body>
  9. <?php
  10. $host = "localhost";
  11. $user = "nicole";
  12. $pass = "ur8zujdcNBCdSseW";
  13. $db   = "users";
  14.  
  15. // This part sets up the connection to database
  16. // (so do not need to reopen the connection
  17. // again on the same page).
  18. $ms = mysql_pconnect($host, $user, $pass);
  19. if ( !$ms )
  20. {
  21. echo "Error connecting to database.\n";
  22. }
  23.  
  24. // Make sure the database is selected.
  26.  
  27. //Input vaildation and the dbase code
  28. if ( $_GET["op"] == "reg" )
  29.  {
  30.  $bInputFlag = false;
  31.  foreach ( $_POST as $field )
  32.   {
  33.   if ($field == "")
  34.    {
  35.    $bInputFlag = false;
  36.    }
  37.   else
  38.    {
  39.    $bInputFlag = true;
  40.    }
  41.   }
  42.  // If we had problems with the input, exit with error
  43.  if ($bInputFlag == false)
  44.   {
  45.   die( "Problem with your registration. "
  46.    ."Please go back and try again.");
  47.   }
  48.  
  49.  // Fields are clear, add user to database
  50.  //  Setup query
  51.  $q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "
  52.   ."VALUES ('".$_POST["username"]."', "
  53.   ."PASSWORD('".$_POST["password"]."'), "
  54.   ."'".$_POST["email"]."')";
  55.  //  Run query
  56.  $r = mysql_query($q);
  57.  
  58.  // Make sure query inserted user successfully
  59.  if ( !mysql_insert_id() )
  60.   {
  61.   die("Error: User not added to database.");
  62.   }
  63.  else
  64.   {
  65.   // Redirect to thank you page.
  66.   Header("Location: register.php?op=thanks");
  67.   }
  68.  } // end if
  69.  
  70. //The thank you page
  71. elseif ( $_GET["op"] == "thanks" )
  72.  {
  73.  echo "<h2>Thank you for registering!</h2>";
  74.  }
  75.  
  76. //The web form for input ability
  77. else
  78.  {
  79.  echo "<form action=\"?op=reg\" method=\"POST\">\n";
  80.  echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";
  81.  echo "Password: <input type=\"password\" name=\"password\"
    MAXLENGTH=\"16\"><br />\n"    ;
  82.  echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br
    />\n"    ;
  83.  echo "<input type=\"submit\">\n";
  84.  echo "</form>\n";
  85.  }
  86. // EOF
  87. ?>
  88.     </body> 
  89.     </html>
  90.  

  
PHPEdit User Community, © 2008 WaterProof SARL
Powered by PHPEdit