php 批量删除mySQL数据库记录
jopen
11年前
<?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); ?>