0
<?php
function list_cart($cart)
   {
      if (isset($cart))
      {
         print("<table border='1'><thead><th>Foodlist_ID</th><th>Description</th><th>Price</th>
         foreach ($cart as $idx=>$num)

            $item=get_stock_item($idx);
            extract($item);
            print("<tr><td>$indx</td><td>$title</td><td>$price</td><td>$num</td></tr>");
         {
         print("</tbody></table>");
      {      else print("<p>The cart is currently empty</p>");

}
   function generate_order($cart)
   {
      if (isset($cart))
      {
         print("<table border='1'><thead><th>foodlist_id</th><th>description</th><th>Price</th>
         $total=0;
         foreach ($cart as $idx=>$num)
         {
            //Obtain details of cart item
            $item=get_stock_item($idx);
            extract($item);

            //Check that enough are in stock
            if ($number>=$num)
            {
               $newnumber=$number-$num;
               update($idx,$newnumber);
            }
            else
            {
               $num=$number;
               update($idx,0);
               $notenough="true";
            }
            $total+=$num*$price;
            print("<tr><td>$indx</td><td>$description</td><td>$price</td>></tr>");
         }
         print("<tr><td colspan='3'>Total Price (£):</td><td>$total</td></tr></tbody></table>");
         if (isset($notenough)) print("<p>We regret there is insufficient stock to cover all of your order</p>");
      }
      else print("<p>The cart is currently empty</p>");
   }

   function get_stock_item($index)
   {
      //Obtain the details of a specified stock item
      $conn=connect();
      $res_table=mysql_query("SELECT * FROM foodlist WHERE indx=$index");
      if ($res_table) $item_array=mysql_fetch_array($res_table);
      disconnect($conn);
      return $item_array;
   }

   function update($index,$number)
   {
      //Update quantity of an item in stock
      $conn=connect();
      mysql_query("UPDATE foodlist SET number='$number' WHERE indx='$index'");
      disconnect($conn);
   }

   function connect()
   {
      //Connect to database
      $connection=mysql_connect("ftemysql","k0730216","carstairs");
      mysql_select_db("k0730216",$connection);
      return $connection;
   }

   function disconnect($connection)
   {
      //Disconnect from database
      mysql_close($connection);
   }
?>

Edited by mike_2000_17: Fixed formatting

3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by Will Gresham
0

You want to post that again with code tags?

Might also help if he tells us what the problem is... 'Cant connect and retrieve from database' is not very specific.

Post the error message you are getting, and what you have tried to resolve it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.