I am working on a project that uses OSCommerce with MySQL and I'm confused as to when I should use tep_db_input() or tep_db_prepare_input(). I'd assume I should use tep_db_input() around any strings that are being inserted/updated, but then when should…
i have items, shoes products_tax_class_id =1, bag products_tax_class_id =2, pen products_tax_class_id =3, pencil products_tax_class_id =1 in shopping card. $result = tep_db_query("select count(*) as tax_check from " . TABLE_PRODUCTS . " where products_tax_class_id = '3' and products_id = '".$items[$i]['id']."'"); while ($get_now…
I want to retrieve products_tax_class_ids in checkout payment page in OSCommerce shopping cart software. E.g., the user has 20 items in his shopping cart and if any of product has products_tax_class_id = 30, the site will warn him. This code…
I need to import an entire e-shop made with osCommerce into OpenCart. So far, so good. I have successfully imported almost everything, except for SEO and some sparse data bits, but I have a problem with the address format. osCommerce…
I have an issue with a file in oscommerce. In a customized bm_categories.php file I get a error: Notice: Undefined offset: 0 in xxxincludesmodulesboxesbm_categories.php on line 52 Here is the code. I have marked Line 52 with : //THIS IS…
I have been through quite a lot of ideas, from testing for /admin/ to looking for cookies. But as far as I can see from the documentation, the admin path can be changed. And a few sites I have known…
I spent quite a while trying to import an osCommerce store into Magento 1.7.0.2 and wanted to document it somewhere relevant. The official migration tool seems like the best free option, but it was clearly never completed or properly tested…
Here is the scenario. This table Orders has an auto_increment column called orders_id. The table uses InnoDB storage engine. (This is not about inserting new records in the Orders table, its about how to avoid sending duplicate IDs to the…
In my osCommerce store I want to fetch the parent_id of categories that either have no sub category or child categories. I used the following in my code: $categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c,…
I'm developing an online store using osCommerce (requirement) and need to integrate it with Twitter Bootstrap, specifically the bootstap.css/bootstap.responsive.css and the jQuery plugins. I have already tried a bit, and everything just goes very wrong, styles all over the place,…