Home/ Questions/How to Check If Table Exists Sql Php
Next
Answered
Adam Chauvet
  • 13
Asked: 2022-04-17T19:16:03+00:00 In:

How to Check If Table Exists Sql Php

  • 13

. Advertisement .

..3..

. Advertisement .

..4..

It’s as easy as it sounds, I’ve conducted some research but am having difficulty in figuring this out. How to Check If Table Exists Sql Php? If anyone knows please let me know

♦ Suggestions of ITtutoria Team
Ideas for “How to Check If Table Exists Sql Php”: Use this check if table exists sql php to find out whether or not a table exists in MySQL. This tool is especially useful for checking whether or not the selected table is empty and exists correctly in MySQL.
In the absence of this, if you need to confirm for the presence of the Table within a specific Schema and also the Specified Database then we can formulate the query below:

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

check ifsql
Share

1 Answer

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

    Everything will be made clear to you via the following way.

    • 6

Leave an answer

You must login to add an answer.

Need An Account,