This program can be used to browse data in MySQL. You can make a very good MySQL browser with a few modifications.
*/
/*
?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('Unable to connect'.$host);
switch($cmd){
case 'db':
$dbs = mysql_list_dbs($con ) or die('mysql_list_dbs Error:'.$php_errmsg);
echo 'databases on '.$host.':
'.chr(13); $num_rows . $i=0;$i<$num_rows;$i++){
urlencode($db).'">'.$db.'
'.chr(13); case 'table' :
$tables = @mysql_list_tables($db,$con) or die('mysql_list_tables $tables = $tables = ;'.chr(13);
$num_rows = mysql_num_rows($tables);
for($i=0;$i<$num_rows;$i++){
$table = mysql_tablename($tables,$i);
echo ' ;/a>
'.
chr(13);
}
mysql_free_result($tables);
echo '
" .$row[$i].''.chr(13); echo ' |
---|