how to make this?

itworks

i have this function that shows the items in a shopping cart but it only shows the unity price.

how to make it deliver the subtotal of every item (multiply price(preco) by quantity(qte)) and also how to show the total (the sum of all the subtotals).

here's the function (if you don't understand something i'll translate it to english):

// função que mostra os items existentes no carrinho de compras do utilizador
        function listaCarrinho($login_utilizador) {
            $sql = "SELECT * FROM carrinho WHERE email='$login_utilizador'";
            $rs=$this->bd->executarSQL($sql);

		echo "<tr bgcolor=\"#FFFFFF\">";
		$n=0;
		while(mysql_fetch_row($rs)) {
				echo "<td bgcolor=\"#FFFFFF\"><a href=\"index.php?pagina=alterar
&id=".mysql_result($rs, $n, "id")."&tipo=".mysql_result($rs, $n, "tipo")."
&modelo=".mysql_result($rs, $n, "modelo")."
&cod=".mysql_result($rs, $n, "cod")."&preco=".mysql_result($rs, $n, "preco")."
&qte=".mysql_result($rs, $n, "qte")."\">
<img src=\"imagens/seta.gif\" border=\"0\" width=\"12\" height=\"10\"></td>
<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "qte")."</b><td bgcolor=\"#FFFFFF\">
".mysql_result($rs, $n, "cod")."</b></td>
<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "tipo")."</td>
<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "modelo")."</td>
<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "preco")."€</td>";
					echo "</tr>";
					$n++;
			}
			echo "</table>";
		}

thanks in advance.

itworks

anyone please?

itworks

ok, just forget it, it must be impossible.

thanks anyway!

drag0n

Im a newbie, but I'll try to get this, sorry if im wrong 🙂.
If you want the preco "price multiplied by quantity", you should do this:

$a = preco;
$b = qte;
$result = $a*$b;
echo "$result";

the result should totally display your total price. I might be off alot here, so tell me what you mean becuase I am a newbie. And if you meant for subtotal as after tax, tou can do this:

$tax = 0.10 //You can use whatever you want as the tax rate.
$subtotal = $result*(1+tax);
echo "$result";

Im sorry if this is way off =)

ednark

how to make it deliver the subtotal of every item (multiply price(preco) by quantity(qte)) and also how to show the total (the sum of all the subtotals).

ok simple problem for thinking in code...

you have $subtotal - a variable that need to get a new value with each item you look at

you have $total - a varibale that needs to up be updated with each item you look at, but remember what it had before

you need $total to be kept outside the loop
and $subtotal to be kept inside the loop
each loop recalculculate the $subtotal as drag0n suggests
at the end of each loop add $subtotal to $total...

at the end of your loop, total will retain the entire total, and subtotal will have taken on each subtotal in the list

make sense?

drag0n

so I was way off?

itworks

i'm not sure i understand what you say.

shouldn't this be in the query?

$sql = "SELECT * FROM carrinho WHERE email='$login_utilizador'";

shouldn't i use something like SUM() or other thing ?
i really haven't got a clue.

sorry for the trouble but could you be more specific, a simple example or something?

thanks in advance.

drag0n

? I thought you wanted to Total up all the money and then Subtotal it with tax?

itworks

i have this table in the database that stores the items added (like a shopping cart).

this is the table

++++++++++++++++++++++++++++++++++++++++++++++++
+  email     +  cod  +   qty  +  type   +  model      + price +  id +
++++++++++++++++++++++++++++++++++++++++++++++++
+bla@bla.com + r0315 +   5    + memory  + rimm 256mb  + 80,00 +  1  +
++++++++++++++++++++++++++++++++++++++++++++++++

this is an example of one entry in that table, now in the function that shows the items in the users shopping cart i want to show the "cod", "qty", "type", "model" and "price". this price i don't want it to be 80,00 i want it to be 400,00 'cause it's 80,00 multiplied by 5 of quantity.

then at the end of the table with the items in the shopping cart i want a sum of all those multiplications of each item.

the function i use to show the items in the table is in my first post.

how to implement this in that code?

drag0n

first if I were you, Id add a table to the db called "Subtotal" if you dunt have that already. That should store the subtotal of all the items Qty*Price. Now with that in Mind, you can make the script. You want to Display the total number of items ordered? And then the subtotal(Price multiplied by quantity) I may be off now, so tell me if this is what you wanted, =)

drag0n

also i would change the table(Price) to a name that means the single price of an item, that way it is more clear to you when u code. BTW, if you are a web developer, where do you get the graphics for your site? Ive been asking everyone that, lol!

itworks

i know that this can be done with the table i have just in the query, i don't need to create a table just for that, i just don't know how to make this query.

drag0n

o, sorry than im all out, Im just a newbie, good luck

itworks

it just came to my mind that maybe this can be done in the code part where i echo the results of the query, in the field where i display the price,

<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "preco")."€</td>"

maybe here i just multiply the result of qte by the result of price, i'm i in the right track? how to do it?

thanks

ednark

drag0n - you were dead on in calculating the subtotal, i don't know about needing an extra table though

for right now just worry about your php

start a new file... and just simulate your databse calls

make an array like

$db_results = array();
$db_results[] = array(
    'column1' => 'value 1',
    'column2' => 'value 2',
    'column3' => 'value 3',
    'column4' => 'value 4'
);
$db_results[] = array(
    'column1' => 'value 1',
    'column2' => 'value 2',
    'column3' => 'value 3',
    'column4' => 'value 4'
);
[code]

use that to step to create your loops and do you calculations... once you have that working... go back in and stick your mysql calls into it  and you should do fine

itworks

i solved the subtotal of each item problem with this:
(not so far from what you told me😃 )

function listaCarrinho($login_utilizador) {
            $sql = "SELECT * FROM carrinho WHERE email='$login_utilizador' ORDER BY id";
            $rs=$this->bd->executarSQL($sql);

		echo "<tr bgcolor=\"#FFFFFF\">";
		$n=0;
		while(mysql_fetch_row($rs)) {
		$subtotal = mysql_result($rs, $n, "preco") * mysql_result($rs, $n, "qte");
				echo "<td bgcolor=\"#FFFFFF\"><a href=\"index.php?pagina=alterar
					&id=".mysql_result($rs, $n, "id")."&tipo=".mysql_result($rs, $n, "tipo")."
					&modelo=".mysql_result($rs, $n, "modelo")."&cod=".mysql_result($rs, $n, "cod")."
					&preco=".mysql_result($rs, $n, "preco")."&qte=".mysql_result($rs, $n, "qte")."\">
					<img src=\"imagens/seta.gif\" border=\"0\" width=\"12\" height=\"10\"></td>
					<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "qte")."</b>
					<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "cod")."</b></td>
					<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "tipo")."</td>
					<td bgcolor=\"#FFFFFF\">".mysql_result($rs, $n, "modelo")."</td>
					<td bgcolor=\"#FFFFFF\" align=\"center\">$subtotal €</td>";
				echo "</tr>";
				$n++;
		}
		echo "</table>";
	}

now this is more complicated i think.

i need a row in the end of the table that shows the sum os all the subtotals.

any thoughts?!

itworks

anyone please?!