-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathupload_excel_file.php
73 lines (58 loc) · 1.6 KB
/
upload_excel_file.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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php
include("../db.php");
?>
<!DOCTYPE html>
<html>
<head>
<title>Excel file in database</title>
</head>
<body>
<?php
if (isset($_POST["upload"])) {
// print_r($_FILES["myfile"]);
$filename=$_FILES["myfile"]["name"];
$tmpname=$_FILES["myfile"]["tmp_name"];
// echo $filename;
// echo $tmpname;
//let find the extension of file
$fileExtension=pathinfo($filename,PATHINFO_EXTENSION);
// echo $fileExtension;
//define allowed extension
$allowedType=array('csv');
if (!in_array($fileExtension,$allowedType)) {
echo "invalid file extension";
}
else
{
$handle=fopen($tmpname,"r");
$str="";
// print_r(fgetcsv($handle));
$str="INSERT INTO class1 (NAME,COURSE) VALUES";
while (($myData=fgetcsv($handle,1000,','))!==false){
// $id=$myData[0];
$name=$myData[0];
$course=$myData[1];
$name=mysqli_real_escape_string($conn,$name);
// echo $name;
$str=$str."('".$name."','".$course."'),";
}
$str=rtrim($str,',');
echo $str;
// echo $query."<br>";
$run=mysqli_query($conn,$str);
if (!$run) {
die("error in uploading file".mysql_error());
}
else{
echo "file uploaded successfully";
}
}
}
?>
<form action="" method="POST" enctype="multipart/form-data">
<h3>upload your excel file</h3>
<input type="file" name="myfile" value="" accept=".csvshivu">
<input type="submit" name="upload" value="upload">
</form>
</body>
</html>