Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form name="emp_actor" id="emp_actor" method="post" action="" >
- <div align="center">
- <h2 align="center">List of 'actor1'</h2>
- <strong> Select actor : </strong>
- <select name="name" id="name" onchange="onSelectChange1();">
- <option value="">----ALL----</option>
- <?php
- $dd_res = mysqli_query($conn, "Select name from actor");
- while ($row = mysqli_fetch_array($dd_res)) {
- echo "<option value='".$row['name']."'>".$row['name']."</option>";
- }
- ?>
- </select>
- <div class="row col-sm-8">
- <div class="col-sm-1">Id</div>
- <div class="col-sm-4">Name</div>
- <div class="col-sm-3">BirthDay</div>
- <div class="col-sm-4">Foto</div>
- </div>
- </div>
- <?php
- if($_SERVER['REQUEST_METHOD'] == "POST") {
- $des = $_POST["name"];
- if ($des == "") // if ALL is selected in Dropdown box
- {
- $res = mysqli_query($conn, "Select * from actor order by actor_id desc ");
- } else {
- $res = mysqli_query($conn, "Select * from actor where name='" . $des . "'");
- }
- // echo "<tr><td colspan='5'></td></tr>";
- while ($row = mysqli_fetch_array($res)) {
- echo
- '<div class="container-fluid" align="center">
- <div class="row col-sm-8">
- <div class="col-sm-1">'.$row['actor_id'].'</div>
- <div class="col-sm-4">'.$row['name'].'</div>
- <div class="col-sm-3">'.$row['birthday'].'</div>
- <div class="col-sm-4"><img src="upload/' . $row['foto'] . '" height="50" width="40" class="img-thumnail" /></div>
- </div></div>';
- }
- }
- ?>
- </form>
- <script>
- function onSelectChange1() {
- document.getElementById('emp_actor').submit();
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement