Mega Code Archive

 
Categories / Php / HTML
 

Use database to store user name and password

//login.html     <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">         Username:<br /><input type="text" name="username" size="10" /><br />         Password:<br /><input type="password" name="pswd" SIZE="10" /><br />         <input type="submit" value="Login" />       </form> //index.php <?php    session_start();    if (! isset($_SESSION['name'])) {       if (isset($_POST['username'])){          $username = $_POST['username'];          $pswd = $_POST['pswd'];          $conn=pg_connect("host=localhost dbname=corporate user=root password=") or die(pg_last_error($conn));          $query = "SELECT name FROM users WHERE username='$username' AND pswd='$pswd'";          $result = pg_query($conn, $query);          if (pg_num_rows($result) == 1){             $_SESSION['name'] = pg_fetch_result($result,0,'name');             $_SESSION['username'] = pg_fetch_result($result,0,'username');             echo "You're logged in. Feel free to return at a later time.";          }       } else {          include "login.html";       }    } else {        $name = $_SESSION['name'];        echo "Welcome back, $name!";     } ?>