function uniqueName($table, $field, $name, $error)
{
$db = new Database();
$result = $db->Select($table, ['*'], [$field => $name]);
if (count($result) != 0) {
return '<div class="errorfunc"> </div>';
} else {
return true;
}
}
private function setPermissions($idu)
{
$db = new Database();
$res = $db->Select('permissions', ['*'], ['idu' => $idu]);
$returning = [];
foreach ($res as $index => $array) {
foreach ($array as $k => $v) {
if ($k != 'idperm' && $k != 'idu') {
$returning[$k] = $v;
}
}
}
return $returning;
}
/**
* Returns photos per QUERY, privacy, and paging restrictions
*
* @access public
* @return Photo[]
*/
public function getPhotos()
{
$sort = $this->photoSortSqlForOption($this->sort);
$condition = $this->whereRestriction;
if (!$this->showPrivatePhotos) {
$condition .= ' AND status = 0';
}
$query = Database::Select('ratings', 'photos.id', $condition, 'ORDER BY ' . $sort . ' ' . 'LIMIT ' . $this->offset . ',' . $this->pageSize, 'LEFT JOIN photos ON ratings.id = photos.id
LEFT JOIN exif ON photos.id=exif.photoid and exif.tag="Date taken"');
$photos = array();
while ($row = $query->fetchAssoc()) {
$photos[] = Photo::getPhotoWithID($row['id']);
}
return $photos;
}
<?php
require_once 'lib/cushion.class.php';
$srv = new Server();
$db1 = Database::Select($srv, 'db1', true);
$designdoc = $db1->GetDesignDocument('testing');
$view = $designdoc->GetView('all');
print_r($view->Map());
} else {
$tmp .= ')';
}
$cnt++;
}
$inserts .= $tmp;
if ($db->NonResultQuery($inserts)) {
echo 'OK';
} else {
echo 'ERROR';
}
}
if ($action == 'selectpayment') {
$names = explode(' ', $_GET['student']);
$result = "";
$student = $db->Select('students', ['cisco', 'www', 'cisco_group', 'www_group'], ['name' => $names[0], 'surname' => $names[1]]);
foreach ($student as $index => $arr) {
foreach ($arr as $k => $v) {
if ($k === 'cisco' && $v !== '') {
$flag1 = true;
} else {
if ($k === 'cisco' && $v === '') {
$flag1 = false;
}
}
if ($k === 'www' && $v !== '') {
$flag2 = true;
} else {
if ($k === 'www' && $v === '') {
$flag2 = false;
}
<?php
require_once "../Engine/DatabaseClass.php";
echo "Testes usuarios<br><br>";
$data = new Database("localhost", "root", "root", "");
echo "Teste INSERT:<br>";
$params = array("Parametro1" => "1", "Parametro2" => "2");
$data->Insert("teste", $params);
echo "<br><br>";
echo "Teste DELETE<br>";
$where_clauses = array("Parametro1" => "1", "Parametro2" => "2");
$union_clauses = array("AND");
$data->Delete("teste", $where_clauses, $union_clauses);
echo "<br><br>";
echo "Teste UPDATE<br>";
$values = array("Nome" => "Jose", "Idade" => "20");
$where_clauses = array("Parametro1" => "1", "Parametro2" => "2");
$union_clauses = array("AND");
$data->Update("teste", $values, $where_clauses, $union_clauses);
echo "<br><br>";
echo "Teste SELECT<br>";
$where_clauses = array("Parametro1" => "1", "Parametro2" => "2");
$union_clauses = array("AND");
$data->Select("teste", null, $where_clauses, $union_clauses);
echo "<br><br>";
echo "Teste SELECT 2<br>";
$cols = array("nome", "idade");
$where_clauses = array("Parametro1" => "1", "Parametro2" => "2");
$union_clauses = array("AND");
$data->Select("teste", $cols, $where_clauses, $union_clauses);
<?php
require_once '../lib/cushion.class.php';
try {
# GET http://localhost:5984/test
$db1 = Database::Select(new Server(), 'test', true);
# GET /test/_design/testing
$designdoc = $db1->CreateDesignDocument('testing', array('all' => array('map' => 'function() { emit(null, doc); }', 'reduce' => 'function(keys, values) { return keys.length; }')));
# GET /test/_design/testing/view/all
$view = $designdoc->GetView('all');
# GET /test/_design/testing/view/all
print_r($view->Map());
# GET /test/_design/testing/view/all?reduce=true
print_r($view->Reduce());
} catch (CouchException $e) {
echo $e->__toString();
}
/**
* Returns photos per QUERY, privacy, and paging restrictions
*
* @access public
* @return Photo[]
*/
public function getPhotos()
{
$sort = $this->photoSortSqlForOption($this->sort);
$conditions = array();
$binds = array();
foreach (preg_split('/\\s+/', $this->query) as $i => $queryPart) {
$conditions[$i] = "(description LIKE :{$i} OR keywords LIKE :{$i})";
$binds[$i] = '%' . $queryPart . '%';
}
if (!$this->showPrivatePhotos) {
$conditions[] = 'status = 0';
}
$query = Database::Select('photos', 'id', implode(' AND ', $conditions), 'ORDER BY ' . $sort . ' ' . 'LIMIT ' . $this->offset . ',' . $this->pageSize, 'LEFT JOIN exif ON photos.id=exif.photoid and exif.tag="Date taken"', $binds);
$photos = array();
while ($row = $query->fetchAssoc()) {
$photos[] = Photo::getPhotoWithID($row['id']);
}
return $photos;
}
static function GetUsers()
{
if (Authentication::IsLogged()) {
$id = Session::Get('current_user')->Get('id');
}
$db = new Database();
$users = array();
$db->Select();
if (isset($id)) {
$db->Where('id', $id, '!=');
}
$result = $db->Get(Config::Get('db.table'));
if ($result) {
foreach ($result as $value) {
$users[] = new User($value);
}
return $users;
}
return false;
}
private function Validator($name, $rules = array())
{
$value = array_shift($rules);
foreach ($rules as $rule => $rule_val) {
switch ($rule) {
case 'required':
if ($rule_val && empty($value)) {
Error::Set($name, $name . 'required');
return false;
}
break;
case 'min':
if (strlen($value) < $rule_val) {
Error::Set($name, $name . 'min');
return false;
}
break;
case 'max':
if (strlen($value) > $rule_val) {
Error::Set($name, $name . 'max');
return false;
}
break;
case 'unique':
$db = new Database();
if ($db->Select($name)->Where($name, $value)->Limit(1)->Get($rule_val)) {
Error::Set($name, $name . 'unique');
return false;
}
break;
case 'match':
if ($value !== $rule_val) {
Error::Set($name, $name . 'match');
return false;
}
break;
case 'contents':
switch ($rule_val) {
case 'nospecialchar':
if (!preg_match('/^[a-zA-Z0-9]+[a-zA-Z0-9\\_\\.]+[a-zA-Z0-9]+$/i', $value)) {
Error::Set($name, $name . 'contents');
return false;
}
break;
case 'email':
if (!filter_var($value, FILTER_VALIDATE_EMAIL)) {
Error::Set($name, $name . 'contents');
return false;
}
break;
case 'alphanumeric':
if (!ctype_alnum($value)) {
Error::Set($name, $name . 'contents');
return false;
}
break;
case 'numeric':
if (!ctype_digit($value)) {
Error::Set($name, $name . 'contents');
return false;
}
break;
default:
return false;
break;
}
break;
default:
return false;
break;
}
}
return true;
}
<?php
$menu_arr = "";
$db = new Database();
$menu_arr = $db->Select('left_menu', ['display_string', 'page_scheme']);
$menu_show = $db->Select('users', ['display_lm']);
$db->Disconnect();
?>
<div id="left-sidebar" data-show="<?php
echo $menu_show[0]['display_lm'];
?>
">
<ul>
<?php
foreach ($menu_arr as $item) {
$active = "";
if (isset($_GET['page']) && $_GET['page'] == $item['page_scheme']) {
$active = 'class="active"';
}
if ($user->getPermissions()['isGm'] || $user->getPermissions()[$item['page_scheme']]) {
echo '<li ' . $active . '><a href="index.php?page=' . $item['page_scheme'] . '">' . $item['display_string'] . '</a></li>';
}
}
?>
</ul>
</div>
public function DatabaseSelect($name, $create = false)
{
return Database::Select($this, $name, $create);
}
<?php
include 'classes/Database.php';
include 'classes/User.php';
session_start();
if (isset($_POST['submit']) && !isset($_SESSION['user'])) {
$db = new Database();
$login = $_POST['usrnm'];
$passwd = $_POST['passwd'];
$result = $db->Select("users", ['idu', 'password'], ['login' => $login], "", "1");
if (empty($result)) {
header('location: enter.php');
die;
}
if (password_verify($passwd, $result[0]['password'])) {
$user = new User($result[0]['idu']);
$_SESSION['user'] = serialize($user);
}
$db->Disconnect();
}
if (isset($_SESSION['user'])) {
header("location: index.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Admin Login</title>
<meta name="application-name" content="LAI_v2.0">
