Ok since cr0w just had to mess up my thread i'll just try again...

so I just want to count all the php/mysql queries on my own php scripts. I'm wondering how Ross did it.



And this it to wrightys reply in my old thread.

I wasn't asking on here, I'm almost positive you can't count the total queries with any client side script. This is for my own php and mysql project

At cr0w's reply.

I did post in the programming board didn't I ?

ahh ok...

by you saying that proves cr0w was right..

---

I would say... run a query and when the query is ran a value is incremented by one... then when you have ran all of the queries you simply output that number...

Cr0w or Ross can correct me if that is an epic phail! Try that though!

Yeah Wrighty, that was pretty close.

I usually do this:

Code:

Select All

 

//Top of page
$queries = 0;
$start = microtime();
function query($s){
    $queries++;
    return mysql_query($s);
}
 
/* Page Content Here */
 
//Bottom of page
$end = microtime();
echo 'Page generated in '.$end-$start.' seconds, with '.$queries.' queries.';

//Top of page {BR}$queries = 0; {BR}$start = microtime(); {BR}function query($s){ {BR}    $queries++; {BR}    return mysql_query($s); {BR}} {BR} {BR}/* Page Content Here */ {BR} {BR}//Bottom of page {BR}$end = microtime(); {BR}echo 'Page generated in '.$end-$start.' seconds, with '.$queries.' queries.';

 

i don't understand your query function crow?

Posted By Dylan on 20th Jan 08 at 4:29am

 

i don't understand your query function crow?

The way Cr0w said is very similar to what I use except my query function is a little more advanced since it does error logging, replaces special values in the query string and can return the query result. But the basic idea of it is so you would call

$myquery = query("SELECT * FROM table_name WHERE field='value' LIMIT 1");

Which would then use the query() function to increase the # of queries used as well as running the actual query.

Posted By Ross on 20th Jan 08 at 11:33am

 

Posted By Dylan on 20th Jan 08 at 4:29am

 

i don't understand your query function crow?

The way Cr0w said is very similar to what I use except my query function is a little more advanced since it does error logging, replaces special values in the query string and can return the query result. But the basic idea of it is so you would call

$myquery = query("SELECT * FROM table_name WHERE field='value' LIMIT 1");

Which would then use the query() function to increase the # of queries used as well as running the actual query.

I do almost the same thing, Ross. I update my query log & error log, as well as return an array [optional].

Usually something like this:

Code:

Select All

 

function query($s,$a="false"){
 
    //Update # Queries
    $queries++;
 
    //Query Log
    error_log("Query: ".$s." @ ".date(),3,"query_log.txt");
 
    //Run Query
    $query = mysql_query($s) or die(error_log("Query Error: ".mysql_error()." @ ".date(),3,"error_log.txt");
 
    //Create Array
    if($a=="assoc"){
        $query = mysql_fetch_assoc($query);
    }
    else if($a=="array"){
        $query = mysql_fetch_array($query);
    }
    else if($a=="numrows"){
        $query = mysql_num_rows($query);
    }
 
    //Return Query
    return $query;
}

function query($s,$a="false"){ {BR} {BR}    //Update # Queries {BR}    $queries++; {BR} {BR}    //Query Log {BR}    error_log("Query: ".$s." @ ".date(),3,"query_log.txt"); {BR} {BR}    //Run Query {BR}    $query = mysql_query($s) or die(error_log("Query Error: ".mysql_error()." @ ".date(),3,"error_log.txt"); {BR} {BR}    //Create Array {BR}    if($a=="assoc"){ {BR}        $query = mysql_fetch_assoc($query); {BR}    } {BR}    else if($a=="array"){ {BR}        $query = mysql_fetch_array($query); {BR}    } {BR}    else if($a=="numrows"){ {BR}        $query = mysql_num_rows($query); {BR}    } {BR} {BR}    //Return Query {BR}    return $query; {BR}}

 

I was just showing Dylan how to show then number of queries, as well as the time to load the page.