No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Read first row from csv file and create table automatically according to it(csv file fields) in mysql. Looking for PHP script? I have tried this. <?php $arr = array(array(),array()); $num = 0; $row = 0; $handle = fopen("./contacts.csv", "r"); while($data = fgetcsv($handle,1000,",")){ $num = count($data); for ($c=0; $c < $num; … |
|
Re:
Hi, I want to do like: 1> [COLOR="Red"]browse file and upload .xls file only[/COLOR] (Not csv or other format) 2> save into mysql database. Any sample demo example?? Or link please? |
|
Re:
Hello guys, i have been working on a new script that will import data from a TXT file to mysql. Using this code works ok: $sql = 'LOAD DATA LOCAL INFILE 'logons-16-12-2013.txt' INTO TABLE pcvsuser COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\\r\\n''; But if i … |