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??? 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? 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. 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
Archived
This topic is now archived and is closed to further replies.