This script is "How to implode csv file into a
database".
<?php
//connect
to the
database
$connect
= mysql_connect("localhost","root","");
//select the
table
mysql_select_db("your
database name",$connect);
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]) {
$val =
explode(';',$data[0]);
mysql_query("INSERT
INTO your
table name
set contact_first='".str_replace('"','',($val[1]))."',contact_last='".str_replace('"',''
($val[2]))."',contact_email='".str_replace('"','',($val[3]))."'");
}
}
while ($data =
fgetcsv($handle,1000,",","'"));
//redirect
header('Location: import.php?success=1'); die;
}
?>
<!DOCTYPE
html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta
http-equiv="Content-Type"
content="text/html;
charset=iso-8859-1" />
<title>Import
a CSV File</title>
</head>
<body>
<?php
if (!empty($_GET['success']))
{ echo "<b>Your file has
been imported.</b><br><br>"; }
?>
<form
action=""
method="post"
enctype="multipart/form-data"
name="form1"
id="form2">
Choose your file:
<br
/>
<input
name="csv"
type="file"
id="csv"
/>
<input
type="submit"
name="Submit"
value="Submit"
/>
</form>
</body>
</html>
I hope it will help you.