Multiple update in single query.

[eluser]Truong Chuong DUong[/eluser]
Try to run multi query in same execute will save server cost. Only need to change a bit in file CodeIgniter\system\database\drivers\mysqli\mysqli_driver.php will make CodeIgniter support this feature:

/**
* Execute the query
*
* @param string an SQL query
* @return mixed
*/
protected function _execute($sql)
{
/*
Remove this line
return @$this->conn_id->query($this->_prep_query($sql));
*/

$sql = $this->_prep_query($sql);
$result = NULL;

/* execute multi query */
if (@$this->conn_id->multi_query($sql))
{
do
{
if ($result)
@$result->free();

$result = $this->conn_id->store_result()
}
while ($this->conn_id->next_result());
}

if ($result === FALSE)
$result = 1;

/* close connection */
return $result;//Only return last result

}


If you see @mysqli_query($this->conn_id, $sql); instead of @$this->conn_id->query($this->_prep_query($sql)) (old version)
Please use these code:


/**
* Execute the query
*
* @param string an SQL query
* @return mixed
*/
protected function _execute($sql)
{
/*
Remove these line
$result = @mysqli_query($this->conn_id, $sql);
return $result;
*/


$sql = $this->_prep_query($sql);
$result = NULL;

/* execute multi query */
if (@mysqli_multi_query($this->conn_id, $sql))
{
do
{
if ($result)
@mysqli_free_result($result);

$result = @mysqli_store_result($this->conn_id);
}
while (mysqli_next_result($this->conn_id));
}

if ($result === FALSE)
$result = 1;

return $result;//Only return last result

}