[Firebug-cvs] firebug/web/postgres firebug.css,NONE,1.1 main.css,NONE,1.1 db_table_buttons.php,1.3,1
Brought to you by:
doolin
From: Karthik D. <da...@us...> - 2005-06-07 00:43:33
|
Update of /cvsroot/firebug/firebug/web/postgres In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3177/postgres Modified Files: db_table_buttons.php db_table_select.php Added Files: firebug.css main.css Log Message: Updated the stylesheets Index: db_table_buttons.php =================================================================== RCS file: /cvsroot/firebug/firebug/web/postgres/db_table_buttons.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** db_table_buttons.php 6 Jun 2005 19:23:19 -0000 1.3 --- db_table_buttons.php 7 Jun 2005 00:43:19 -0000 1.4 *************** *** 17,21 **** } else { $rows = pg_numrows($stat); ! for ($i = 0; $i < $rows; $i++) { $data = pg_fetch_row($stat, $i); --- 17,21 ---- } else { $rows = pg_numrows($stat); ! /* for ($i = 0; $i < $rows; $i++) { $data = pg_fetch_row($stat, $i); *************** *** 23,26 **** --- 23,35 ---- print ("<input type=submit name=tbl1 value=\"" . $data[0] . "\">"); } + */ + print ("<input type=hidden name=db1 value=\"$dbname\">"); + print ("<input type=submit value=GO>"); + print("<select name=tbl1>"); + for ($i = 0; $i < $rows; $i++) { + $data = pg_fetch_row($stat, $i); + print ("<option value=$data[0]> $data[0] </option>"); + } + print ("<\select>"); } --- NEW FILE: main.css --- BODY, TD, P { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #000000;} .black { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #000000;} .grey { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; color: #676767;} .white { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; color: #FFFFFF;} a.white { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight:bold; color: #FFFFFF;} .orange {color: #FF6600;} .titlered {color: #960707; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18px; font-weight:bold;} .titleorange {color: #CC6633; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18px; font-weight:bold;} .red { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; color: #990000;} .small {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; font-weight:normal;} a.nav-main { font-size: 10px; color: #FFFFFF; font-weight:bold; text-decoration:none; } a.nav-main:hover { font-size: 10px; color: #FFF; font-weight:bold; text-decoration:none; } a.nav-sub { font-size: 10px; color: #FFFFFF; text-decoration:none; } a.nav-sub:hover { font-size: 10px; color: #CCCCCC; text-decoration:none; } A { font-family: Verdana, Arial, Helvetica, sans-serif; color: #0066CC;} A:HOVER { color: #FF9900; text-decoration: underline;} A:HOVER.white { color: #FFFFDD; text-decoration: underline;} A:HOVER.black { color: #FF9900; text-decoration: underline;} A:HOVER.orange { color: #993300; text-decoration: underline;} A.small { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #0066CC;} .topnav { font-size: 10px;} .topnav_active {background-color:#FDCD85; color:#394D73; font-weight: bold; font-size: 10px;} a.topnav{font-weight: bold; text-decoration:none; color:#394D73;} a.topnav:hover{background-color:#FDCD85; color:#394D73; text-decoration:none;} .header { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 15px; color: #000000; font-weight: bold;} .headerwhite { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 15px; color: #FFFFFF; font-weight: bold;} .wl {font-family:verdana, Helvetica, Sans-Serif; font-size: 12px; font-weight:bold; color:#666633;} .wlt {font-family:verdana, Helvetica, Sans-Serif; font-size: 11px; color:#666633;} .blueh {font-family:verdana, Helvetica, Sans-Serif; font-size: 13px;font-weight:bold;color:#336699;} .bluet {font-family:verdana, Helvetica, Sans-Serif; font-size: 12px;color:#336699;} .bluetsml {font-family:verdana, Helvetica, Sans-Serif; font-size: 10px; color:#336699;} .bluetout {font-family:verdana, Helvetica, Sans-Serif; font-size: 10px;color:#336699;} .boldsmall {font-family:verdana, Helvetica, Sans-Serif; font-size: 10px;color:#000000; font-weight:bold} .spacer1p {margin-top:1px;} .spacer2p {margin-top:2px;} .spacer4p {margin-top:4px;} .spacer5p {margin-top:5px;} .spacer7p {margin-top:7px;} .spacer10p {margin-top:10px;} .spacer12p {margin-top:12px;} .spacer15p {margin-top:15px;} .spacer20p {margin-top:20px;} .spacer25p {margin-top:25px;} .navbox {margin-top:2px;} TR.NavRow TD { vertical-align: middle; border: 1px solid; border-color: #369 #003 #003; border-left: none; cursor: pointer; } .Nav { background-color: #384ccc; color: #fff; cursor: pointer; } .NavText, .NavHighlightText, .NavGroupText { font-family: verdana, arial, sans-serif; font-size: 10px; font-weight: bold; line-height: 14px; padding-left: 6px; text-decoration: none; } .Nav A:link, .Nav A:visited { color: #fff; Text-decoration: none;} .NavHilite { background-color: #5A6B94; color: #fff; } .NavHilite A:link, .NavHilite A:visited { color: #fff; } TR TD.NavHilite A:link, TR TD.NavHilite A:visited { text-decoration: none; } TR.NavHiliteRow TD { vertical-align: middle; border: 1px solid; border-color: #000 #5A6B94 #000; border-left: none; } --- NEW FILE: firebug.css --- table.header { font-weight:bold; font-size:30pt; } table.code { background-color:#ffff66; border:none; width:80%; } table.db_schema { background-color:#ffff66; border-collapse:collapse; border-top:double; border-bottom:double; border-right:double; border-left:double; border-style:solid; align:center; /* width:80%; font-size:75%; */ } table.new { width:50%; } tr.code { /*background-color:#ffff66; */ } tr.msg_header { background-color:#ffcc00; text-align:center; } td.code { padding:5px; width:100%; } h1 { background-color:#ffcc00; color:#ff3300; font-family:tahoma,helvetica,arial; font-size:150%; } h2 { background-color:#ffcc00; color:#ff3300; font-family:tahoma,helvetica,arial; font-size:100%; } h3 { color:#0E37D0; font-family:Georgia; font-weight:bold; font-size:200%; } h4 { /*background-color:#072285;*/ color:#5A7CFC; font-family:Courier New; font-style:normal; font-weight:bold; font-size:150%; } p.jazzy { color:#1841D8; font-family:Comic Sans MS; } p.nice { color:#465BAA; font-family:Lucida Console; } pre.code { background-color:#ffff66; } code.progname { font-weight:bold; } BODY { color:black; background-color:#FFFFF5; } SPAN.title {color:green} SPAN.author {color:purple;} SPAN.publication {color:green} SPAN.fortran { font-variant: small-caps; } span.invisible { color:#FFFFF5; } P.abstract {color:blue; margin-left: 10%; /* width: 80%; */ margin-right: auto; /* background-color: gray; */ } /* a:active { color:red; } a:visited { color:yellow; background-color:blue; } a:link { color:green; } a:hover { color:green; font:bold; } */ /* IMG.inlinemath { text-align: bottom } */ /************************************************/ body { margin:9px 9px 0 9px; padding:0; background-color:#ffffff; } #level0{ background-color:#ffcc00; } #level1 { margin-left:143px; padding-left:9px; background-color:#FFFFFF; } #level2 { background:#FFF3AC; position:relative; } #level3 { margin-right:143px; padding-right:9px; background:#FFFFFF; } #main { background:#fff3ac; } #topBar { background:#ffffff; } #advBar { background:#fff3ac; } #tipDay { float:right; width:175px; background:#FFF3AC; } #lftBar { position:absolute; width:143px; top:9px; left:9px; } #rgtBar { position:absolute; width:143px; top:0; right:0; } Index: db_table_select.php =================================================================== RCS file: /cvsroot/firebug/firebug/web/postgres/db_table_select.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** db_table_select.php 19 Aug 2004 21:59:57 -0000 1.2 --- db_table_select.php 7 Jun 2005 00:43:19 -0000 1.3 *************** *** 30,37 **** <?php - //if (!isset($HTTP_SESSION_VARS["tblname"])) { if ($HTTP_POST_VARS["tbl1"]!=Null){ ! $HTTP_SESSION_VARS["tblname"] = $HTTP_POST_VARS["tbl1"]; ! $HTTP_SESSION_VARS["dbname"] = $HTTP_POST_VARS["db1"]; } --- 30,36 ---- <?php if ($HTTP_POST_VARS["tbl1"]!=Null){ ! $HTTP_SESSION_VARS["tblname"] = $HTTP_POST_VARS["tbl1"]; ! $HTTP_SESSION_VARS["dbname"] = $HTTP_POST_VARS["db1"]; } *************** *** 54,72 **** <?php $dbh = connect_postgres($dbname); ! $statement = "SELECT a.attname FROM pg_attribute a,pg_class c where c.relname = '$tblname' and a.attrelid = c.oid and a.attnum > 0"; $stat = @pg_exec($dbh,$statement); if (!$stat) { print "<strong>ERROR</strong>: Could not retrieve table header column names for<strong>".strtoupper($tblname)."</strong>."; ! } else { // Build the table header column names. Make this into a function. - print("<tr>\n"); $cols = pg_numrows($stat); for ($i=0 ; $i < $cols; $i++) { ! print ("<td>"); $header = pg_fetch_row($stat,$i); print $header[0]; ! print ("</td>"); } print("</tr>\n"); --- 53,71 ---- <?php $dbh = connect_postgres($dbname); ! $statement = "SELECT a.attname FROM pg_attribute a,pg_class c where c.relname ='$tblname' and a.attrelid = c.oid and a.attnum > 0"; $stat = @pg_exec($dbh,$statement); if (!$stat) { print "<strong>ERROR</strong>: Could not retrieve table header column names for<strong>".strtoupper($tblname)."</strong>."; ! } ! else { // Build the table header column names. Make this into a function. print("<tr>\n"); $cols = pg_numrows($stat); for ($i=0 ; $i < $cols; $i++) { ! print ("<td><b><align=center><h2>"); $header = pg_fetch_row($stat,$i); print $header[0]; ! print ("<//h2></b></td>"); } print("</tr>\n"); *************** *** 82,86 **** function print_row($item2,$key) { ! print ("<td>\n"); echo "$item2\n"; print ("</td>\n"); --- 81,85 ---- function print_row($item2,$key) { ! print ("<td><align=\"center\">\n"); echo "$item2\n"; print ("</td>\n"); *************** *** 101,104 **** --- 100,105 ---- } pg_close($dbh); + + } ?> |