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 to write new code. They are no longer maintained and the community has begun [deprecation process](http://goo.gl/KJveJ). See the [*red box*](http://goo.gl/GPmFd)? Instead you should learn about [prepared statements](http://goo.gl/vn8zQ) and use either [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli). If you can't decide which, [this article](http://goo.gl/3gqF9) will help you. If you pick PDO, [here is good tutorial](http://goo.gl/vFWnC). — tereško, Oct 11 '12 at 23:02

score 2 · Accepted Answer · answered Oct 11 '12 at 19:28

2

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

$files[]=$rd->fileName;

answered Oct 11 '12 at 19:28

andrewsi

10,807
132
35
51

score 0 · Answer 2 · answered Oct 11 '12 at 19:28

0

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

$files[]=$rd->FileName;

answered Oct 11 '12 at 19:28

JvdBerg

21,777
8
38
55

Thank You , same as the guys above – Slytherin Oct 11 '12 at 19:36

score 0 · Answer 3 · answered Oct 11 '12 at 19:29

0

It should be

$rd->FileName

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

answered Oct 11 '12 at 19:29

hjpotter92

78,589
36
144
183

score 0 · Answer 4 · answered Oct 11 '12 at 19:33

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;

MySQL column into PHP array error

4 Answers4