mjcoco Posted April 28, 2008 Share Posted April 28, 2008 I'm sure this question is asked alot, but im having problems and cant figure out where im going wrong here. I have a login.php form, which uses the checklogin.php to validate the login. Here is what i have <?php $host="localhost"; // Host name $username="username"; // Mysql username $password="yourpass"; // Mysql password $db_name="checklog"; // 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"); // username and password sent from form $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 { echo "Wrong Username or Password"; } ?> I've altered $username="username"; // Mysql username to equal $username="" and for it to equal the same as the form name. Still cant get it to work. Any help would be appreciated. Here is the error i get Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'localhost' (using password: YES) in /checklogin.php on line 68 cannot connect Thanks in advance Quote Link to comment Share on other sites More sharing options...
mjcoco Posted April 28, 2008 Author Share Posted April 28, 2008 Ok, i figured it out... hostmonster has it set up odd. Anyway, i just needed to set the account_username and account_checklog oops anyway. I do have another question. I wanted to display the login form only when a user is not logged in. i know i need to use session_start() but im not sure exactly how to use it. Any help at all? Quote Link to comment Share on other sites More sharing options...
mjcoco Posted May 4, 2008 Author Share Posted May 4, 2008 Nevermind i fixed it with adding a simple checklogin function with a if else statement. 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.