|
|
 |
Join us on FaceBook | |
 |
Submit Your Code | |
 |
Poker Tournaments | |
|
Poker Guide for Developers | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile |
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Resources | ||
| Web Development Content | ||
| Internet Security Software | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| פרייסז - הכח לקנות עובר לידיים שלך | ||
| Texas Holdem Poker Evangelists | ||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | ||||||||||
1. Select a database from the combo box 2. Select the fields you want to see from the tables 3. Click on selected fields to see all records matching your selection Code : <?php // lines to change to make your connection $DB_SERVER="localhost"; // Database Server machine $DB_LOGIN="ODBC@localhost"; // Database login $DB_PASSWORD=""; // Database password $HTTP_HOST="localhost"; // HTTP Host $DOCROOT="list_mysql"; // Path, where application is installed $DB=""; set_magic_quotes_runtime(0); // Disable magic_quotes_runtime - don't change $ocon = mysql_connect("localhost",$DB_LOGIN,$DB_PASSWORD); //mysql error function function mysql_die($mess) { echo "Mysql-Error " . mysql_error() ."<br>"; echo $mess . "<br>"; exit; } if(isset($rtn_db)) { $DB=$rtn_db; unset($rtn_db); } // have we changed the database if(isset($do_db)) { unset($do_db); $DB=$dbs; } // have we selected to sow the details if((isset($do_all)) || (isset($do_sel))) { ?> <html><head> </head><body><center> <?php $DB=$the_db; echo $DB; $rest=mysql_list_tables($DB); $tables=array(); mysql_data_seek($rest,0); $nb_tbl=0; while ($rowt=mysql_fetch_array($rest)) { $sql="show fields from $rowt[0]"; $resf["$rowt[0]"]=mysql_db_query($DB,$sql) or mysql_die($sql); $row_max=mysql_num_rows($resf["$rowt[0]"]); $j=0; for($i=0; $i<$row_max; $i++) { $key=$rowt[0].$i; if(($$key=="on") || (isset($do_all))) { $tables["$rowt[0]"][$j]=$key; $j++; } } if($j!=0) $nb_tbl++; } unset($do_all); unset($do_sel); mysql_data_seek($rest,0); echo "<center><table width=100% border=2><tr>"; if ($nb_tbl!=0) $tblw=(int)(100/$nb_tbl); while ($rowt=mysql_fetch_array($rest)) { if(isset($tables["$rowt[0]"][0])) { echo "<td align=center width=\"$tblw%\" ><A Href=\"#$rowt[0]\">$rowt[0] </A></td>"; } } echo "</tr></table></center>"; mysql_data_seek($rest,0); while ($rowt=mysql_fetch_array($rest)) { if(isset($tables["$rowt[0]"][0])) { echo "<center><table><tr>"; echo "<td><A id=\"$rowt[0]\"></A>Table: " . $rowt[0] ."</td>"; echo "</tr></table></center>"; echo "<center><table border=1><tr>"; $sql="show fields from $rowt[0]"; $resr=mysql_db_query($DB,$sql) or mysql_die($sql); $sql="SELECT"; for($i=0; $i<999; $i++) { if(isset($tables["$rowt[0]"][$i])) { $val=str_replace($rowt[0],"",$tables["$rowt[0]"][$i]); mysql_data_seek($resr,(int)($val)); $rowr=mysql_fetch_array($resr); echo "<td>Field: " . $rowr[0] . "</td>"; if ($sql>"SELECT") $sql.=","; $sql.= " " . $rowr[0] ; } else continue; } $sql.= " from " . $rowt[0]; $res = mysql_db_query($DB,$sql) or mysql_die($sql); echo "</tr>"; $nb_field = mysql_num_fields($res); while ($rowd=mysql_fetch_array($res)) { echo "<tr>"; for($k=0; $k<$nb_field; $k++) { $val=$rowd[$k] . ""; echo "<td>" . $val . "</td>"; } echo "</tr>"; } echo "</table></center>"; echo "<hr size=2>"; } } mysql_data_seek($rest,0); echo "<center><table border=2 width=100%><tr>"; while ($rowt=mysql_fetch_array($rest)) { if(isset($tables["$rowt[0]"][0])) { echo "<td align=center width=\"$tblw%\" ><A Href=\"#$rowt[0]\">$rowt[0] </A></td>"; } } ?> </tr></table><br> <form><input type=hidden name="rtn_db" value="<?echo $DB;?>"> <input type=submit name="back" value=back> </form></center> <center><font face=verdana size=2 color=navy> <li>Written by <A href="mailto:michel@afixis.com">michel beeckmans</A> from <A href="http://www.afixis.com">Afixis Trade Unlimited</A></center> </font> </body></html> <?php exit; } ?> <html><head></head><body> <script language="JavaScript"> <!-- function do_check( chk_name,chk_nb,chk_val) { for(i=0; i<chk_nb; i++) { chk_el=chk_name+i; document.forms(1).elements(chk_el).checked=chk_val; } return false; } //--> </script> <center> <table width=50% border=1><form method="POST"> <font face="verdana,helvetica,arial" size="1"> <tr><td align=center>Select your database</td></tr> <tr><td align=center> <select size=1 name="dbs"> <?php $i= ($DB<=""?0:1); if ($DB>"") $rest=mysql_list_tables($DB); $dbs=mysql_list_dbs(); while ($rowdb=mysql_fetch_array($dbs)) { echo "<option value=$rowdb[0]"; if ($i==0 || $DB==$rowdb[0]) { echo " SELECTED"; $i++; if ($DB<="") { $DB=$rowdb[0]; // Database containing the tables $rest=mysql_list_tables($DB); } } echo ">$rowdb[0]</option>"; } ?> </select></td></tr> <tr><td align=center> <input type=submit value="Change database" name="do_db"> </td></tr></form></font> </table><hr size=2 color=fuschia> <table width=25% border=1> <font face="verdana,helvetica,arial" size="2"> <tr><td align=center><?echo $DB;?> tables</td></tr> <?php $max_col=mysql_num_rows($rest); $colsize=(int)(100/$max_col); ?> </font> </table><br> <form method="POST"> <table width=100% border=1> <font face="verdana,helvetica,arial" size="1"> <tr> <?php while ($rowt=mysql_fetch_array($rest)) { echo "<td align=center width=$colsize% colspan=2>$rowt[0]</td>"; } mysql_data_seek($rest,0); echo "</tr>"; $row_max=0; while ($rowt=mysql_fetch_array($rest)) { $sql="show fields from $rowt[0]"; $resf["$rowt[0]"]=mysql_db_query($DB,$sql) or mysql_die($sql); if(mysql_num_rows($resf["$rowt[0]"])>$row_max) $row_max=mysql_num_rows($resf["$rowt[0]"]); } for($i=0; $i<$row_max; $i++) { echo "<tr>"; mysql_data_seek($rest,0); while ($rowt=mysql_fetch_array($rest)) { if($i<mysql_num_rows($resf["$rowt[0]"])) { mysql_data_seek($resf["$rowt[0]"],$i); $val=mysql_fetch_array($resf["$rowt[0]"]); echo "<td>" . $val[0] . "</td><td>"; echo "<input type=checkbox name=$rowt[0]$i>"; echo "</td>"; } else { echo "<td colspan=2></td>"; } } echo "</tr>"; } mysql_data_seek($rest,0); echo "<tr>"; while ($rowt=mysql_fetch_array($rest)) { echo "<td colspan=2 align=center >"; $rn = $rowt[0]; $rv = mysql_num_rows($resf["$rowt[0]"]); ?> <input type=submit value=" All " onClick="return do_check('<? echo $rn;?>',<? echo $rv;?>,1)"> <input type=submit value=" None " onClick="return do_check('<? echo $rn;?>',<? echo $rv;?>,0)"> <?php echo "</td>"; } ?> <tr><td align=center colspan=<?echo ($max_col * 2);?>> <b>Select the fields you want to see</b> </td></tr> <tr><td colspan=<?echo ($max_col);?> align=center> <input type=hidden name="the_db" value="<?echo $DB; ?>"> <input type=submit name="do_all" value="Show all"></td> <td colspan=<?echo ($max_col);?> align=center> <input type=submit name="do_sel" value="Show selected fields"> </td></tr> </font></table> </form> <center><font face=verdana size=2 color=navy> <li>Written by <A href="mailto:michel@afixis.com">michel beeckmans</A> from <A href="http://www.afixis.com">Afixis Trade Unlimited</A></center> </font> </body></html> | ||||||||||
| Related Code Examples | ||||||||||
|
| ||||||||||
| User Comments | ||||||||||
|
||||||||||
