//line 15
//line 22
//line 101
//line 22
//line 101
JavaScript:
//test
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" />
<script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
<script src="assets/bootstrap.min.js"></script>
<link href="assets/bootstrap.min.css" media="all" rel="stylesheet" type="text/css" />
<?php
if ($_SERVER['REQUEST_METHOD'] != 'POST')
{
session_destroy();
echo "<center><form style='width:300px;margin-top:50px' method='post']";
if ($_GET["err"])
echo "<div class='alert alert-danger']Invalid Password</div>";
echo "<input id='txt_password' name='txt_password' class='form-control' /><br>";
echo "<button class='btn btn-primary' type='submit' name='submit']Login</button></form></center>";
exit;
}
else
{
if (!(isset($_POST["txt_password"]) && strtolower($_POST["txt_password"])=="123"))
{
session_destroy();
// die("catastrophic failure");
header("Location: show_participants.php?err=1");
exit;
} else {
$_SESSION["x"] = "123";
}
}
// include DB
require_once ('config.php');
$db = connect();
$cmb_rows = null;
$cmb_rows = getSet($db,"select distinct(app_name) from votes order by app_name DESC", null);
?>
<script src="assets/bootstrap-table.min.js"></script>
<link href="assets/bootstrap-table.min.css" media="all" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(function() {
//http://wenzhixin.net.cn/p/bootstrap-table/docs/examples.html#via-javascript-table
$('#votes_tbl').bootstrapTable();
var jArray = <?php echo json_encode($cmb_rows); ?>;
var the_rows = "<option></option>";
for (var i = 0; i < jArray.length; i++)
{
the_rows += "<option>" + jArray[i]["app_name"] + "</option>\r\n";
}
//set the contest rows
$("#cmb_contest").html(the_rows);
$('#cmb_contest').on('change', function() {
$('#votes_tbl').bootstrapTable('refresh');
});
}); //jQuery ends
//bootstrap-table
function queryParamsVOTES(params)
{
var q = {
"limit": params.limit,
"offset": params.offset,
"search": params.search,
"name": params.sort,
"order": params.order,
//
"contest": $("#cmb_contest").val()
};
return q;
}
</script>
</head>
<body>
<div style="width:300px">
<select id="cmb_contest" class="form-control">
</select>
</div>
[TABLE]
[TD]
[TR]
[TD]
[/TD]
[TD]
id
[/TD]
[TD]
member_id
[/TD]
[TD]
fullname
[/TD]
[TD]
mail
[/TD]
[TD]
gender
[/TD]
[TD]
timezone
[/TD]
[TD]
date_rec
[/TD]
[TD]
app_name
[/TD]
[/TR]
<tbody id="tbl_rows">
[/TABLE]
</body>
</html>
JavaScript:
//show_participants_pagination.php
session_start();
//check if logged in
if (!isset($_SESSION["x"])) {
header("Location: show_participants.php");
exit ;
}
.
.
.
.
$arr = array('total'=> $count_recs,'rows' => $rows);
header("Content-Type: application/json", true);
echo json_encode($arr);