1, modifying the database driver
Phpcms/libs/classes/mysql.class. PHP Add the following code:
/**
* Last query statement
*/
Private$lastquerysql ="';
Publicfunction Lastsql () {
return$ This->lastquerysql;
}
Modify the Execute method,
$ This->lastqueryid = mysql_query ($sql, $ This->link) or $ This->halt (Mysql_error (), $sql);
Add a row before
$ This->lastquerysql = $sql;
That
Privatefunction Execute ($sql) {
if(!is_resource ($ This->link)) {
$ This->connect ();
}
$ This->lastquerysql = $sql;
$ This->lastqueryid = mysql_query ($sql, $ This->link) or $ This->halt (Mysql_error (), $sql);
$ This->querycount++;
return$ This->lastqueryid;
}
2, modify the Model
Phpcms/libs/classes/model.class. PHP Add a method to
Publicfunction Lastsql () {
return$ This->db->lastsql ();
}
3Call
After the query is completed using a custom model class, the Lastsql () method of the model class is called to
Phpsso MySQL class and model class can be changed without change, under normal circumstances will not be used
Phpcms V9 Transformation: Output SQL statement