D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
aviscollection.com
/
admin
/
Filename :
customers-list.php
back
Copy
<?php include'config.php'; $page_title = "customers"; $view_res = "SELECT * FROM customers c INNER JOIN state_list s ON C.customer_state = s.state_id"; $run_query = mysqli_query($conn, $view_res) or mysqli_error($conn); ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Admin, <?php echo $page_title; ?> | <?php echo $company; ?></title> <?php include'style.php'; ?> </head> <body> <div id="layout-wrapper"> <?php include'header.php'; ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18"><?php echo $page_title; ?> list</h4> <!-- <div class="addItem_div"> <a class="btn btn-info" href="manage-customer.php?action=add_customer">Add <?php echo $page_title; ?></a> </div> --> <div class="page-title-right"> <ol class="breadcrumb m-0"> <li class="breadcrumb-item"><a href="javascript: void(0);">Admin</a></li> <li class="breadcrumb-item active"><?php echo $page_title; ?> list</li> </ol> </div> </div> </div> </div> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <div class="table-responsive"> <table id="datatable-buttons" class='table table-editable table-nowrap align-middle table-edits'> <thead> <tr> <th>ID</th> <th>Name</th> <th>Phone</th> <th>Email</th> <th>Password</th> <th>Gender</th> <th>Address</th> <th>City</th> <th>Pin Code</th> <th>State</th> <th>Action</th> </tr> </thead> <tbody> <?php if($run_query-> num_rows > 0){ while($row = mysqli_fetch_assoc($run_query)) { $item_id = $row['customer_id']; $item_name = $row['customer_name']; $item_phone = $row['customer_phone']; $item_email = $row['customer_email']; $item_password = $row['customer_password']; $item_gender = $row['customer_gender']; $item_address = $row['customer_address']; $item_city = $row['customer_city']; $item_pin = $row['customer_pin']; $item_state = $row['customer_state']; $state_name = $row['state_name']; echo "<tr data-id='1'> <td id='customer_".$item_id."' style='width: 80px'> $item_id.</td> <td>$item_name</td> <td>$item_phone</td> <td>$item_email</td> <td>$item_password</td> <td>$item_gender</td> <td>$item_address</td> <td>$item_city</td> <td >$item_pin</td> <td >$state_name</td> <td style='width: 100px'> <a href='manage-customer.php?id=$item_id&action=edit_customer' class='btn btn-outline-secondary btn-sm edit' title='Edit'> <i class='fas fa-pencil-alt'></i> </a> <a href='manage-customer.php?id=$item_id&action=delete_customer' class='btn btn-outline-secondary btn-sm edit' title='Delete'> <i class='fas fa-trash-alt'></i> </a> </td> </tr>"; } } else{ echo "<span style='color:#fe0002;font-size:15px;'>$page_title list is empty.</span>"; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <?php include'right-sidebar.php'; ?> <?php include'script.php'; ?> </body> </html>