Jump to content

[SOLVED] MySQL Login question


mjcoco

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.