Posted in
4
4:25 am, December 2, 2019
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 :(";
}
?>
View Statistics
This Week
21
This Month
118
This Year
0
Add Comment
Other Items in php
fixing error Call to undefined function simplexml_load_string
get the content of a url get the content of a link with php and test if the result is empty
php check if url is valid with filter_var
php save csv from array to file
php export csv from string to browser download
convert json string to a php array
how to json encode an array in php
how to decode xml in php
php get file and save it
php function to remove the query string from a url
using php parse_url function to remove the query string from a url
add every value in the load_array array into the out for testing
Fix for PHP Warning Trying to get property '*name*' of non-object
write the contents of a url into a file with php
sqlite fetchArray into another array
php return json header and content
list_all_array an early stages of list all function that uses an array to pass in main variables
replace singular variable assignment with an array loop and variable variables
using the $_SERVER['HTTP_REFERER'] to check referring pages
timeline class and function
php html template class system
views list function for checking what views have been made on the current week
load array load all items from an array while in a sqlite load sql loop
create a 200 character summary from a longer html string
using strlen to check the length of a string and do something about it
How to record your own page views with PHP, and make them into weekly monthly and yearly charts
load from fields array php class function
get the current week as a number with php
creating embedded php code from a database field
test php bundle write
check if a file exists with php
check if the file is a directory or check if the directory exists in php
get the current working directory in php
create directory with php create folder with php
check if a product already exists by its md5
load random videos module using template
PHP/SQLite - Load Random Item
split a string into links using the comma
extract youtube image from video url
simple php ip blocker
preg replace clean a string only allow a-zA-Z0-9 characters
get last month as a number with php
verify the google recapture server php
rtrim strip white space or strings from the end of a string
get the current month as a number
show the difference between two dates in years, months, days, hours and seconds
counting the occurrence of words in a multidimensional array
write string contents to a file with php
unable to access the $_FILES when submitting a form php
check column exists in table sqlite
Related Search Terms
Other Categories in Code
c testing apache apps asp bat bootstrap bootstrap templates core css css grid design elements fancybox fonts foundation framework gimp git html icons ideas images javascript jquery js linux mac nginx node php php functions php simple html dom pi400 python react sections site bugs site documentation sql sqlite sublime svg templates tools virtual box webdev windows wordpress
