Hello dear group I have a problem with an authentication in mysql. I got a database-table 'user' with columns for 'login' and 'passwort' and several other columns. A customer shall be able to enter his UserID and Password into fields (html input types) and these are posted to the following php-script: Further explanation: $usid comes from the <input type = 'text' ...> for the username $pass comes from the <input type = password...> for the password. The problem: I wrote the php on my machine, where I have LAMP running, and everything works fine. Then I installed everything to a server, which is intented for the job, but now the username fails, unless it's working on my machine. What is wrong, I just cannot explain??? Im completely pzzled and confused.
Please help me. It would be nice if you'd cc to my email-address too. Thank you very much for your interest. dennis <?php $host = "localhost"; $user = "load"; $pass = "+u3§sr"; $dbname = "rbos"; $conex = mysql_pconnect($host, $user, $pass); if (mysql_select_db($dbname, $conex)) { $getuser = mysql_query('Select * from user where login = "'.$usid.'"'); //usid kommt aus dem Eingabefeld $exuser = '[a-zA-Z]+'; if($entity = mysql_fetch_object($getuser)) { if (ereg($pwd, $entity->passwort)) { echo "Vielen Dank, Anmeldung erfolgreich"; echo "<br>Willkommen ".$entity->vorname." ".$entity->nachname; } else { echo "Login not successful (check Password)"; } } else echo "Login not successful (check Username)"; mysql_free_result($getuser); } else { echo "Can't connect to database !!! <br>"; echo mysql_errno() . " : " . mysql_error() . "<hr>"; } ?> TABLE USER: mysql> describe user; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | nummer | int(4) | YES | | NULL | | | login | varchar(8) | YES | | NULL | | | passwort | varchar(8) | YES | | NULL | | | vorname | varchar(255) | YES | | NULL | | | nachname | varchar(255) | YES | | NULL | | | gruppe | varchar(30) | YES | | NULL | | | level | int(1) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php