php mysql table exists function

this checks if a mysql table already exists in the selected database and returns true or false
<?php
// setup database connection
$db = new mysqli($db_host, $db_user, $db_pass, $db_name);

// function
function table_exists($table) {
  global $db;
  $table = $db->mysql_real_escape_string($table);
  $sql = "SHOW TABLES LIKE '$table' ";
  $result = $db->query($sql);
  $num = 0;
  $num = mysqli_num_rows($result);
  if($num > 0) {
      return true;
  }
  return false;
}

// usage
$my_table_name = "my_table_name";
if(table_exists($table = $my_table_name)) {
  echo "$my_table_name exists :)";
} else {
  echo "$my_table_name does not exist :(";
}
?>
Posted in php
4:25 am, December 2, 2019

Other Items in php
explode a string into an array
using gzdeflate on a string php
include tinymce only if a user is logged into the site
Quick tool to convert time into decimal
generating all css colours with php?
php countries array to dropdown form element
Fix for Fatal error: Uncaught Error: Call to undefined function file_get_dom() simplehtmldom simple_html_dom
Fixing PHP SQLite database is locked warning - Unable to execute statement: database is locked
simple usage for php password_hash
change string to capital words ucwords
change upper case case string to lower case (uppercase, lowercase)
convert a string to uppercase with php
php substr return part of a string
php countries array
check if a timestamp is older than one hour
making var_dump look nice
php mysql table exists function
how to display a php file as html with php
php convert date now into a sql timestamp
Generate a Random User Name
return a state name from an australian postcode
get the average of a number list using an array in php
IP Address
PHP Finding the position of a string in another string using strpos
PHP str_replace - find and replace part of a string
Random string generator function in php suniqid
using the disk free space function in php
create a mysql or sqlite current timestamp with php
Cut a string when it finds a certain character with PHP
validate a url using php with FILTER_VALIDATE_URL
function to create a uid from html
calculate a percentage (dec) difference based on two numbers
check if a user is logged in using sessions
PHP MySQL vs SQLite Count Items Function
How Many Days Since a Date and other Calculations
Date Conversion PHP
Generate a random title from an array
echo todays date and time in a nice format
Generate Sub menu using Core
page load timer class
human_filesize php
for loop set variables $p1,$p2.. etc as blank
sqlite check table name exists
get current class name with get_class
assign array to variables in a loop
generate a random color rgb code with php
Regular expression breakdown regex preg_replace php
replace anything in brackets in a string using preg_replace regex php
for loop with a 5 increment
Get Current Page URL PHP
Related Search Terms
php php 2
php sql 3
Page Views

This page has been viewed 564 times.

Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code snippits here, mostly for my reference. Also if i find a good site, i usually add it here.

âĪðŸ‘Đ‍ðŸ’ŧðŸ•đ

Random Quote
therock Somewhere along this crazy road I learned (often times the hard way) the most important things I can do is be authentic, trust my gut, be the hardest worker in the room, celebrate the mistakes, be a grateful man and always remember that it's nice to be important, but it's more important to be nice.
The Rock