E
E
el_vis2014-09-18 12:23:06
PHP
el_vis, 2014-09-18 12:23:06

Is there a framework (or module) in php to update mysql tables from csv or excel?

Hello. I just can't find a convenient universal solution for such a task:
1. There is a spreadsheet document (TD) with a simple structure. (csv, excel)
2. There is a table or a bunch of tables in mysql where this data must be periodically loaded, updated and sometimes unloaded back.
I want to find for improvement, a ready-made prototype in php with an interface, where we specify a unique field in mysql and TD for which we are looking for matches, compare the fields of mysql and TD, and if the data from the file is not found in mysql, we add it.
The connector for connection is optional and unimportant, you can always stick your own. Reverse unloading is not fundamental, but it will be a nice bonus.
I thought of pulling it out of some kind of online store engine that can load price lists, but from the fact that it looked either miserable or cumbersome.
Can anyone come across and tell me where to look? thank.
update: I’ll clarify that it’s for the web, and I’m looking for a ready-made prototype with a client part, namely a universal web interface that fits the needs
. data sharpened for universality.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
evnuh, 2014-09-18
@evnuh

We look just below my answer, the block "Similar questions". And we find a solved question there: How is it optimal to import from XLS to PHP?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question