[SOLVED] Fatal error: Trying to clone an uncloneable object of class mysqli_result

[JoeBuntu]

I get this error on the simple code below. Google did not offer much help.

 

Yes I did make sure that my php.ini file had zend.ze1_compatibility_mode set to "off"- which it was. I restarted apache just to make sure- still no good.

 

also- I have checked the result, it works fine- just I can't clone it.

Am I going about this the wrong way, perhaps?

 

<?php
//code

$result = $db->query($query);
$ted = clone $result;
?>

[genericnumber1]

Why are you trying to clone it? You can't clone mysqli results I'm fairly sure.

[JoeBuntu]

I am passing the result to a class. I need to use the result in a couple places in the class.

 

if I store the result as I have below, anytime I run $result->fetch_Object, a record of data is lost. I need to be able to run fetch_object a few times within my class and preserve the data. I thought cloning would be a good solution for this.

<?php
 public function __construct($displayFields, $mysqliResult)
 {
 	$this->_data = $mysqliResult;
                $this->somefunction($mysqliResult);

 }
?>

[JoeBuntu]

Can anyone help?

[Mchl]

Can't you rewind the result to beginning using mysqli_result::data_seek ?

Never tried it, so I'm not sure.

[sasa]

http://www.cit.gu.edu.au/doc/php_doc/function.mysqli-store-result.html

[JoeBuntu]

Thanks- the seek function worked perfect for me.