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???