Menu
Community /Pin to ProfileBookmark
@NogDogOct 31.2010 — #Assuming the query syntax is valid, [b]$table_check_result[/b] will always be true (actually a valid query result resource), regardless of whether the table exists. You probably can do a mysql_num_rows() to find out if there was a non-zero number of matches returned by the query.@NogDogNov 01.2010 — #You could even cut out another step:
?@NogDogNov 01.2010 — #
I thought about it, but sometimes you can get too much of a good thing, impacting readability and modifiability (to coin a word). ? (Especially since I'd probably add some sort of error-checking after the query, just in case.)
Help to return true/false from function
Hi
I have tried to make a simple function that checks if a table in database exists, and return true or false, but I can’t seem to make it work!
Any ideas why??
[code=php]function check_table($table){
$table_check = “SHOW TABLES LIKE ‘$table'”;
$table_check_result = mysql_query($table_check)
or die ($table_check_error = mysql_error());
if (empty($table_check_result)){
return true;
}
else{
return false;
}
}
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogOct 31.2010 — #Assuming the query syntax is valid, [b]$table_check_result[/b] will always be true (actually a valid query result resource), regardless of whether the table exists. You probably can do a mysql_num_rows() to find out if there was a non-zero number of matches returned by the query.0
@NogDogNov 01.2010 — #You could even cut out another step:[code=php]
return mysql_num_rows($table_check_result) == 0;
[/code]?
0
@NogDogNov 01.2010 — #Myself, I would make that whole function a one-liner. But that's just me.[/QUOTE]
I thought about it, but sometimes you can get too much of a good thing, impacting readability and modifiability (to coin a word). ? (Especially since I'd probably add some sort of error-checking after the query, just in case.)