Php > Databases

DB Field Finder

DB Field Finder

<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>