A convenient SELECT * function.
| public get ( string $tableName, integer | array $numRows = null, string $columns = '*' ) : array | ||
| $tableName | string | The name of the database table to work with. |
| $numRows | integer | array | Array to define SQL limit in format Array ($count, $offset) or only $count |
| $columns | string | Desired columns |
| return | array | Contains the returned rows from the select query. |
function GET()
{
$db = new MysqliDb($this->config["host"], $this->config["user"], $this->config["pass"], $this->config["base"]);
$results = $db->get('VIP');
if (!empty($results) && count($results) > 0) {
SimplestView::render('index', array("results" => $results));
}
}
$function = $_GET["function"];
if ($function == 'get') {
get();
}
}
function get()
{
$db = new MysqliDb();
$results = $db->rawQuery('select oferta_laboral_id, DATE_FORMAT(fecha,"%d-%m-%Y") fecha, titulo, detalle, cliente_id, status, 0 cliente from ofertas_laborales order by oferta_laboral_id desc');
foreach ($results as $key => $row) {
$db->where('cliente_id', $row["cliente_id"]);
function getSlider($conProductos)
{
$db = new MysqliDb();
// $results = $db->get('sliders');
// $results = $db->rawQuery('Select slider_id, o.producto_id producto_id, kit_id, precio, o.descripcion descripcion,
// imagen, titulo, p.nombre producto from sliders o inner join productos p on o.producto_id = p.producto_id;');
$results = $db->rawQuery('Select oferta_id slider_id, o.producto_id producto_id, kit_id, precio, o.descripcion descripcion,
imagen, titulo, 0 producto from ofertas o;');
if ($conProductos) {
foreach ($results as $key => $row) {
$db->where('producto_id', $row["producto_id"]);
$producto = $db->get('productos');
$results[$key]["producto"] = $producto;
}
}
echo json_encode($results);
}
/**
* Fetch all objects
*
* @access public
* @param integer|array $limit Array to define SQL limit in format Array ($count, $offset)
or only $count
* @param array|string $fields Array or coma separated list of fields to fetch
*
* @return array Array of dbObjects
*/
private function get($limit = null, $fields = null)
{
$objects = array();
$results = $this->db->get($this->dbTable, $limit, $fields);
foreach ($results as &$r) {
$this->processArrays($r);
$this->processWith($r);
if ($this->returnType == 'Object') {
$item = new static($r);
$item->isNew = false;
$objects[] = $item;
}
}
if ($this->returnType == 'Object') {
return $objects;
}
return $results;
}
/**
* send message to all users
* @param $text
* @param $chatid
* @param $status
* @param MysqliDb $db
* @param TelegramBot\Api\BotApi $bot
*/
function sendMessageToAll($text = null, $chatid, $status, $db, $bot)
{
//this is use for hide confirm keyboard
$hideKeys = new \TelegramBot\Api\Types\ReplyKeyboardHide(true);
if ($status == 1) {
//confirm keyboard
$keys = new \TelegramBot\Api\Types\ReplyKeyboardMarkup(array(array("بله", "خیر")), false, true, true);
if ($text == null) {
//admin is going to send next message and next message stored
$db->orderBy('ID', 'DESC');
$q = $db->getOne('nextMessages', array('text'));
$text = $q['text'];
}
$db->update('adminOperations', array('message' => $text));
$status = 2;
//admin get confirm
$msg = "پیام زیر برای همه کاربران ارسال خواهد شد. آیا برای ارسال پیامها اطمینان دارید؟\n\n";
$msg .= $text;
$bot->sendMessage($chatid, $msg, true, null, $keys);
} elseif ($status == 2 && $text == 'بله') {
//get all user and send message for them
$users = $db->get('users');
$db->orderBy('ID', 'DESC');
//custom message and next message temporary stored in adminOperations table
$q = $db->getOne('adminOperations', array('message'));
$message = $q['message'];
foreach ($users as $user) {
try {
$bot->sendMessage($user['ID'], $message);
} catch (Exception $e) {
error_log($e->getMessage());
}
}
$bot->sendMessage($chatid, 'پیام مورد نظر ارسال شد', true, null, $hideKeys);
$status = 0;
} else {
$bot->sendMessage($chatid, 'ارسال پیام لغو شد', true, null, $hideKeys);
$status = 0;
}
$db->update('adminOperations', array('send_status' => $status));
}
/**
* @descr Obtiene las pedidodetalles
*/
function getPedidosDetalles($pedido_id)
{
$db = new MysqliDb();
$db->where('pedido_id', $pedido_id);
$results = $db->get('pedidos_detalles');
echo json_encode($results);
}
function getNoticias()
{
$db = new MysqliDb();
$results = $db->rawQuery('Select noticia_id, titulo, detalles, fecha, creador_id, vistas, tipo, 0 fotos, 0 comentarios from noticias;');
foreach ($results as $key => $row) {
$db->where('noticia_id', $row["noticia_id"]);
$fotos = $db->get('noticias_fotos');
$results[$key]["fotos"] = $fotos;
$db->where('noticia_id', $row["noticia_id"]);
$comentarios = $db->get('noticias_comentarios');
$results[$key]["comentarios"] = $comentarios;
}
echo json_encode($results);
}
/**
* @Author: ananayarora
* @Date: 2016-01-14 20:08:08
* @Last Modified by: ananayarora
* @Last Modified time: 2016-01-14 23:41:31
*/
if (!isset($_GET['id'])) {
header("Location: index.php");
}
require 'header.php';
require 'conf.php';
require 'sql.php';
$c = new Conf();
$o = new MysqliDb($c->host, $c->username, $c->password, $c->db);
$o->where("id", $o->escape($_GET['id']));
$k = $o->get("startups");
?>
<center>
<div class="main_startup">
<div style='background-image:url("<?php
echo $k[0]['imageurl'];
?>
");' class="startup_photo"></div>
<div class="startup_details">
<h3 class="startup_name"><?php
echo $k[0]['name'];
?>
</h3>
<p class="oneliner"><?php
echo $k[0]['oneliner'];
?>
public function getUserReport($uid)
{
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$db->where('uid', $uid);
$db->orderBy("id", "Desc");
$result = $db->get("activities");
return $result;
}
<main class="mdl-layout__content">
<div class="discover">
<h1 class="discover-text">Discover</h1>
</div>
<div class="main-section">
<center>
</center>
<?php
require 'conf.php';
require 'sql.php';
$c = new Conf();
$o = new MysqliDb($c->host, $c->username, $c->password, $c->db);
$o->orderBy('timeadded', 'desc');
$k = $o->get('startups', 20);
foreach ($k as $key => $value) {
?>
<div class="mdl-card mdl-shadow--2dp startup-card">
<div class="mdl-card__title mdl-card--expand startup-image" style="background-image:url('<?php
echo $value['imageurl'];
?>
');">
<div class="startup-overlay"></div>
<h2 class="mdl-card__title-text startup-name"><?php
echo $value['name'];
?>
</h2>
</div>
<div class="mdl-card__supporting-text">
break;
case 'getContract':
$encrypt = new Encryption();
$id = $encrypt->decode($_GET['id']);
$db = new MysqliDb();
$db->where('id', $id);
$contracts = $db->getOne('contracts');
echo json_encode($contracts);
break;
case 'getContractByClient':
$encrypt = new Encryption();
$id = $encrypt->decode($_GET['id']);
$db = new MysqliDb();
$db->where('id', $id);
$cols = array("id", "ignitor_name", "ignitor_title", "client", "ignitor_email", "client_name", "client_title", "client_company", "client_name is not null as registed");
$contracts = $db->get('contracts', null, $cols);
echo json_encode($contracts);
break;
case 'saveToHistory':
$db = new MysqliDb();
//$db->where('id',$_GET['id']);
$data = array('doc_id' => $_POST['index'], 'contract_id' => $_POST['id'], 'content' => $_POST['content'], 'date' => date('Y-m-d H:i:s'));
$id = $db->insert('history', $data);
break;
case 'getContractContent':
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$contracts = $db->getOne('contracts');
echo json_encode($contracts);
break;
case 'getHistory':
if (!$setup['db_host'] || !$setup['db_user'] || !$setup['db_pswd'] || !$setup['db_name']) {
die('Holy hole in the plot, Batman! Joker\'s made a laugh of the config file!');
}
// MySQLi wrapper
require_once '../_system/MysqliDb.php';
$db = new MysqliDb($setup['db_host'], $setup['db_user'], $setup['db_pswd'], $setup['db_name']);
$db->setPrefix('grlx_');
// Grawlix db class
$db_ops = new GrlxDbOps($db);
// echo '<pre>$_SESSION|';print_r($_SESSION);echo '|</pre>';
/* ! Check security * * * * * * * */
if (!$except) {
if (!$_SESSION['admin']) {
header('location:panl.login.php?ref=' . $_SERVER['REQUEST_URI']);
die('no session');
} else {
$maybe_serial = $_SESSION['admin'];
$query = "SELECT id FROM user WHERE serial = '{$maybe_serial}'";
$db->where('serial', $maybe_serial);
$result = $db->get('user', null, 'id');
$maybe_admin = $result[0];
}
if (!$maybe_admin) {
header('location:panl.login.php');
die($query);
}
}
$frequency_list_init = display_pretty_publish_frequency();
// Get vital milieu data
$milieu_list = get_site_milieu($db);
header("Content-Type: text/html; charset=utf-8");
require_once 'constantes.php';
$bd = new MysqliDb(SERVER_DB_URL, SERVER_DB_USUARIO, SERVER_DB_PASS, SERVER_DB_NOMBRE);
if (!$bd->ping()) {
$bd->connect();
}
if ($_SERVER["REQUEST_METHOD"] == REQUEST_METODO_POST) {
$postdata = json_decode(file_get_contents('php://input'));
$usuario_form = $postdata->usuario;
$pass_form = md5($postdata->pass);
$bd->where(COLUMNA_EMAIL, $usuario_form);
$bd->where(COLUMNA_PASS, $pass_form);
if ($bd->has(TABLA_USUARIO)) {
// CORRECTO
$accion_form = $postdata->form_accion;
if ($accion_form == ACCION_OBTENER) {
$query = $bd->get(TABLA_PRODUCTO);
foreach ($query as $parametro_key => $parametro_valor) {
// AGREGOS LAS CATEGORIAS A LA QUE PERTENECE CADA PRODUCTO
$bd->where(COLUMNA_ID_PRODUCTO, $parametro_valor[COLUMNA_ID_M]);
$referencias = $bd->get(TABLA_REL_PRODUCTO_CATEGORIA);
$parametro_valor[VALOR_CATEGORIAS] = $referencias;
$query[$parametro_key] = $parametro_valor;
}
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
} else {
if ($accion_form == ACCION_AGREGAR) {
$data_post = $postdata->form_data;
if (!isset($data_post->FOTO)) {
$data_post->FOTO = NULL;
}
$datos = array(COLUMNA_NOMBRE => $data_post->NOMBRE, COLUMNA_DESCRIPCION => $data_post->DESCRIPCION, COLUMNA_ESTADO => $data_post->ESTADO, COLUMNA_FOTO => $data_post->FOTO, COLUMNA_MUESTRA_FULLSCREEN => $data_post->MUESTRA_FULLSCREEN, COLUMNA_MUESTRA_PRECIO => $data_post->MUESTRA_PRECIO);
require_once 'constantes.php';
$bd = new MysqliDb(SERVER_DB_URL, SERVER_DB_USUARIO, SERVER_DB_PASS, SERVER_DB_NOMBRE);
if (!$bd->ping()) {
$bd->connect();
}
if ($_SERVER['REQUEST_METHOD'] == REQUEST_METODO_POST) {
$postdata = json_decode(file_get_contents('php://input'));
$usuario_form = $postdata->usuario;
$pass_form = md5($postdata->pass);
$bd->where(COLUMNA_EMAIL, $usuario_form);
$bd->where(COLUMNA_PASS, $pass_form);
if ($bd->has(TABLA_USUARIO)) {
// CORRECTO
$accion_form = $postdata->form_accion;
if ($accion_form == ACCION_OBTENER) {
$query = $bd->get(TABLA_CATEGORIA);
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
} else {
if ($accion_form == ACCION_OBTERNER_POR_ID) {
$parametros = $postdata->form_parametros;
foreach ($parametros as $parametro_key => $parametro_valor) {
// var_dump($parametro_key);
// var_dump($parametro_valor);
foreach ($parametro_valor as $key => $val) {
// var_dump($key);
// var_dump($val);
switch ($key) {
case PARAMETRO_ID:
$bd->where(COLUMNA_ID, (int) $val);
break;
}
function changePassword($cliente_id, $pass_old, $pass_new)
{
$db = new MysqliDb();
$db->where('cliente_id', $cliente_id);
$results = $db->get("clientes");
if ($db->count > 0) {
$result = $results[0];
$options = ['cost' => 12];
$password = password_hash($pass_new, PASSWORD_BCRYPT, $options);
$db->where('cliente_id', $cliente_id);
$data = array('password' => $password);
if ($db->update('clientes', $data)) {
echo json_encode(1);
} else {
echo json_encode(-1);
}
} else {
echo json_encode(-1);
}
}
<?php
require_once 'includes/MysqliDb.php';
$db = new MysqliDb('localhost', 'root', '', 'madeinnrb');
$startups = $db->get('startups');
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Made in Nairobi</title>
<link href="css/nairobi.css" rel="stylesheet" type="text/css" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
</head>
<body>
<?php
include 'expanding.php';
?>
<article>
<ol>
<?php
foreach ($startups as $startup) {
?>
<li>
<a href="<?php
echo $startup['website'];
?>
" target="_blank"><?php
echo $startup['company_name'];
header('Content-type: text/html; charset=utf-8');
require __DIR__ . '/vendor/autoload.php';
$params = array_merge(require __DIR__ . '/config.php');
$fmt = datefmt_create('ru_RU', IntlDateFormatter::SHORT, IntlDateFormatter::SHORT, 'UTC', IntlDateFormatter::GREGORIAN);
$db = new MysqliDb($params['db_config']);
echo '<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>';
echo '<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/themes/smoothness/jquery-ui.css">';
echo '<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>';
/*
action block's
*/
if (isset($_GET['bank']) and $_GET['bank'] != null) {
echo "<a href='#' onclick='history.back()'>Вернуться назад</a> <br />";
$db->where("bank_id", $_GET['bank']);
$provodki = $db->get("provodki");
echo '<table class="td-prov"><tbody><tr><td>Дата</td><td>Коментарий</td><td>Сумма</td></tr></tbody>';
if ($db->count > 0) {
foreach ($provodki as $prov) {
$date = datefmt_format($fmt, $prov['date']);
echo "<tr><td>{$date}</td><td>{$prov['com']}</td><td>{$prov['sum']}</td>";
}
}
echo '</table>';
$db->where("bank_id", $_GET['bank']);
$sum = $db->getValue("provodki", "sum(sum)");
echo "Итого: {$sum} <br />";
die;
}
//end if(isset($_GET['bank']) and $_GET['bank']!=null)
if (isset($_GET['edit_sob'])) {
<?php
require_once 'inc/MysqliDb.php';
require_once 'inc/HtmlDiff.php';
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$history = $db->getOne('history');
$db->where('contract_id', $history['contract_id']);
$db->where('doc_id', $history['doc_id']);
$historys = $db->get('history');
if (!isset($_GET['toid']) || $_GET['toid'] == null || $_GET['toid'] == "" || $_GET['toid'] == 0) {
$db->where('id', $history['contract_id']);
$contracts = $db->getOne('contracts');
$index = $history['doc_id'];
$contract_content = json_decode($contracts['content']);
$to_text = $contract_content[$index]->content;
} else {
$db->where('id', $_GET['toid']);
$to_history = $db->getOne('history');
$to_text = $to_history['content'];
}
$from_text = $history['content'];
// $opcodes = FineDiff::getDiffOpcodes($from_text, $to_text);
// echo FineDiff::renderDiffToHTMLFromOpcodes($from_text, $opcodes);
$diff = new HtmlDiff($from_text, $to_text);
$diff->build();
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script type="text/javascript" src="../assets/js/jquery/jquery-1.7.1.min.js"></script>
function getNoticias()
{
$db = new MysqliDb();
$results = $db->rawQuery('Select noticia_id, titulo, subtitulo, link, detalles, fecha, creador_id, vistas, tipo, 0 fotos, 0 comentarios from noticias order by noticia_id desc;');
foreach ($results as $key => $row) {
$db->where('noticia_id', $row["noticia_id"]);
$fotos = $db->get('noticias_fotos');
$results[$key]["fotos"] = $fotos;
$sql_comment = 'SELECT noticia_comentario_id, noticia_id,titulo,detalles,parent_id,creador_id,0 creador,votos_up,votos_down,fecha FROM noticias_comentarios WHERE noticia_id = ' . $row["noticia_id"] . ';';
$comentarios = $db->rawQuery($sql_comment);
foreach ($comentarios as $keyComment => $rowComment) {
$db2 = new MysqliDb();
$db2->where('cliente_id', $rowComment['creador_id']);
$cliente = $db2->get('clientes');
$comentarios[$keyComment]['creador'] = $cliente;
}
$results[$key]["comentarios"] = $comentarios;
}
echo json_encode($results);
}
/**
* @descr Obtiene los productos. En caso de enviar un usuario_id != -1, se traerán todos los carritos. Solo usar esta opción cuando se aplica en la parte de administración
*/
function getCarritos($usuario_id)
{
$db = new MysqliDb();
if ($usuario_id != -1) {
$db->where('c.usuario_id', $usuario_id);
}
$db->join("usuarios u", "u.usuario_id=c.usuario_id", "LEFT");
$results = $db->get('carritos c', null, 'c.carrito_id, c.status, c.total, c.fecha, c.usuario_id, u.nombre, u.apellido');
foreach ($results as $key => $row) {
$db = new MysqliDb();
$db->where('carrito_id', $row['carrito_id']);
$db->join("productos p", "p.producto_id=c.producto_id", "LEFT");
$productos = $db->get('carrito_detalles c', null, 'c.carrito_detalle_id, c.carrito_id, c.producto_id, p.nombre, c.cantidad, c.en_oferta, c.precio_unitario');
$results[$key]['productos'] = $productos;
}
echo json_encode($results);
}
<?php
require "/nfs/users/clind/public_html/prescriptiontrails.org/admin/db.php";
$adminPage = true;
require "/nfs/users/clind/public_html/prescriptiontrails.org/src/secure.php";
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$cols = array("id", "fname", "lname", "email", "is_verified", "is_active", "is_admin");
$result = $db->get("users", null, $cols);
$final = array();
foreach ($result as $id => $user) {
if ($user['is_verified'] == 1) {
$verified = "Verified";
} else {
$verified = "Unverified";
}
if ($user['is_active'] == 1) {
$active = "Active";
} else {
$active = "Inactive";
}
if ($user['is_super'] == 1) {
$type = "SuperUser";
} elseif ($user['is_admin'] == 1) {
$type = "Admin";
} else {
$type = "User";
}
$newentry = array("id" => $user['id'], "fname" => $user['fname'], "lname" => $user['lname'], "email" => $user['email'], "verified" => $verified, "status" => $active, "permissions" => $type);
array_push($final, $newentry);
}
$return = array("data" => $final);
function getCupones($cliente_id, $numero)
{
$db = new MysqliDb();
$db->join("clientes c", "c.cliente_id=u.cliente_id", "LEFT");
if ($cliente_id != -1) {
$db->where('u.cliente_id', $cliente_id);
}
if ($numero != -1) {
$db->where('c.numero', $numero);
}
$result = $db->get('cupones u', null, 'u.numero, u.fecha, c.mail');
echo json_encode($result);
}
function changePassword($usuario_id, $pass_old, $pass_new)
{
$db = new MysqliDb();
$db->where('usuario_id', $usuario_id);
$results = $db->get("usuarios");
if ($db->count > 0) {
$result = $results[0];
if ($pass_old == '' || password_verify($pass_old, $result['password'])) {
$options = ['cost' => 12];
$password = password_hash($pass_new, PASSWORD_BCRYPT, $options);
$db->where('usuario_id', $usuario_id);
$data = array('password' => $password);
if ($db->update('usuarios', $data)) {
echo json_encode(1);
} else {
echo json_encode(-1);
}
}
} else {
echo json_encode(-1);
}
}
/**
* @description Retorna las donaciones, en caso de ser la consulta de un usuario, solo trae las del usuario
* @param $usuario_id
*/
function getDonaciones($usuario_id)
{
$db = new MysqliDb();
$where = '';
if ($usuario_id != -1) {
$where = 'c.donador_id in (select usuario_id from proyectos p1 where p1.proyecto_id = p.proyecto_id)';
}
$results = $db->rawQuery('donaciones c', null, 'c.donacion_id, c.status, c.total, c.fecha, c.usuario_id, u.nombre, u.apellido');
foreach ($results as $key => $row) {
$db = new MysqliDb();
$db->where('donacion_id', $row['donacion_id']);
$db->join("proyectos p", "p.proyecto_id=c.proyecto_id", "LEFT");
$proyectos = $db->get('donacion_detalles c', null, 'c.donacion_detalle_id, c.donacion_id, c.proyecto_id, p.nombre, c.cantidad, c.en_oferta, c.precio_unitario');
$results[$key]['proyectos'] = $proyectos;
}
echo json_encode($results);
}
?>
<div id="playView">
<div id="msgPanel" class="ui-widget-content">
<h3 class="ui-widget-header">Communicator</h3>
<div id="msgTabs">
<ul>
<li>
<a href="#chatPane">Chat</a>
</li>
<li>
<a href="#pmPane">Private Message</a>
</li>
</ul>
<div id="chatPane">
<?php
$posts = $db->get('Posts');
foreach ($posts as $x) {
echo '<label><font color="blue">' . $db->where('id', $x['uId'])->getOne('Users')['fName'] . '</font></label>:<span> ' . $x['message'] . '</span><br />' . "\n";
}
?>
</div>
<div id="pmPane">
<div id="pmAccordion">
<?php
$members = $db->where('pId', '0')->get('Parties');
foreach ($members as $member) {
echo '<h4>' . $db->where('id', $member['uId'])->getOne('Users')['fName'] . "</h4>\n<div></div>\n";
}
?>
<h4>Eric Collett</h4>
<div></div>
* @Date: 2016-01-10 14:28:50
* @Last Modified by: ananayarora
* @Last Modified time: 2016-01-10 21:22:46
*/
session_start();
if (isset($_SESSION['loggedin'])) {
header("Location: discover.php");
}
if (isset($_POST['submit'])) {
require 'conf.php';
require 'sql.php';
$c = new Conf();
$o = new MysqliDb($c->host, $c->username, $c->password, $c->db);
$o->where("username", $_POST['username']);
$o->where("password", md5($_POST['password']));
$o->get("users");
if ($o->count == 1 && !isset($_GET['next'])) {
header("Location: discover.php");
$_SESSION['loggedin'] = true;
$_SESSION['username'] = $_POST['username'];
} elseif ($o->count == 1 && isset($_GET['next'])) {
header("Location: " . $_GET['next']);
$_SESSION['loggedin'] = true;
$_SESSION['username'] = $_POST['username'];
} elseif ($o->count == 0 && !isset($_GET['next'])) {
header("Location: signin.php?wrong");
} elseif ($o->count == 0 && isset($_GET['next'])) {
header("Location: signin.php?wrong&next=" . $_GET['next']);
}
}
require "header.php";
/**
* @description Obtiene las sucursales
*/
function getSucursales()
{
$db = new MysqliDb();
$results = $db->get('sucursales');
echo json_encode($results);
}
</li>
</ul>
</div>
<!-- /#sidebar-wrapper -->
<!-- Page Content -->
<div id="page-content-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1>Previous games</h1>
<?php
date_default_timezone_set('UTC');
$db = new MysqliDb('localhost', 'root', '', 'golf-cards');
$cols = array("friendly_name", "max_round", "game_id ");
$result = $db->get("game_names", null, $cols);
?>
<table class="table table-striped">
<thead>
<tr>
<th>Game Name</th>
<th>Highest round played</th>
<th>Date game was played</th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($result); $i++) {
?>
<tr>
<?php
require_once 'inc/MysqliDb.php';
require_once 'inc/Encryption.php';
ini_set("memory_limit", "200M");
$db = new MysqliDb();
$db->orderBy("id", "Desc");
$contracts = $db->get('contracts');
$encrypt = new Encryption();
?>
<!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">
<meta name="description" content="contract generater for ignitorlabs">
<meta name="author" content="anyun">
<title>Contract List</title>
<!-- Bootstrap core CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<!-- Custom styles for this template -->
<link href="//cdn.datatables.net/1.10.2/css/jquery.dataTables.css" rel="stylesheet">
<script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
<script src="//cdn.datatables.net/1.10.2/js/jquery.dataTables.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
</head>