Insert multi-record using single query in Joomla.
/**
* Insert the attributes into website.
*
* @return boolean If found return true else falase.
*/
protected function saveAttributes($member_id, $data)
{
// Build the values for multi-row insert.
$values = array();
foreach ($data as $attribute_id => $value)
{
$values[] = "('".$member_id."','".$attribute_id."','".$value."', '1')";
}
$values = implode(',', $values);
// Build the insert query
$sql = 'INSERT INTO #__bmember_attribute_vals (`mid`, `attribute_id`, `value`, `state`)
VALUES'.$values;
$db = $this->getDbo();
$query = $db->getQuery(true); // Reset the $query variable.
$db->setQuery($sql);
$db->query();
}
No comments:
Post a Comment
Please post any queries and comments here.