mysqli_rpl_probe
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
}
mysqli_rpl_query_type
mysqli::rpl_query_type
(PHP 5)
mysqli_rpl_query_type -- mysqli::rpl_query_type — Returns RPL query type
Descrição
Estilo orientado a objetos
int mysqli::rpl_query_type
( string $query
)
Estilo de procedimentos
Returns MYSQLI_RPL_MASTER, MYSQLI_RPL_SLAVE or MYSQLI_RPL_ADMIN depending on a query type. INSERT, UPDATE and similar are master queries, SELECT is slave, and FLUSH, REPAIR and similar are admin.
Aviso
Esta função não está documentada; somente a lista de argumentos está disponível.
Aviso
Esta função tornou-se OBSOLETA e REMOVIDA do PHP 5.3.0.
User Contributed Notes
mysqli_rpl_query_type
mysqli_rpl_query_type
steohan at gobro dot de
22-Sep-2010 03:22
22-Sep-2010 03:22
technique-glamour at condenast dot fr
19-Jul-2007 12:28
19-Jul-2007 12:28
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;
}