PriteshP23 Posted July 30, 2013 Share Posted July 30, 2013 Hello, I would like to know how i can develop interface between XML and MDB files? Actually, i need to convert files from XML into MDB and vice versa. Approximately, how much time it will take? Thanks in advanced for your input. Quote Link to comment Share on other sites More sharing options...
trq Posted July 30, 2013 Share Posted July 30, 2013 Approximately, how much time it will take? That would completely depend on your ability, and the amount of differing data that you have. How long is a piece of string? Quote Link to comment Share on other sites More sharing options...
PriteshP23 Posted July 30, 2013 Author Share Posted July 30, 2013 I have 50 Mb MDB file and 20 Mb XML file. I just need to know functional flow and tools/technical issues. I hope i am clear to you. Quote Link to comment Share on other sites More sharing options...
trq Posted July 30, 2013 Share Posted July 30, 2013 Do you have a specific issue? Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted July 31, 2013 Share Posted July 31, 2013 I have 50 Mb MDB file and 20 Mb XML file. I just need to know functional flow and tools/technical issues. I hope i am clear to you. From XML to Access: 1. Read xml with simplexml and store in vars 2. Connect to mdb with odbc functions or PDO odbc 3. Insert records using vars From Access to XML: 1. Connect to mdb with odbc functions or PDO odbc 2. Run query and get records and store in vars 3. Write out XML with simplexml using vars Quote Link to comment Share on other sites More sharing options...
PriteshP23 Posted August 1, 2013 Author Share Posted August 1, 2013 @AbraCadaver: It sounds good. Thanks a lot. Which one will be better ? Simplexml or DOMParser ? Quote Link to comment Share on other sites More sharing options...
trq Posted August 1, 2013 Share Posted August 1, 2013 Which one will be better ? Simplexml or DOMParser ?/quote] They do two different things. Quote Link to comment Share on other sites More sharing options...
PriteshP23 Posted August 2, 2013 Author Share Posted August 2, 2013 I think to read XML file only. Which one i should choose ? Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted August 2, 2013 Share Posted August 2, 2013 (edited) I think to read XML file only. Which one i should choose ? You need to evaluate the complexity of your XML and project in general. SimpleXML is "simple" and somewhat limited. DOM implements the W3C DOM API, differentiates between element and attribute nodes and allows you to use PHP functions in XPath queries. So DOM might be a good choice. Start with that as it will give you more control. Edited August 2, 2013 by AbraCadaver Quote Link to comment Share on other sites More sharing options...
Solution PriteshP23 Posted August 2, 2013 Author Solution Share Posted August 2, 2013 Thank you all for your input. I have got the basic idea for the project. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.