Frontend\Modules\Profiles\Engine\Model::setSettings PHP Method

setSettings() public static method

Insert or update multiple profile settings.
public static setSettings ( integer $id, array $values )
$id integer Profile id.
$values array Settings in key=>value form.
    public static function setSettings($id, array $values)
    {
        // build parameters
        $parameters = array();
        foreach ($values as $key => $value) {
            $parameters[] = $id;
            $parameters[] = $key;
            $parameters[] = serialize($value);
        }
        // build the query
        $query = 'INSERT INTO profiles_settings(profile_id, name, value)
                  VALUES';
        $query .= rtrim(str_repeat('(?, ?, ?), ', count($values)), ', ') . ' ';
        $query .= 'ON DUPLICATE KEY UPDATE value = VALUES(value)';
        FrontendModel::getContainer()->get('database')->execute($query, $parameters);
    }

Usage Example

Beispiel #1
0
 /**
  * Insert or update multiple profile settings.
  *
  * @param array $values Settings in key=>value form.
  */
 public function setSettings(array $values)
 {
     // set settings
     FrontendProfilesModel::setSettings($this->getId(), $values);
     // add settings to cache
     foreach ($values as $key => $value) {
         $this->settings[$key] = $value;
     }
 }
All Usage Examples Of Frontend\Modules\Profiles\Engine\Model::setSettings