高手请进！！！！！！！！急！！！谁正确回答，分全给他！！！！！

我用的是这个你改一下下面的这一行
//$database=pg_connect("host=192.168.0.101 port=5432 dbname=crsdb user=oasisdb password=millennium"); <HTML>
<HEAD><TITLE>Database Browser</TITLE></HEAD> <style type="text/css">

</style><BODY BGCOLOR="#FFFFD9" class="Fnt12px">
<?
// Please enter your connection string below
$database=pg_connect("host=192.168.0.101 port=5432 dbname=crsdb user=oasisdb password=millennium"); // This is a simple fragment of code which will run just fine as long as
// you change the connection string. Copyright 2000, Derek Young, GS Data Design
echo "<FORM METHOD=\"POST\" ACTION=\"$PHP_SELF\">\n";
echo "Type SQL Query Here<BR>\n";
echo "<TEXTAREA NAME=\"usersql\" ROWS=\"10\" COLS=\"130\" class=\"Fnt12px\"></TEXTAREA><BR>\n";
echo "<INPUT TYPE=\"SUBMIT\" VALUE=\"Query\" NAME=\"query\" class=\"Fnt12px\">\n";
echo "<INPUT TYPE=\"reset\" VALUE=\"Reset\" class=\"Fnt12px\">\n";
echo "<INPUT TYPE=\"HIDDEN\" VALUE=\"usersql\" NAME=\"action\">\n";
echo "</FORM>";
echo "<BR>\n";
if($action=="usersql") {
        $usersql=stripslashes($usersql);
    echo "QUERY: ".htmlspecialchars($usersql)."<BR>\n";
    echo "<A HREF=\"$PHP_SELF\">Return to tables</A><BR><BR>\n";
    $result=pg_exec($database,$usersql);
    if($numofrows=pg_numrows($result)) {
        echo "<TABLE BORDER=\"0\" CELLPADDING=\"3\" CELLSPACING=\"1\" BGCOLOR=\"#000000\">\n<TR>";
        $fields=pg_numfields($result);
        $fields2=$fields;
        while($fields2) {
            echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">".pg_fieldname($result,$fields-$fields2);
            echo "</TD>";
            $fields2-- ; }
        echo "</TR>\n";
        $click=0;
        while($numofrows > $click) {
            $row=pg_fetch_array($result,$click++);
            echo "<TR>";
            $fields2=$fields;
            while($fields2) {
                echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">";
                echo htmlspecialchars($row[$fields-$fields2--]);
echo " ";
                echo "</TD>";  }
            echo "</TR>\n";
            }
    echo "</TABLE>";
    }
        else $action="";
} if ($action=="") {
   $sql="SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user WHERE usesysid = relowner and ( relkind = 'r' OR relkind = 'S' OR relkind = 'v') and relname !~ '^pg_' and relname !~ '^xinx' ORDER BY relname";
   $result=pg_exec($database,$sql);
//接上
if(!pg_NumRows($result)) echo "No Tables Found!";
    else {
    echo "<TABLE BORDER=\"0\" CELLPADDING=\"3\" CELLSPACING=\"1\" BGCOLOR=\"#000000\">\n";
    echo "<TR><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">Owner</TD><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">Relation</TD><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">Type</TD></TR>\n";
    $click=0;
        $numofrows=pg_numrows($result);
    while($click < $numofrows) {
        $row=pg_fetch_array($result,$click++,1);
        echo "<TR><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">".$row[usename]."</TD><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">";
        echo "<A HREF=\"$PHP_SELF?action=viewt&table=";
        echo rawurlencode($row[relname])."\">".$row[relname]."</TD>";
        if($row[relkind]=="S") echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">sequence</TD></TR>\n";
        if($row[relkind]=="r") echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">table</TD></TR>\n";
        if($row[relkind]=="i") echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">index</TD></TR>\n";
        if($row[relkind]=="v") echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">view</TD></TR>\n";
        }
    echo "</TABLE>\n";
    }
} if($action=="viewt") {
   $sql="SELECT a.attnum as attnum, a.attname as attname, t.typname as typname, a.attlen as attlen, a.atttypmod as atttypmod, a.attnotnull as attnotnull, a.atthasdef as atthasdef FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = '$table' and a.attnum > 0 and a.attrelid = c.oid and a.atttypid = t.oid ORDER BY attnum";
$result=pg_exec($database,$sql); $sql2="SELECT viewname, definition FROM pg_views WHERE viewname like '$table'";
$result2=pg_exec($database,$sql2);
if (pg_numrows($result2)) {
    $row=pg_fetch_array($result2,0,1);
    echo "View = " . $row[viewname] . "<BR>\n";
    echo "Query = " . $row[definition] . "<BR>\n"; }
   else echo "Table = " . $table . "<BR>\n";
   echo "<A HREF=\"$PHP_SELF\">Return to Tables</A><BR><BR>\n"; $click=0;
$numofrows=pg_numrows($result);
echo "<TABLE BORDER=\"0\" CELLPADDING=\"3\" CELLSPACING=\"1\" BGCOLOR=\"#000000\">\n";
echo "<TR><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCC\">Name</TD><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCC\">Length</TD BGCOLOR=\"#FFFFCC\"><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCC\">Type</TD></TR>\n";
while($click < $numofrows) {
    $row = pg_fetch_array($result, $click++, 1);
    echo "<TR><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">".$row[attname]."</TD>";
    if ($row[attlen]==-1) $row[attlen]="var";
    echo "<TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">".$row[attlen]."</TD><TD class=\"Fnt12px\" BGCOLOR=\"#FFFFCA\">".$row[typname]." ";
    if($row[attnotnull]=="t") echo "not null ";
    if($row[atthasdef]=="t") {
        echo "default = ";
        $sql2="SELECT d.adsrc as adsrc FROM pg_attrdef d, pg_class c WHERE c.relname = '$table' and c.oid = d.adrelid and d.adnum = ".$row[attnum];
        $result2=pg_exec($database,$sql2);
        $row2=pg_fetch_array($result2,0,1);
        echo $row2[adsrc]; }
    echo "</TD></TR>\n";
    }
echo "</TABLE>\n"; $sql2="SELECT c2.relname as relname FROM pg_class c, pg_class c2, pg_index i WHERE c.relname = '$table' and c.oid = i.indrelid and i.indexrelid = c2.oid ORDER BY c2.relname";
$result2=pg_exec($database,$sql2);
if($numofrows=pg_numrows($result2)) {
    $click=0;
    while($numofrows > $click) {
        $row2=pg_fetch_array($result2,$click++,1);
        echo "<BR>Index: " . $row2[relname] . "<BR>\n";
        }
    }
} ?> </BODY>
</HTML>

调试易

高手请进！！！！！！！！急！！！谁正确回答，分全给他！！！！！

解决方案 »