FUDforum: comp.lang.php » PEAR DB: "PHP Fatal error: Call to undefined method DB::query()"

Home » Imported messages » comp.lang.php » PEAR DB: "PHP Fatal error: Call to undefined method DB::query()"

Show: Today's Messages :: Polls :: Message Navigator

Re: PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" [message #180215 is a reply to message #180207]

Tue, 29 January 2013 12:58

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 1/29/2013 4:03 AM, Robert S wrote:
> I have the following code:
>
> <?php
> require_once( 'DB.php' );
> $dsn = 'mysql://user:password@localhost/table';
> $dbh = new DB();
> $dbh->connect( $dsn );
> if ( $dbh->isError( $dbh )) die ( $dbh->getMessage );
> $query = "SELECT * FROM Table ORDER BY Date LIMIT 1";
> $sth = $dbh->query( $query );
> ?>
>
> I get:
>
> PHP Fatal error: Call to undefined method DB::query()
>
> Can somebody tell me where I am going wrong? This all worked using my old code, but I got a lot of warnings about non static methods being called statically:
>
> $dbh = DB::connect( $dsn );
> if ( DB::isError( $dbh )) die ( $dbh->getMessage );
> $sth = $dbh->query( $query );
>

OK, it used to work but doesn't now. What changed?

You do have some problems in your code. For instance, you are not
saving the object returned by the connect() method. You can find an
example at
http://pear.php.net/manual/en/package.database.db.intro-query.php for
the proper way to do a query. Also, the fact you had warnings earlier
should have been a red flag. They are there for a reason.

However, beware that the PEAR DB package has been replaced by the PEAR
MDB2 package. The former is no longer being maintained and should not
be used.

Rather, I recommend you use a the PHP PDO class. It will require some
rewriting of your code, but you're going to have to do that anyway.

BTW - it's almost never a good idea to modify the code in packages. It
always leads to more work in the long run as you have to maintain the
modified code as well as your own.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" By: Robert S on Tue, 29 January 2013 09:03
		Re: PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" By: Christoph Becker on Tue, 29 January 2013 09:19
		Re: PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" By: Robert S on Tue, 29 January 2013 10:35
		Re: PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" By: Christoph Becker on Tue, 29 January 2013 11:20
		Re: PEAR DB: "PHP Fatal error: Call to undefined method DB::query()" By: Jerry Stuckle on Tue, 29 January 2013 12:58

Previous Topic:	my blog
Next Topic:	Formatting a number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 18:36:18 GMT 2024

Total time taken to generate the page: 0.04358 seconds