Hi all, I have seen this done many of times, how ever no idea how to make it work.. I have read alot of people having issues (which they have some understanding) and tutorials, unfortunately I cannot find anywhere a simple example to work off
Attached is the XML file I want to import
In this file (booking) i would want to insert into 2 tables
<Identification Company="AE" BookingNo="604433"/>
<ReservationDetails BookingStatus="BOOKING" DepartureDate="2015-09-01"
These would go into a table called: enq_land
under: land_supplier, supplier_ref, land_process, land_findate (respectively)
after this, all the items (hotels,transfers,etc) will need to be put into a different table reffing back to enq_land
I have the basics setup for the selection of the file to insert, but do not know how to push it through a form to be read
<input type=file name=xmlfile value=Browse accept=".xml"> <input type=submit name=AddXML value="Import XML">
Any help is appreciated for this enormous task.