i am new to php programming . i am not getting your code . it is doing nothing . the above script is not working. i want to know whether file is need to be keep in wamp server or somewhere else and at the start of code it is not in code please help i am new to php

Thanks a lot, this is what I am looking for-)

Oops i was doing the same silly mistake of not adding the enctype=”multipart/form-data”.
This code is working properly

Thank You sir! Now I’m using this

Thank you for sharing your thoughts here. I really appreciate it.

@mahendra I have checked this script only two little mistake on this script. Just replace

to

And

to

@mahendra I have checked this script only two little mistake on this script. Just replace

input type=’text’ name=’sel_file’ size=’20′
to
input type=”file” name=”sel_file” id=”sel_file”

And

input type=’submit’ name=’submit’ value=’submit’
to
input type=’submit’ name=’submit’ value=’SUBMIT’

thanx for the code

Thanks .iam using the code.but i have a small problem.iam getting only one record inserted in the database.Only the last record.plz help me

thanks for sharing the code sir

Thanks .iam using the code.but i have a small problem.iam getting only one record inserted in the database.Only the last record.plz help me

please help me as soon as possibel

This code won’t work if there are more than one dot in name of file.
Try this: if(strtolower($chk_ext[substr_count($files_name,".")]) == “csv”)

How can I skip the first line in a csv file using the code above?

Hello boss the excel file is uploading but not showing content in to the database and the code is
<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
echo "Connected to MySQL”;
mysql_select_db(“test”) or die(mysql_error());
echo “Connected to Database”;
?>

<form action='’ method=’post’ enctype=”multipart/form-data”>

Import File : <!—->

the code is working

I want information about only for .xls sheets to import data into mysql database. if any one knows please help me

running sucessfully but after some change, Nice and helpful tutorial, need some rework on it… here is mine

<form action='’ method=’post’ enctype=”multipart/form-data” >

Import File :

Hey, the above script is not well formed, if the file has more then one .(dot), it will not work. Use the mime type of the file instead, this never lies. Or you could use array_pop, on the exploded array to get the last part of the array (this is the extension).

$mime_type = $[FILES]['sel_file]['type'] or $chk_ext_array = explode(‘.’, $fname); $extension = array_pop($chk_ext_array);

But thanks for mentioning the fgetcsv, this is what I was looking for

After Uploading the excel sheet, it is not showing any message. I added enctype=”multipart/form-data” in the form. Also changed the ID and Value of the input type. pls help me.