Untitled

<?php
session_start();
?>

<html>

<head>
    <meta charset="utf-8">
    <title>Delete a Record</title>
</head>

<body>
    <form action="delete_table_handler.php" method="post">
        <table border="0">
            <tr>
                <td>
                    <select name="table">
                        <option value="Animals">Animals</option>
                        <option value="Characters">Characters</option>
                        <option value="Chimeras">Chimeras</option>
                        <option value="Cities">Cities</option>
                        <option value="Countries">Countries</option>
                        <option value="Races">Races</option>
                    </select>
                </td>
            <tr>
            <tr>
                <td>
                    <input type="submit" value="Select a Record">
                </td>
            <tr>
        </table>
    </form>
<body>
</html>

<?php
session_start();


$_SESSION["table"] = $_POST["table"];
$_SESSION["table"] = addslashes($_SESSION["table"]);

header("Location: delete_record.php")

?>

<?php
session_start();
?>

<html>

<head>
    <meta charset="utf-8">
    <title>Delete a Record</title>
</head>

<body>
    <?php
        echo "<p>".$_SESSION["table"]."</p>"
    ?>
    <form action="delete_record_handler.php" method="post">
        <table border="0">
            <tr>
                <td>
                    <select name="record">
                        <?php

                            $servername = "localhost";
                            $username = "id5347670_userid";
                            $password = "password";
                            $dbname = "id5347670_chwikidb";

                            $conn = new mysqli($servername, $username, $password, $dbname);
                            if ($conn->connect_error) {
                                die("Connection failed: " . $conn->connect_error);
                            }
                            $sql = "SELECT name FROM '".$_SESSION["table"]."'";
                            $result = $conn->query($sql);
                            while($row = $result->fetch_assoc()) {
                                echo "<option value='".$row["name"]."'>".$row["name"]."</option>";
                            }
                        ?>
                    </select>
                </td>
            <tr>
            <tr>
                <td>
                    <input type="submit" value="Select a Record"/>
                </td>
            <tr>
        </table>
    </form>
<body>

</html>