
Untitled
By: a guest on
Aug 12th, 2012 | syntax:
None | size: 0.62 KB | hits: 15 | expires: Never
MySQLi - num_rows - ->query usage
class sql extends mysqli {
public function __construct($data = array()) {
parent::__construct($dbhost, $dbuser, $dbpass, $dbname);
$this->set_charset("utf8");
}
function get($sql) {
$res = self::query($sql)
or trigger_error("Prepared Select Statement Error: " . $this->error . "n");
return $res;
}
}
$sql = new sql();
$result = $sql->get('select * from `session` LIMIT 1');
$num = $result->num_rows;
if($num === 1)
// update statement
else
// insert new row.
while($array = $result->fetch_assoc())
{
// parse data
}