通过php快速统计某个数据库中每张表的数据量_PHP教程

<br><!--?php <BR-->$conn=mysql_connect('localhost','root',''); <br>mysql_select_db('数据库',$conn); <br>$sql="SELECT information_schema.TABLES.TABLE_NAME FROM information_schema. TABLES WHERE table_schema = '数据库'"; <br>$res=mysql_query($sql); <br>while ($result = mysql_fetch_assoc($res)) { <br>$tables[]=$result['TABLE_NAME']; <br>}; <br>echo "<br><br><br><br><br>"; <br>foreach ($tables as $k=>$v){ <br>$sql_count="select count(id) AS nums,'".$v."' from ".$tables[$k]; <br>$res_count=mysql_query($sql_count); <br>$result_count = mysql_fetch_assoc($res_count); <br>echo "'; <br>} <br>echo "<table> <tbody> <tr> <td>表名</td> <td>数据量</td> </tr><tr><td>".$result_count[$v].'</td><td>'.$result_count['nums'].'</td></tr></tbody></table>" <br>?> <br>
<p></p>
<p align="left"><span id="url" itemprop="url">http://www.bkjia.com/PHPjc/325888.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http://www.bkjia.com/PHPjc/325888.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">所以自己简单写了几行代码用来实现以上需求 执行结果：  代码如下:</span></p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>?php $conn=mysql_connect('localhost','root',''); mysql_select_db('数据库',...<p></p></li><li>                    </li></ol></pre>