note 68142 added to function.mysqli-free-result

Here's a method I wrote to simplify the automatic freeing of mysqli_result objects when all references disappear. The beauty of it is that it's presence is tranparent to the user because it acts exactly like a mysqli_result object. Also, jon at fuck dot org, you don't have to pass the resultmode ("flag") around because it's accessible with the mysqli_result object (the 'type' property). <?php final class MysqliResultWrapper { private $m_mysqli_result; public function __construct($i_result) { if (isset($i_result) && $i_result instanceof mysqli_result) $this->m_mysqli_result = $i_result; else throw new Exception(__CLASS__ . ' instantiated with ' . gettype($i_result)); } // automatically disappear the mysqli_result when all references to us vanish public function __destruct() { if (isset($this->m_mysqli_result)) $this->m_mysqli_result->free(); } // pass back mysqli_result properties public function __get($i_varname) { if (!isset($this->m_mysqli_result)) return NULL; /** * Do you know a generic way for PHP to retrieve a member * function instead of this ugly switch? */ switch ($i_varname) { case 'current_field': return $this->m_mysqli_result->current_field; case 'field_count': return $this->m_mysqli_result->field_count; case 'lengths': return $this->m_mysqli_result->lengths; case 'num_rows': return $this->m_mysqli_result->num_rows; case 'type': return $this->m_mysqli_result->type; } throw new Exception('Trying to get non-existent mysqli property ' . $i_varname); } // forward mysqli_result function calls public function __call($i_funcname, $i_arguments) { call_user_func_array(array(&$this->m_mysqli_result, $i_funcname), $i_arguments); } } ?> Example usage: <?php function some_query_func($i_query, $i_resultmode = MYSQLI_STORE_RESULT) { $conn = getExistingMysqliObjectFromSomePlace(); $result = @$conn->query($i_query, $i_resultmode); if ($result === FALSE || $result === NULL) throw new Exception($conn->error); return $result instanceof mysqli_result ? new MysqliResultWrapper($result) : $result; } $result = some_query_func($query);// unhandled Exception thrown on failure if ($result->num_rows > 0)// calls __get() while ($assoc = $result->fetch_assoc())// calls __call() ;// ... ?> ---- Server IP: 216.194.113.175 Probable Submitter: 208.247.75.49 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-free-result.php Edit -- http://master.php.net/note/edit/68142 Del: integrated -- http://master.php.net/note/delete/68142/integrated Del: useless -- http://master.php.net/note/delete/68142/useless Del: bad code -- http://master.php.net/note/delete/68142/bad+code Del: spam -- http://master.php.net/note/delete/68142/spam Del: non-english -- http://master.php.net/note/delete/68142/non-english Del: in docs -- http://master.php.net/note/delete/68142/in+docs Del: other reasons-- http://master.php.net/note/delete/68142 Reject -- http://master.php.net/note/reject/68142 Search -- http://master.php.net/manage/user-notes.php