Ad:

PHP Discussion Thread
Marked Solved
Views: 2506

Oct 24th, 2009

PDO Number of Total Queries per Page

Expand Post »

Hi Community!

I have already searched the whole web about this Problem, and I didn't find anything. Maybe you can help...

I want to show the number of all SQL queries I executed to load a web page. It is a very complex system I programmed, and I don't want to count them manually. I use PDO for this, so I can't easily write a function count_query($sql) which increases a counter and return query($sql)
I have already tried to write my an "myPDO"-class, extended from PDO, to do this job, but it didn't work.

PHP Syntax (Toggle Plain Text)
class myPDO extends PDO{
    var $myOwnCount =0;
    public function __construct($location,$user,$pass)
    {
        parent::__construct($location,$user,$pass);
    } 
    public function exec($q){
        $this->myOwnCount ++;
        return parent::exec($s);
    }
    public function query($q){
        $this->myOwnCount ++;
        return parent::query($s);
    }
}
class myPDO extends PDO{
    var $myOwnCount =0;
    public function __construct($location,$user,$pass)
    {
        parent::__construct($location,$user,$pass);
    } 
    public function exec($q){
        $this->myOwnCount ++;
        return parent::exec($s);
    }
    public function query($q){
        $this->myOwnCount ++;
        return parent::query($s);
    }
}

Gave those Errors:

PHP Syntax (Toggle Plain Text)
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\...\functions.php on line 52
Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\...\index.php on line 69
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\...\functions.php on line 52
Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\...\index.php on line 69

Thanks for help

Paul

Similar Threads

Front Page error when opening .HTM file in HTML and CSS
memorising requested variables after page reset in PHP
How to Refresh a PHP page and add a clickable link in PHP
How do you only display 8 rows per page? PHP/MYSQL in PHP
memory management in wndows 2000 in Windows NT / 2000 / XP

opatut

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Oct 2009

Permalink

Oct 24th, 2009

Re: PDO Number of Total Queries per Page

Quote ...

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\...\functions.php on line 52

What is the Code in functions.php on line 52? (the whole function if possible)

Quote ...

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\...\index.php on line 69

I think this is caused because you didn't create a instance of the class

$class = new YourClassName();

Or declare fetch as a static public function(), but when you access it you call it like

YourClassName::fetch($arguments_here_if_any);

smartness

Reputation Points: 7

Solved Threads: 14

Junior Poster

Offline

103 posts
since Aug 2007

Permalink

Oct 24th, 2009

Re: PDO Number of Total Queries per Page

I Create the Object like this:

PHP Syntax (Toggle Plain Text)
$dataBase = new myPDO($location, $user, $pass);
$dataBase = new myPDO($location, $user, $pass);

If I use PDO instead, it works:

PHP Syntax (Toggle Plain Text)
$dataBase = new PDO($location, $user, $pass);
$dataBase = new PDO($location, $user, $pass);

Functions.php around line 52:

php Syntax (Toggle Plain Text)
$sql = $database->query("SELECT id,title FROM general");
foreach ($sql as $general)
    $generalData[$general["id"]] = $g["title"];
$sql = $database->query("SELECT id,title FROM general");
foreach ($sql as $general)
    $generalData[$general["id"]] = $g["title"];

The Problem is that you can use the PDOStatement in foreach like an Array. My class doesn't support this, but it should because it is extended from PDO...

Last edited by opatut; Oct 24th, 2009 at 3:11 pm.

opatut

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Oct 2009

Permalink

Oct 24th, 2009

Re: PDO Number of Total Queries per Page

Quote ...

$sql = $database->query("SELECT id,title FROM general");
foreach ($sql as $general)
$generalData[$general["id"]] = $g["title"];

Edited, removed!

EDIT: Glad you solved it!

Last edited by smartness; Oct 24th, 2009 at 3:29 pm.

smartness

Reputation Points: 7

Solved Threads: 14

Junior Poster

Offline

103 posts
since Aug 2007

Permalink

Oct 24th, 2009

Re: PDO Number of Total Queries per Page

I FOUND IT!!!

(Toggle Plain Text)

public function query($q){
     $this->myOwnCount ++;
     return parent::query($s);
}

This cant work! Thanks for helping, but it was - of course - a little mistake.

Paul

Last edited by peter_budo; Oct 25th, 2009 at 6:59 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

opatut

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Oct 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: block js injections through php

Next Thread in PHP Forum Timeline: Really stupid

DaniWeb Message

Cancel Changes

User Name
Password