import excel data into mysql using php script ? problem

[meeanji]

php codes goes like this[php]<?
$fcontents = file ('./spreadsheet.xls');
# expects the csv file to be in the same dir as this script
for($i=0; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);
$arr = explode("\t", $line);
$sql = "insert into TABLENAME values ('".
implode("','", $arr) ."')";
mysql_query($sql);
echo $sql ."<br>\n";
if(mysql_error()) {
echo mysql_error() ."<br>\n";
}
}
?>[/php]// above is my code . it is working fine for comma separated values.But i am unable to work out with tab . and is not working for XLS file. my aim is to read Excel data into Mysql database.

thanks,
Anji

[ronverdonk]

WARNING:
Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[code green]

I think it is this line [PHP]$sql = "insert into TABLENAME values ('".
implode("','", $arr) ."')"; [/PHP] You are looking for commas.
If it is tab delimted you need [PHP]$sql = "insert into TABLENAME values ('".
implode("\t", $arr) ."')"; [/PHP]

[yuva17raj]

hi
with the same code is it possible to update the database table with excel file base on some condition
such as

update tablename set field1 = '$exceldata1' where field2 = '$exceldata2'


if soo help me with the sample code

regards
yuvaraj

[Dormilich]

with the same code is it possible to update the database table with excel file base on some condition such as
update tablename set field1 = '$exceldata1' where field2 = '$exceldata2'

yes, I would it do exactly this way