紀錄些小事情

//列出所有資料庫

$result =mysql_list_dbs($localmat);

while ($row = mysql_fetch_object($result)) {

echo "資料庫:";

echo $row->Database . "\n";

}

echo "
";





//資料庫名稱,列出所有table

if ($dname!="")

{

$result =mysql_list_tables($dname);

echo $dname."的table
";

while ($row = mysql_fetch_row($result)) {

print "Table: $row[0]\n";

}

}

echo "
";







//table名稱,列出所有欄位

if ($tname!="")

{

mysql_select_db($dname, $localmat);

$result = mysql_query("select * from $tname", $localmat);

echo mysql_error();

//劃出欄位名稱

echo "";

$i=0;

echo "";



do {

echo "" ;

} while ($i < @mysql_num_fields ($result)) ;

echo "

表格:$tname

"; $i++; $meta = @mysql_fetch_field ($result); echo $meta->name."

";

}

echo "
";







$sname=strtolower($sname);

if ($sname!="")

{

mysql_select_db($dname, $localmat);

$result = mysql_query($sname, $localmat);

echo mysql_error();



//echo $localmat;

}

$aa=explode(" ", $sname);

switch ($aa[0]) {

case 'insert':

$try="into";

break;

case 'update':

$try="update";

break;

case 'delete':

$try="from";

break;

default :

$try="select";

break;

}

echo $sname."字串長度
";

//echo $try."驗證
";

$str1=substr($sname,strpos( $sname, $try ));

$str2=explode(" ", $str1);



if ($try!="select" and $try!="") $sname="select * from ".$str2[1]." where 1";

//echo $sname;



if ($sname!="" and $dname!="") {

mysql_select_db($dname, $localmat);

$result = mysql_query($sname, $localmat);

echo mysql_error();



//劃出欄位名稱

echo "";

$i=0;

do {

echo "" ;

} while ($i < @mysql_num_fields ($result)) ;



do {

echo "";

for ($j=0;$j<$i;$j++) echo "";

echo "";



} while (@$row_Recordset1 = mysql_fetch_row($result)) ;



echo "

$i"; $i++; $meta = @mysql_fetch_field ($result); echo $meta->name."

$row_Recordset1[$j]

";

}

?>

資料庫名稱




table名稱

sql語法




<?=$sname;?><br /><br />