1 reply to this topic

[Stasonix]

So as you can read in the title of this topic I'm trying to know is some table is empty or no, now I am realized this issue with this code:

// if table is empty it must return TRUE, if full FALSE

private function isEmpty($tableName)
{

    if ($result = $this->mysqli->prepare("SELECT COUNT(*) FROM ?"))
    {

        $result->bind_param("s",$tableName);
        $result->execute();
        $row_cnt = $result->num_rows;

        if (empty($row_cnt))
        {

            return TRUE;

        }
        else
        {

            return FALSE;

        }

    }

}

this code seems not a really perfect, I would like to know is there a better way to get the same results, but using predicat SQL EXISTS or something else? Thank you.

[Stasonix]

$mysqli = new mysqli("localhost","root","","db");
if ($result = $mysqli->query("SELECT * FROM `table` LIMIT 1"))
{
if ($obj = $result->fetch_object())
{

  echo "NOT EMPTY";

}
else
{

  echo "empty";

}


$result->close();
}
$mysqli->close();

solved.