workshop/99_Miscellaneous/Refactoring/deletepage.php [42:58]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                        <option value="0">--Select Page--</option>
                        <?php
                        $statement = $databaseConnection->prepare("SELECT id, menulabel FROM pages");
                        $statement->execute();

                        if ($statement->error) {
                            die("Database query failed: " . $statement->error);
                        }

                        $statement->bind_result($id, $menulabel);
                        while ($statement->fetch()) {
                            echo "<option value=\"$id\">$menulabel</option>\n";
                        }
                        ?>
                    </select>
                </li>
            </ol>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



workshop/99_Miscellaneous/Refactoring/selectpagetoedit.php [38:54]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                            <option value="0">--Select Page--</option>
                            <?php
                            $statement = $databaseConnection->prepare("SELECT id, menulabel FROM pages");
                            $statement->execute();

                            if ($statement->error) {
                                die("Database query failed: " . $statement->error);
                            }

                            $statement->bind_result($id, $menulabel);
                            while ($statement->fetch()) {
                                echo "<option value=\"$id\">$menulabel</option>\n";
                            }
                            ?>
                        </select>
                    </li>
                </ol>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -