linux php脚本:
php脚本输入命令行参数:
可以直接调用argc(参数个数),argc[](参数内容)进行输入输出;
php----preg_match_all()函数:
preg_match_all($parttner,$string,$matches);
对于这个函数,检查$string中只要有符合$partnerr中的条件的,就会保存到$matches数组中,作为索引数组。
读取一个数据库中的所有表:
mysql语句:show tables------得到所有的表名:
$query = "show tables";
$tables = array();
$res = $conn->query($query);
$tables = $res->fetch_all(MYSQLI_NUM);
此时tables中就是按索引数组保存所有的table名;
将tables中的内容读出,用mysql语句:select * from tables[xx]进行读取;
往后的操作就是常规的从table中读取数据的过程。
将所得内容输出到网页中:
<h1>数据库信息</h1>
<?php
$str;
$dsn=array();
$username = "root";
$passwd = "root";
$localhost = "127.0.0.1";
$port = "3308";
$database = "xxx";
echo "数据库配置信息:$username $passwd $localhost $port $database ";
//得到每个配置信息,进行连接:
$conn = mysqli_init();
$conn->options(MYSQLI_OPT_CONNECT_TIMEOUT, 1);
$conn->real_connect($localhost,$username,$passwd,$database,(int)$port);
//得到这个数据库的所有表名:
$query = "show tables";
$tables = array();
$res = $conn->query($query);
$tables = $res->fetch_all(MYSQLI_NUM);
foreach($tables as $src){
$query = "select * from ".$src[0];
$res = $conn->query($query);
$data = array();
$data = $res->fetch_all(MYSQLI_ASSOC);
foreach($data as $i)
$keys = array_keys($i);
echo "<br/><br/>";
echo "<table width='100%' border='1' cellpadding='0' cellspacing='0'>";
echo "表名:$src[0]";
echo "<tr>";
foreach ($keys as $k){
echo "<td>$k</td>";
}
echo "</tr>";
foreach($data as $i){
echo "<tr>";
foreach($keys as $k){
echo "<td>{$i[$k]}</td>";
}
echo "</tr>";
}
echo "</table>";
}
?>