i am building an ecommerce app for my website. This is the first time i am developing an app. As of now i am making use of phone gap to do the work for me. But i am stuck at this particular place, i have made the cart and it is working fine and i have made the checkout form also separately. But i don't know how to pass the product information from the cart to the checkout flow and then update it in the database. As of now i am sending the product parameters through the url but i know it is not safe. and i make use of
location.search.string(1)
to get all product parameter from the cart and then attach these to the form data and send it to the php file and from there i add it to the database. Again in the database i am having another problem. I am maintaining two different table, one for the orde information and the other for products. But here the problem is i don't know how to link the two table i.e when a new order is created an order id is assigned to it, now i don't know how to get that order id and use that order id to update the product information in product table. So can some one help me out with these two problems.
I am using jquery and html to create the app and php and mysql for the server side.
thanks in advance.