"sell", pset7

sell.php:

<?php

    require("../includes/config.php");

    $current_stock = CS50::query("SELECT symbol FROM portfolios WHERE user_id = ?", $_SESSION["id"]);

    render("selling_form.php", ["stocks" => $current_stock, "title" => "Sell"]);

?>

selling_form.php:

<form action="sell_stock.php" method="post">
    <div class="form-group">
        <select class="form-control" name="symbol">
            <option disabled selected value="">Symbol</option>
            <?php foreach ($stocks as $stock): ?>
                <option value="<?= $stock["symbol"] ?>"><?= $stock["symbol"] ?></option>
            <?php endforeach ?>
        </select>
        <br/>
        <br/>
        <input type="submit" class="btn btn-default" value="Sell"/>
    </div>
</form>

sell_stock.php

<?php

    require("../includes/config.php");

    $shares = CS50::query("SELECT shares, symbol FROM portfolios WHERE user_id = ?", $_SESSION["id"]);

    $delete_from_portfolios = CS50::query("DELETE FROM portfolios WHERE user_id = ? AND symbol = ?", $_SESSION["id"], $shares[0]["symbol"]);

    $stock = lookup($_POST["symbol"]);
    if ($stock === false)
    {
        apologize("invalid symbol");
    }

    $total_cash = $stock["price"] * $shares[0]["shares"];

    $positions = [];

    $update = CS50::query("UPDATE users SET cash = cash + ?", $total_cash);

    foreach ($shares as $share)
    {
        $positions[] = [
            "name" => $stock["name"],
            "price" => $stock["price"],
            "shares" => $share["shares"],
            "symbol" => $stock["symbol"],
            "total" => $stock["price"] * $share["shares"]
        ];
    }

    render("portfolio.php", ["positions" => $positions, "cash" => $total_cash, "title" => "Portfolio"]);

?>