时间: 2021-07-31 作者:daque
这个步调不妨用来欣赏mysql中的数据,您不妨稍做窜改就不妨做出很不错的mysql欣赏器.*//*?cmd=db?cmd=table&db={}?cmd=record&db={}&table={}*/$host = 'localhost';$user = 'test';$password = '';if(!isset($cmd)) $cmd = 'db';switch($cmd){ case 'db': break; case 'table': break; case 'record': break; default: $cmd = 'db'; break;}$con = @mysql_connect($host,$user,$password) or die('没辙贯穿'.$host);switch($cmd){ case 'db': $dbs = mysql_list_dbs($con) or die('mysql_list_dbs 堕落:'.$php_errmsg); echo 'databases on '.$host.':<br>'.chr(13); $num_rows = mysql_num_rows($dbs); for($i=0;$i<$num_rows;$i++){ $db = mysql_tablename($dbs,$i); echo ' <a href="'.$php_self.'?cmd=table&db='. urlencode($db).'">'.$db.'</a><br>'.chr(13); } mysql_free_result($dbs); break; case 'table': $tables = @mysql_list_tables($db,$con) or die('mysql_list_tables 堕落:'. $php_errmsg); echo 'tables on '.$db.' of '.$host.':<br>'.chr(13); $num_rows = mysql_num_rows($tables); for($i=0;$i<$num_rows;$i++){ $table = mysql_tablename($tables,$i); echo ' <a href="'.$php_self.'?cmd=record&db='. urlencode($db).'&table='.urlencode($table).'">'.$table.'</a><br>'. chr(13); } mysql_free_result($tables); echo '<hr><a href="'.$php_self.'?cmd=db">show databases</a>'.chr(13); break; case 'record': $records = mysql_db_query($db,'select * from '.$table,$con) or die('mysql_db_query 堕落:'.$php_errmsg); echo 'records on '.$table.':<br>'.chr(13); echo '<table border="1" cellspacing="0" cellpadding="0">'.chr(13); echo '<tr>'.chr(13); $num_fields = mysql_num_fields($records); for($i=0;$i<$num_fields;$i++) echo '<th> '.mysql_field_name($records,$i).'</th>'.chr(13); echo '</tr>'.chr(13); while($row=mysql_fetch_row($records)){ echo '<tr>'.chr(13); for($i=0;$i<$num_fields;$i++) echo '<td> '.$row[$i].'</td>'.chr(13); echo '</tr>'.chr(13); } echo '</table>'.chr(13); mysql_free_result($records); echo '<hr><a href="'.$php_self.'?cmd=db">show databases</a> <a href="'.$php_self.'?cmd=table&db='.urlencode($db).'">show tables </a>'.chr(13); break;}mysql_close($con) or die('没辙与'.$host.'割断贯穿');?>