<?php
            $sqlGrow = "SELECT * FROM grow_details ";
            $query = $conn->query($sqlGrow);

            $grows = array();

           while ($grow = mysqli_fetch_assoc($query) ) {
               $grows[] = $grow;
           }

           foreach($grows as $grow) {
               $id = $grow['id'];
               $growName = $grow['name'];
        ?>
        <div class="container">
            <div class="details">
                <h2><?php echo $grow['name']; ?></h2>
                <p class="growNum">Grow #: <?php echo $id; ?></p>
                <table class="growDetails">
                    <form method="POST" action="">
                        <tr>
                            <td class="label_growDetails"><label for="datePlanted">Date Planted:</label></td>
                            <td><input type="text" name="edit_datePlanted" id="edit_datePlanted" value="<?php echo $grow['datePlanted']; ?>" />
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="strain">Strain:</label></td>
                            <td><input type="text" name="edit_strain" id="edit_strain" value="<?php echo $grow['strain']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="toMaturity">Days to mature:</label></td>
                            <td><input type="text" name="edit_toMaturity" id="edit_toMaturity" value="<?php echo $grow['toMaturity']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="type">Type:</label></td>
                            <td><input type="text" name="edit_type" id="edit_type" value="<?php echo $grow['type']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="gender">Gender:</label></td>
                            <td><input type="text" name="edit_gender" id="edit_gender" value="<?php echo $grow['gender']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="medium">Medium:</label></td>
                            <td><input type="text" name="edit_medium" id="edit_medium" value="<?php echo $grow['medium']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="watts">Watts:</label></td>
                            <td><input type="text" name="edit_watts" id="edit_watts" value="<?php echo $grow['watts']; ?>" /></td>
                        </tr>
                        <tr>
                            <td class="label_growDetails"><label for="lightType">Light Type:</label></td>
                            <td><input type="text" name="edit_lightType" id="edit_lightType" value="<?php echo $grow['lightType']; ?>" /></td>
                            <td class="edit"><input type="submit" name="submit_editGrowDetails" id="submit_editGrowDetails" value="&nbsp;&nbsp;&nbsp;Save Edits&nbsp;&nbsp;&nbsp;" /></td>
                        </tr>
                    </form>
                </table>

            </div>

<?php
    if(isset($_POST['submit_editGrowDetails'])){
        $edit_datePlanted = mysqli_real_escape_string($conn, $_POST['edit_datePlanted']);
        $edit_strain = mysqli_real_escape_string($conn, $_POST['edit_strain']);
        $edit_toMaturity = mysqli_real_escape_string($conn, $_POST['edit_toMaturity']);
        $edit_type = mysqli_real_escape_string($conn, $_POST['edit_type']);
        $edit_gender = mysqli_real_escape_string($conn, $_POST['edit_gender']);
        $edit_medium = mysqli_real_escape_string($conn, $_POST['edit_medium']);
        $edit_watts = mysqli_real_escape_string($conn, $_POST['edit_watts']);
        $edit_lightType = mysqli_real_escape_string($conn, $_POST['edit_lightType']);

        $name = $grow['name'];

        $edit_growDetails = "UPDATE grow_details
                     SET datePlanted = '$edit_datePlanted', strain = '$edit_strain', toMaturity = '$edit_toMaturity', type = '$edit_type', gender = '$edit_gender', medium = '$edit_medium', watts = '$edit_watts', lightType = '$edit_lightType'
                     WHERE name = '$name'; ";
        $query_edit_growDetails = $conn->query($edit_growDetails);

        if($query_edit_growDetails) {
            echo '<p class="success" id="success">Successfully updated log for '.$name.'! <a class="refresh" href="journal.php">Refresh</a></p>';
            } else {
                echo '<p class="error" id="error">There was an error: '. $conn->error .'</p>';
    }
}
?>