I have load data from two different table "prod & size", in push.php all data from chosen product push into array.
My question is, how to push the data from "size" along with the "prod"?
I wonder if I merge those two arrays.
Prod.php
<table>
<tr>
<td style="vertical-align:top;">
<img src="<? echo $qprod['prod_img'] ?>">
</td>
<td>
<pre>
<? echo $qprod['prod_name'] ?><br />
Rp. <? echo $harga ?><br />
<? echo $qprod['prod_vendor'] ?><br />
<? echo $qprod['prod_desc'] ?><br />
<?
$qsize = mysql_query("SELECT * FROM a_size ORDER BY size_id ASC")or die("Error Select Size");
echo "Select Size : <select name=\"size_id\">";
while($rsize=mysql_fetch_array($qsize))
{
echo ("
<option value=$rsize[size_id]>$rsize[size_number]</option>
");
}
echo "</select>";
?>
</pre>
<center><a href="z_push.php?prod_id=<?=$qprod['prod_id']?>&action=add">Add To Cart</a></center>
</td>
</tr>
</table>
Push.php
<?
include "function.php";
connect();
session_start();
$prod_id = $_GET['prod_id'];
$action = $_GET['action'];
switch($action){
case "add":
$_SESSION['cart'][$prod_id]++;
break;
case "remove":
$_SESSION['cart'][$prod_id]--;
break;
case "empty":
break;
}
header("location:z_cart.php");
?>
Cart.php
<?
$prod_id = $_GET['prod_id'];
if(!$_SESSION['cart'])
{
echo "Cart Empty!";
}else{
foreach($_SESSION['cart'] as $prod_id => $q)
{
$prod = mysql_query("SELECT prod_name,prod_price FROM a_prod WHERE prod_id='$prod_id'");
if(mysql_num_rows($prod) > 0)
{
list($prod_name, $prod_price) = mysql_fetch_row($prod);
$subtotal = $prod_price * $q;
$total += $subtotal;
echo $prod_name." - ".$q." - $".$subtotal."<br>";
}
}
echo "<br>Total : $".$total;
}
?>