I agree with Curt, use mySQL to get the sum of 'sess_itemsize' then
divide the result by size per disk to get quantity. So your function
should look something like this:
function cart_cdqty()
{
$query = "SELECT SUM(sess_itemsize) AS total_size
FROM sessions
WHERE sess_id = ".$_COOKIE['SID']."";
$result = mysql_query($query);
if($row = mysql_fetch_array($result))
{
$n = $row['total_size'];
$x = ceil( $n / 690.0 );
$cart_cdqty = array(
'quantity' => '$x',
'total_size' => '$n',
);
return $cart_cdqty;
} else {
return false;
}
}
Then all you do is call the function like this:
if(!$cdqty = cart_cdqty())
{
print 'no items found in your shopping cart';
} else {
print 'Total Size:' . $cdqty['quantity'] . '<BR>';
print 'Total CDs:' . $cdqty['total_size'] . 'MBs <BR>';
}
I have not tested this but it should work.
Ralph
-----Original Message-----
From: Cesar Aracena [mailto:[EMAIL PROTECTED]
Sent: Monday, August 18, 2003 8:54 PM
To: 'Ralph Guzman'; [EMAIL PROTECTED]
Subject: RE: [PHP] Delimiter WITHOUT lots of IF's
Importance: High
Sensitivity: Confidential
Ok. Here you have the entire function to see how many CD's the order
will contain:
function cart_cdqty()
{
$query = "SELECT * FROM sessions WHERE sess_sid =
".$_COOKIE['SID']."";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
$x = 0;
$n = 0;
for ($y = 0; $y < $num_rows; $y++)
{
$row = mysql_fetch_array($result);
$n = $n + $row[sess_itemsize];
}
if ($n > 0 AND $n <= 690.0) {
$x = 1;
} elseif ($n > 690.1 AND $n <= 1380.0) {
$x = 2;
} elseif ($n > 1380.1 AND $n <= 2070.0) {
$x = 3;
} elseif ($n > 2070.1 AND $n <= 2760.0) {
$x = 4;
} elseif ($n > 2760.1 AND $n <= 3450.0) {
$x = 5;
}
return $x;
}
Pretty long if someone wants to order 17MBs don't you agree?
Thanks for this,
Cesar Aracena
>
> No, that sounds about right.
>
> So your table should have the following fields:
>
> customer_session_id, item_id, quantity, final_price
>
> so then all you have to do is query this table looking for all items
in
> customers shopping cart.
>
> I am not quite sure how you are going about calculating orders in
> customer's basket. You said you wrote a function with multiple IF
> statements, can you show me the code for this function so that I can
get
> a better idea of what you are currently doing?
>
>
> -----Original Message-----
> From: Cesar Aracena [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 18, 2003 8:38 PM
> To: 'Ralph Guzman'; [EMAIL PROTECTED]
> Subject: RE: [PHP] Delimiter WITHOUT lots of IF's
> Importance: High
> Sensitivity: Confidential
>
> Using a cookie (I know, I know...) I plant a cookie in the visitor's
> browser when he opens the site with a random generated number which
> expires when the browser(s) is closed. With that SID, PHP stores the
> orders (one per line) into a "sessions" table in MySQL each with the
> itemID. Is it fine or am I too messy?
>
> TXS,
>
> Cesar Aracena
>
> >
> > How are you keeping track of items added being added to the shopping
> > cart?
> >
> > -----Original Message-----
> > From: Cesar Aracena [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 18, 2003 7:55 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Delimiter WITHOUT lots of IF's
> > Importance: High
> > Sensitivity: Confidential
> >
> > Hi all,
> >
> > I need to create an automatic process for visitors who are adding
> items
> > into a shopping cart, be able to see how many MBs and how many CDs
> will
> > the order have.
> >
> > >From this site, visitors will be able to choose one ore more
software
> > products from a list of hundreds. I want them to check the cart to
see
> > something like:
> >
> > Total size: 872,43 MBs
> > Total CDs: 2
> > Total price: $XXX,XX
> >
> > Now, I developed a decision function that works with a lot of IF
> > statements, but I only calculated a max o 6 CDs (690,00 MBs max. per
> > CD), but I want to be able to make this automatically... Can someone
> > help me with this?
> >
> > BTW, Using PHP 4+ and MySQL 3+.
> >
> > Thanks in advanced,
> >
> > Cesar Aracena
> > www.icaam.com.ar
> >
> > Note: The information inside this message and also in the attached
> files
> > might be confidential. If you are not the desired receptor or the
> person
> > responsible of delivering the message, we notify you that it's copy,
> > distribution, keep or illegal use of the information it has it's
> > prohibited. Therefore we ask you to notify the sender by replying
this
> > message immediately and then delete it from your computer.
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
