Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products display on the front page


tuppergirl

Recommended Posts

Posted

Hi all,

 

How do I change the number of products featured on the front page? After a while of searching and editing the codes with my limited php knowledge, I can't get it done correctly. I need two columns instead of three. Is it from new_products.php or else where? What are the lines of codes that I need to change? Thanks

Posted
Hi all,

 

How do I change the number of products featured on the front page? After a while of searching and editing the codes with my limited php knowledge, I can't get it done correctly. I need two columns instead of three. Is it from new_products.php or else where? What are the lines of codes that I need to change? Thanks

 

the number of products can be changed in admin ... the columns are hardcoded into new_products.php

 

<?php
/*
 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 new contentBoxHeading($info_box_contents);

 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']);
   $info_box_contents[$row][$col] = array('align' => 'center',
                                          'params' => 'class="smallText" width="33%" valign="top"',
                                          'text' => '<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) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

   $col ++;
   if ($col > 2) {
     $col = 0;
     $row ++;
   }
 }

 new contentBox($info_box_contents);
?>
<!-- new_products_eof //-->

 

to have 2 columns instead of 3, change

width="33%"

to

width="50%"

 

and

 

if ($col > 2) {

to

if ($col > 1) {

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted
Great thanks! I've another question.. How do I control the number of rows from this?

 

Thanks again!

 

admin -> max values -> New Products Module

 

how many items you want.

 

4 rows is 8 items :-)

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted

THANKS for your help, Monika! You've saved some of my brain cells.

 

I've been trying to achieve this effect which can be seen on this link..

 

http://demo.yourwebstore.net/oscommerce/OS06E00089/index.php

 

where there are lines in the New products main box, I can't figure out how it is done. I managed to add the tep_draw_separator in the products listing to have line separating the products. The price and the buy now is aligned horizontally too.

 

Do I use tep_draw separator for those lines too? The main page has codes that I don't understand how to fit that in. Do you know how it can be done too?

Posted
THANKS for your help, Monika! You've saved some of my brain cells.

 

I've been trying to achieve this effect which can be seen on this link..

 

http://demo.yourwebstore.net/oscommerce/OS06E00089/index.php

 

where there are lines in the New products main box, I can't figure out how it is done. I managed to add the tep_draw_separator in the products listing to have line separating the products. The price and the buy now is aligned horizontally too.

 

Do I use tep_draw separator for those lines too? The main page has codes that I don't understand how to fit that in. Do you know how it can be done too?

 

show me how close you got to that image, and I'll try to guide you through setting it up.

 

The upper and lower tep_draw_separator are added before and after your regular code in the "text" piece. Best would be to make the whole text piece a table with 3 cells, used full width for the upper line and in 3 parts for the price/divider (same sep but vertically) and the buy now button.

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...