The following is part of my script and I checked the data file. All rows
got inserted.
<?php
print "Connecting to Oracle...\r\n";
ob_flush();
$conn = ocilogon("abc","12345","Oracle8") or die("Cannot connect to
Oracle!\r\n");
print "Connected!\r\n";
ob_flush();
print "Loading glacct table...\r\n";
ob_flush();
$fp = fopen(".\GLAccount.csv","r");
while ($data = fgetcsv($fp,100,",")) { //Loop through each data row.
$SQLString = "INSERT INTO glacct
(gla_company_cd,gla_division_cd,gla_acct) VALUES
('company','division','$data[0]')";
$SQLStmt = ociparse($conn,$SQLString);
$SQLReturn = ociexecute($SQLStmt);
If ($SQLReturn) {
ocicommit($conn);
} Else {
ocirollback($conn);
}
}
fclose($fp);
ocilogoff($conn);
?>
William Cheung, B.Sc. MCSE MCDBA
Databyte Corp.
