ID: 49181 User updated by: adaro2000 at yahoo dot fr Reported By: adaro2000 at yahoo dot fr -Status: Feedback +Status: Open Bug Type: Apache2 related Operating System: Win XP Pro Version 2002 SP2 PHP Version: 5.2.10 New Comment:
I run it on command line as suggested. I'm having an error. I have a prompt saying that CLI encouter an error and must .... I run a query like this "SELECT login FROM admin". Everything is OK. But have i run a query of more than one column that the error occure. Any idea ? Previous Comments: ------------------------------------------------------------------------ [2009-08-06 20:06:09] [email protected] Try run the script on command line using the CLI binary. ------------------------------------------------------------------------ [2009-08-06 18:15:52] adaro2000 at yahoo dot fr Description: ------------ I install Xampp xampp-win32-1.7.0-installer. Php version is 5.2.8, Mysql version 5.1.30, Apache version 2.2.11 I'm using PDO to query my database. As i query out a result of more than one column, apache restart, and in log i read : [Thu Aug 06 17:53:23 2009] [notice] cannot use a full URL in a 401 ErrorDocument directive --- ignoring! [Thu Aug 06 17:53:31 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting. [Thu Aug 06 17:53:31 2009] [notice] Digest: generating secret for digest authentication ... [Thu Aug 06 17:53:31 2009] [notice] Digest: done Reproduce code: --------------- This produces an error : <?php $pdo = new PDO('mysql:host=localhost;dbname=data','user','pass'); $result = $pdo->query("SELECT login, pass FROM admin"); $result->setFetchMode(PDO::FETCH_OBJ); foreach ($result AS $line){ echo '<label class="nom">'.$line->login.'</label>'; echo '<label class="rates">'.$line->pass.'</label>'; } ?> Expected result: ---------------- I hope this will print data, but not. I run this without problem : <?php $pdo = new PDO('mysql:host=localhost;dbname=data','user','pass'); $result = $pdo->query("SELECT COUNT(*) as Me FROM admin"); $result->setFetchMode(PDO::FETCH_OBJ); foreach ($result AS $line){ echo '<label class="nom">'.$line->Me.'</label>'; } ?> It prints the exact number. Actual result: -------------- The browser seems to load the page, but i have a prompt Apache HTTP encouter an error and must... and the log is what i show on the top. Can you help me please ? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=49181&edit=1
