adredz Posted May 8, 2010 Share Posted May 8, 2010 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??? Quote Link to comment https://forums.phpfreaks.com/topic/201084-function-to-insert-data-into-my-db-not-working/ Share on other sites More sharing options...
RichardRotterdam Posted May 8, 2010 Share Posted May 8, 2010 is this function part of a class? And what error do you receive? Quote Link to comment https://forums.phpfreaks.com/topic/201084-function-to-insert-data-into-my-db-not-working/#findComment-1055000 Share on other sites More sharing options...
PFMaBiSmAd Posted May 8, 2010 Share Posted May 8, 2010 The nettuts site has at least three different php scripts that cover user registration. Quote Link to comment https://forums.phpfreaks.com/topic/201084-function-to-insert-data-into-my-db-not-working/#findComment-1055056 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.