Jump to content

function to insert data into my db not working... :(


adredz

Recommended Posts

I found a tutorial from nettuts about Login system and it has a source code in it so tried implementing it in my site.. It is working now. However, it doesn't have a Registration system so I am making one. The thing is, as I have expected, my code is not working... It doesn't seem to know how to INSERT into the database. Here's the function that inserts data into the db.

function register_User($un, $email, $pwd) {
    $query = "INSERT INTO users( username, password, email )
                    VALUES(:uname, :pwd, :email)
                    LIMIT 1";

    if($stmt = $this->conn->prepare($query)) {
        $stmt->bind_param(':uname', $un);
        $stmt->bind_param(':pwd', $pwd);
        $stmt->bind_param(':email', $email);
        $stmt->execute();

        if($stmt->fetch()) {
            $stmt->close();
            return true;
        } else return "The username or email you entered is already in                      
                      use...";
    }
}

 

Can you please help me pen point the error in this??? :(

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.