php 批量删除mySQL数据库记录

jopen 10年前

<?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);      ?>