Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $hostname = "localhost";
- $username = "root";
- $password = "";
- $databaseName = "coits";
- $connect = mysqli_connect ($hostname, $username, $password, $databaseName);
- $query = "SELECT * FROM `department`";
- $result1 = mysqli_query ($connect, $query);
- ?>
- <select>
- <?php while ($row1 = mysqli_fetch_array($result1)):; ?>
- <option value="<?php echo $row1['departments']; ?>"><?php echo $row1['departments']; ?></option>
- <?php endwhile; ?>
- </select>
- <select name="demo">
- <?php
- for($i=1; $i<=4; $i++)
- {
- echo "<option value=".$i.">".$i."</option>";
- }
- ?>
- <option name="demo"> </option>
- </select>
- <input type="submit" name="submit" value="insert" />
- if($_POST['submit'])
- {
- echo $_POST['demo'];
- //then your insert query
- }
Add Comment
Please, Sign In to add comment