php - If affected_rows returning non-object error with DB class

Question

My Question About DB Class for reference

Hi! In this question above (link) I was with a problem with connection to DB with PHP CLASS. Now it's working. But, after the commands I've understood in this topic, I'm having a problem now with affected_rows.

$strSQL = $conexao->Query("INSERT INTO clientes(id_cliente,nome,checkout,metodo_pag,valor) VALUES (NULL, 'Nome Cliente', NOW(), '0', '$valorTotal')");

if ($strSQL->affected_rows == 1) {

When I execute it, the PHP returns "Trying to get property of non-object in".

What's wrong? Isn't the var $strSQL checking if $conexao->Query was done sucessful?

Answer 1

My suggestion would be to use validation on the result from the query:

$rs = $conexao->Query("SELECT * FROM `table` WHERE 1;");
if ($rs)
    print $rs->affected_rows;

This allows you to be able to check if it has rows/isn't false etc and use the result and give your own error if not

Class that I am creating for MySQLi extension and use found here