salve ragazzi, intanto mi scuso per il titolo del post, ma non sapevo che nome dare, comunque, io ho un sito ecommerce, ho apportato qualche modifica, solo che adesso avrei bisogno del vostro aiuto come potete vedere dalla foto a sinistra c'è il menu (browser by categories ) e a destra categories come potete vedere dalla foto, sotto categories c'è il nome del'oggetto selezionato quello che vorrei fare io è far comparire il nome dell'oggetto selezionato al posto di categories, sperando di essermi spiegato e aspettando gentilmente un vostro aiuto vi parte dei 2 codici:
Index.php
<?php
require('includes/application_top.php');
$category_depth = 'top';
if (isset($cPath) && tep_not_null($cPath)) {
$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
$cateqories_products = tep_db_fetch_array($categories_products_query);
if ($cateqories_products['total'] > 0) {
$category_depth = 'products'; // display products
} else {
$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
$category_parent = tep_db_fetch_array($category_parent_query);
if ($category_parent['total'] > 0) {
$category_depth = 'nested'; // navigate through the categories
} else {
$category_depth = 'products'; // category has no products, but display the 'no products' message
}
}
}
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
da quello che ho potuto capire, il nome dell'oggetto selezionato è categories_id
mentre il secondo codice è:
product_listing.php
<?php
$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="630" cellspacing="0" cellpadding="0">
<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;
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 . '');
}
if ($listing_split->number_of_rows > 0) {
$rows = 0;
$column = 0;
echo '
<table cellspacing=0 cellpadding=0 width=626 align=center>
<tr><td background=images/m22.gif width=626 height=29 valign=top>
<table cellspacing=0 cellpadding=0>
<tr><td height=8></td></tr>
<tr><td width=25></td><td class=ch6>categories</td></tr>
</table>
</td></tr>
<tr><td valign=top class=ch7>
<table cellspacing=0 cellpadding=0 width=626 border=0 align=center>
<tr><td height=18></td></tr>
<tr><td colspan=3 class=ch13> <u>'.$breadcrumb->trail(' » ').'</u></td></tr>
<tr><td height=15></td></tr>
<tr>
';
$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
$product_contents = array();
$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 = '';
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 = '' . $listing['products_name'] . '';
} else {
$lc_text = '' . $listing['products_name'] . '';
}
break;
case 'PRODUCT_LIST_MANUFACTURER':
$lc_align = '';
$lc_text = '' . $listing['manufacturers_name'] . '';
break;
case 'PRODUCT_LIST_PRICE':
$lc_align = 'right';
if (tep_not_null($listing['specials_new_products_price'])) {
$lc_text = '<span class=ch8 style="color:#7F7F7F;font-size:11px"><s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s></span>
<span class=ch8>' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
} else {
$lc_text = '<span class=ch8>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
}
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 = '' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '';
} else {
$lc_text = '' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '';
}
break;
case 'PRODUCT_LIST_BUY_NOW':
$lc_align = 'center';
$lc_text = '' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '';
break;
}
$list_box_contents[$cur_row][] = array('align' => $lc_align,
'params' => 'class="productListing-data"',
'text' => $lc_text);
$product_contents[] = $lc_text;
}
$product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)1 . "'");
$product = tep_db_fetch_array($product_query);
$new_products['products_description'] = $product['products_description'];
echo '
<td width=208 valign=top align=center>
<table cellspacing=0 cellpadding=0 width=200 align=center>
<tr><td width=90 align=center valign=top>'.$product_contents[0].'</td>
<td valign=top>
<table cellspacing=0 border=0 cellpadding=0>
<tr><td height=55 valign=middle>'.$product_contents[1].'</td></tr>
<tr><td height=30 valign=middle class=ch10>'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 25)).' ...</td></tr>
<tr><td height=0></td></tr>
<tr><td height=35 valign=middle><span class=ch11>price:</span> <span class=ch8>'.$product_contents[2].'</span> </td></tr>
</table>
</td>
</tr>
<tr><td height=2></td></tr>
<tr><td colspan=2 align=right>' . tep_image_button('small_view.gif') . '' . tep_image_button('button_in_cart.gif') . ' </td></tr>
</table>
</td>
';
$column ++;
if ($column >= 2) {
$rows ++;
$column = 0;
echo '
</tr>
<tr><td height=5></td></tr>
<tr><td colspan=3 valign=top>
<table cellspacing=0 cellpadding=0>
<tr><td width=200 height=1 background=images/m29.gif></td><td width=14></td> <td width=200 height=1 background=images/m29.gif></td></tr>
</table>
</td></tr>
<tr><td height=5></td></tr>
<tr>
';
} else echo '<td background=images/m09.gif width=1></td>';
}
echo '
</tr>
</table>
</td></tr>
<tr><td><img src=images/m30.gif width=627 height=7></td></tr>
</table>
';
//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);
echo '<div class=PageHeading>Categories</div>';
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 height=20></td></tr>
<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
}
?>
e se non sbaglio la stringa che devo modificare su product_listing.php è :
echo '<div class=PageHeading>Categories</div>';
a questo codice come faccio ad aggiungere categories_id senza ( ovvero nome prodotto) al posto della scritta categories? grazie
Rispondi quotando