php读取csv更新mysql_php-将CSV导入MySql,如果重复,则更新所选值

我正在尝试将一个csv文件导入到mysql-databse中,并且我希望uploadscript检查重复项,如果发现有任何重复,则应该更新该行,但只能更新选定的值.我希望它更新除“首次看到”以外的所有值. bssid是我唯一的标识.我也得到一些建议,我应该将“ addslashes”更改为一些更好的代码,但是我不知道哪种方法是最好的做法,有什么建议吗？

//Count ap´s before import

$before = mysql_query("SELECT * FROM wifi");

$num_rows_before = mysql_num_rows($before);

if ($_FILES[csv][size] > 0) {

//get the csv file

$file = $_FILES[csv][tmp_name];

$handle = fopen($file,"r");

//loop through the csv file and insert into database

do {

if ($data[0]) {

$linesCount ++;

mysql_query("INSERT INTO wifi (bssid, channel, privacy, ciper, auth, power, essid, latitude, longitude, first_seen, last_seen) VALUES

(

'".addslashes($data[0])."',

'".addslashes($data[1])."',

'".addslashes($data[2])."',

'".addslashes($data[3])."',

'".addslashes($data[4])."',

'".addslashes($data[5])."',

'".addslashes($data[6])."',

'".addslashes($data[7])."',

'".addslashes($data[8])."',

'".addslashes($data[9])."',

'".addslashes($data[10])."'

)

");

}

} while ($data = fgetcsv($handle,1000,","));

//redirect

header('Location: index.php/ladda-upp?success=1&before=' . $num_rows_before); die;

}

//Catch argument from url

$arg_bef=$_GET['before'];

//Count ap´s after import

$after = mysql_query("SELECT * FROM wifi");

$num_rows_after = mysql_num_rows($after);

//Count new rows

$new_rows = $num_rows_after - $arg_bef;

//generic success notice

if (!empty($_GET[success])) { echo "Resultat: Din fil har blivit importerad!
";

//echo stats

echo "Antal före import - ";

echo "$arg_bef";

echo "
";

echo "Antal efter import - ";

echo "$num_rows_after";

echo "
";

echo "Antal nya rader - ";

echo "$new_rows";

echo "
";

echo "Rader i CSV-fil - ";

}

//Close connection to databse

mysql_close($connect) ;

?>

解决方法:

您想要mysql的重复键功能

确保在CSV中显示的字段上设置了密钥,例如：bssid可能有效.

不用addslashes()来使用mysql_real_escape_string(),但是毫无疑问,有人会指出mysql_函数已被弃用,并将很快被删除,因此您至少应使用mysqli.

标签：mysql,php

来源： https://codeday.me/bug/20191123/2065083.html