<?php
$hostname ='localhost'; //服务器地址
$userid = 'username'; //用户名
$password = 'password'; //密码
$dbname = '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]");
}
?>
<?php
#Usage: php mysql_rmByKey.php <user> <passwd> <database> <table_name> <key_name> <del_key_files>
#Usage: php mysql_rmByKey.php <database> <table_name> <key_name> <del_key_files>
#count($argv) > 0, the first $argv[0] is the php file
if(count($argv) == 7){
$user = $argv[1];
$passwd = $argv[2];
$db = $argv[3];
$table = $argv[4];
$key = $argv[5];
$delFile = $argv[6];
}else if(count($argv) == 5){
$user = 'user';
$passwd = '123456';
$db = $argv[1];
$table = $argv[2];
$key = $argv[3];
$delFile = $argv[4];
}else{
#usage();
echo '
Usage: php mysql_rmByKey.php <user> <passwd> <database> <table_name> <key_name> <del_key_files>'."n";
}
$link = mysql_connect('localhost',$user,$passwd);
if(!$link){
die("Could not connect to mysql server: ". mysql_error());
}
mysql_select_db($db,$link);
$fp = fopen($delFile, 'r');
while(!feof($fp) && $ln = fgets($fp)){
$id = chop($ln);
$sql = "delete from $table where $key = '$id';";
mysql_query($sql, $link);
}
fclose($fp);
mysql_close($link);
?>
