Results 1 to 3 of 3

Thread: help me with signup and login script

  1. #1
    Join Date
    Jun 2013

    help me with signup and login script

    this is my sign up script...
    PHP Code:

    $lname $_POST['lname'];
    $gender $_POST['gender'];
    $email $_POST['email'];
    $password1 $_POST['pass1'];
    $password2 $_POST['pass2'];
    $password1 != $password2)
    header('Location: signup.html');

    $passwordHash sha1($_POST['pass1']);
    $mysqli = new mysqli('localhost''root''dhiraj''test'); //we change the mysqli_connect to "new mysqli"
    $query "INSERT INTO users ( u_fname, u_lname, gender,u_email, u_pass) VALUES 
            ( '
    $fname', '$lname', '$gender' , '$email', '$passwordHash' )";
    //remove $conn variable in order to connect to our database using OOP.
    header('Location: index.html');
    and this is login script

    PHP Code:
    $passwordHash sha1($_POST['log_pass']);
    $conn mysqli_connect('localhost''root''dhiraj''test');

    $query "SELECT u_fname
            FROM users
            WHERE u_email = '
    $email' AND u_pass='$passwordHash';";
    $result mysqli_query($conn$query);
    mysqli_num_rows($result) < 1
    'Sorry, your username or password was incorrect!';
    // this echo statement gets executed. what is the problem?

    /* Log user in */
    echo "Welcome back $_POST['log_email'] ";
    So everything works ...has is calculated on password...database gets updated bu the problem is after login
    the echo statement gets executed ..means no result generated from the query in the login script.
    pls help me.

    would love if provide any script. Thanks
    Last edited by NogDog; 08-22-2013 at 12:36 PM. Reason: added [php] tags

  2. #2
    Join Date
    Jul 2013
    Voorheesville NY USA
    If you had written proper code that checked for errors you would have seen an sql error in your query. You have an extra semi in your query.

  3. #3
    Join Date
    Mar 2007
    Your script security is very poor, your script is open to attack.

    You need to check if the script the $_POST['submit'] is present when executed and also have a function to sanitize the inputs in to an array.

    You will find plenty of examples already posted on this site.
    --> JavaScript Frameworks like JQuery, Angular, Node <--
    ... and please remember to wrap code with forum BBCode tags:-

    [CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]

    If you can't think outside the box, you will be trapped forever with no escape...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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