php – 如何在使用PDO时设置SQL模式？

从MySql手册：

“You can change the SQL mode at runtime by using a SET
[GLOBAL|SESSION] sql_mode=’modes’ statement to set the sql_mode system
value. Setting the GLOBAL variable requires the SUPER privilege and
affects the operation of all clients that connect from that time on.
Setting the SESSION variable affects only the current client. Any
client can change its own session sql_mode value at any time.”

我个人在我的数据库类中添加了一些方法来处理这个问题. initSqlMode()将执行查询’SELECT SESSION.sql_mode’并将默认值存储为类变量. setSqlMode()允许您将SESSION sql_mode设置为(VALIDATED)自定义值. resetSqlMode()将SESSION sql_mode设置回默认值.我总是在操作sql_mode时使用SESSION变量.

然后你可以做类似以下的事情.注意这只是伪代码;我的例子中没有任何东西可以阻止sql注入或参数化sql查询.

$db = new database();
$badqueryresult = $db->executeStrict('BAD SQL QUERY');
Class database {
     ...
     function executeStrict($query){
      $this->initSqlMode();
      $this->setSqlMode('STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION');
      $result = $this->Execute($query);
      $this->resetSqlMode();
      return $result;
     }
}