Hi,
i made a very basic php code that read a XML file and then insert these data to MySQL.
the problem with my code is really not practical and it does duplicate some records.
--
--
---------------------------------
this is what i need
---------------------------------
- one page that i can from it choose my XML (browse from CP)
- then i choose validation method By : 1- EmployeeID or 2-Passport N.O. (CheckBoxs)
- after i click (submit) the code will read my XML file row after a row
- then check this row is it exist in the DB or no (validated by my choice)
--
--
----------------------
Notes/guidelines:
----------------------
- my real XML contains 106,000 rows/records but the attached file only contains (484) rows/records.
- each XML row is containing 34 cells and my table contains more 16 cells (50) .
- use my attachment file only as a reference.
- all files and DB records MUST be in utf-8 and characters MUST stored in DB as it is (Arabic/Urdu).
-
-
-----------------
Attachment : [login to view URL]
-----------------
-
-
i need file in one hour. it's small and simple. i'll pay $8 for it.