Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    3

    Unanswered: Helf for Login Form

    Hi all,
    I am new in php programming and I am trying to make a login form for administrator.

    Mysql code is :
    Code:
    CREATE DATABASE dbname;
    USE dbname;
    
    CREATE TABLE users (
    id mediumint(9) NOT NULL auto_increment,
    username varchar(15) default NULL,
    password varchar(15) default NULL,
    PRIMARY KEY (id)
    ) TYPE=MyISAM AUTO_INCREMENT=1;
    
    INSERT users VALUES(null,'pro','123456');
    and my file login.php :
    PHP Code:
    <?php
    // Connects to your Database
    mysql_connect("localhost""root""") or die(mysql_error());
    mysql_select_db("dbname") or die(mysql_error());

    //Checks if there is a login cookie
    if(isset($_COOKIE['ID_my_site']))

    //if there is, it logs you in and directes you to the members page
    {
    $username $_COOKIE['ID_my_site'];
    $pass $_COOKIE['Key_my_site'];
    $check mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
    while(
    $info mysql_fetch_array$check ))
    {
    if (
    $pass != $info['password'])
    {
    }
    else
    {
    header("Location: members.php");

    }
    }
    }

    //if the login form is submitted
    if (isset($_POST['submit'])) { // if form has been submitted

    // makes sure they filled it in
    if(!$_POST['username'] | !$_POST['pass']) {
    die(
    'You did not fill in a required field.');
    }
    // checks it against the database

    if (!get_magic_quotes_gpc()) {
    $_POST['email'] = addslashes($_POST['email']);
    }
    $check mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")or die(mysql_error());

    //Gives error if user dosen't exist
    $check2 mysql_num_rows($check);
    if (
    $check2 == 0) {
    die(
    'That user does not exist in our database. <a href=add.php>Click Here to Register</a>');
    }
    while(
    $info mysql_fetch_array$check ))
    {
    $_POST['pass'] = stripslashes($_POST['pass']);
    $info['password'] = stripslashes($info['password']);
    $_POST['pass'] = md5($_POST['pass']);

    //gives error if the password is wrong
    if ($_POST['pass'] != $info['password']) {
    die(
    'Incorrect password, please try again.');
    }

    else
    {

    // if login is ok then we add a cookie
    $_POST['username'] = stripslashes($_POST['username']);
    $hour time() + 3600;
    setcookie(ID_my_site$_POST['username'], $hour);
    setcookie(Key_my_site$_POST['pass'], $hour);

    //then redirect them to the members area
    header("Location: index.php");
    }
    }
    }
    else
    {

    // if they are not logged in
    ?>
    <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
    <table border="0">
    <tr><td colspan=2><h1>Login</h1></td></tr>
    <tr><td>Username:</td><td>
    <input type="text" name="username" maxlength="40">
    </td></tr>
    <tr><td>Password:</td><td>
    <input type="password" name="pass" maxlength="50">
    </td></tr>
    <tr><td colspan="2" align="right">
    <input type="submit" name="submit" value="Login">
    <input type="reset" name="reset" value="Clear">
    </td></tr>
    </table>
    </form>
    <?php
    }
    ?>
    What am I doing Wrong ??
    Because I am trying to login with correct username and password but I take error Incorrect password

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Try this tool.

    Happy to helf
    Last edited by mike_bike_kite; 10-07-09 at 07:35.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •