CSV file uploaded in php and inserted to oracle database
Posted on 2011-03-15
I am sorry if this question has been answered before, but I have looked and googled many pages and can't seem to find what I want to do.
I have been updating the database every week by manually writing the code and then inserting values into my table. The table is called freight and have colums like this
ORNO NOT NULL CHAR(9)
DDAT NOT NULL DATE
what i would like to do is create a php file that will allow me to browse and select a file to upload, validate (orno must start with SOA, and no blank lines) the data and then insert into table.
Can someone please show me how to do this?