print the last mysql_query string

fatnjazzy

hi there,
is this possible
<?

mysql_query("select * from somethind where id='1'") or die(mysql_last_query_string());
?>

i want to buld a general function that prints the last query string without sending it
dont ask y (-:
thans

TF_TheMoon

Can you give more of an idea of what you are trying to achieve. From what you've said it sounds like you're just trying to do

$query = "SELECT * FROM table";
echo $query;

which makes no real sense.

fatnjazzy

ok
i have few systems that im developing and controlling.
in order to make the development eazier i want to build a function that will print the this

function sqlErr($line,$err,$query){
print "there is an mysql error in line: ".$line;
print "<br>the error says: ".$err;
print "<br>the query string is: ".$query;

}

mysql_query($query) or sqlErr(LINE, mysql_error(),mysql_last_query_string());

i know that i can insert the query into a var but, im going to do search and replace on 150 files, i dont know the names of the vars in every query, that is y I need some thing like : mysql_last_query_string();
hope u got me right

TF_TheMoon

Have you thought about using the PEAR DB libary? then you can use the DB::isError to detect the errors and print out the backtrace which will give yuo the line number and query beign called and a wholoe load of ther information.

It will also make your code more portable, as if you change database, say from mysql to mssql or postgres etc, you just need to change the DSN and the rest of your code stays the same.

If you have command line access you can install (go-pear) then use the commands
pear install db to install the DB libary (if its not bundled its been a while since i've installed a new server).

If you don't yuo will need to download the main PEAR libaries and DB.

Then to use it, its simply a matter of

require_once('PEAR.php');
require_once('DB.php');

// define the DSN, usually you'd do this in a global include file so you have a single place to change it.  in this example I'm using the mysqli extension form php5
$dsn = "mysqli://username:password@host/database";

// connect and check for errors
if ( DB::isError( $db = &DB::connect( $dsn ) ) ) {
  //die printing the reason for the error
    die($db->getMessage());
}

// Set the fetch mode to be an associate array, ie heading=>value
$db->setFetchMode( DB_FETCHMODE_ASSOC );


// create a query
$query = "SELECT * FROM table;";

// run the query whilst checking for errors
if( DB::isError( $rtn = $db->getAll( $query ) ) {
    // Die printing trn which is now an error object for more information
    die( $rtn);
}

if an error occurs, PEAR DB returns an erorr object. Calling the getMessage() method will return the SQL error, or you could print_r() the var (see the end of my code where I do a die( $rtn ); which will print the error object which will show you a lot more info

fatnjazzy

thanks for the reply.
we are thinking to do so in the futer on a new projects.
but right now we have to stay with the current configuration and it means that i cant move, this is a very complicate issue.
so there is no way to do it in my way?
thanks a lot for your time

TF_TheMoon

There is a way your way, just PEAR DB already does it, so I thought why re-invent the wheel. I've not used the php built in ways in a while, but have you tried this mysql_info()
http://uk.php.net/manual/en/function.mysql-info.php