How to send a value to mysql?

Hi,

I have created a new text field under Delivery Method (cataloge/checkout/shipping_method.tpl) on checkout where customers can fill in their mobile number.

how can I get the value from that field to be inserted into my database (order->mobile)?

I have tried two nights in a row now, I really need help with this So far I think i have to modyfi something in a controller file and mabye a model file.

I hope someone out there has an answer

most of the data from all the steps for checkout reaches the confirm.php file, and it calls the addOrder function in catalog/model/checkout/order.php

Okay, thanks for the info will check it out

MarketInSG wrote:most of the data from all the steps for checkout reaches the confirm.php file, and it calls the addOrder function in catalog/model/checkout/order.php

Damn didn't get it to work. I have more info how my setup is.

I have removed the "fax" field in guest checkout and added it on shipping method with the new name "mobile" ($mobile).

I also changed the fax to mobile in database. In the addOrder I changed fax to mobile so add addOrder will insert mobile variable into mySQL.

It must be something in the shipping_method.php under controller? I have also changed the fax to mobile in confirm.php.

Please let me know if you need any more information. Really want this to work

Thanks for helping me out!

I don't see a need in changing the variables names in the files. If you would like, you can consider just to rename the fax field to be named a mobile field. Changing the language file would do the trick instead

Would it be hard to move the text field (fax) down under Delivery Method instead of Account & Billing Details?

yes, you will need more skills to do that. Would recommend you to hire someone to work on that if you aren't proficient in OpenCart.