MySQL column into PHP array error

Question

I have a problem with getting MySQL column into php array variable , for further foreach() cycling.

Here is my code:

$files=array();
$filesFetch = "SELECT FileName FROM articledata";
$rs=mysql_query($filesFetch);
while($rd=mysql_fetch_object($rs))
{
$files[]=$rd->files;
}

if (!$files) {
    die('getting filenames failed');
}
foreach ($files as $key => $id) 
{  //... do the stuff }

I am not getting stopped at the die condition, but my error says:

Notice: Undefined property: stdClass::$files

I assume there is problem with formatting, because this error notice repeats :"rowCountTimes"

Also this error appears for the line.

$files[]=$rd->files;

Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — tereško
– tereško, Commented Oct 11, 2012 at 23:02

andrewsi · Accepted Answer · 2012-10-11 19:28:32Z

2

Your object has properties based on the column names; you need to use:

$files[]=$rd->fileName;

answered Oct 11, 2012 at 19:28

andrewsi

10.7k132 gold badges37 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JvdBerg · Accepted Answer · 2012-10-11 19:28:56Z

0

You are fetching FileName, so you must use that in your object:

$files[]=$rd->FileName;

answered Oct 11, 2012 at 19:28

JvdBerg

21.8k8 gold badges40 silver badges55 bronze badges

1 Comment

Slytherin Over a year ago

Thank You , same as the guys above

hjpotter92 · Accepted Answer · 2012-10-11 19:29:50Z

0

It should be

$rd->FileName

instead of $rd->files since your column name is FileName

answered Oct 11, 2012 at 19:29

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Comments

Aljana Polanc · Accepted Answer · 2012-10-11 19:33:27Z

0

The code you wrote certainly doesn't make sense. You are fetching an object which is saved in a variable $rd. Then you are trying to access property files but of course that is undefined since you only fetched the column named FileName.

So use instead: $files[] = $rd->FileName;

answered Oct 11, 2012 at 19:33

Aljana Polanc

9508 silver badges12 bronze badges

Collectives™ on Stack Overflow

MySQL column into PHP array error

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest