Mega Code Archive
DB Field Finder
<![CDATA[
<html>
<head>
<title>db Field Finder</title>
</head>
<body bgcolor=black text=#999999 alink=orange vlink=orange link=orange>
<?
/*
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 ? <?echo date(Y);?></small><br>
]]>