sell.php

<?php
    // configuration
   require("../includes/config.php");

       // need to lookup current user
       $rows = query("SELECT * FROM portfolio WHERE id = ?",$_SESSION["id"]);

   if ($_SERVER["REQUEST_METHOD"] == "POST")
   {
          // validate submission
       if (empty($_POST["symbol"]))
       {
           apologize("You must provide a symbol.");
       }



       // display stock or stocks owned in dropdown menu

       // upon selection of stock
           if ($_POST["symbol"] == $row["symbol"])
           {

           // Delete stock
           query("DELETE FROM portfolio WHERE id =? AND symbol = ?",$_SESSION['id'],'shares');
           // update cash
           query ("UPDATE users SET cash = cash + ? WHERE id = ?",'price',$_SESSION['id']);
           }
           redirect("/");
     }
    else
    {
       render("sell_temp.php", ["rows" => $rows, "title" => "sell"]);
    }
?>