php 批量刪除mySQL數據庫記錄

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



?></pre>