<?php
echo "hello";
session_start();
require 'Smarty.class.php';
require 'SmartyPaginate.class.php';
$smarty =& new Smarty();
// required connect
SmartyPaginate::connect();
// set items per page
SmartyPaginate::setLimit(25);
// assign your db results to the template
$smarty->assign('results', get_db_results());
// assign {$paginate} var
SmartyPaginate::assign($smarty);
// display results
$smarty->display('index.tpl');
function get_db_results()
{
// normally you would have an SQL query here,
// for this example we fabricate a 100 item array
// (emulating a table with 100 records)
// and slice out our pagination range
// (emulating a LIMIT X,Y MySQL clause)
$_data = range(1, 100);
SmartyPaginate::setTotal(count($_data));
return array_slice($_data, SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
}
/**
* @return DB
*/
private function getDataRecords()
{
DateDataTypeHandler::$MASK_CUSTOM = 'Y-m-d';
ini_set('max_execution_time', 0);
$records = get_db_results(TRUE, $this->requestDataSet->name, $this->requestDataSet->columns, $this->requestDataSet->parameters, $this->requestDataSet->sortColumn, $this->requestDataSet->startWith, $this->requestDataSet->limit, NULL);
return $records;
}
die("Please use php-cli\n");
}
require "functions.php";
require "candidates.php";
require "settings.php";
restore_error_handler();
error_reporting(E_ALL);
ini_set('display_errors', 'On');
if (empty($settings['show_res_secret'])) {
die("Not configured\n");
}
if ($argv[2] != $settings['show_res_secret']) {
die("Usage: php show_res.php <mode> <secret>\n");
}
if ($argv[1] == "db") {
$res = get_db_results();
}
if ($argv[1] == "file") {
$res = get_file_results();
}
$res = transcode_results($res);
show_results($res);
exit;
function get_db_results()
{
$db = db_connect();
$res = $db->query("SELECT choice FROM ballot_box");
$out = array();
while ($obj = $res->fetch_object()) {
$out[] = $obj->choice;
}
