Member Avatar for eman neercs

Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts.

Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot be inadvertently changed by the other scripts. I currently add this back manually but I'd like to use php to do it.

I could change the data to txt or csv and use mysql insert statements but I cannot find how to do a simple upload the .sql to a db.

Where should I start looking?

  • 2 Contributors
  • 1 Reply
  • 110 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by chrishea
Member Avatar for chrishea

There are lots of resources out there so you just have to do a bit of searching. The link below leads to a lot of programs in this general category. You may find one that does exactly what you want but if not, you can probably use one of them as a starting point and add whatever else you need.

http://www.hotscripts.com/search/php/mysql+file+upload

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.