Problem using foreach to loop pdo results

rafaelrgl
rafaelrgl used Ask the Experts™
on
Here is the scenario. On my local vm this works great. but on the production server does not work.

My VM where the code works:
uname -a
Linux dev 3.13.0-65-generic #106-Ubuntu SMP Fri Oct 2 22:08:27 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
root@dev:/var/www# php -v
PHP 5.5.9-1ubuntu4.14 (cli) (built: Oct 28 2015 01:34:46)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
    with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies
root@dev:/var/www# mysql --version
mysql  Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3

Open in new window


The Production server:
 
uname -a
Linux  2.6.32-573.8.1.el6.x86_64 #1 SMP Tue Nov 10 18:01:38 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@server1 ~]# php -v
PHP 5.4.45 (cli) (built: Mar  2 2016 16:08:51)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
[root@server1 ~]# mysql --version
mysql  Ver 14.14 Distrib 5.5.48, for Linux (x86_64) using readline 5.1

Open in new window


Here is the code:
Screenshot_5.png
so above i have this code. on my vm i get the result['filename'] printed as it should be. but on my production server I got printed the word "Array"

So what is going on here. pls help me.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2016
Commented:
At first glance, your code looks correct to me, but it's a data-dependent problem, so we would need to see the data.

When you try to print a PHP array (or otherwise convert it to a string) PHP returns "array."  Not very helpful!

Here is the man page for fetchAll():
http://php.net/manual/en/function.var-dump.php

Try looking directly at the raw data.  You can use var_dump($results) to see what the data structure looks like.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial