PHP print_structure_gallery Examples

Example #1

File: files_create.php Project: Jonur/electro-CMS

    echo '<option value="0" SELECTED>Κανένα</option>';
    while ($result_mg = mysql_fetch_array($query_mg)) {
        echo "ENTERED";
        echo '<optgroup label="' . stripslashes($result_mg['MGL_ALIAS']) . '">';
        //START: MENU ITEMS
        $sql_mi_mother = "SELECT * FROM `menu_items` \n\t\t\t\t\t\t\t\t\t\tINNER JOIN `menu_items-languages` ON `menu_items`.MI_ID=`menu_items-languages`.MI_ID\n\t\t\t\t\t\t\t\t\t\tINNER JOIN `menu_groups-menu_items` ON `menu_items`.MI_ID=`menu_groups-menu_items`.MI_ID\n\t\t\t\t\t\t\t\t\t\tWHERE `menu_groups-menu_items`.MG_ID = '" . $result_mg['MG_ID'] . "'  \t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tAND `menu_items`.MI_DELETED = 0 \n\t\t\t\t\t\t\t\t\t\tAND `menu_items-languages`.L_ID = '{$DLTL}'   \n\t\t\t\t\t\t\t\t\t\tAND (`menu_items`.MI_MOTHER IS NULL OR `menu_items`.MI_MOTHER = '0') \n\t\t\t\t\t\t\t\t\t\tORDER BY `menu_items`.MI_RANK, `menu_items-languages`.MIL_ALIAS";
        $query_mi_mother = mysql_query($sql_mi_mother) or die(mysql_error());
        $pcs = '';
        //dashes
        while ($result_mi_mother = mysql_fetch_array($query_mi_mother)) {
            $is_disabled = "";
            if ($result_mi_mother['MT_ID'] != 'ZS4z2y9E5F') {
                $is_disabled = "DISABLED";
            }
            echo '<option value="' . $result_mi_mother['MI_ID'] . '" ' . $is_disabled . '>' . $pcs . stripslashes($result_mi_mother['MIL_ALIAS']) . '</option>';
            print_structure_gallery($result_mi_mother['MI_ID'], $pcs . ' - - - ');
        }
        //END: MENU ITEMS
        echo '</optgroup>';
    }
    echo '</select>';
} else {
    echo '<div class="form_left"></div><div class="form_right">Δεν υπάρχουν διαθέσιμα Στοιχεία Μενού προς αντιστοίχιση.';
}
require "db_disconnect.php";
?>
			</div>
		<div class="clear"></div>
	</div>
	<!-- END: MENU -->
	<div class="form_left">&nbsp;</div><div class="form_right"><input type="submit" class="form_button" value="Ανέβασμα" /></div>

Example #2

File: functions.php Project: Jonur/electro-CMS

function print_structure_gallery($pcid, $pcs, $mi_mother = '0')
{
    global $tab_lang;
    global $DLTL;
    $sql_p_c = "SELECT * FROM `menu_items` \n\t\t\t\t\tINNER JOIN `menu_items-languages` ON `menu_items`.MI_ID=`menu_items-languages`.MI_ID\n\t\t\t\t\tWHERE `menu_items`.MI_DELETED = 0 AND `menu_items`.MI_MOTHER = '{$pcid}'  \n\t\t\t\t\tAND `menu_items-languages`.L_ID = '{$DLTL}'   \n\t\t\t\t\tORDER BY `menu_items`.MI_RANK, `menu_items-languages`.MIL_ALIAS";
    $query_p_c = mysql_query($sql_p_c);
    $rows_p_c = mysql_num_rows($query_p_c);
    if ($rows_p_c) {
        while ($result_p_c = mysql_fetch_array($query_p_c)) {
            $is_disabled = "";
            if ($result_p_c['MT_ID'] != 'EKatjWfxOt') {
                $is_disabled = "DISABLED";
            }
            $mi_selected = "";
            if ($result_p_c['MI_ID'] == $mi_mother) {
                $mi_selected = "SELECTED";
            }
            echo '<option value="' . $result_p_c['MI_ID'] . '" ' . $mi_selected . ' ' . $is_disabled . '>' . $pcs . stripslashes($result_p_c['MIL_ALIAS']) . '</option>';
            print_structure_gallery($result_p_c['MI_ID'], $pcs . ' - - - ', $mi_mother);
        }
    }
}