高手请进!!!!!!!!急!!!谁正确回答,分全给他!!!!! http://linuxbyte.net/showsoftd.php?ID=660 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我用的是这个你改一下下面的这一行//$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"><!--a { font-family: "Tahoma","Arial", "Helvetica", "sans-serif"}a:link { color: #3333FF; text-decoration: none}a:visited { color: #990000; text-decoration: none}a:hover {color: #FF6600; text-decoration: underline}.Title1 { font-size: 18px; font-weight: bold; font-family: "Tahoma","Arial", "Helvetica", "sans-serif"}.Title2 { font-size: 16px; font-weight: bold; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif"}.Fnt12px { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" }.Fnt12pxG { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #666666}.Fnt12pxW { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}.Title3 { font-size: 12px; font-weight: bold; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" }.Fnt12pxR { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #CC0000}.Menu1 { background-color: #88ACE8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Menu2 { background-color: #000098; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}.Menu3 { background-color: #a0d8d8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.TdMn { background-color: #A8ACC8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Td1 { background-color: #F0F0F8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Td2 { background-color: #D8D0E8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Td3 { background-color: #FFCC99; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Td4 { background-color: #F4EFC6; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000 }.Td5 { background-color: #009898; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}.Td6 { background-color: #A0DBDB; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}.Fld1 { background-color: #ffcc88; font-size: 12px}form { margin: 0px}hr { height: 1px}input { font-size: 12px}.Td7 { background-color: #DDD0EA; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000 }--></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> curl在本地正常输出,访问在线URL一片空白 用php实现ping命令不调用exec()的方法谁能指点一下??? PHP基础入门? 哪有php框架下载 广州首饰公司招PHP程序员 如何导出mysql的数据到sql server 或access???是新网的mysql空间 不知道是不是php的bug,关于字符串中含有"?>" 我按网上说的方法配置了httpd.conf文件,可是apache还是执行不了php文件,为什么 关于虚拟路径的问题? 管理员登录界面普通用户也可登录进去 这段为什么执行不了?请高手指教? 访问表为什么报警告,或者查询结果为空?
//$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">
<!--a { font-family: "Tahoma","Arial", "Helvetica", "sans-serif"}
a:link { color: #3333FF; text-decoration: none}
a:visited { color: #990000; text-decoration: none}
a:hover {color: #FF6600; text-decoration: underline}
.Title1 { font-size: 18px; font-weight: bold; font-family: "Tahoma","Arial", "Helvetica", "sans-serif"}
.Title2 { font-size: 16px; font-weight: bold; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif"}
.Fnt12px { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" }
.Fnt12pxG { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #666666}
.Fnt12pxW { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}
.Title3 { font-size: 12px; font-weight: bold; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" }
.Fnt12pxR { font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #CC0000}
.Menu1 { background-color: #88ACE8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Menu2 { background-color: #000098; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}
.Menu3 { background-color: #a0d8d8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.TdMn { background-color: #A8ACC8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Td1 { background-color: #F0F0F8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Td2 { background-color: #D8D0E8; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Td3 { background-color: #FFCC99; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Td4 { background-color: #F4EFC6; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000 }
.Td5 { background-color: #009898; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #FFFFFF}
.Td6 { background-color: #A0DBDB; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000}
.Fld1 { background-color: #ffcc88; font-size: 12px}
form { margin: 0px}
hr { height: 1px}
input { font-size: 12px}
.Td7 { background-color: #DDD0EA; font-size: 12px; font-family: "Tahoma", "Arial", "Helvetica", "sans-serif" ; color: #000000 }-->
</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>