Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > PHP batch delete mySQL database records

PHP batch delete mySQL database records

WBOY

Release： 2016-07-25 09:12:42

Original

1219 people have browsed it

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

复制代码

Related labels：

php 批量删除mySQL数据库记录

source：php.cn

Previous article：js method to obtain radio and select attributes Next article：How to get the drop-down list value and number of elements in js

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn