add.php

<?php include 'header.php'; ?>



<div id="main-content">
    <h2>Add New Record</h2>
    <form class="post-form" action="savedata.php" method="post">
        <div class="form-group">
            <label>Name</label>
            <input type="text" name="sname" />
        </div>
        <div class="form-group">
            <label>Address</label>
            <input type="text" name="saddress" />
        </div>
        <div class="form-group">
            <label>Class</label>
            <select name="class">
                <option value="" selected disabled>Select Class</option>
                <?php
                $connection = mysqli_connect("localhost", "root", "", "crud") or die("Couldn't connect'");
                $sql_query = "SELECT * FROM studentclass";
                $result = mysqli_query($connection, $sql_query) or die("Failed");
                while ($row = mysqli_fetch_assoc($result)) {
                ?>
                    <option value="<?php echo $row['cid'] ?>"><?php echo $row['cname'] ?></option>
                <?php } ?>
            </select>
        </div>
        <div class="form-group">
            <label>Phone</label>
            <input type="text" name="sphone" />
        </div>
        <input class="submit" type="submit" value="Save" />
    </form>
</div>
</div>
</body>

</html>