-
Notifications
You must be signed in to change notification settings - Fork 2
/
import_csv.php
44 lines (34 loc) · 1.3 KB
/
import_csv.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?php
include_once("config.php");
/*
* Import data from csv file
*/
$csvmimes = array('text/x-comma-serated-values','text/comma-serpated-values','application/octet-stream','application/vnd.ms-excel','application/x-csv','text/x-csv','text/csv','application/csv','application/excel','application/vnd.msexcel','text/application');
if (!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'],$csvmimes)) {
if (is_uploaded_file($_FILES['file']['tmp_name'])) {
$csvFile = fopen($_FILES['file']['tmp_name'], 'r');
fgetcsv($csvFile);
while(($line = fgetcsv($csvFile)) != FALSE){
$id=$line[0];
$name=$line[1];
$phone=$line[2];
$created_at=$line[3];
$updated_at=$line[4];
$prevQuery = "SELECT * FROM phonesdirectory WHERE name='$name'";
$prevResult = $conn->query($prevQuery);
if ($prevResult->num_rows > 0 ){
$conn->query("UPDATE phonesdirectory SET name='$name', phone ='$phone' , created_at=$created_at , updated_at = NOW()");
}else{
$conn->query("INSERT INTO phonesdirectory (name,phone,updated_at) VALUES ('$name' ,'$phone',NOW())");
}
}
fclose($csvFile);
$resback = "resback='Imported successfully'";
}else{
$resback = "resback='Error wile importing!'";
}
}else{
$resback = "resback='UnknownFile!'";
}
header('Location: index.php?'.$resback)
?>