/SQL/How to query all tables mysql at the same time

How to query all tables mysql at the same time

function searchAllDB($search){
    global $mysqli;

    $out = "";

    $sql = "show tables";
    $rs = $mysqli->query($sql);
    if($rs->num_rows > 0){
        while($r = $rs->fetch_array()){
            $table = $r[0];
            $out .= $table.";";
            $sql_search = "select * from ".$table." where ";
            $sql_search_fields = Array();
            $sql2 = "SHOW COLUMNS FROM ".$table;
            $rs2 = $mysqli->query($sql2);
            if($rs2->num_rows > 0){
                while($r2 = $rs2->fetch_array()){
                    $column = $r2[0];
                    $sql_search_fields[] = $column." like('%".$search."%')";
                }
                $rs2->close();
            }
            $sql_search .= implode(" OR ", $sql_search_fields);
            $rs3 = $mysqli->query($sql_search);
            $out .= $rs3->num_rows."\n";
            if($rs3->num_rows > 0){
                $rs3->close();
            }
        }
        $rs->close();
    }

    return $out;
}

Source: stackoverflow.com

Similar codes

0 vote322 views1 answer
Update set with join pl sql
SQL
0 vote320 views1 answer
How to drop columns with constraint from a table in sql script
SQL
-1 vote353 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote342 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote374 views1 answer
What is initial catalog in sql connection string
SQL
0 vote390 views1 answer
Sql server remove primary key without dropping table
SQL
2 votes332 views6 answers
In in sql
SQL
21 votes340 views3 answers
Sql average
SQL
0 vote359 views1 answer
Postgresql show owner of database
SQL
7 votes303 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL