Viewing file:  index.php (6.01 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="UTF-8">
<title>Data Report</title>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css'>
<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.10.0/bootstrap-table.min.css'>
<link rel='stylesheet' href='https://rawgit.com/vitalets/x-editable/master/dist/bootstrap3-editable/css/bootstrap-editable.css'><link rel="stylesheet" href="./style.css">
</head>
<body>
<!-- partial:index.partial.html -->
<div class="container">
<h1>Total Data : <span id="total_count"></span></h1>
<!-- <p> Mémo pour les options du Bootstrap Table : <a href="http://bootstrap-table.wenzhixin.net.cn/documentation/">Bootstrap Table Documentation</a></p>
<p>Eléments de Bootstrap Table utilisés : <a href="http://jsfiddle.net/wenyi/e3nk137y/3178/">Data Checkbox</a>, pour cocher les éléments à sélectionner, <a href="https://github.com/wenzhixin/bootstrap-table-examples/blob/master/extensions/filter-control.html">extension Filter control</a>, pour les filtres via les colonnes, <a href="https://github.com/kayalshri/tableExport.jquery.plugin">extension Data export</a> pour exporter</p> -->
<div id="toolbar">
<select class="form-control">
<option value="">Export Basic</option>
<option value="all">Export All</option>
<option value="selected">Export Selected</option>
</select>
</div>
<?php
$con=mysqli_connect("localhost","admin","wahid","sub_camp");
if(!$con)
{
die("Connection Error: ".mysqli_connect_error()."<br/>");
}
// else
// {
// echo "Database Connected Successfully..<br/>";
// }
// $email=$_POST['email'];
// $password=$_POST['password'];
$sql="SELECT * FROM campaign order by id desc limit 1,100";
$result=mysqli_query($con,$sql);
?>
<table id="table"
data-toggle="table"
data-search="true"
data-filter-control="true"
data-show-export="true"
data-click-to-select="true"
data-toolbar="#toolbar">
<thead>
<tr>
<th data-field="state" data-checkbox="true"></th>
<th data-field="campaign_id" data-filter-control="select" data-sortable="true">Campaign</th>
<th data-field="zone_id" data-filter-control="select" data-sortable="true" >Zone</th>
<!-- <th data-field="click_id" data-filter-control="input" data-sortable="true" >ClickID</th>
<td id="td_id">'.$row["clickid"].'</td> -->
<th data-field="time" data-filter-control="select" data-sortable="true" >Time</th>
<th data-field="uid" data-filter-control="input" data-sortable="true" >UID</th>
<th data-field="ip" data-filter-control="input" data-sortable="true" >IP</th>
<th data-field="pid" data-filter-control="select" data-sortable="true">PID</th>
<th data-field="message" data-filter-control="select" data-sortable="true" >Message</th>
<th data-field="banner_id" data-filter-control="select" data-sortable="true" >Banner</th>
<th data-field="zone_type" data-filter-control="select" data-sortable="true" >Zone Type</th>
<!--
<th data-field="prenom" data-filter-control="input" data-sortable="true">Prénom</th>
<th data-field="date" data-filter-control="select" data-sortable="true">Date</th>
<th data-field="examen" data-filter-control="select" data-sortable="true">Examen</th>
<th data-field="test" data-filter-control="select" data-sortable="true">test</th>
<th data-field="note" data-sortable="true">Note</th> -->
</tr>
</thead>
<tbody>
<!-- <td class="bs-checkbox " id="td_id"><input data-index="0" name="btSelectItem" type="checkbox"></td> -->
<?php
if(mysqli_num_rows($result)>0)
{
while($row=mysqli_fetch_array($result))
{
echo '<tr>
<td class="bs-checkbox"><input data-index="'.$row["id"].'" name="btSelectItem" type="checkbox" value="'.$row["id"].'"></td>
<td id="td_id">'.$row["campaignid"].'</td>
<td id="td_zoneid">'.$row["zoneid"].'</td>
<td id="td_time">'.date("Y-m-d",strtotime($row["time"])).'</td>
<td id="td_uid">'.$row["uid"].'</td>
<td id="td_ip">'.$row["ip"].'</td>
<td id="td_pid">'.$row["pid"].'</td>
<td id="td_message">'.$row["message"].'</td>
<td id="td_banner">'.$row["bannerid"].'</td>
<td id="td_type">'.$row["zone_type"].'</td>
</tr>';
}
}
else
{
echo "No data found.<br/>";
}
?>
</tbody>
<!-- <tfoot style="border:1px solid;"></tfoot> -->
</table>
<?php
mysqli_close($con);
?>
</div>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.10.0/bootstrap-table.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.9.1/extensions/editable/bootstrap-table-editable.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.9.1/extensions/export/bootstrap-table-export.js'></script>
<script src='https://rawgit.com/hhurz/tableExport.jquery.plugin/master/tableExport.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.9.1/extensions/filter-control/bootstrap-table-filter-control.js'></script><script src="./script.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
$(document).ready(function () {
// var table=$('#example').dataTable({"pageLength": 30});
// var tbl = $('#example').DataTable();
// alert(JSON.stringify(tbl.page.info()));
var count = $('#table tr').length-1;
$("#total_count").text(count);
// $( "#table thead tr" ).on( "click", function( event ) {
// var count = $('#table tr').length-1;
// $("#total_count").text(count);
// });
$( "select" ).on( "click", function( event ) {
var count = $('#table tr').length-1;
$("#total_count").text(count);
});
});
// $('select').find('option').click(function () {
// var optionSelected = $(this);
// var valueSelected = optionSelected.val();
// var textSelected = optionSelected.text();
// console.log("heloo");
// });
</script>
</body>
</html>
|