#29217 [Fbk->NoF]: Notice:Undefinied index :user
| From: | php-bugs at lists dot php dot net | Date: | Thu, 29 Jul 2004 23:00:07 +0000 |
| Subject: | #29217 [Fbk->NoF]: Notice:Undefinied index :user | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-63789@lists.php.net to get a copy of this message | ||
ID: 29217
Updated by: php-bugs@lists.php.net
Reported By: all4blitz at fftemple dot it
-Status: Feedback
+Status: No Feedback
Bug Type: Unknown/Other Function
Operating System: Windows 2000 Professional
PHP Version: 4.3.7
New Comment:
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
Previous Comments:
------------------------------------------------------------------------
[2004-07-16 22:17:57] georg@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try avoid embedding huge scripts into the report.
Please provide a small and working test script which
includes
a) a create table statement
b) an insert statement for necessary values in your table
c) the version of mysql server and client
d) provide the name of columns in your select statement,
instead of using SELECT *
------------------------------------------------------------------------
[2004-07-16 21:10:04] all4blitz at fftemple dot it
the first part of the code is like this sorry:
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$settings = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($sr["default"]=="Y"){
------------------------------------------------------------------------
[2004-07-16 21:08:54] all4blitz at fftemple dot it
the first part of the code is like this sorry:
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$settings = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($sr["default"]=="Y"){
------------------------------------------------------------------------
[2004-07-16 21:05:16] all4blitz at fftemple dot it
Description:
------------
After any mysql query, php returns this string:
"Notice: Undefined index: user in d:\etc..."
"user" is the name of the mysql called field.
But the page still works perfectly.
Reproduce code:
---------------
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$result = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($row["default"]=="Y"){
$url_noslash=$row["url_noslash"];
$siteurl=$row["url"];
$librerie_att=$row["librerie"];
$admin_user=$row["user"];
$admin_password=$row["password"];
$session_file=$row["sessionfile"];
$counter_hp=$row["contatore_hp"];
$counter_op=$row["contatore_op"];
$predlang=$row["lingua"];
$defaultpage=$row["homepage"];
$predskin=$row["skin"];
}
Expected result:
----------------
variable "$admin_user" equal to mysql field "user" to use in the
background
Actual result:
--------------
Notice: Undefined index: user in d:\etc... on line 11
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29217&edit=1