FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » php PDO does not work
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
php PDO does not work [message #177281] Sat, 03 March 2012 10:10 Go to next message
test japan is currently offline  test japan
Messages: 2
Registered: March 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
i installed php and mysql on archlinux by pacman,
and in phpinfo page, i can see the infomation about mysql & pdo_mysql

in php.ini, i uncommented the following lines:
extension=mysqli.so
extension=mysql.so
extension=pdo_mysql.so

but when running the code below, the browser shows a blank page
no result, even no error message.

try {
$dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
echo 'Connected to database!!';
} catch (PDOException ex) {
echo $ex->getMessage();


anyone can help me?
thanks!
Re: php PDO does not work [message #177282 is a reply to message #177281] Sat, 03 March 2012 10:34 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 03-03-2012 16:10, test japan wrote:
> i installed php and mysql on archlinux by pacman,
> and in phpinfo page, i can see the infomation about mysql & pdo_mysql
>
> in php.ini, i uncommented the following lines:
> extension=mysqli.so
> extension=mysql.so
> extension=pdo_mysql.so
>
> but when running the code below, the browser shows a blank page
> no result, even no error message.
>
> try {
> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
> echo 'Connected to database!!';
> } catch (PDOException ex) {

change above line to:
} catch (PDOException $ex) {


> echo $ex->getMessage();
>
>
> anyone can help me?
> thanks!
Re: php PDO does not work [message #177285 is a reply to message #177281] Sat, 03 March 2012 12:59 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 3/3/2012 10:10 AM, test japan wrote:
> i installed php and mysql on archlinux by pacman,
> and in phpinfo page, i can see the infomation about mysql& pdo_mysql
>
> in php.ini, i uncommented the following lines:
> extension=mysqli.so
> extension=mysql.so
> extension=pdo_mysql.so
>
> but when running the code below, the browser shows a blank page
> no result, even no error message.
>
> try {
> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
> echo 'Connected to database!!';
> } catch (PDOException ex) {
> echo $ex->getMessage();
>
>
> anyone can help me?
> thanks!

On your development system, enable error reporting and display the
errors. In your php.ini file you should have:

error_reporting = E_ALL
display_errors = on

Note you do NOT want to have display_errors=on in a production
environment, and should log the errors instead.

Once you fix the syntax error(s) (Luuk found one - don't know if you
have any others), you shouldn't get a blank page.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Re: php PDO does not work [message #177287 is a reply to message #177285] Sat, 03 March 2012 20:08 Go to previous messageGo to next message
test japan is currently offline  test japan
Messages: 2
Registered: March 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
thanks for your help!

On Sunday, March 4, 2012 1:59:26 AM UTC+8, Jerry Stuckle wrote:
> On 3/3/2012 10:10 AM, test japan wrote:
>> i installed php and mysql on archlinux by pacman,
>> and in phpinfo page, i can see the infomation about mysql& pdo_mysql
>>
>> in php.ini, i uncommented the following lines:
>> extension=mysqli.so
>> extension=mysql.so
>> extension=pdo_mysql.so
>>
>> but when running the code below, the browser shows a blank page
>> no result, even no error message.
>>
>> try {
>> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
>> echo 'Connected to database!!';
>> } catch (PDOException ex) {
>> echo $ex->getMessage();
>>
>>
>> anyone can help me?
>> thanks!
>
> On your development system, enable error reporting and display the
> errors. In your php.ini file you should have:
>
> error_reporting = E_ALL
> display_errors = on
>
> Note you do NOT want to have display_errors=on in a production
> environment, and should log the errors instead.
>
> Once you fix the syntax error(s) (Luuk found one - don't know if you
> have any others), you shouldn't get a blank page.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex(at)attglobal(dot)net
> ==================



On Sunday, March 4, 2012 1:59:26 AM UTC+8, Jerry Stuckle wrote:
> On 3/3/2012 10:10 AM, test japan wrote:
>> i installed php and mysql on archlinux by pacman,
>> and in phpinfo page, i can see the infomation about mysql& pdo_mysql
>>
>> in php.ini, i uncommented the following lines:
>> extension=mysqli.so
>> extension=mysql.so
>> extension=pdo_mysql.so
>>
>> but when running the code below, the browser shows a blank page
>> no result, even no error message.
>>
>> try {
>> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
>> echo 'Connected to database!!';
>> } catch (PDOException ex) {
>> echo $ex->getMessage();
>>
>>
>> anyone can help me?
>> thanks!
>
> On your development system, enable error reporting and display the
> errors. In your php.ini file you should have:
>
> error_reporting = E_ALL
> display_errors = on
>
> Note you do NOT want to have display_errors=on in a production
> environment, and should log the errors instead.
>
> Once you fix the syntax error(s) (Luuk found one - don't know if you
> have any others), you shouldn't get a blank page.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex(at)attglobal(dot)net
> ==================
Re: php PDO does not work [message #177292 is a reply to message #177281] Mon, 05 March 2012 04:23 Go to previous messageGo to next message
alvaro.NOSPAMTHANX is currently offline  alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
El 03/03/2012 16:10, test japan escribió/wrote:
> i installed php and mysql on archlinux by pacman,
> and in phpinfo page, i can see the infomation about mysql& pdo_mysql
>
> in php.ini, i uncommented the following lines:
> extension=mysqli.so
> extension=mysql.so

As far as I know, these are unrelated to PDO.


> extension=pdo_mysql.so

Correct, this is the PDO driver for MySQL, though I don't really
understand why pdo_mysql actually showed up in phpinfo() if this line
was commented out :-?


> but when running the code below, the browser shows a blank page
> no result, even no error message.
>
> try {
> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username", "password");
> echo 'Connected to database!!';
> } catch (PDOException ex) {
> echo $ex->getMessage();

Assuming there's a PHP start tag, you should be getting this:

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE

I suggest you configure your development box to display all possible
errors. You have several ways to do so:

1. Edit your "php.ini" file:

error_reporting = E_ALL | E_STRICT
display_errors = On

2. Put this on top of your script:

<?php
error_reporting(E_ALL | E_STRICT);
ini_set('display_errors', TRUE);

3. If PHP runs as Apache module, you can also use an `.htaccess` file:

# You cannot use PHP constants here
php_value error_reporting -1
php_flag display_errors on

This is not specifically related to PDO, it's how PHP error reporting
works in general.



Additionally, PDO will not throw exceptions unless you tell it to
because the default mode is PDO::ERRMODE_SILENT:

http://es2.php.net/manual/en/pdo.error-handling.php

This also implies that you cannot use exceptions to capture connection
errors unless you set PDO::ERRMODE_EXCEPTION in the constructor.


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
Re: php PDO does not work [message #177295 is a reply to message #177292] Mon, 05 March 2012 08:04 Go to previous message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 3/5/2012 4:23 AM, "Álvaro G. Vicario" wrote:
> El 03/03/2012 16:10, test japan escribió/wrote:
>> i installed php and mysql on archlinux by pacman,
>> and in phpinfo page, i can see the infomation about mysql& pdo_mysql
>>
>> in php.ini, i uncommented the following lines:
>> extension=mysqli.so
>> extension=mysql.so
>
> As far as I know, these are unrelated to PDO.
>
>
>> extension=pdo_mysql.so
>
> Correct, this is the PDO driver for MySQL, though I don't really
> understand why pdo_mysql actually showed up in phpinfo() if this line
> was commented out :-?
>
>
>> but when running the code below, the browser shows a blank page
>> no result, even no error message.
>>
>> try {
>> $dbh = new PDO("mysql:host=192.168.0.1;dbname=testdb", "username",
>> "password");
>> echo 'Connected to database!!';
>> } catch (PDOException ex) {
>> echo $ex->getMessage();
>
> Assuming there's a PHP start tag, you should be getting this:
>
> Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE
>
> I suggest you configure your development box to display all possible
> errors. You have several ways to do so:
>
> 1. Edit your "php.ini" file:
>
> error_reporting = E_ALL | E_STRICT
> display_errors = On
>
> 2. Put this on top of your script:
>
> <?php
> error_reporting(E_ALL | E_STRICT);
> ini_set('display_errors', TRUE);
>

This will not catch parse errors because the code is never executed.

> 3. If PHP runs as Apache module, you can also use an `.htaccess` file:
>
> # You cannot use PHP constants here
> php_value error_reporting -1
> php_flag display_errors on
>

The httpd.conf file must be set up to allow this, of course (I got
caught on this one recently).

> This is not specifically related to PDO, it's how PHP error reporting
> works in general.
>
>
>
> Additionally, PDO will not throw exceptions unless you tell it to
> because the default mode is PDO::ERRMODE_SILENT:
>
> http://es2.php.net/manual/en/pdo.error-handling.php
>
> This also implies that you cannot use exceptions to capture connection
> errors unless you set PDO::ERRMODE_EXCEPTION in the constructor.
>
>


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Stats comp.lang.php (last 7 days)
Next Topic: Mac OS X how to install php / yaml ?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 14 10:21:03 EST 2017

Total time taken to generate the page: 0.00797 seconds