Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

I Need The Product List In This Fation But Don't Know How To Do It?


Guest

Recommended Posts

Posted

here is what I would like currently i have created new pages just to get the format i want but I wuld like all pages when viewing product to look the same.

 

here is what I'm looking for

 

this is the way I would like the format to look

 

 

 

<table border="7" width="550" cellspacing="4" cellpadding="0" >
<!-- MSTableType="layout" -->
<tr>
	<td width="360" bordercolor="#FFFFFF"><b>
	<font size="4" color="#FF0000" face="Tahoma"><p align="center"><u>
	<a href="product_info.php?products_id=30"> <font size="4" color="#FF0000" face="Tahoma">Education Reserved for Princes and Nobility</a></u></font></b></td></p>
	<td bordercolor="#FFFFFF" align="center" height="94" width="111">
	<p align="center">
	<img border="0" src="images/medieval%20night%20jim%20&%20gracie.jpg" width="111" height="92"></td>
</tr>
<tr>
	<td colspan="2" bordercolor="#FFFFFF" >    As far back as Alexander the Great, fatherly kings have secured 
	learned tutors to educate their princely sons.  Too often tutors only 
	educated the minds of their pupils.  Mentoring, a combination of 
	tutoring and discipleship, educated both mind AND heart.  <br>
    Jessica Hulcy, co-author of KONOS Curriculum and 
	homeschooling mom of 24 years, believes home schoolers have the rare 
	opportunity to employ the form of education once reserved for princes 
	and nobility, the expanded form of tutoring called mentoring to raise up 
	the next generation of princes and nobility to serve the one true King.<div align="right">
		<table border="1" width="13%" bordercolorlight="#FF6666" bordercolordark="#FF0000">
			<tr>
				<td>
				<p align="center"> <b><font face="Tahoma">$12.00</font></b></td>
			</tr>
		</table>
	</div>
	</td>
</tr>
</table>

<table border="0" width="550" cellspacing="0" cellpadding="0">
<tr>
	<td> </td>
</tr>
</table>

 

This is what I have in product_listing.php I hope this is where the info is put lol

 

<?php
/*
 $Id: product_listing.php,v 1.44 2003/06/09 22:49:59 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

 if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }

 $list_box_contents = array();

 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
  case 'PRODUCT_LIST_MODEL':
	$lc_text = TABLE_HEADING_MODEL;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_NAME':
	$lc_text = TABLE_HEADING_PRODUCTS;
	$lc_align = '';
	break;
// Products Description Hack begins
  case 'PRODUCT_LIST_DESCRIPTION':
	$lc_text = TABLE_LIST_DESCRIPTION;
	break;
// Products Description Hack ends
  case 'PRODUCT_LIST_MANUFACTURER':
	$lc_text = TABLE_HEADING_MANUFACTURER;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_PRICE':
	$lc_text = TABLE_HEADING_PRICE;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_QUANTITY':
	$lc_text = TABLE_HEADING_QUANTITY;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_WEIGHT':
	$lc_text = TABLE_HEADING_WEIGHT;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_IMAGE':
	$lc_text = TABLE_HEADING_IMAGE;
	$lc_align = 'center';
	break;
  case 'PRODUCT_LIST_BUY_NOW':
	$lc_text = TABLE_HEADING_BUY_NOW;
	$lc_align = 'center';
	break;
}

//	if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list
//	[$col] != 'PRODUCT_LIST_IMAGE') ) {
//	$lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, 
//	$lc_text);
//	}
//
//	$list_box_contents[0][] = array('align' => $lc_align,
//								   'params' => 'class="productListing-heading"',
//									'text' => ' ' . $lc_text . ' ');
//  }

// Products Description Hack begins
if ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW' &&
	$column_list[$col] != 'PRODUCT_LIST_IMAGE' &&
	$column_list[$col] != 'PRODUCT_LIST_DESCRIPTION')
  $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);

if ($column_list[$col] != 'PRODUCT_LIST_DESCRIPTION') {
  $list_box_contents[0][] = array('align' => $lc_align,
										 'params' => 'class="productListing-heading"',
										 'text'  => " " . $lc_text . " ");
}

 }
// Products Description Hack ends

 if ($listing_split->number_of_rows > 0) {
$rows = 0;
$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
  $rows++;

  if (($rows/2) == floor($rows/2)) {
	$list_box_contents[] = array('params' => 'class="productListing-even"');
  } else {
	$list_box_contents[] = array('params' => 'class="productListing-odd"');
  }

  $cur_row = sizeof($list_box_contents) - 1;

  for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
	$lc_align = '';
	// Products Description Hack begins
	$lc_params = '';
	// Products Description Hack ends

	switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
		$lc_align = '';
		$lc_text = ' ' . $listing['products_model'] . ' ';
		break;
	  case 'PRODUCT_LIST_NAME':
		$lc_align = '';
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> ';
		}
		break;
// Products Description Hack begins
	  case 'PRODUCT_LIST_DESCRIPTION':
		$lc_text = ' ' . osc_trunc_string(strip_tags($listing['products_description'], '<a><b><em><font><i><s><span><strong><sub><sup><u>'), PRODUCT_LIST_DESCRIPTION_LENGTH) . ' ';
		$col_to_span = sizeof($column_list)-1;
		if (PRODUCT_LIST_IMAGE > 0) {
		  $col_to_span -= 1;
		}
		$lc_params = 'colspan="' . $col_to_span . '" ';
		break;
	  // Products Description Hack ends
	  case 'PRODUCT_LIST_MANUFACTURER':
		$lc_align = '';
		$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
		break;
	  case 'PRODUCT_LIST_PRICE':
		$lc_align = 'right';
		if (tep_not_null($listing['specials_new_products_price'])) {
		  $lc_text = ' <s>' .  $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> ';
		} else {
		  $lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' ';
		}
		break;
	  case 'PRODUCT_LIST_QUANTITY':
		$lc_align = 'right';
		$lc_text = ' ' . $listing['products_quantity'] . ' ';
		break;
	  case 'PRODUCT_LIST_WEIGHT':
		$lc_align = 'right';
		$lc_text = ' ' . $listing['products_weight'] . ' ';
		break;
	  case 'PRODUCT_LIST_IMAGE':
		$lc_align = 'center';
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> ';
		// Products Description Hack begins
		if (PRODUCT_LIST_DESCRIPTION > 0) {
		  $lc_params = 'rowspan="2" ';
		}
		// Products Description Hack ends			
		}
		break;
	  case 'PRODUCT_LIST_BUY_NOW':
		$lc_align = 'center';
		$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';
		break;
	}

//		$list_box_contents[$cur_row][] = array('align' => $lc_align,
//											   'params' => 'class="productListing-data"',
//											   'text'  => $lc_text);
	// Products Description Hack begins
	$lc_params .= 'class="productListing-data"';
	if ($column_list[$col] == 'PRODUCT_LIST_DESCRIPTION') {
	  $list_box_contents[$cur_row][] = array('align' => $lc_align,
											 'params' => $lc_params,
											 'text' => $lc_text,
											 'desc_flag' => 'true');
	} else {
	  $list_box_contents[$cur_row][] = array('align' => $lc_align,
											 'params' => $lc_params,
											 'text'  => $lc_text);
	}
	// Products Description Hack ends
  }
}

new productListingBox($list_box_contents);
 } else {
$list_box_contents = array();

$list_box_contents[0] = array('params' => 'class="productListing-odd"');
$list_box_contents[0][] = array('params' => 'class="productListing-data"',
							   'text' => TEXT_NO_PRODUCTS);

new productListingBox($list_box_contents);
 }

 if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }
?>

Posted

Please Help me :'(

 

Yours truly

Pecanhouse

Archived

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

×
×
  • Create New...