PHP Database::doSelect Examples

Example #1

File: TSunic.class.php Project: nfrickler/tsunic

 /** Get all installed modules
  *
  * Get a list of all installed modules
  *
  * @return array|bool
  */
 public function getModules()
 {
     if (!$this->Db) {
         return array();
     }
     // get all modules from database
     $sql = "SELECT id__module as id,\n\t    name,\n\t    author,\n\t    description,\n\t    version_installed,\n\t    link\n\t    FROM " . $this->Config->get('prefix') . "modules\n\t    WHERE is_activated = 1\n\t    AND is_parsed = 1\n\t    ORDER BY name ASC;";
     return $this->Db->doSelect($sql);
 }