mysqli::rpl_query_type()
(PHP 5, PHP 7)
返回 RPL 查询类型
说明
面向对象风格
mysqli::rpl_query_type(string $query): int
过程化风格
mysqli_rpl_query_type(mysqli$link,string $query): int
返回MYSQLI_RPL_MASTER
,MYSQLI_RPL_SLAVE
或MYSQLI_RPL_ADMIN
,具体的返回值取决于查询的类型。INSERT,UPDATE以及类似的操作属于主机查询,SELECT属于从机查询,FLUSH和REPAIR以及类似的操作属于管理查询。
Warning本函数还未编写文档,仅有参数列表。
Warning自 PHP 5.3.0起,已经废弃并移除此函数。
Because the sql types could be combined it would be better to use a function like this: function getMySQLType($str){ $str=trim($str); return strtoupper(substr($str,0,strpos($str,' '))); } $sql="select * from user;"; if (getMySQLType($sql) == 'SELECT'){ //true }
WARNING : this function (or maybe the "enable_rpl_parse" function) randomly causes a segfault into PHP. We don't use this function anymore. Instead we check if the query contains the word 'SELECT' : function query_type($query) { if ( stripos($query,'SELECT')) return true; return false; }