调试PDO连接和PHP输出 [英] DEBUG PDO Connection & PHP Output

问题描述

我正在尝试使用PDO连接到mySQL.

I am trying to connect to mySQL using PDO.

如果我犯了一个明显的错误，请原谅我-我只是在学习...

Please forgive me if I have made a glaring error - I am just learining...

 <?php

try {
    $db_conn = new PDO('mysql:host=localhost;dbname=testdatabase','test', 'testpass');  
} 
catch (PDOException $e) {
    echo 'Could not connect to database';
}

$stmt = $db_conn->query('SELECT * FROM PRODUCTS');

while ($row = $stmt->fetch() ) {
    echo '<pre>'; print_r($row); echo '<pre>';
}

?>

浏览器的输出如下:

query('SELECT * FROM PRODUCTS'); while ($row = $stmt->fetch() ) { echo '
'; print_r($row); echo '
';
}

?>

我做错了什么???为什么PHP无法解析PHP脚本?

What have I done wrong??? why is PHP not parsing the PHP script?

更新:

如果我创建一个新的php文件，并运行phpinfo();可以.

If I create a new php file, and run phpinfo(); it works.

如果我将phpinfo()粘贴到上述代码的顶部，如下所示:

If I paste phpinfo() into the top of the above code as follows:

<?php

phpinfo();

echo '<h1>PDO TEST</h1>';

try {
    $db_conn = new PDO('mysql:host=localhost;dbname=testdatabase','test', 'testpass');  
} 
catch (PDOException $e) {
    echo 'Could not connect to database';
}

$stmt = $db_conn->query('SELECT * FROM Products');

while ($row = $stmt->fetch() ) {
    echo '<pre>'; print_r($row); echo '<pre>';
}

?>

我得到以下输出:

PDO TEST'; try { $db_conn = new PDO('mysql:host=localhost;dbname=testdatabase','test', 'testpass');  } catch (PDOException $e) { echo 'Could not connect to database'; } $stmt = $db_conn->query('SELECT * FROM Products'); while ($row = $stmt->fetch() ) { echo '
'; print_r($row); echo '
';
}

?>

更新: 问题已解决...这是某种文件编码问题.当我将代码复制并粘贴到新文件中时，它可以完美地工作.很奇怪.

UPDATE: Problem solved... It was some kind of file encoding issue. It works perfectly when I copy and paste the code into a new file. Very strange.

推荐答案

打开httpd.conf文件，并将此行添加到内部:

Open httpd.conf file and Add this line inside :

AddType application/x-httpd-php .php .phtml 

这使您的PHP脚本由PHP解释器执行.

This makes your PHP script execute by PHP interpreter.

Then restart apache server using /etc/init.d/apache2 or httpd restart

这篇关于调试PDO连接和PHP输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！