Exemple #1
0
            <p id="instruction" style="font-size: 2em; font-family: Arial, Helveitca, Sans-serif; color: Blue; margin-bottom: 5px;">
                <span style="color: Crimson; font-weight: bold;">Crtl+Click</span>
                on a field you want to edit...
                <small style="color:red; font-size:0.9em;">Be careful with those that have HTML content!</small>
            </p>

<?php 
        print_a($aql_data);
        elapsed('before getting cols');
        $column_name = $tablename . "_id";
        $sql = "SELECT\n                        a.table_name\n                    FROM information_schema.columns a,\n                        information_schema.columns b,\n                        information_schema.columns c\n                    WHERE a.table_name = b.table_name\n                        and a.table_name = c.table_name\n                        and b.column_name = 'id'\n                        and c.column_name = 'active'\n                        and a.column_name = '{$column_name}'";
        $cols = sql_array($sql);
        if ($cols) {
            echo '<hr />';
            foreach ($cols as $col) {
                $count = aql::count("{$col['table_name']} { where {$column_name} = '{$id}' }");
                if ($count) {
                    ?>
                    <p>
                        <a  href="/dev/ide/<?php 
                    echo $col['table_name'];
                    ?>
/<?php 
                    echo $column_name;
                    ?>
/<?php 
                    echo $id;
                    ?>
"
                            class="ide"
                            >