viewmovie.php

<?php
session_start();

if(empty($_SESSION["admin_username"]))
{
    header("Location:index.php");
}

else
{
  
    include("admin_header.php");

    $con=new connec();
$sql="SELECT movie.id, movie.name, movie.movie_banner, movie.rel_date, industry.industry_name, genre.genre_name, language.lang_name, movie.duration
      FROM movie, genre, industry, movie_ticket_booking.language
      where
      movie.industry_id=industry.id AND
      movie.genre_id=genre.id AND
      movie.lang_id=language.id;";
$result=$con->select_by_query($sql);
   ?>
       
            
            <section>
                <div class="continer-fluid">
                    <div class="row">
                        <div class="col-md-2" style="background-color:gold;color:black;">
                            <?php include('admin_sidenavbar.php'); ?>
                        </div>
                        <div class="col-md-10">
                            <h5 class="text-center mt-2" style="color:black;">Movie Details</h5>
                            <a href="addmovie.php">Add movie</a>
                             <table class="table mt-5" border=1 >
                                <thead style="background-color:gold;color:black;color:black">
                                    <tr>
                                        <th>Banner</th>
                                        <th>Name</th>
                                        <th>Release Date</th>
                                        <th>Industry</th>
                                        <th>Genre</th>
                                        <th>Language</th>
                                        <th>Duration</th>
                                        <th>action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php 
                                    if($result->num_rows>0)
                                    {
                                        while($row=$result->fetch_assoc())
                                        {
                                    ?>
                                    <tr>
                                        <td><img src="../<?php echo $row["movie_banner"]; ?>" style="height:100px;"></td>
                                        <td> <?php echo $row["name"]; ?> </td>
                                        <td> <?php echo $row["rel_date"]; ?></td>
                                        <td> <?php echo $row["industry_name"]; ?></td>
                                        <td> <?php echo $row["genre_name"]; ?></td>
                                        <td> <?php echo $row["lang_name"]; ?></td>
                                        <td> <?php echo $row["duration"]; ?></td>
                                        <td><a href="editmovie.php?id=<?php echo $row["id"]; ?> " class="btn btn-primary">Edit</a>
                                        <a href="deletemovie.php?id=<?php echo $row["id"]; ?>=" class="btn btn-danger">Delete</a></td>
                                    </tr>
                                    <?php
                                    }

                                }

                                    ?>
                                </tbody>
                             </table>


                        </div>
                    </div>
                </div>
            </section>
                    
    <?php
     include("admin_footer.php");
}
?>