PHP Piwik\Db AdapterInterface::fetchAll Examples

Example #1

File: PluginSettingsTable.php Project: piwik/piwik

 public function load()
 {
     $this->initDbIfNeeded();
     $sql = "SELECT `setting_name`, `setting_value` FROM " . $this->getTableName() . " WHERE plugin_name = ? and user_login = ?";
     $bind = array($this->pluginName, $this->userLogin);
     $settings = $this->db->fetchAll($sql, $bind);
     $flat = array();
     foreach ($settings as $setting) {
         $name = $setting['setting_name'];
         if (array_key_exists($name, $flat)) {
             if (!is_array($flat[$name])) {
                 $flat[$name] = array($flat[$name]);
             }
             $flat[$name][] = $setting['setting_value'];
         } else {
             $flat[$name] = $setting['setting_value'];
         }
     }
     return $flat;
 }