Login Script that uses mysql

[josh.legogeek]

Hi,
I'm looking for a FREE php script that uses mysql to make a login page. I would like one that has a create your account page. Right now I am using ezUserManager, but it does not work well.
Thanks!

[glambert]

this php code will check a posted username and password in a users table on mysql. if you need a full script the message me


<?php
session_start();
if(isset($_POST['login'])){
if(!empty($_POST['username']) && !empty($_POST['password'])){
mysql_connect('host', 'user', 'pass');
mysql_select_db('database');
$q=mysql_query("select * from users where username = '".$_POST['username']."' and password = '".$_POST['password']."' limit 1") or die(mysql_error());
if(mysql_num_rows($q) != '1'){
die('user not found');
}else{
$_SESSION['logged_in']='1';
header("Location: /home.php");exit();
}
}

session_write_close();

?>

[josh.legogeek]

I might be able to work with that, but I found an xml one that works fine.
Thanks anyways!