Show Data From Database
<?php
include_once 'dbconnect.php' ;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/css/bootstrap.min.css" rel="stylesheet">
<link href='https://fonts.googleapis.com/css?family=Open+Sans:400,600,700,800' rel='stylesheet' type='text/css'>
<title>Document</title>
<style>
table{
font-size:20px;
}
th{
background:black;
color:white;
text-align:center;
}
tr:nth-child(even){
background:#210000;
color:white;
text-align:center;
}
tr:nth-child(odd){
background:#199977;
color:white;
text-align:center;
}
</style>
</head>
<body>
<h1>::Show Edit Delete From Database::</h1>
<table id="convert" border="1" class="table-hover" cellspacing="0" rules="all" width="100%">
<div id="example_wrapper" class="dataTables_wrapper no-footer"><div class="dt-buttons"> <button class="dt-button buttons-copy buttons-html5" tabindex="0" aria-controls="example" type="button"><span>Copy</span></button> <button class="dt-button buttons-csv buttons-html5" tabindex="0" aria-controls="example" type="button"><span>CSV</span></button> <button class="dt-button buttons-excel buttons-html5" tabindex="0" aria-controls="example" type="button"><span>Excel</span></button> <button class="dt-button buttons-pdf buttons-html5" tabindex="0" aria-controls="example" type="button"><span>PDF</span></button> <button class="dt-button buttons-print" tabindex="0" aria-controls="example" type="button"><span>Print</span></button> </div><div id="example_filter" class="dataTables_filter"><label>Search:<input type="search" class="" placeholder="" aria-controls="example"></label></div><table id="example" class="table table-striped table-bordered dataTable no-footer" style="font-size:10pt;" role="grid" aria-describedby="example_info">
<tr>
<th>$</th>
<th>Name</th>
<th>Email</th>
<th>Mobile</th>
<th>Password</th>
<th colspan="2">Edit</th>
</tr>
<?php
$sql ="select * from vritant_tbl";
$result =mysqli_query($conn,$sql);
$count =mysqli_num_rows($result);
if($count>0){
while($data =mysqli_fetch_assoc($result)){
?>
<tr>
<td>
<?php echo $data['id']; ?>
</td>
<td>
<?php echo $data['name']; ?>
</td>
<td>
<?php echo $data['email']; ?>
</td>
<td>
<?php echo $data['mobile']; ?>
</td>
<td>
<?php echo $data['password']; ?>
</td>
<td>
<a href=" edit.php?/=<?php echo $data['id']; ?>" style="text-decoration:none;color:yellow;">Edit</a>
</td>
<td>
<a href=" delete.php?/=<?php echo $data['id']; ?>"onclick="return confirm('Do You Sure delete this Student')" style="text-decoration:none;color:red;">Delete</a>
</td>
</tr>
<?php
}
}else{
?>
<tr>
<td colspan="6"><?php echo "No Record Found";?></td>
</tr>
<?php
}
?>
</table>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.1/css/buttons.dataTables.min.css">
<style type="text/css" class="init">
</style>
<script type="text/javascript" src="/media/js/site.js?_=a64810efc82bfd3b645784011efa5963"></script>
<script type="text/javascript" src="/media/js/dynamic.php?comments-page=extensions%2Fbuttons%2Fexamples%2Finitialisation%2Fexport.html" async></script>
<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.6.1/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.flash.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.html5.min.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.print.min.js"></script>
<script type="text/javascript" language="javascript" src="../../../../examples/resources/demo.js">
</script>
<script type="text/javascript" class="init">
$(document).ready(function() {
$('#convert').DataTable( {
dom: 'Bfrtip',
buttons: [
'copy', 'csv', 'excel', 'pdf', 'print'
]
});
});
</script>
</body>
</html>
0 Comments