Re: [programming] Upload file text ke database

[Ferry I]

At 01:09 30/10/2002 -0800, Togu Raja wrote:

Salam semua anggota milis...

Saya mau nanya,
gimana cara upload file text yang berisi data (bukan
script SQL) ke database dengan PHP.
Database yg dipakai PostgreSQL dan atau MySQL.

Bisa dng 2 cara :

1.
$fH = fopen ($fullPathToFile, "r");
while (!feof($fH)) {
Parsing file text anda --> bikin sql statement insertnya --> Execute
}

2. Pakai bulk insert nya mysql LOAD DATA
Coba lihat manual.txt nya MySql buat syntax command LOAD DATA

LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]

Shortcut : pakai phpMyAdmin ;)


Best Regards,
Ferry I



--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3