<h2>Big Apple Shopping Network</h2>

<?php session_start(); include("DADB.class.php"); $db=new DADB(); ?> <table border="1" width="100%" cellpadding=" 0" cellspacing="0"> <tr> <td>Code name</td> <td>Fruit name</td> <td>Fruit price</td> <td>Original Origin</td> <td>Shelves</td> <td>Inventory</td> <td></td> </tr> <?php $uid=$_SESSION ["uid"]; $sql="select * from fruit"; $arr=$db->Query($sql); foreach($arr as $v) { echo"<tr> <td>{ $v[0]}</td> // Retrieve the content we need from the database <td>{$v[1]}</td> <td>{$v[2]}< ;/td> <td>{$v[3]}</td> <td>{$v[4]}</td> <td>{$v[5]}</ td> <td><a href='add.php?ids={$v[0]}'>Add</a></td> //Shopping here is equivalent to adding to the shopping cart Functions </tr>"; } ?> <?php //This shows how many products there are in the shopping cart and the total price of the products $ann=array(); if(!empty($_SESSION["gwc "])) { $ann=$_SESSION["gwc"]; } $zhonglei = count($ann); $sum=0; foreach($ann as $k) { $sql1="select price from fruit where ids ='{$v[0]}'"; $danjia=$db->Query($sql1); foreach($danjia as $n) { $sum=$sum $n[0]*$k[1 ]; } } echo"The shopping cart contains <mark>{$zhonglei}</mark> products, the total price is <mark>{$sum}</mark>元"; ?> </table> <div> <a href="gouwuche.php" rel="external nofollow" rel="external nofollow" >View shopping cart</ a> <a href="main.php" rel="external nofollow" rel="external nofollow" >Browse products</a> <a href="zhanghu.php" rel="external nofollow" rel ="external nofollow" >View account</a> </div> </body>