Not Correct Login
Moderator: General Moderators
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm
-
timhortons
- Forum Commoner
- Posts: 29
- Joined: Thu Jan 15, 2004 11:48 am
- Location: Calgary, AB, Canada
- SilverMist
- Forum Commoner
- Posts: 65
- Joined: Tue Mar 02, 2004 2:06 pm
- Location: Canada
- Contact:
I edited it and it should work now. The posts came so fast after I told you.
Code: Select all
<?php
$host = "localhost";
$dbusername = "user";
$password = "pass";
$database = "db";
// Connect to mysql and database
$link = mysql_connect($host, $dbusername, $password)
or die("<P>Could not connect: ".mysql_error()."</P>");
mysql_select_db($database)
or die("<P>Could not select database</P>");
$username = $HTTP_POST_VARS['txtName'];
$password = $HTTP_POST_VARS['txtPassword'];
$query = "SELECT * FROM Members WHERE Name = '".$username."' AND Password = '".$password."'";
$result = mysql_query($query) or die("<P>Query failed: ".mysql_error()."</P>");
// Check to see if user exists
if(mysql_num_rows($result) > 0)
{
// Make cookie for user
if(setcookie("loginname", $username))
{
echo "Welcome";
}
else
{
echo "Error setting cookie.";
}
}
else
{
echo "Failed login.";
}
?>- SilverMist
- Forum Commoner
- Posts: 65
- Joined: Tue Mar 02, 2004 2:06 pm
- Location: Canada
- Contact:
- SilverMist
- Forum Commoner
- Posts: 65
- Joined: Tue Mar 02, 2004 2:06 pm
- Location: Canada
- Contact:
Code: Select all
<?php
$query = "SELECT * FROM Members WHERE Name = '".$username."' AND Password = '".$password."'";
?>- SilverMist
- Forum Commoner
- Posts: 65
- Joined: Tue Mar 02, 2004 2:06 pm
- Location: Canada
- Contact:
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm