调试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屋!