Storing info in a PostgreSQl database issue

Posted by MrEnder on Stack Overflow See other posts from Stack Overflow or by MrEnder
Published on 2010-04-05T00:21:14Z Indexed on 2010/04/05 0:23 UTC
Read the original article Hit count: 655

Filed under:
|
|
|

Ok I am making a registry for my website.

First page asks for some personal info

        if($error==false) {

        $query = pg_query("INSERT INTO chatterlogins(firstName, lastName, gender, password, ageMonth, ageDay, ageYear, email, createDate) VALUES('$firstNameSignup', '$lastNameSignup', '$genderSignup', md5('$passwordSignup'), $monthSignup, $daySignup, $yearSignup, '$emailSignup', now());");
        $query = pg_query("INSERT INTO chatterprofileinfo(email, lastLogin) VALUES('$emailSignup', now());");
        $userNameSet = $emailSignup;
        $_SESSION['$userNameSet'] = $userNameSet;
        header('Location: signup_step2.php'.$rdruri);

    }

The first query works. The second query works but doesn't save the email...

the session doesn't work but the header works and sends me to the next page

I get no errors even if I comment out header

next page

    @session_start();

$conn = pg_connect("host=localhost dbname=brittains_db user=brittains password=XXXX" );

$signinCheck = false;
$checkForm = "";

if(isset($_SESSION['$userName'])) {

    $userName = $_SESSION['$userName'];
    $signinCheck = true;
    $query = pg_query("UPDATE chatterprofileinfo SET lastLogin='now()' WHERE email='$userName'");

}

if(isset($_SESSION['$userNameSet'])) {

    $userName = $_SESSION['$userNameSet'];
    $signinCheck = true;
    $query = pg_query("UPDATE chatterprofileinfo SET lastLogin='now()' WHERE email='$userName'");

}

This is the top starting the session depending on if your logged in or not.

then if I enter in the info here and put it through this

if($error==false) {

    $query = pg_query("UPDATE chatterprofileinfo SET aboutSelf='$aboutSelf', hobbies='$hobbies', music='$music', tv='$tv', sports='$sports', lastLogin='now()' WHERE email='$userName'") or exit(pg_last_error());
    //header('Location: signup_step3.php'.$rdruri);

}

nothing shows up for on my database from this.

I have no idea where I went wrong

the website is

http://opentech.durhamcollege.ca/~intn2201/brittains/chatter/

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about php