I require a script that takes a custom XML structure from my local test server and sends the data to the target ecommerce websites. The PHP array of XML data contains product information and the target websites are all PHP MySQL based shopping carts. I will not have phpmyadmin access to the target carts so if sending SQL queries, you will need to ensure -
1. XSS is not an issue
2. transfer is secure
3. recently inserted product ID is returned
It would be preferable if I had a main PHP file that held all the functional stuff and separate specific template PHP file that was cart specific, calling the functions as required and transforming data where needed.
oscommerce.php (which transforms the data to be sent specifically for oscommerce)
creloaded.php (which transforms the data to be sent specifically for creloaded)
Standard product details will be sent, including options/attributes, images so please include this in your thought process.
You may use any implementation you wish but you must first draw up a specification of what you plan to do. If you require further clarification please say.
I'll pick the best solution.