ID: 20901
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: Performance problem
Operating System: Win2K Server
PHP Version: 4.2.3
New Comment:
Try this one, it really takes ages:
function verify_login($username, $password) {
/* verify the username and password. if it is a valid login, return an
array
* with the username, firstname, lastname, and email address of the
user */
$qid = db_query("
SELECT username, firstname, lastname, email, priv
FROM users
WHERE username = '$username' AND password = '" . md5($password) . "'
");
return db_fetch_array($qid);
}
Previous Comments:
------------------------------------------------------------------------
[2002-12-09 06:21:52] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
AFAIK, no browser is able to access MySQL, so some example code would
be pleasant.
------------------------------------------------------------------------
[2002-12-09 06:04:06] [EMAIL PROTECTED]
Querying MySQL takes an awfully long time from Netscape. I am running
4.08 and cannot comment about other versions. IE 5.5 does not display
this problem.
A clue to debugging this is that changing focus after the query brings
the result back immediately.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=20901&edit=1
