Edit Report a Bug

    mysqli::rpl_query_type

    mysqli_rpl_query_type

    (PHP 5, PHP 7)

    mysqli::rpl_query_type -- mysqli_rpl_query_type — Returns RPL query type

    Beschreibung

    Objektorientierter Stil

    public mysqli::rpl_query_type ( string $query ) : int

    Prozeduraler Stil

    mysqli_rpl_query_type ( mysqli $link , string $query ) : int

    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.

    Warnung

    Diese Funktion ist bis jetzt nicht dokumentiert. Es steht nur die Liste der Argumente zur Verfügung.

    Warnung

    Diese Funktion war DEPRECATED (veraltet) und wurde mit PHP 5.3.0 ENTFERNT.

    add a note add a note

    User Contributed Notes 2 notes

    up
    4
    steohan at gobro dot de
    14 years ago
    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
    }
    up
    0
    technique-glamour at condenast dot fr
    17 years ago
    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;
    }
    add a note add a note
    To Top