Databases

Anon

I have tried to get a mysql database to work on a remote server but it doesnt! on my server i dont want to pay £60 to upgrade just to get mysql. So could anyone help me by giving me a script that can make a .txt database and checks it for the username and password of a person. I dont want any fancy features i just want it to check if its right i have one at the moment which is a single username and password form where there is only one password and one username.
Here is the source for that maybe you could work with it?
<?
$mypass = 'qwerty';
$name = 'name';
if (isset($pass)) {
if ($pass == $mypass && $user == $name) {
setcookie ("admin", "yes");
echo "<meta http-equiv='Refresh' content='0; URL=" . $PHP_SELF . "'>";
} else {
echo "Wrong password, try again!<meta http-equiv='Refresh' content='1; URL=" . $PHP_SELF . "'>";
exit;
}
}
?>
In the body section i had
<?
if ((!isset($admin)) && ($admin != "yes")) {
echo "<form name=Login method=post action=" . $PHP_SELF . ">";
echo "<table width=94% border=0 cellspacing=0 cellpadding=0 height=19>";
echo "<tr><td height=21 width=13%><font face=Arial, Helvetica, sans-serif size=1 color=#FF0000>";
echo "Username<br></font></td><td height=21 width=14%><input type=text name=user style=</td>";
echo "<td height=21 width=5%><font face=Arial, Helvetica, sans-serif size=1 color=#FF0000>Password</font></td><td height=21 width=12%><input type=password name=pass style=</td><td height=21 width=56%><font face=Arial, Helvetica, sans-serif size=1 color=#FF0000><input onMouseOver=\"this.style.background=\'#FFcc00\'\" onMouseOut=\"this.style.background=\'#FF9900\'\" type=submit name=submit value=Login style=<font size=2>Dont Have an account? <a href=signupform.htm>Sign Up!</a></font></font></td></tr></table></form>";
exit;
}
?>
Hope you can help!

Anon

Josh,

On the remote server with mysql, does your usr have remote access, or is it set up for local access only. If you don't admin that box, you might want to ask your admin to check where you can access from. As for a txt database, sorry, I can't help there. I just had a similar problem with one of my guys trying to access from the outside IP rather than 'localhost' on one of his scripts. I changed his script to access from inside and he was fine, likewise, I could have given him outside access and all would have also been well. I try to keep a limit on outside access which is why I moved his script to look inside.

You could also download MySQL from http://www.mysql.com. There you can find releases for whatever OS you are running. Do check their licensing terms, commercial users have to pay a licensing fee, while non-commercial users don't.

The downloads aren't that large, and come with documentation on instalation.

Hope this helps.

Charles

Anon

You can also look at www.hotscripts.com, wheter there is already something like that.