PHP ExtractTablenameFromSQLの例

コード例 #1

ファイル: sql_dataview.php プロジェクト: robmat/samplebator

        $ret = 0;
    }
    return $ret;
}
//Data-View
echo $aus . '<h4>' . ($showtables == 1 ? $lang['L_SQL_TABLEVIEW'] : $lang['L_SQL_DATAVIEW']) . '</h4><p>';
if ($showtables == 0) {
    $p = 'sql.php?sql_statement=' . urlencode($sql['sql_statement']) . '&amp;db=' . $db . '&amp;tablename=' . $tablename . '&amp;dbid=' . $dbid . '&amp;limitstart=' . $limitstart . '&amp;order=' . urlencode($order) . '&amp;orderdir=' . $orderdir . '&amp;tdc=' . $tdcompact;
    echo '<a href="' . $p . '&amp;mode=new">' . $lang['L_SQL_RECORDNEW'] . '</a>&nbsp;&nbsp;&nbsp;&nbsp;';
    echo '<a href="sql.php?db=' . $databases['db_actual'] . '&amp;dbid=' . $dbid . '&amp;tablename=' . $tablename . '&amp;context=2">' . $lang['L_SQL_EDIT_TABLESTRUCTURE'] . '</a>';
} else {
    $p = 'sql.php?db=' . $db . '&amp;dbid=' . $dbid . '&amp;context=2';
    echo '<a href="' . $p . '">' . $lang['L_SQL_TABLENEW'] . '</a>';
}
//Statuszeile
$tn = ExtractTablenameFromSQL($sql['sql_statement']);
if ($databases['Name'][$dbid] != $databases['db_actual']) {
    // Table is located in a different databasse
    // switch the actual database
    $databases['db_actual'] = $databases['Name'][$dbid];
    // refresh menu to switch to actual database
    echo '<script type="text/javascript" language="javascript">' . 'parent.MySQL_Dumper_menu.location.href=\'menu.php?dbindex=' . $dbid . '\';</script>';
}
echo '</p><p class="tablename">' . ($tn != '' ? $lang['L_TABLE'] . ' <strong>`' . $databases['db_actual'] . '`.`' . $tn . '`</strong><br>' : '');
if (isset($msg)) {
    echo $msg;
}
$numrowsabs = -1;
$numrows = 0;
// vorgehensweise - zwischen SELECT und FROM alles rausschneiden und durch count(*) ersetzen
// es soll die Summe der Datensaetze ermittelt werden, wenn es kein LIMIT geben wuerde, um die

コード例 #2

ファイル: sql.php プロジェクト: BackupTheBerlios/oos-svn

        $aus .= '</table>' . FormHiddenParams() . '<input type="hidden" name="sql_statement" value="' . urlencode($sql['sql_statement']) . '"></form></div>';
    }
}
if ($context == 0) {
    //Data-View
    echo $aus . '<h4>' . ($showtables == 1 ? $lang['sql_tableview'] : $lang['sql_dataview']) . '</h4><p>';
    if ($showtables == 0) {
        $p = 'sql.php?sql_statement=' . urlencode($sql['sql_statement']) . '&amp;db=' . $db . '&amp;tablename=' . $tablename . '&amp;dbid=' . $dbid . '&amp;limitstart=' . $limitstart . '&amp;order=' . $order . '&amp;orderdir=' . $orderdir . '&amp;tdc=' . $tdcompact;
        echo '<a href="' . $p . '&amp;mode=new">' . $lang['sql_recordnew'] . '</a>&nbsp;&nbsp;&nbsp;&nbsp;';
        echo '<a href="sql.php?db=' . $db . '&amp;dbid=' . $dbid . '&amp;tablename=' . $tablename . '&amp;context=2">Tabellenstruktur bearbeiten</a>';
    } else {
        $p = 'sql.php?db=' . $db . '&amp;dbid=' . $dbid . '&amp;context=2';
        echo '<a href="' . $p . '">' . $lang['sql_tablenew'] . '</a>';
    }
    //Statuszeile
    echo '</p><p>&nbsp;' . ExtractTablenameFromSQL($sql['sql_statement']) . '</p><p align="left">';
    if (isset($msg)) {
        echo $msg;
    }
    //SQL ausführen
    if ($sql_to_display_data == 0) {
        //mehrere SQL-Statements
        $numrowsabs = $numrows = 0;
        MSD_DoSQL($sql['sql_statement']);
        echo SQLOutput($out);
    } else {
        $numrowsabs = $numrows = 0;
        $res = MSD_query($sql['sql_statement']) or die(SQLError($sql['sql_statement'], mysql_error()));
        $numrowsabs = mysql_num_rows($res);
        $res = MSD_query($sql['sql_statement'] . $sql['order_statement'] . $limit) or die(SQLError($sql['sql_statement'] . $sql['order_statement'] . $limit, mysql_error()));
        $numrows = mysql_num_rows($res);