php 批次刪除mySQL資料庫記錄

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


?>