Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jul 15th, 2012  |  syntax: None  |  size: 1.19 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Very Simple PHP   MySql Login Form Not Working?
  2. <?php
  3. mysql_connect("localhost", "username", "password");
  4. mysql_select_db("dbname");
  5. ?>
  6.  
  7. <body>
  8. <?php
  9. if(isset($_POST['submit'])){
  10. $username = $_POST['username'];
  11. $password = $_POST['password'];
  12.  
  13. $result = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");
  14. $num = mysql_num_rows($result);
  15. if($num == 0){
  16. echo "Bad login, go <a href='login.php'>back</a>.";
  17. }else{
  18. session_start();
  19. $_SESSION['username'] = $username;
  20. header("Location: admin.php");
  21. }
  22.  
  23.  
  24. }else{
  25. ?>
  26.  
  27.  
  28. <form action='login.php' method='post'>
  29.    Username: <input type='text' name='username' /><br />
  30.    Password: <input type='password' name='password' /><br /><br />
  31.    <input type='submit' value='Login' />
  32. </form>
  33. <?php
  34. }
  35. ?>
  36. </body>
  37.        
  38. if(isset($_POST['submit'])){
  39.        
  40. <input type='submit' name='submit' value='Login' />
  41.        
  42. mysql_real_escape_string($_POST['username']));
  43.   mysql_real_escape_string($_POST['username']));
  44.        
  45. <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  46.        
  47. <?php // some php scripting ?>
  48.  
  49. <!-- blank lines also counts as output -->
  50. <body>
  51.   <?php session_start(); header("What ever"); ?>
  52. </body>
  53.        
  54. <?php session_start(); ... ?>