Below is a script that reads a file with all my website users on it, it checks for usernames and passwords, I would like to switch to a database. Could you please show me how to convert the script to read from a database instead of a file....Thankyou!
$file = fopen('test.dat','r');
$i = 0;
do {
$i++;
$userinfo[$i]["username"] = trim(fgets($file,4096));
$userinfo[$i]["password"] = trim(fgets($file,4096));
$userinfo[$i]["realname"] = trim(fgets($file,4096));
$userinfo[$i]["rankingnumber"] = trim(fgets($file,4096));
$userinfo[$i]["rank"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecordwins"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecordlosses"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecorddisconnects"] = trim(fgets($file,4096));
$userinfo[$i]["icq"] = trim(fgets($file,4096));
$userinfo[$i]["aolim"] = trim(fgets($file,4096));
$userinfo[$i]["emailaddr"] = trim(fgets($file,4096));
$userinfo[$i]["joinTimeStamp"] = trim(fgets($file,4096));
$userinfo[$i]["loginTimeStamp"] = trim(fgets($file,4096));
$userinfo[$i]["space"] = trim(fgets($file,4096));
} while (!feof($file));
fclose($file);
for($x = 1; $x <= $i; $x++) {
if (($userinfo[$x]["username" == $sent_username) && ($userinfo[$x]["password"] == $sent_password)) {
$userid = $x;
$good_pw = 1;
setcookie("Cusername","$sent_username");
setcookie("Cpassword","$sent_password");
}
}
-Jason Rottman
