Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 12th, 2012  |  syntax: None  |  size: 0.62 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. MySQLi - num_rows - ->query usage
  2. class sql extends mysqli {
  3.     public function __construct($data = array()) {
  4.         parent::__construct($dbhost, $dbuser, $dbpass, $dbname);
  5.         $this->set_charset("utf8");
  6.     }
  7.    function get($sql) {
  8.         $res = self::query($sql)
  9.                 or trigger_error("Prepared Select Statement Error: " . $this->error . "n");
  10.  
  11.         return $res;
  12.     }
  13. }
  14.        
  15. $sql = new sql();
  16. $result = $sql->get('select * from `session` LIMIT 1');
  17. $num = $result->num_rows;
  18. if($num === 1)
  19.     // update statement
  20. else
  21.    //  insert new row.
  22.  
  23. while($array = $result->fetch_assoc())
  24. {
  25.     // parse data
  26. }