1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / esachqig / public_html / admin /
Filename : news.php
back
<?php
include_once("security.php");
include_once("meta/header.php");
?>

<button type="button" class="btn btn-danger" data-toggle="modal" data-target="#exampleModal" data-whatever="@getbootstrap">Add news</button>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">New message</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      
<form action="div-news.php" method="POST" enctype="multipart/form-data">
      <div class="modal-body">
            <div class="form-group">
              <label for="cars">Choose a Category:</label>
                <select id="cars" name="news_p_cat">
                  <option label="தமிழ்நாடு"> தமிழ்நாடு</option>
                  <option label="இந்தியா"> இந்தியா</option>
                  <option label="உலகசெய்திகள்"> உலகசெய்திகள்</option>
                  <option label="ஆன்மிகம்"> ஆன்மிகம்</option>
                  <option label="ஜோதிடம்"> ஜோதிடம்</option>
                  <option label="வேலைவாய்ப்பு"> வேலைவாய்ப்பு</option>
                  <option label="பொருளாதாரம்"> பொருளாதாரம்</option> 
                  <option label="தொழில்நுட்பம்"> தொழில்நுட்பம்</option>
                  <option label="ஆன்மிகம்"> ஆன்மிகம்</option>
                  <option label="ஜோதிடம்"> ஜோதிடம்</option>
                  <option label="வேலைவாய்ப்பு"> வேலைவாய்ப்பு</option>
                  <option label="பொருளாதாரம்"> பொருளாதாரம்</option> 
                  <option label="தொழில்நுட்பம்"> தொழில்நுட்பம்</option>
                  
                </select>
            </div>
             <div class="form-group">
                <label> Title </label>
                <textarea name="news_p_t" class="form-control" placeholder="Heading / Title" required></textarea> 
            </div>
            <div class="form-group">
                <label> News Paragraph 1</label>
                <textarea name="news_p_mnw" class="form-control" placeholder="Main News" required></textarea> 
            </div>
            <div class="form-group">
                <label> News Paragraph 2</label>
                <textarea name="news_p_mnw2" class="form-control" placeholder="Main News" required></textarea> 
            </div>
            <div class="form-group">
                <label> News Paragraph 3</label>
                <textarea name="news_p_mnw3" class="form-control" placeholder="Main News" required></textarea> 
            </div>
            <div class="form-group">
                <label> News Paragraph 4</label>
                <textarea name="news_p_mnw4" class="form-control" placeholder="Main News" required></textarea> 
            </div>
            
             <div class="form-group">
                <label>Upload image</label>
                <input type="file" name="news_p_mnbimg1" id="news_p_mnbimg1" class="form-control" required>
            </div>
            <div class="form-group">
                <label>Upload image</label>
                <input type="file" name="news_p_mnbimg2" id="news_p_mnbimg2" class="form-control" required>
            </div>
            <div class="form-group">
                <label>Upload image</label>
                <input type="file" name="news_p_mnbimg3" id="news_p_mnbimg3" class="form-control" required>
            </div>
            

      </div>
      <div class="modal-footer">
            <button type="button" class="btn btn-black" data-dismiss="modal">Close</button>
            <button type="submit" name="news_up_btn" class="btn btn-danger">Save</button>
      </div>
      
    </form>

     
    </div>
  </div>
</div>


<!----Modal End-->
<div class="container-fluid">

                    <!-- Page Heading -->
                    <h1 class="h3 mb-2 text-gray-800">Main News</h1>
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Main News</h6>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                            	 	<?php                  
                       $query = "SELECT * FROM mn_news_p ORDER BY id_mn_p DESC";
                        $query_run = mysqli_query($connection, $query);
                      ?>
                           
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                        <tr>
                                            <th>News ID</th>
                                            <th>Date</th>
                                            <th>Category</th>
                                            <th>Title</th>
                                            <th>Main Image</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                           <th>News ID</th>
                                            <th>Date</th>
                                            <th>Category</th>
                                            <th>Title</th>
                                            <th>Main Image</th>
                                            <th>Delete</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
                                    	 <?php
                      if(mysqli_num_rows($query_run) > 0)

                      {
                        while($row = mysqli_fetch_assoc($query_run))
                          {
                              ?>
                                        <tr>
                                          <td><?php echo $row['id_mn_p']; ?></td>
                                          <td><?php echo $row['news_p_dt']; ?></td>
                                          <td><?php echo $row['news_p_cat']; ?></td>
                                          <td><?php echo $row['news_p_t']; ?></td>
                                           <td><?php echo '<img src="upload/newsmain/'.$row['images'].'" width="100px;" height="100px;" >' ?> </td>
                                           
                                            <td>
                                              <form action="div-news.php" method="post">
                                                <input type="hidden" name="delete_id" value="<?php echo $row['id_mn_p']; ?>">
                                                <button type="submit" name="delete_mn_nws" data-bs-toggle="modal" data-bs-target="#exampleModal" class="btn btn-warning">DELETE</button>
                                              </form>
                                            </td>
                                        </tr>
                                        <?php
                            }

                        } 

                        else {
                          //echo "No record found";
                        }
                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
                <!-- /.container-fluid -->

            </div>
            <!-- End of Main Content -->



<?php
include_once("meta/footer.php");
?>