Check if table exists sql php

if ($result = $mysqli->query("SHOW TABLES LIKE '".$table."'")) {
    if($result->num_rows == 1) {
        echo "Table exists";
    }
}
else {
    echo "Table does not exist";
}

Source: stackoverflow.com

Similar codes

3 votes217 views2 answers
Laravel carbon created_at date in current month
PHP Laravel
4 votes160 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel
2 votes169 views1 answer
Laravel vendor:publish not working
PHP
0 vote199 views1 answer
Symfony refresh endpoints
PHP Symfony
0 vote192 views1 answer
Wordpress max post revision
PHP Wordpress
3 votes181 views1 answer
Wordpress page template
PHP
12 votes182 views2 answers
Debug bar laravel print array
PHP
0 vote173 views1 answer
Who is known as the father of PHP?
PHP
0 vote228 views1 answer
How to filter the all special characters in cakephp from an array
PHP CakePHP
0 vote183 views2 answers
Laravel migration change column order
PHP