 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
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 Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| 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 | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<html> <head> <title>db Field Finder</title> </head> <body bgcolor=black text=#999999 alink=orange vlink=orange link=orange> <? //Paul Routledge qube@proqc.com // //Cheezy Script to find MySQL tablenames - remove th@t for error msgs// /* CREATE TABLE tabs(db varchar(120) NOT NULL,tabs varchar(120) NOT NULL,fld varchar(120) NOT NULL) */ $dbn="test";//do the bit $table="tabs";//do th bit @mysql_connect("Heavenlyhost","UserBlame","aBsuRd");//do h bit function bold($b,$name){$b=eregi_replace("$name","<font color=\"orange\"><b>$name</b></font>",$b);return($b);} $nb=" | "; echo"<h2>db Field Finder - switched off for obvious reasons.......</h2> <form action=$PHP_SELF><input type=text name=field_name><input type=submit> <br>Type a single word Phrase</form>"; if(!$field_name){return;} @$db=mysql_list_dbs(); while(@$dbs=mysql_fetch_array($db)) { $lt=mysql_list_tables($dbs[0]); while($tabs=mysql_fetch_array($lt)) { $lf=mysql_list_fields($dbs[0],$tabs[0]); $f=mysql_num_fields($lf); for($i=0;$i<$f;$i++) { if(mysql_field_name($lf,$i)==$field_name) { $fn=mysql_field_name($lf,$i); $sql_query = "insert into $table values('$dbs[0]','$tabs[0]','$fn')"; echo"<b>Field \"<font color=red>$field_name</font>\"</b> is in <b>Database [<font color=red>$dbs[0]</font> ] Table [ <font color=red>$tabs[0]</font> <font class=a>]</font></b>"; echo$nb; echo mysql_field_type($lf,$i);echo$nb;echo mysql_field_len($lf,$i);echo$nb; echo mysql_field_flags($lf,$i); echo"<br>"; } else { $fn=mysql_field_name($lf,$i); $sql_query = "insert into $table values('$dbs[0]','$tabs[0]','$fn')"; $res= mysql_db_query($dbn, $sql_query); } } } } echo"<p>"; $last="select fld,tabs,db from $table where fld like '%$field_name%' order by db,tabs,fld"; @$results = mysql_db_query($dbn, $last); while(@$d=mysql_fetch_array($results)) { echo"Search for <b><font color=red>\"</font>$field_name<font color=red>\"</font> </b> is part of a fieldname in <b>Database [ <font color=red>$d[db] </font> ] Table [ <font color=red>$d[tabs]</font> ] </b> "; echo $field_name2=$b=bold($d[fld],$field_name); echo"<br>"; } $del_query="delete from $table"; @$del = mysql_db_query($dbn, $del_query); @mysql_close(); ?> <br><br><small>Programming © <a href="mailto:qube@proqc.com">Paul Routledge</a> <?echo date(Y);?></small><br> | |||||
| Related Code Examples | |||||
