jonathanchacon Posted September 18, 2009 Share Posted September 18, 2009 I have this login script that I got online and while the script works and it does access the database, it doesn't actually input the users and their passwords into the database.Here is the php for the login: <?php ob_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Define $myusername and $mypassword $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { header("location:http://www.yahoo.com"); } ob_end_flush(); ?> I only use yahoo as a location til I get the direct link to where it will eventually point to. The database does not show anyone who has logged in. It is also supposed to send them to the login_success.php page if they have logged in before. Where is the error in my code? Quote Link to comment Share on other sites More sharing options...
btherl Posted September 18, 2009 Share Posted September 18, 2009 Change this line: $result=mysql_query($sql); to $result=mysql_query($sql) or die("Error in $sql: " . mysql_error()); Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 18, 2009 Share Posted September 18, 2009 PHP won't write into MySQL database That's because the code you posted is attempting to match what is in the database to log someone in. It is not attempting to write anything in to a database. The database does not show anyone who has logged inThere is no code in the code you posted to do that. It is also supposed to send them to the login_success.php page if they have logged in beforeThere's nothing in it testing if they previously did anything. Where is the error in my code?The code you posted does not contain or do most of what you stated it is supposed to be doing. What is your actual code? Quote Link to comment Share on other sites More sharing options...
DJTim666 Posted September 18, 2009 Share Posted September 18, 2009 Lmfao. This is a login script. Not a register script. Try creating one of those to first create the users you want to login to your site. I'm sure you can find a few free register scripts on google. Quote Link to comment Share on other sites More sharing options...
jonathanchacon Posted September 18, 2009 Author Share Posted September 18, 2009 Thanks for the input, i'll look for a register script. I don't deal much with php, I'm just a graphic designer and trying to learn the ropes of web design. I do have html and css down, but just starting to learn the basics of php Quote Link to comment 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.