Total Pageviews

Wednesday 17 October 2012

一键清空MYSQL数据库的数据


新建一个del.php文件, 将如下代码放置其中,修改数据库信息后保存, 传至空间根目录,
访问www.urdomain.com/del.php   

 
代码:
<html>
<head>
<title>刹那芳华</title>
<script language="javascript">
alert("所有数据已经清空!");
</script>
</head>
<body>
<?php
$hostname =\’localhost\’
$userid = \’用户名\’
$password = \’用户密码\’
$dbname = \’数据库名\’
$connect = mysql_connect($hostname,$userid,$password);
mysql_select_db($dbname);
$result = mysql_query("show table status from $dbname",$connect);
while($data=mysql_fetch_array($result)) {
mysql_query("drop table $data[Name]");

?>
<font color="#FF0000">删除成功!</font>
</body>
</html>