Viewing File: /home/quiczmwg/affordablerealtycorporation.com/admin/manage-settings.php

<?php
if(isset($_POST['btnSave'])){
//   include 'register-process.php';
}
?>
<?php 
include 'head.php';
include 'header.php';
?>

<body class="skin-default fixed-layout">
    <div id="main-wrapper">
        <?php 
        include 'sidebar.php';
        // include_once ("../_db.php");
        
        $sql = $conn->query("SELECT * FROM dsettings ORDER BY id DESC");
        ?>
        <div class="page-wrapper">
            <div class="container-fluid">
                <?php include 'nav.php'; ?>

       <!-- Button to Open the Modal -->
       <div class="container">
            <div class="text-right my-3">
                <button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal">
                    <i class="bi bi-plus"></i>Manage Settings
                </button>
            </div>
        </div>

    <section>
    <div class="d-flex justify-content-end align-items-center">
            <div class="container-fluid">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table">
                                <thead>
                                    <th>#</th>
                                    <th>Gate Pass</th>
                                    <th>Fee</th>
                                    <!-- <th>Prices</th> -->
                                    <!-- <th>Outdoor Games</th> -->
                                    <th>----</th>
                                </thead><br>

                                
                                
                                    <?php 
                                    if($sql->num_rows>0){
                                        $num=1;
                                        while($row = $sql->fetch_assoc()){                               
                                    ?>
                                    <tr>
                                        <td><?php echo $num++; ?></td>
                                        <td><?php echo $row['dcategory']; ?></td>
                                        <td><?php echo $row['dpricess']; ?></td>
                                        
                                        <td>


                                         
                                        <a href="#" data-toggle="modal" data-target="#myModal<?php echo $row['id']; ?>" class="btn btn-info btn-sm">Edit</a>

                                        <a href="set-controller.php?id=<?php echo $row
                                        ['userid']; ?>&status=delete" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#myModalx<?php echo $row
                                        ['userid']; ?>">Delete</a>

                                         <div class="modal fade" id="myModalx<?php echo $row
                                        ['userid']; ?>">
                                          <div class="modal-dialog">
                                            <div class="modal-content">
                                            
                                              <!-- Modal Header -->
                                              <div class="modal-header">
                                                <h4 class="modal-title">Manage Settings</h4>
                                                <button type="button" class="close" data-dismiss="modal">&times;</button>
                                              </div>
                                              
                                              <!-- Modal body -->
                                              <div class="modal-body">
                                                <form action="manage-sets-process.php" method="post">
                                            
                                                <div class="text-center my-4">
                                                  <h5>Are you sure you want to delete this file?</h5>
                                                </div>
                                              
                              
                                              </div>
                                              
                                              <!-- Modal footer --> 
                                              <div class="modal-footer">
                                              <a href="set-controller.php?id=<?php echo $row
                                                ['userid']; ?>&status=delete" class="btn btn-danger">Delete</a>
                                                <button type="button" class="btn btn-warning" data-dismiss="modal">Close</button>
                                              </div>
                                              </form>
                                            </div>
                                          </div>
                                      </div>
               
                                    </td><br>
                                    </tr>
                                    <tbody>
                                            <?php } }?>
                                </tbody>
                             </table>
                        </div>
                    </div>
                </div>
            </div>
      </div>
    </section>
</div>
</div>
</div>


    <?php
    include 'footer.php';
    ?>


         

          <!-- The Modal -->
          <div class="modal fade" id="myModal">
            <div class="modal-dialog">
              <div class="modal-content">
              
                <!-- Modal Header -->
                <div class="modal-header">
                  <h4 class="modal-title">Manage Settings</h4>
                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                
                <!-- Modal body -->
                <div class="modal-body">
                  <form action="manage-sets-process.php" method="post">
               
                   <select name="category" class="form-control">
                      <option value="">Category</option>
                      
                      <option>Adult</option>
                      <option>Kids</option>
                  </select>


                  <div class="form-group">
                    <input name="prices" class="form-control my-2" placeholder="Prices" required>
                  </div>
                 
 
                </div>
                
                <!-- Modal footer -->
                <div class="modal-footer">
                  <button type="submit" name="btnSave"  class="btn btn-success bg-warn">Submit</button>
                  <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                </div>
                </form>
              </div>
            </div>
        </div>
               
        <?php 
        $sql = $conn->query("SELECT * FROM dsettings ORDER BY id DESC");
            if($sql->num_rows>0){
                $num=1;
                while($rowx = $sql->fetch_assoc()){                               
            ?>

            <!-- The Modal -->
          <div class="modal fade" id="myModal<?php echo $rowx['id']; ?>">
            <div class="modal-dialog">
              <div class="modal-content">
              
                <!-- Modal Header -->
                <div class="modal-header">
                  <h4 class="modal-title">Manage Admin Settings</h4>
                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                
                <!-- Modal body -->
                <div class="modal-body">
                  <form action="manage-sets-process.php" method="post">

                  <div class="form-group">
                  <select name="category" class="form-control">
                      <option value="">Game Category</option>
                      
                      <option <?php echo "Adults"==$rowx['dcategory']?"selected":"" ?> >Adults</option>
                      <option  <?php echo "Kids"==$rowx['dcategory']?"selected":"" ?> >Kids</option>
                  </select>
                  
                  <!-- <input type="text"> -->
                  <select name="id" class="form-control d-none">
                      <option value='<?php echo $rowx['id']; ?>'>Game Category</option>
                      
                      <option value='<?php echo $rowx['id']; ?>' >Adults</option>
                      <option  value='<?php echo $rowx['id']; ?>' >Kids</option>
                  </select>
                  </div>
   
                  <div class="form-group">
                    <input name="prices" value='<?php echo $rowx['dpricess']; ?>' class="form-control my-2" placeholder="Prices" required>
                    <input name="id" value='<?php echo $rowx['id']; ?>' type='hidden'>
                  </div>
                </div>
                
                <!-- Modal footer -->
                <div class="modal-footer">
                    <button type="submit" name="btnSaveUpdate"  class="btn btn-success bg-warn">Update</button>
                  <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                </div>
                </form>
              </div>
            </div>
        </div>
        <?php }}?>


        
Back to Directory File Manager
<