login form

maryam · 10-17-2005, 02:41 PM

please tell me how can I make a login form checking the username and password from a sql database.

Encenta.com · 10-17-2005, 02:48 PM

PHP Code:

   
????: NamePros.com http://www.namepros.com/programming/132600-login-form.html
if ($_POST['submit']) 

{ 

 
$db_host = "localhost";

$db_username = "xxxx";

$db_password = "xxxx";

$database = "xxxx";

 
 
mysql_connect(localhost,$db_username,$db_password);

@mysql_select_db($database) or die( "Unable to select database");

 
 
$passwordbeforemd5 = $_POST['password'];

 
$username = $_POST['username'];

$password = md5($passwordbeforemd5);

 
 
//Check user exists in database

$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1");

 
$login_check = mysql_num_rows($sql);

 
if ($login_check == "1") {

$_SESSION['logged_in'] = true;

include ("xxxx.php");

????: NamePros.com http://www.namepros.com/showthread.php?t=132600
                                }

else {

echo "we could not log you in";

      }

}

Something like that should do it. Just replace the xxxx's with whatever is necessary.

10-17-2005, 02:41 PM	THREAD STARTER #1 (permalink)
maryam New Member Join Date: Aug 2005 Posts: 7	login form please tell me how can I make a login form checking the username and password from a sql database.

10-17-2005, 02:48 PM	#2 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	PHP Code: ????: NamePros.com http://www.namepros.com/programming/132600-login-form.html if ($_POST['submit']) { $db_host = "localhost"; $db_username = "xxxx"; $db_password = "xxxx"; $database = "xxxx"; mysql_connect(localhost,$db_username,$db_password); @mysql_select_db($database) or die( "Unable to select database"); $passwordbeforemd5 = $_POST['password']; $username = $_POST['username']; $password = md5($passwordbeforemd5); //Check user exists in database $sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1"); $login_check = mysql_num_rows($sql); if ($login_check == "1") { $_SESSION['logged_in'] = true; include ("xxxx.php"); ????: NamePros.com http://www.namepros.com/showthread.php?t=132600 } else { echo "we could not log you in"; } } Something like that should do it. Just replace the xxxx's with whatever is necessary. __________________ Encenta - Amazon Associates CMS

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with a small php login form	TWM	Programming	5	08-03-2005 10:37 AM
Paypal Settlement	CMachuca	The Break Room	3	07-31-2004 11:14 PM
PAYPAL Litigation	johnn	Domain Name Discussion	6	07-31-2004 10:51 PM
Paypal Settlement	Lord	The Break Room	2	07-30-2004 10:30 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)