Display mysqli error using die

Question

Wore mysql_query, as it is no longer used I am using the MySQLi.

That left me with a question.

To display query error by DIE that’s how you do it?

$sql = $mysqli->query("SELECT * Fron tabela") or die(mysqli_error();

Thank you.

Answer 1

Avoid mixing Mysqli procedural and OO style, maintain consistency

In object oriented the correct form is through the property $error

$sql = $mysqli->query("SELECT * FROM tabela") or die($mysqli->error);

In the procedural you are required to pass the connection to the function:

$sql = mysqli_query($conexao, "SELECT * FROM tabela") or die(mysqli_error($conexao));