OScommerce PHP help.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steven Kalcevich
    #1

    OScommerce PHP help.

    Hi all.

    I am working on finishing an oscommerce based site and need some help.
    One page is listing in 1 column 6 down, I wish to have a layout of 4
    across and 5 down. When there is more then 20 items you can press next
    to go to page 2 and so on...

    The page I am talking about is here
    404 Not Found
    http://www.philcos.com/catalog/products_new_week.php


    Below is the php file. Can anyone help me out here? I went through all
    the contributions and there is none like this to use. I also went
    through the forum and could not find anything also went through
    google!!! Please reply to group or offlist at stevenATciscoki d.net
    thanks!

    ----------------

    <?php
    /*
    $Id: products_new.ph p,v 1.27 2003/06/09 22:35:33 hpdl Exp $

    osCommerce, Open Source E-Commerce Solutions
    FREE shopping cart and open source eCommerce platform - Start selling online with osCommerce
    http://www.oscommerce.com
    FREE Shopping cart osCommerce to start selling online. Accelerate your business endlessly by adding apps and custom development. Open source eCommerce platform.


    Copyright (c) 2003 osCommerce

    Released under the GNU General Public License
    */
    require('includ es/application_top .php');

    require(DIR_WS_ LANGUAGES . $language . '/' . FILENAME_PRODUC TS_NEW);

    $breadcrumb->add(NAVBAR_TIT LE, tep_href_link(F ILENAME_PRODUCT S_NEW));
    ?>
    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html <?php echo HTML_PARAMS; ?>>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo
    CHARSET; ?>">
    <title><?php echo TITLE; ?></title>
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER :
    HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet " type="text/css" href="styleshee t.css">
    <link rel="stylesheet " type="text/css" media="print" href="print.css ">
    </head>
    <body marginwidth="0" marginheight="0 " topmargin="0" bottommargin="0 "
    leftmargin="0" rightmargin="0" >
    <!-- header //-->
    <?php require(DIR_WS_ INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->

    <!-- body //-->
    <table border="0" width="100%" cellspacing="1" cellpadding="0" >
    <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><t able border="0"
    width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2" >
    <!-- left_navigation //-->
    <?php require(DIR_WS_ INCLUDES . 'column_left.ph p'); ?>
    <!-- left_navigation _eof //-->
    </table></td>
    <!-- body_text //-->


    <td width="100%" valign="top"><t able border="0" width="100%"
    cellspacing="0" cellpadding="0" >

    <tr>
    <td><?php echo tep_draw_separa tor('pixel_tran s.gif', '100%',
    '10'); ?></td>
    </tr>
    <?php


    $products_new_a rray = array();

    $products_new_q uery_raw = "select p.products_id, pd.products_nam e,
    p.products_imag e, p.products_pric e, p.products_date _added,
    p.products_mode l, m.manufacturers _name from " . TABLE_PRODUCTS . " p
    left join " . TABLE_MANUFACTU RERS . " m on (p.manufacturer s_id =
    m.manufacturers _id), " . TABLE_PRODUCTS_ DESCRIPTION . " pd where
    p.products_stat us = '1' and p.products_id = pd.products_id and
    TO_DAYS(NOW()) - TO_DAYS(p.produ cts_date_added) < '" . '7' . "' and
    pd.language_id = '" . (int)$languages _id . "' order by pd.products_nam e
    ASC, pd.products_nam e";
    $products_new_s plit = new splitPageResult s($products_new _query_raw,
    6);

    if (($products_new _split->number_of_ro ws > 0) &&
    ((PREV_NEXT_BAR _LOCATION == '1') || (PREV_NEXT_BAR_ LOCATION == '3'))) {
    ?>


    <tr>
    <td><table border="0" width="100%" cellspacing="0"
    cellpadding="2" >
    <tr>
    <td class="smallTex t"><?php echo
    $products_new_s plit->display_count( TEXT_DISPLAY_NU MBER_OF_PRODUCT S_NEW);
    ?></td>
    <td align="right" class="smallTex t"><?php echo
    TEXT_RESULT_PAG E . ' ' .
    $products_new_s plit->display_links( MAX_DISPLAY_PAG E_LINKS,
    tep_get_all_get _params(array(' page', 'info', 'x', 'y'))); ?></td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td><?php echo tep_draw_separa tor('pixel_tran s.gif', '100%',
    '10'); ?></td>
    </tr>
    <?php
    }
    ?>
    <tr>
    <td><table border="0" width="100%" cellspacing="0"
    cellpadding="2" >
    <?php
    if ($products_new_ split->number_of_ro ws > 0) {
    $products_new_q uery = tep_db_query($p roducts_new_spl it->sql_query);
    while ($products_new = tep_db_fetch_ar ray($products_n ew_query)) {
    if ($new_price =
    tep_get_product s_special_price ($products_new['products_id'])) {
    $products_price = '<s>' .
    $currencies->display_price( $products_new['products_price '],
    tep_get_tax_rat e($products_new['products_tax_c lass_id'])) . '</s> <span
    class="productS pecialPrice">' . $currencies->display_price( $new_price,
    tep_get_tax_rat e($products_new['products_tax_c lass_id'])) . '</span>';
    } else {
    $products_price =
    $currencies->display_price( $products_new['products_price '],
    tep_get_tax_rat e($products_new['products_tax_c lass_id']));
    }
    // added for New Product Icon contribution
    // convert times to unix timestamp for comparison
    // 2592000 = 30 days in the unix timestamp format
    if ( ($today_time -
    strtotime($prod ucts_new['products_date_ added']) ) < 2592000) {
    $products_new['products_name'] .= '&nbsp' .
    tep_image_butto n('icon_newarri val.gif', TEXT_ICON_NEW_P RODUCT);
    }
    // end addition New Product Icon contribution
    ?>
    <tr>
    <td width="<?php echo SMALL_IMAGE_WID TH; ?>"
    valign="left" class="main"><? php echo '<a href="' .
    tep_href_link(F ILENAME_PRODUCT _INFO, 'products_id=' .
    $products_new['products_id']) . '">' . tep_image(DIR_W S_IMAGES .
    $products_new['products_image '], $products_new['products_name'],
    SMALL_IMAGE_WID TH, SMALL_IMAGE_HEI GHT) . '</a>'; ?></td>
    <td valign="top"
    class="main"><? php echo '<a href="' .
    tep_href_link(F ILENAME_PRODUCT _INFO, 'products_id=' .
    $products_new['products_id']) . '"><b>' .
    $products_new['products_model '] . ' ' . $products_new['']
    ..'</b></a><br>' . ' ' . $products_new['manufacturers_ name'] . '<br>' .
    ' ' . $products_price ; ?></td>
    </tr>
    <tr>
    <td colspüan="3"><? php echo
    tep_draw_separa tor('pixel_tran s.gif', '100%', '10'); ?></td>
    </tr>
    <?php
    }
    } else {
    ?>
    <tr>
    <td class="main"><? php echo TEXT_NO_NEW_PRO DUCTS; ?></td>
    </tr>
    <tr>
    <td><?php echo tep_draw_separa tor('pixel_tran s.gif',
    '100%', '10'); ?></td>
    </tr>
    <?php
    }
    ?>
    </table></td>
    </tr>
    <?php

    if (($products_new _split->number_of_ro ws > 0) &&
    ((PREV_NEXT_BAR _LOCATION == '2') || (PREV_NEXT_BAR_ LOCATION == '3'))) {
    ?>
    <tr>
    <td><table border="0" width="100%" cellspacing="0"
    cellpadding="2" >
    <tr>
    <td class="smallTex t"><?php echo
    $products_new_s plit->display_count( TEXT_DISPLAY_NU MBER_OF_PRODUCT S_NEW);
    ?></td>
    <td align="right" class="smallTex t"><?php echo
    TEXT_RESULT_PAG E . ' ' .
    $products_new_s plit->display_links( MAX_DISPLAY_PAG E_LINKS,
    tep_get_all_get _params(array(' page', 'info', 'x', 'y'))); ?></td>
    </tr>
    </table></td>
    </tr>
    <?php
    }
    ?>
    </table></td>
    <!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><t able border="0"
    width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2" >
    <!-- right_navigatio n //-->
    <?php require(DIR_WS_ INCLUDES . 'column_right.p hp'); ?>
    <!-- right_navigatio n_eof //-->
    </table></td>
    </tr>
    </table>
    <!-- body_eof //-->

    <!-- footer //-->
    <?php require(DIR_WS_ INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br>
    </body>
    </html>
    <?php require(DIR_WS_ INCLUDES . 'application_bo ttom.php'); ?>




    -----------

    Tags: None
    • Antò LuZombi
      #2
      Re: OScommerce PHP help.

      In data 16 Nov 2005 07:42:53 -0800, Steven Kalcevich ha scritto:
      [color=blue]
      > Hi all.[/color]

      hi steven
      [color=blue]
      > I am working on finishing an oscommerce based site and need some help.
      > One page is listing in 1 column 6 down, I wish to have a layout of 4
      > across and 5 down. When there is more then 20 items you can press next
      > to go to page 2 and so on...[/color]

      [cut]
      [color=blue]
      > $products_new_s plit = new splitPageResult s($products_new _query_raw,
      > 6);[/color]

      try to change 6 with 4 in this code line

        Comment

        • Antò LuZombi
          #3
          Re: OScommerce PHP help.

          In data Wed, 16 Nov 2005 17:32:50 +0100, Antò LuZombi ha scritto:
          [color=blue]
          > In data 16 Nov 2005 07:42:53 -0800, Steven Kalcevich ha scritto:
          >[color=green]
          >> Hi all.[/color]
          >
          > hi steven
          >[color=green]
          >> I am working on finishing an oscommerce based site and need some help.
          >> One page is listing in 1 column 6 down, I wish to have a layout of 4
          >> across and 5 down. When there is more then 20 items you can press next
          >> to go to page 2 and so on...[/color]
          >
          > [cut]
          >[color=green]
          >> $products_new_s plit = new splitPageResult s($products_new _query_raw,
          >> 6);[/color]
          >
          > try to change 6 with 4 in this code line[/color]

          Sorry maybe i don't understand well, however, IMHO, is the class
          splitPageResult s which design the layout

            Comment

            • Steven Kalcevich
              #4
              Re: OScommerce PHP help.

              HI there,

              I tried that and now its listed 4 down. I am not sure how to make it go
              across 4 then go down and go 4 across again.

                Comment

                • Steven Kalcevich
                  #5
                  Re: OScommerce PHP help.

                  I am going to play around splitPageResult s with that then thanks

                    Comment

                    • Webmontreal.com
                      #6
                      Re: OScommerce PHP help.

                      reduce the number of items per page in the admin configuration.

                      good luck

                      nick

                        Comment

                        • Steven Kalcevich
                          #7
                          Re: OScommerce PHP help.

                          I found out via google someone had a page like it I just modified it
                          here it is if anyone wants to know!

                          ---

                          actually i found a fix not there but via google search. belows the code
                          if anyone googles this in the future!

                          ----

                          <?php
                          /*
                          $Id: products_new.ph p,v 1.27 2003/06/09 22:35:33 hpdl Exp $

                          osCommerce, Open Source E-Commerce Solutions
                          FREE shopping cart and open source eCommerce platform - Start selling online with osCommerce
                          http://www.oscommerce.com
                          FREE Shopping cart osCommerce to start selling online. Accelerate your business endlessly by adding apps and custom development. Open source eCommerce platform.


                          Copyright (c) 2003 osCommerce

                          Released under the GNU General Public License
                          */

                          require('includ es/application_top .php');

                          require(DIR_WS_ LANGUAGES . $language . '/' . FILENAME_PRODUC TS_NEW);

                          $breadcrumb->add(NAVBAR_TIT LE, tep_href_link(F ILENAME_PRODUCT S_NEW));
                          ?>
                          <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
                          <html <?php echo HTML_PARAMS; ?>>
                          <head>
                          <link rel="stylesheet " type="text/css" href="styleshee t.css">
                          <link rel="stylesheet " type="text/css" media="print" href="print.css ">
                          <meta http-equiv="Content-Type" content="text/html; charset=<?php echo
                          CHARSET; ?>">
                          <title><?php echo TITLE; ?></title>
                          <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER :
                          HTTP_SERVER) . DIR_WS_CATALOG; ?>">
                          </head>
                          <body marginwidth="0" marginheight="0 " topmargin="0" bottommargin="0 "
                          leftmargin="0" rightmargin="0" >
                          <table align="left" width="805" height="100%" cellpadding="0"
                          cellspacing="0" >
                          <tr>
                          <td align="center" valign="top">
                          <!-- header //-->
                          <?php require(DIR_WS_ INCLUDES . 'header.php'); ?>
                          <!-- header_eof //-->
                          <!-- body //-->
                          <img src="../gfx/x.gif" width="1" height="3"><br>
                          <table border="0" width="100%" cellspacing="3" cellpadding="0"
                          align="left">
                          <tr>
                          <td width="<?php echo BOX_WIDTH; ?>" valign="top"><t able border="0"
                          width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2" >
                          <!-- left_navigation //-->
                          <?php require(DIR_WS_ INCLUDES . 'column_left.ph p'); ?>
                          <!-- left_navigation _eof //-->
                          </table></td>
                          <td width="5"><img src="../gfx/x.gif" width="5" height="1"></td>
                          <!-- body_text //-->
                          <td width="100%" valign="top"><t able border="0" width="100%"
                          cellspacing="0" cellpadding="0" >
                          <tr>
                          <td>
                          <?php
                          // create column list
                          $define_list = array('PRODUCT_ LIST_NAME' => PRODUCT_LIST_NA ME,
                          'PRODUCT_LIST_M ANUFACTURER' =>
                          PRODUCT_LIST_MA NUFACTURER,
                          'PRODUCT_LIST_P RICE' => PRODUCT_LIST_PR ICE,
                          'PRODUCT_LIST_M ODEL' => PRODUCT_LIST_MO DEL,
                          'PRODUCT_LIST_I MAGE' => PRODUCT_LIST_IM AGE);



                          asort($define_l ist);

                          $column_list = array();
                          reset($define_l ist);
                          while (list($column, $value) = each($define_li st)) {
                          if ($value) $column_list[] = $column;
                          }

                          $select_column_ list = '';

                          for ($col=0, $n=sizeof($colu mn_list); $col<$n; $col++) {
                          if ( ($column_list[$col] == 'PRODUCT_LIST_B UY_NOW') ||
                          ($column_list[$col] == 'PRODUCT_LIST_N AME') || ($column_list[$col] ==
                          'PRODUCT_LIST_P RICE') ) {
                          continue;
                          }
                          }
                          $listing_sql = "select p.products_id, pd.products_nam e,
                          p.products_imag e, p.products_pric e, p.products_date _added,
                          p.products_mode l, m.manufacturers _name from " . TABLE_PRODUCTS . " p
                          left join " . TABLE_MANUFACTU RERS . " m on (p.manufacturer s_id =
                          m.manufacturers _id), " . TABLE_PRODUCTS_ DESCRIPTION . " pd where
                          p.products_stat us = '1' and p.products_id = pd.products_id and
                          TO_DAYS(NOW()) - TO_DAYS(p.produ cts_date_added) < '" . '7' . "' and
                          pd.language_id = '" . (int)$languages _id . "' order by pd.products_nam e
                          ASC, m.manufacturers _name";
                          //$listing_sql = "select p.products_id, pd.products_nam e,
                          pd.products_des cription, p.products_imag e, p.products_pric e,
                          IF(s.status, s.specials_new_ products_price, NULL) as
                          specials_new_pr oducts_price, p.products_date _added,
                          m.manufacturers _name from " . TABLE_PRODUCTS . " p left join " .
                          TABLE_MANUFACTU RERS . " m on p.manufacturers _id = m.manufacturers _id
                          left join " . TABLE_PRODUCTS_ DESCRIPTION . " pd on p.products_id =
                          pd.products_id and pd.language_id = '" . $languages_id . "' left join "
                          .. TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by
                          pd.products_nam e ASC, pd.products_nam e";
                          include(DIR_WS_ MODULES . FILENAME_PRODUC T_LISTING_COL);
                          ?>
                          </td>
                          </tr>
                          </table></td>
                          </tr>
                          <?php
                          if (($products_new _split->number_of_ro ws > 0) &&
                          ((PREV_NEXT_BAR _LOCATION == '2') || (PREV_NEXT_BAR_ LOCATION == '3'))) {
                          ?>
                          <tr>
                          <td><table border="0" width="100%" cellspacing="0"
                          cellpadding="2" >
                          <tr>
                          <td class="smallTex t"><?php echo
                          $products_new_s plit->display_count( TEXT_DISPLAY_NU MBER_OF_PRODUCT S_NEW);
                          ?></td>
                          <td align="left" class="smallTex t"><?php echo
                          TEXT_RESULT_PAG E . ' ' .
                          $products_new_s plit->display_links( MAX_DISPLAY_PAG E_LINKS,
                          tep_get_all_get _params(array(' page', 'info', 'x', 'y'))); ?></td>
                          </tr>
                          </table></td>
                          <?php
                          }
                          ?>
                          <!-- body_text_eof //-->
                          </tr>
                          </table>
                          <!-- body_eof //-->
                          </td>
                          <td align="right" width="1" valign="top"
                          background="../gfx/line.gif"><img src="../gfx/x.gif" width="1"
                          height="1"></td>
                          </tr></table>
                          <br>
                          </body>
                          </html>
                          <?php require(DIR_WS_ INCLUDES . 'application_bo ttom.php'); ?>

                          --

                          cheers!!!!

                          Regards,

                          Steven Kalcevich

                            Comment

                            Previous template Next
                            Working...