PHP crazedsanity\database Database::farray_nvp Examples

Example #1

File: ability.class.php Project: crazedsanity/cs-battletrack

 public static function get_all_abilities(Database $dbObj, $byId = false)
 {
     $sql = "SELECT * FROM csbt_ability_table";
     try {
         $numrows = $dbObj->run_query($sql);
         if ($numrows > 0) {
             if ($byId) {
                 $data = $dbObj->farray_nvp('ability_id', 'ability_name');
             } else {
                 $data = $dbObj->farray_nvp('ability_name', 'ability_id');
             }
         } else {
             throw new LogicException(__METHOD__ . ": no data available");
         }
     } catch (Exception $ex) {
         throw new ErrorException(__METHOD__ . ": failed to retrieve cache, DETAILS::: " . $ex->getMessage());
     }
     return $data;
 }