php 批量删除mySQL数据库记录
-
原创
-
2016-07-25 09:12:42
973浏览
- #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);
- ?>
|
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
