PHP get_array_by_query Beispiele

Beispiel #1

Datei: Release.class.php Projekt: BackupTheBerlios/igoan-svn

 function list_categories()
 {
     return get_array_by_query('SELECT id_cat FROM ' . DB_PREF . '_belongsto WHERE id_rel=\'' . int($this->get_id_rel()) . '\'');
 }

Beispiel #2

Datei: User.class.php Projekt: BackupTheBerlios/igoan

 function list_releases()
 {
     return get_array_by_query('SELECT id_rel FROM authors WHERE id_user=\'' . int($this->get_id_user()) . '\'');
 }

Beispiel #3

Datei: Platform.class.php Projekt: BackupTheBerlios/igoan-svn

function platform_list()
{
    return get_array_by_query("SELECT id_pf,name_pf FROM platforms ORDER BY name_pf");
}

Beispiel #4

Datei: Project.class.php Projekt: BackupTheBerlios/igoan-svn

 function list_branches($id_branch = 0)
 {
     return get_array_by_query('SELECT id_branch FROM branches WHERE id_prj=\'' . int($this->get_id_prj()) . '\' AND id_branch<>' . int($id_branch));
 }

Beispiel #5

Datei: License.class.php Projekt: BackupTheBerlios/igoan

function license_list()
{
    return get_array_by_query('SELECT id_lic,name_lic,terms FROM licenses ORDER BY name_lic');
}

Beispiel #6

Datei: Branch.class.php Projekt: BackupTheBerlios/igoan-svn

 function list_releases($except_rel = 0)
 {
     return get_array_by_query('SELECT id_rel FROM releases WHERE id_branch=\'' . int($this->get_id_branch()) . '\' AND id_rel<>' . int($except_rel) . ' ORDER BY date_rel DESC');
 }

Beispiel #7

Datei: Language.class.php Projekt: BackupTheBerlios/igoan-svn

function language_list()
{
    return get_array_by_query('SELECT id_lang,name_lang FROM ' . DB_PREF . '_languages ORDER BY name_lang');
}

Beispiel #8

Datei: Category.class.php Projekt: BackupTheBerlios/igoan

function category_list_all()
{
    return get_array_by_query('SELECT id_cat,name_cat,index,parent FROM categories ORDER BY index');
}

Beispiel #9

Datei: Platform.class.php Projekt: BackupTheBerlios/igoan-svn

function platform_list()
{
    return get_array_by_query('SELECT id_pf,name_pf FROM ' . DB_PREF . '_platforms ORDER BY name_pf');
}