invisio v2.0

<?php
	include("innerpageheader.php");
	include("config.php");
	$result = $js->query('SELECT * FROM `brands` ORDER BY `brandname`');
			$result->execute();
			
?>
<section>
			<div class="content listing-content">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<div class="col">
							<div class="heading-messages">
								<h3>Brands</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Listing</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>All
								</div>
							</div>
						</div>
					</div>

<div class="box">
 <div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="add_brands.php">Add New Brands<i class="fas fa-plus"></i></a>
								</div>
							</div>
							<div class="col text-end">
								<div class="tools-btns">
									<a href="#"><i class="fas fa-print" data-bs-toggle="tooltip" data-html="true" title="Print"></i></a>
									<a href="#"><i class="fas fa-file-pdf" data-bs-toggle="tooltip" data-html="true" title="Pdf"></i></a>
									<a href="#"><i class="fas fa-file-excel" data-bs-toggle="tooltip" data-html="true"
											title="Excel"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
                                    <thead>
                                        <tr>
                                            <th>Brand Name</th>
                                            <th>Description</th>
                                             <th>Delete</th>
                                        </tr>
                                    </thead>










                                    <tbody>
									<?php
										while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											$id = $row['id'];
											$brandid = $row['brandid'];
											$brname = $row['brandname'];
											$brdesc = $row['branddescr'];
											
											echo "<tr>";
												echo "<td>$brname</td>";
												echo "<td>$brdesc</td>";
												
										?>
                                                <td><a onclick="return add('<?php echo $id?>')"  style='background-color:red; border-color:red;' class='btn btn-primary btn-circle'><i  class='fa fa-times'></i></a></td>	
												<?php
											echo "</tr>";
										}
									?>
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>

</div>

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

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>    
    <script src="js/demo/datatables-demo.js"></script>
    
     <script type="text/javascript"> 
	function add(a)
	{
		if(confirm('Are You Sure to Delete'))
		{
			window.location.href = "delete_brands.php?brid="+ a ;
		}
		else
		{
			return false;
		}
	}
</script>