Back to General and Gameplay Programming

PHP and Mysql problem

demonrealms · 2003-06-18T07:23:25

Hey, I can''t figure out what''s wrong with this code. Could you tell me please. <html> <head> <script> document.title="Demon Realms Studios->Login"; window.status="Demon Realms Studios->Login"; </script> <title>Demon Realms Studios->Login</title> </head> <body bgcolor="#FFFFFF"> <?php if($submit) { $dbh=mysql_connect ("localhost", "demonrea_admin", "demon45gars") or die (''I cannot connect to the database because: '' . mysql_error()); mysql_select_db ("demonrea_user"); $sql = "SELECT auth_level FROM auth WHERE username =''$username'' AND password = ''$password'' "; $result = mysql_query($sql, $dbh); while ($row = mysql_fetch_array($result)) { $auth_level = $row["auth_level"]; } if (!mysql_num_rows($result)) { echo "You are not Authorized for access."; }else { setcookie(''username'', $_POST[''username''], (time()+2592000), ''/'', '''', 0); setcookie(''auth_level'', $_POST[''auth_level''], (time()+2592000), ''/'', '''', 0); } if ($auth_level == "1") { echo "You are logged in as a Guest.<br /> <a href=''next.php''>Click here for options</a> "; } elseif ($auth_level == "2") { echo "You have Member level access.<br /> <a href=''next.php''>Click here for options</a> "; } elseif ($auth_level == "3") { echo "You have Editor level access.<br /> <a href=''next.php''>Click here for options</a> "; } elseif ($auth_level == "4") { echo "You have Administrative access.<br /> <a href=''next.php''>Click here for options</a> "; } ?> <form method="POST" action="<?php echo $GLOBALS [''PHP_SELF''];?>"> Name:<input type="text" name="username"><br /> Password: <input type="password" name="password"><br /> <input type="submit" name="submit" value="Login"> </form> </body> </html> Thanks, Demonrealms

General and Gameplay Programming Programming

Started by demonrealms June 16, 2003 01:24 PM

9 comments, last by demonrealms 20 years, 10 months ago

LousyPhreak

133

June 18, 2003 07:23 AM

Server: Apache/2.0.45 (Win32) PHP/4.3.1
works

Server: Apache/1.3.27 (Unix) Debian GNU/Linux PHP/4.2.3
works not...

the php 4.3.1 version might be a bit improved...

mfg Phreak
--
"Input... need input!" - Johnny Five, Short Circuit.

http://mitglied.lycos.de/lousyphreak/

PHP and Mysql problem

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

PHP and Mysql problem

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

Reticulating splines