File "page_list.php"

Full Path: /home/krishnamexports/public_html/panel/partials/page_list.php
File size: 2.02 KB
MIME-type: text/x-php; charset=us-ascii
Charset: utf-8

<?php

	

			if(isset($_GET['delete_id']))

			{

				$id      = $_GET['delete_id'];

				$sql     = mysqli_query($cn, "delete from tbl_page where id='$id'");

				if($sql)

				{

					echo '<div class="alert alert-success"><strong>Success!</strong> Page Deleted Successfully.</div>';

				}

				else

				{

					echo "error: " . $sql . "<br>" . mysqli_error($conn);	

				}

			}	

?>

	<div class="card">

                <div class="card-body">

                  <h4 class="card-title">Page List</h4>

				  

				  

                  

                  <div class="table-responsive">

                    <table class="table table-striped">

                      <thead>

                        <tr>

                          <th>Sr. No.</th>

                          <th>parent_id</th>

                          <th>Page Name</th>

                          <th>Page Order</th>

                          <th>Meta Title</th>

						  <th>Action</th>

                        </tr>

                      </thead>

                      <tbody>

							<?php

							$i = 1;						  

							$sqlEmployee = mysqli_query($cn, "select * from `tbl_page`");

							while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee)){?>

							<tr>

							  <td><?php echo $i++;?></td>

                              <td><?php echo $sqlEmployeeData['parent_id'];?></td>

							  <td><?php echo $sqlEmployeeData['name'];?></td>

                              <td><?php echo $sqlEmployeeData['page_order'];?></td>

                              <td><?php echo $sqlEmployeeData['meta_title'];?></td>

							  <td>

							  <a href="home.php?pages=page&edit_id=<?php echo $sqlEmployeeData['id'];?>">Edit</a> | <a href="home.php?pages=page_list&delete_id=<?php echo $sqlEmployeeData['id'];?>" onclick="return deleteConfirm();"> Delete</a></td>

							</tr>

					    <?php } ?>

					  </tbody>

                    </table>

                  </div>

                </div>

              </div>