File Manager

Editing File: /home/quiczmwg/public_html/admin/manage-plan.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 'config.php';
        
        // $sql = $conn->query("SELECT * FROM dcategory, ORDER BY id DESC");
        ?>
        <div class="page-wrapper">
            <div class="container-fluid">
                <?php include 'nav.php'; ?>

<div class="container">
            <div class="text-right my-3">
                <button type="button" class="btn text-white" data-toggle="modal" data-target="#myModal" style="background: rgb(2, 2, 83);">
                    <i class="bi bi-plus"></i> Add Investment Plan
                </button>
            </div>
        </div>

<div class="modal fade" id="myModal">
            <div class="modal-dialog">
              <div class="modal-content">
              
                
                <div class="modal-header">
                  <h4 class="modal-title">Manage Plan</h4>
                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                
                
                <div class="modal-body">
                  <form action="manage-plan-process.php" method="post">
                
                  <div class="form-group">
                    <input name="plan_title"  class="form-control my-2" placeholder="Enter Plan" required>
                  </div>

<div class="form-group">
                    <input name="days" type="number"  class="form-control my-2" placeholder="days" required>
                  </div>
 
                </div>
                
                
                <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>

<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>Plan</th>
                                    <th>Mimimum</th>
                                    <th>Maximum</th>
                                    <th>Profit</th>
                                    <th>ROI</th>
                                    <th>Days</th>
                                    <th>----</th>
                                </thead><br>

<tbody>
                                  <?php
                                // Modify the SQL query to order by a column (e.g., registration date)
                                      $sql = $conn->query("SELECT * FROM plans ORDER BY id ASC");

// Check if there are any rows returned by the query
                                      if ($sql !== false && $sql->num_rows > 0) {
                                          $num = 1;
                                          // Fetch each row from the result set
                                          while ($row = $sql->fetch_assoc()) {
                                              ?>
                                              
                                            
                                                          <tr>
                                        
                                        <td><?php echo $num++; ?></td>  
                                        <td><?php echo $row['plan_title']; ?></td>
                                        <td><?php echo '$' .number_format($row['minimum'],2.); ?></td>
                                        <td><?php echo '$' .number_format($row['maximum'],2.); ?></td>
                                        <td><?php echo '$' .number_format($row['profit'],2.); ?></td>
                                        
                                        <td><?php echo $row['roi']; ?>%</td>
                                        <td><?php echo $row['days']; ?></td>
                                        
                                        <td>
                                        <a href="edit_plan.php?id=<?php echo $row['id']; ?>" class="btn btn-info btn-sm">Edit</a>

<a href="plan-controller.php?delete=<?php echo $row['id']; ?>" class="btn btn-danger" onclick="return confirm('are you sure you want to delete this?');"><i class="bi bi-trash3-fill"></i> Delete</a>
                                        <?php } }?>
                                         
                                      
                                    </td><br>
                                    </tr>

</tbody>
                             </table>
                        </div>
                    </div>
                </div>
            </div>
      </div>
    </section>
</div>
</div>
</div>

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

Back to Directory File Manager