custom inventory look

i need to have a page that shows the inventory of one specific item but in a very large font

ie an ezpage with the sql query embedded that just i code the html around it

anyone point me in the direction of how to structure the sql query :)

a google search of "sql queries in php" yields this.

Is this your only product?

re:only product - no but only have a few and its the main product

Is this specifically something NOT contained in the product description?

no its just the products inventory

the idea is basically to have an ezpage showing a "counter" of how much stock is left on this one item - the counter being the inventory level with the font size or form style being very large

The "counter" is already there by default as the quantity. You could have a specific css file for that product's page to change the quantity font when that page is called.

The CSS_read_me.txt in the includes/templates/template_default/css folder tells how you would name the special stylesheet.

i´´m not worried about the size, i´´m trying to get the coding into a seperate, effectively static, page - ie an ezpage

ie something like this (very basic) that i can put into the contents of an ezpage

"Hurry we only have:

units of this product left"

By search there is a topic about this, please refer to it.
PHP inside ezpages

.

thanks but i still dont know how to pull the inventory data from the db and display it ;)

my product id is 1, but when i do this i get the sold out button but it definitly has stock - what am i missing ? :)

i think i have to define the product id somewhere to begin with ?

<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
  // do nothing
} else {
?>
            <?php
    $display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['1'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['1']) . '</p>' : '');
            if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
              // hide the quantity box and default to 1
              $the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('1', (int)$_GET['1']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            } else {
              // show the quantity box
    $the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['1'])) . '" maxlength="6" size="4" /><br />' . zen_get_products_quantity_min_units_display((int)$_GET['1']) . '<br />' . zen_draw_hidden_field('1', (int)$_GET['1']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            }
    $display_button = zen_get_buy_now_button($_GET['1'], $the_button);
  ?>
  <?php if ($display_qty != '' or $display_button != '') { ?>
    <div id="cartAdd">
    <?php
      echo $display_qty;
      echo $display_button;
            ?>
          </div>
  <?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<!--eof Add to Cart Box-->

ive nearly sussed it - ive added &product_id=1 to the end of the link and put product_id back in the code but i only get the add to cart button and not the quantity or buy now button!

arrgggghhhh

<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
  // do nothing
} else {
?>
            <?php
    $display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');
            if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
              // hide the quantity box and default to 1
              $the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            } else {
              // show the quantity box
    $the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" /><br />' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '<br />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            }
    $display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);
  ?>
  <?php if ($display_qty != '' or $display_button != '') { ?>
    <div align=center">
    <br /><br />
<table width="477" border="0" align=center cellpadding="4" cellspacing="0" bgcolor="#0000CC">
<tr>
<td class="whitetext">
<p align="justify">Hosting slots available: <?php
      echo $display_qty;
echo;
      echo $display_button;
            ?>
          </div>
  <?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<!--eof Add to Cart Box--></p></td>
</tr>
</table>

need this quite urgently now - ive put a commercial help request in as well

thanks

bump a

I'm way behind the power curve here with security updates for Joomla now. Let me know the specific id of the product in question and I'll see what I can do later today.

product id is 1 ;) - honestly..

anything you can do would be great :)

(i used joomla on another site about 6 months ago and was able to hack something similar hence me wanting to do the same here but i had time then... )

Here's a copy of a file that will do what you want once you fill in the requirements. Adjust the text as you like. Add css where needed. Then you will need to call it from wherever in the site you want with an include.

<?php

  // Connect to the database server
    $dbcnx = @mysql_connect("###.###.###.###",
           "$$$$$$$", "%%%%%%%%%");
  if (!$dbcnx) {
    echo( "<P>Unable to connect to the @@@@@@" .
          "database server at this time.</P>" );
    exit();
  }

  // Select the @@@@@@@ database
  if (! @mysql_select_db("^^^^^^^") ) {
    echo( "<P>Unable to locate the @@@@@@@ " .
          "database at this time.</P>" );
    exit();
  }

?><P> Here is where you put the text you want associated with the call out.  FOR INFO--The ###.###.###.### is the host of your database(could be localhost, an IP address, etc).  The $$$$$$ is the database username.  The %%%%%%%% is the database password.  The @@@@@@ is the site name. The ^^^^^^^^ is the name of your database</P><BLOCKQUOTE>

<?php
   // Request the quantity of the product
  $result = mysql_query(
            "SELECT products_quantity  FROM products WHERE products_id=1");

  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }


  // Display the quantity in a paragraph
  while ( $row = mysql_fetch_array($result) ) {
    echo(
	"<P>Better Hurry\! We only have <strong>" . $row["products_quantity"] . " left\!</strong></P>");
  }
?>

Sorry for the delay. 10G irons in the fire.

And... I'm sure there will be other suggestions.:D

wot a star :)

its friday night and have been at this site for 14 days straight so i´´m taking a bit of a siesta but will let you know tomorrow :)

top man

i get this error :(

Error performing query: Table 'sling.products' doesn't exist

IF sling is your table prefix does it have an underscore instead of a period? Check with phpmyadmin to verify the table name.