get affected rows mysql php code example

Example: mysqli check if delete was successful

$sql = "DELETE FROM art WHERE id='5'"; 
if($db->query($sql)=== TRUE) {
	    $message = "good"; // all worked good.
}else{
	    $message = "bad"; // didnt work because something was wrong
}