D72 Posted August 6, 2006 Share Posted August 6, 2006 Hi all, I am dealing for a couple of weeks with a really annoying problem. The problem is, i can't get the code working to buy or add products from new products wich are displayed on my index. I am able to view the info by clicking on the product image, or the info by clicking on the info button. But when i want to add the product in my cart, i am redirected to the checkout section, but the id of the product isn't added to the checkout list. How on earth do i correct this in my code line. I really searched dozens of topics on forums. But it seems that i am not able to fix my problem. The code wich is shown in my new_products.php looks like this: <td style="padding-top:1px;"><a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a></td> Please can someone help me with this. I am really clueless abou tthis one. The whole code of my new_products.php is as following: <?php ?> <!-- new_products //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => '<div class="header"><img src="images/marker_header.gif" width="3" height="5" alt="" style="margin:0px 6px 2px 0px;" />'.TABLE_HEADING_NEW_PRODUCTS.'</div>'); new contentBoxHeading($info_box_contents); ?> <div style="border:1px solid #9A927E;margin-top:1px; padding:3px 0px;"> <?php if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id; $description_query = tep_db_query($sql); $description = mysql_fetch_array($description_query, MYSQL_ASSOC); $description['products_description'] = substr($description['products_description'], 0, 65); $desc_len = strlen($description['products_description']); $description['products_description'][$desc_len-1] = '.'; $description['products_description'][$desc_len-2] = '.'; $description['products_description'][$desc_len-3] = '.'; if ( ($col == 1 && $row == 0) || ($col == 1 && $row == 2) ){ $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'width="1" height="100%" valign="middle" style="border-left:1px solid #5E6367"', 'text' => '<table height="" width="100%" border="0" cellspacing="0" cellpadding="0" > <tr> <td><div style="width:1px;"></div></td> </tr> </table>'); } elseif (($col == 0 && $row == 1) || ($col == 2 && $row == 1)) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'height="1"', 'text' => '<table width="95%" border="0" cellspacing="0" cellpadding="0" > <tr> <td style="font-size:1px;background:url(images/points.gif) repeat-x;"> </td> </tr> </table>'); } elseif ($col == 1 && $row == 1) { $info_box_contents[$row][$col] = array('align' => '', 'params' => '', 'text' => ' '); } else { $info_box_contents[$row][$col] = array('align' => 'left', 'params' => 'class="main" width="260" valign="top" align="left"', 'text' => '<table width="260" cellpadding=0 cellspacing=0 border=0 style="margin:8px 1px 10px 0px;"> <tr> <td rowspan="4"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="absmiddle"') . '</a></td> <td height="35" style="padding-right:10px;"><div style="border-bottom:1px solid #333333" class="productName">'.$new_products['products_name'].'</div></td> </tr> <tr> <td height="60" align="left" valign="top">'.$description['products_description'].'</td> </tr> <tr> <td height="32" ><span style="color:#FF7F00; font-size:20px; "> ' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span></td> </tr> <tr> <td class="main" valign=top align="right" style="padding-right:10px; >'. tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')).' <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-top:1px solid #333333; "> <tr> <td style="padding-top:1px; padding-right:1px;" ><a href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'">'.tep_image_button('button_details.gif', Informatie).'</a></td><td style="padding-top:1px;"><a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a></td> </tr> </table></form> </td> </tr> </table>'); } $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents, 0); ?> </div> </td> </tr> <!-- new_products_eof //--> Really hoping that someone can help me with it. Thanks! Link to comment Share on other sites More sharing options...
D72 Posted August 6, 2006 Author Share Posted August 6, 2006 The website with this problem is located - here - Link to comment Share on other sites More sharing options...
Jan Zonjee Posted August 6, 2006 Share Posted August 6, 2006 I am dealing for a couple of weeks with a really annoying problem.The problem is, i can't get the code working to buy or add products from new products wich are displayed on my index. If you would have done a "View Source" in your browser you might have spotted that the products_id is empty in that particular link. It is caused by the fact that you use $products_new['products_id'] (which is empty) instead of $new_products['products_id']: <td style="padding-top:1px; padding-right:1px;" ><a href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'">'.tep_image_button('button_details.gif', Informatie).'</a></td><td style="padding-top:1px;"><a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a></td> Link to comment Share on other sites More sharing options...
D72 Posted August 6, 2006 Author Share Posted August 6, 2006 O h M y G o d... :| That's all? I did just change: $products_new['products_id'] into $new_products['products_id'] and the whole problem is solved. This is really a relief, i didn't made the existing code. It was allready in there. So i thought it wasn't wrong. I am really glad that this problem is over. Thanks JanZ. You really was a great help! Now up to my next problem... Still have one to go :( The taxes and region part... Also a pain in the ass This topic can be closed too in my case Again, thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.