<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link href="../assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="//cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
<link href="../assets/css/highlight/default.css" rel="stylesheet" type="text/css" />
<script src="../assets/js/jquery-1.7.2.min.js" type="text/javascript"></script>
<script src="../assets/js/bootstrap.min.js" type="text/javascript"></script>
<script src="../assets/js/highlight.pack.js" type="text/javascript"></script>
<style>
.wrapper{
margin: 0 auto;
max-width: 800px;
padding-top: 50px;
}
.code{
display:none;
}
</style>
<script>hljs.initHighlightingOnLoad();</script>
</head>
<body>
<nav class="navbar navbar-default" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="#">teaPagination</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-3">
<a href="../../index.html" class="btn btn-default navbar-btn"><i class="fa fa-home"></i> Home</a>
</div>
</div>
</nav>
<div class="wrapper">
<div class="alert alert-info"><strong>Please, </strong>Click <a href="javascript:void(0)" onClick="$('.code').toggle()" style="font-weight:bold">here</a> to view the code</div>
<div class="row">
<pre class="code php html">
<code>
//.htaccess file
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^countries-of-the-world/([0-9]{1,4})\.html friendlyUrl.php?pag=$1 [L,QSA]
</code>
</pre>
<pre class="code php html">
<code>
//create the sql statement to be processed
$sql = 'SELECT * FROM countries';
//added the class options
$options = array(
'beginLoop' => '<blockquote>',
'endLoop' => '</blockquote>',
'maxButtons' => 5,
'itemsPage' => 10,
'nameVar' => 'pag', //parameter name containing the page number
'urlPage' => '%d.html', //Output customization url for each page. %d is replaced by the page number
'buttons' => array('class' => 'pagination'),
'connect_db' => array('user' => 'root', 'database' => 'example', 'password' => 'passw')
);
//Instance is started
$pagination = new teaPagination($sql, $options);
//Add in the method a function of interaction (create_list_data)
$pagination->loop('', 'create_list_data');
//The result is shown
echo '<div class="row" style="margin-bottom:20px;margin-left:5px">Showing ' . $pagination->currentPage . ' - ' . $pagination->TotalPage . ' of ' . $pagination->TotalRecord . ' entries</div><hr/>' . $pagination->render() . $pagination->buttons();
//interaction function
function create_list_data($data) {
return '<p><a href="javascript:void(0)" onClick="alert(\'Country: ' . $data['short_name'] . '\')">' . $data['short_name'] . '</a></p><small>' . $data['long_name'] . '</small>';
}
</code>
</pre>
</div>
<?php
function create_list_data($data) {
return '<p><a href="javascript:void(0)" onClick="alert(\'Country: ' . $data['short_name'] . '\')">' . $data['short_name'] . '</a></p><small>' . $data['long_name'] . '</small>';
}
require_once('../teaPagination.php');
require_once('setting/setting.php');
$sql = 'SELECT * FROM countries';
$options = array(
'beginLoop' => '<blockquote>',
'endLoop' => '</blockquote>',
'maxButtons' => 5,
'itemsPage' => 10,
'nameVar' => 'pag',
'urlPage' => '%d.html',
'buttons' => array('class' => 'pagination'),
'connect_db' => array('user' => USER, 'database' => DATABASE, 'password' => PASSWORD)
);
$pagination = new teaPagination($sql, $options);
$pagination->loop('', 'create_list_data');
echo '<div class="row" style="margin-bottom:20px;margin-left:5px">Showing ' . $pagination->currentPage . ' - ' . $pagination->TotalPage . ' of ' . $pagination->TotalRecord . ' entries</div><hr/>' . $pagination->render() . $pagination->buttons();
?>
</body>
</html>
|
Download
