Buat script di php, utk membaca file csv tersebut :
misalkan bentuk file csv nya
Kode Item Quantity
AB123 50
AB456 60
AB321 55
// buka filename test.csv
$handle = fopen("./files/test.csv", "r");
while ($userinfo = fscanf($handle, "%[a-zA-Z0-9],%[0-9]\n")) {
list ($item, $qty) = $userinfo;
//... insert to database with the values
$query = "INSERT INTO test VALUES ('".$item."',".$qty.")";
$stid = oci_parse($conn, $query);
$r = oci_execute($stid,OCI_DEFAULT);
}
Smoga membantu
Regards,
Darmawan
----- Original Message -----
From: eldien hasmanto
To: [email protected]
Sent: Thursday, November 23, 2006 08:39
Subject: RE: [indo-oracle] upload data excel ke oracle10g via web (php)
Buat suatu prosedur / fungsi PL/SQL yang berfungsi untuk membaca data dari
excel ( biasa formatnya csv ) lalu fungsi / prosedur tersebut dipanggil di
skrip php...
>From: "bludab_ora" <[EMAIL PROTECTED]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: [indo-oracle] upload data excel ke oracle10g via web (php)
>Date: Wed, 22 Nov 2006 14:38:12 -0000
>
>dear frend,
>
>Saya punya data di excel rencana pengindi upload atau migrasi ke
>database Oracle10g via web (php please), bagaimana ya temen-temen?
>thnx b4..
>
>
__________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
[Non-text portions of this message have been removed]
