User/Pass Athentication...

Anon

I am trying to set up and authentication by checking the Username/Password combination that is already set up in a MySQL database. I.E. the username/password "jim"/"beam" is already set up in MySQL. I wan't this person to be able to enter that combination, have it checked against the the MySQL user table,

if(myql_connect("localhost", $username, $password)){
//execute code here
}

which would let them in if it matched, etc.

I would be willing to read a good tutorial. I am trying to figure out if sessions is the answer, but I wan't this to work in PHP3 and PHP4. Is there a way to track all of this info without putting it into a db table? Am I making any sense? Ask me questions if you're not clear on what I am asking.

Thanks, and sorry for the jumbled thoughts... it's late. =)

Anon

Try this:
(I use Sybase, so some certain commands
has to be changed in order to use MySQL)

<?php
if (!isset($doCheck))
{
?>

<head><title>Login</title></head>
<body>
<form method="POST" action=<? $PHP_SELF ?>>
<input type="hidden" name="doCheck" value="1">
<input type="textfield" name="name">
<input type="password" name="passwd">
<input type="submit">
</form>
</body>

<? }
else
{
$mysql = mysql_connect("a" , "b" , "");
mysql_select_db("c");
$sql = mysql_query("SELECT Username, Password from TABLE WHERE Username = '$name' AND Password = '$passwd'");

$result = $sql;
$num_of_rows = @mysql_num_rows($result);

if ($num_of_rows < 1) {
print "<H1>Sorry, wrong username and password</H1>";
mysql_close();
exit();
}
else {

header("Location: adress.php");
mysql_close();
}
}

Anon

Thank you for your suggestions! I still have a bit of a problem though... =)

I will be using the User/Pass combination that the user supplys to create a connection to the MySQL server. I won't be able to check the combination against the database, because I won't be logged in at that point. I also want to have sessioning of some type but do it without using the database to keep track of it.

Once again, If anyone knows of a good tutorial that would help with this, I am willing to read that. Just post the URL for me!

Thanks!

Anon

Hopefully
this is what your looking for:

http://www.phpbuilder.com/manual/features.php3