php批量删除mySQL数据库记录
时间：2021-07-01 10:21:17
帮助过：30人阅读
- #Usage: php mysql_rmByKey.php
- #Usage: php mysql_rmByKey.php
- #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 '."\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);
- ?>
|
