function getListComposersDb()
{
    $db = new MysqliDb(HOST, USER, PASSWORD, DBNAME);
    $query = "SELECT * FROM composers";
    $composers = $db->rawQuery($query);
    return $composers;
}

 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));
     }
 }

        echo json_encode(true);
    } else {
        echo json_encode(false);
    }
}
function update($item)
{
    $db = new MysqliDb();
    $decoded = json_decode($item);
    $db->where('revista_id', $decoded->revista_id);
    $data = array('nombre' => $decoded->nombre, 'link' => $decoded->link);
    if ($db->update('revistas', $data)) {

 function GET($matches)
 {
     if ($matches[1]) {
         $db = new MysqliDb($this->config["host"], $this->config["user"], $this->config["pass"], $this->config["base"]);
         $results = $db->where('idphoto', $matches[1])->get('photo', 1);
         if (!empty($results) && count($results) > 0) {
             header("Content-Type: image/jpg");
             header("Content-Length: " . strlen($results[0]["contenu"]));
             echo $results[0]["contenu"];
         }
     }
 }

        echo json_encode(true);
    } else {
        echo json_encode(false);
    }
}
/**
 * esta funcion me retorna un cliente filtrando x email
 * @param $email
 */
function update($item)
{
    $db = new MysqliDb();
    $decoded = json_decode($item);

function insertCompositionsOnDB()
{
    $composers = getListComposers();
    foreach ($composers as $index => $composer) {
        $slug = getSlugComposer($composer);
        $relevance = $index + 1;
        $db = new MysqliDb(HOST, USER, PASSWORD, DBNAME);
        $query = "INSERT INTO `composers`(`slug`,`name`,`relevance`)";
        $query .= " VALUES ('" . $slug . "','" . $composer . "','" . $relevance . "');";
        echo $query . PHP_EOL;
        $db->rawQuery($query);
    }
}

function order_paid()
{
    require_once './submodules/php-mysqli-database-class/MysqliDb.php';
    require './includes/config.php';
    $db = new MysqliDb($db_host, $db_user, $db_pass, $db_name);
    $payid = $_GET['out_trade_no'];
    $aPayId = explode('_', $payid);
    $mtrid = $aPayId[1];
    $params = json_encode($_GET);
    //验证是否已经支付过
    $db->where("mtr_id = '{$mtrid}'")->get('mark_trafficpolice_reward');
    if ($db->count == 0) {
        $aNew = array('mtr_id' => $mtrid, 'pay_id' => $payid, 'pay_success' => 1, 'pay_money' => $_GET['total_fee'], 'pay_date' => $_GET['gmt_payment'], 'pay_params' => $params, 'created_date' => $db->now());
        $id = $db->insert('mark_trafficpolice_reward', $aNew);
        //给用户增加余额
        $sql = "SELECT mt.user_id,u.user_money FROM `mark_trafficpolice` mt\n            LEFT JOIN mark_trafficpolice_received mtr ON mt.id=mtr.mt_id\n            LEFT JOIN users u ON u.user_id=mt.user_id\n            WHERE mtr.id= '{$mtrid}'";
        $aUser = $db->rawQuery($sql);
        if ($db->count) {
            $aUpdate = array('user_money' => $aUser[0]['user_money'] + $_GET['total_fee'], 'updated_date' => $db->now());
            $db->where('user_id', $aUser[0]['user_id']);
            $db->update('users', $aUpdate);
        }
    } else {
        echo "already rewarded";
    }
}

 public static function getInstance($dbKey = 'DB')
 {
     if (array_key_exists($dbKey, self::$db)) {
         return self::$db[$dbKey];
     } else {
         $newdb = new MysqliDb($dbKey);
         if ($newdb->connect()) {
             self::$db[$dbKey] = $newdb;
             return $newdb;
         } else {
             return false;
         }
     }
 }

function insertComposersOnDB()
{
    $db = new MysqliDb(HOST, USER, PASSWORD, DBNAME);
    $composers = getListComposersDb();
    foreach ($composers as $index => $composer) {
        $compositions = extractCompositionsFromSearchHtmls($composer['name']);
        foreach ($compositions as $composition) {
            echo "Inserting " . $composition . "..." . PHP_EOL;
            $relevance = $index + 1;
            $query = "INSERT INTO `compositions`(`composer_id`,`name`,`relevance`)";
            $query .= " VALUES ('" . $composer['id'] . "','" . escapeSingleQuote($composition) . "','" . $relevance . "');";
            $db->rawQuery($query);
        }
    }
}

function showzx()
{
    $zid = req('zid');
    $start = req('start', 0);
    $perpage = req('perpage', 0);
    if ($start < 0) {
        $start = 0;
    }
    if (empty($perpage)) {
        $perpage = 30;
    }
    if (empty($zid)) {
        showjson('zid_not_exist');
    }
    $db = MysqliDb::getInstance();
    $data = $db->rawQueryOne("SELECT z.*, u.username FROM zixun z LEFT JOIN users u ON z.uid=u.uid WHERE z.zid='{$zid}'");
    if ($db->count > 0) {
        $db->where("zid", $zid);
        $stats = $db->getOne("comment", "count(*) as cnt");
        $data['total'] = $stats['cnt'];
        //if($start>=$data['total']) $start=0;
        $comment = $db->rawQuery("SELECT c.*,s.username FROM comment c LEFT JOIN users s ON c.uid=s.uid WHERE c.zid='{$zid}' ORDER BY c.cid LIMIT {$start},{$perpage}");
        $data['count'] = $db->count;
        $data['comment'] = $comment;
        showjson('do_success', 0, array("zixun" => $data));
    }
    showjson('show_error');
}

function saveSlider($slider)
{
    $db = new MysqliDb();
    $item_decoded = $slider;
    //    $fotos_decoded = json_decode($producto->fotos);
    $db->where('oferta_id', $item_decoded->slider_id);
    $data = array('producto_id' => $item_decoded->producto_id, 'precio' => $item_decoded->precio, 'descripcion' => $item_decoded->descripcion, 'imagen' => $item_decoded->imagen, 'titulo' => $item_decoded->titulo);
    $results = $db->update('ofertas', $data);
    $res = ['status' => 1, 'results' => 0];
    echo json_encode($results);
    if ($results) {
        $res["results"] = $results;
        echo json_encode($res);
    } else {
        $res->status = 0;
        echo $res;
    }
}

 public function __construct()
 {
     /** @var array $db */
     include_once 'config.php';
     require_once 'PHP-MySQLi-Database-Class-master/MysqliDb.php';
     new MysqliDb($db);
     $this->db_instance = MysqliDb::getInstance();
     $this->db_config = $db;
 }

 /**
  * constructor
  *
  * @param string $type tipo de datamanager a ser incializado
  *
  * inicializa o objeto de log e de bd
  * inicializa o vetor de dados nulo de acordo com o tipo
  */
 function __construct($type)
 {
     $this->db = MysqliDb::getInstance();
     $this->log = Log::getInstance();
     //tipo de dado valido pra iniciar
     if (array_key_exists($type, $this->_validFields)) {
         $this->type = $type;
         foreach ($this->_validFields[$this->type] as $key => $value) {
             $this->setField($key, null);
         }
     }
 }

 public function routeToCrm($host, $username, $password, $databaseName)
 {
     if (isset($_COOKIE['username'])) {
         $user = $_COOKIE['username'];
     }
     if (isset($_COOKIE['mdp'])) {
         //Récupération du mot de passe stocké
         $db = new MysqliDb($host, $username, $password, $databaseName);
         $db->where("user_name", $user);
         $users = $db->getOne("users");
         $pwd = $users['user_hash'];
         // Création du mot de passe hashé
         // $mdp = crypt(strtolower($_COOKIE['mdp']),$pwd);
         $mdp = $_COOKIE['mdp'];
     }
     // Login au CRM
     $url = "http://localhost/mysite/crm74/service/v4_1/soap.php?wsdl";
     require_once "../crm74/include/nusoap/lib/nusoap.php";
     //retrieve WSDL
     $client = new nusoap_client($url, 'wsdl');
     $proxy = $client->getProxy();
     //Affichage des erreurs
     $err = $client->getError();
     if ($err) {
         echo '<h2>Erreur du constructeur</h2><pre>' . $err . '</pre>';
         echo '<h2>Debug</h2><pre>' . htmlspecialchars($client->getDebug(), ENT_QUOTES) . '</pre>';
         exit;
     }
     // login ----------------------------------------------------
     $login_parameters = array('user_auth' => array('user_name' => $user, 'password' => $mdp, 'version' => '1'), 'application_name' => 'SugarTest');
     $login_result = $client->call('login', $login_parameters);
     echo '<pre>';
     //get session id
     $session_id = $login_result['id'];
     $result = $proxy->seamless_login($session_id);
     // Ouverture de la session SuiteCRM
     header("Location: http://localhost/mysite/crm74/index.php?module=Administration&action=index&MSID={$session_id}");
 }

/**
 * Created by PhpStorm.
 * User: André
 * Date: 01/04/2015
 * Time: 13:57
 */
function buildOutput($data, $debug = false)
{
    $log = Log::getInstance();
    $db = MysqliDb::getInstance();
    $output = array();
    if ($log->countErrors() > 0) {
        $errors = $log->getErrors();
    }
    $output = $data;
    if (isset($errors) && sizeof($errors) > 0) {
        $output['_ERROR_'] = $errors;
    }
    if ($debug == 'true') {
        $output['_DEBUG_'] = $log->getLogs();
    }
    echo json_encode($output, JSON_PRETTY_PRINT);
}

function login()
{
    $password = req('password');
    $username = req('username');
    $db = MysqliDb::getInstance();
    if ($password && $username) {
        $db->where('username', $username);
        if ($user = $db->getOne('users')) {
            if ($user['password'] == $password) {
                $auth = authcode("{$user['password']}\t{$user['uid']}", 'ENCODE');
                showjson('do_success', 0, array("auth" => rawurlencode($auth)));
            }
            showjson('password_error');
        }
    }
    showjson('login_error');
}

function checkauth()
{
    global $_SGLOBAL;
    $auth = req('auth');
    if ($auth) {
        $db = MysqliDb::getInstance();
        @(list($password, $uid) = explode("\t", authcode($auth, 'DECODE')));
        $_SGLOBAL['uid'] = intval($uid);
        if ($password && $_SGLOBAL['uid']) {
            $db->where('uid', $_SGLOBAL['uid']);
            if ($user = $db->getOne('users')) {
                if ($user['password'] == $password) {
                    $_SGLOBAL['usertype'] = $user['usertype'];
                    $_SGLOBAL['username'] = $user['username'];
                    return;
                }
            }
        }
    }
    showjson('to_login');
}

function comment()
{
    global $_SGLOBAL;
    checkauth();
    //验证登陆
    $op = req('op');
    $db = MysqliDb::getInstance();
    if ($op == 'add') {
        $setarr = array('uid' => $_SGLOBAL['uid']);
        $setarr['message'] = req('message');
        $setarr['zid'] = req('zid', 0);
        if ($setarr['message'] && $setarr['zid']) {
            $id = $db->insert('comment', $setarr);
            //插入数据
            if ($id) {
                showjson('do_success', 0, array("cid" => $id));
            }
            showjson('submit_comment_error');
        }
        showjson('zid_or_message_can_not_empty');
    } elseif ($op == 'del') {
        $cid = req('cid', 0);
        if (empty($cid)) {
            showjson('non_normal_operation');
        }
        $db->where('cid', $cid);
        if ($_SGLOBAL['usertype'] == 1) {
            //是否管理员
        } else {
            $db->where('uid', $_SGLOBAL['uid']);
        }
        $result = $db->delete('comment');
        //删除评论
        if ($result) {
            showjson('do_success', 0);
        }
        showjson('comment_not_exist');
    }
}

<?php

require "../db.php";
$adminPage = true;
require "../../src/secure.php";
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if (empty($_POST['desc']) || empty($_POST['surface']) || empty($_POST['parking']) || empty($_POST['facilities'])) {
    header("Location: " . $baseurl . "admin/translate/?error=true&id=" . $_POST['id'] . "&lang=" . $_POST['lang']);
    exit;
}
$id = $_POST['id'];
$lang = $_POST['lang'];
$facilities = $_POST['facilities'];
$lighting = $_POST['lighting'];
$surface = $_POST['surface'];
$transit = $_POST['transit'];
$parking = $_POST['parking'];
$desc = rawurlencode($_POST['desc']);
$hours = $_POST['hours'];
$loopcount = $_POST['loopcount'];
$attractioncount = $_POST['attractioncount'];
$postaction = $_POST['postaction'];
$trans_id = $_POST['trans_id'];
$attractions = array();
$i = 0;
while ($i <= $attractioncount) {
    array_push($attractions, rawurlencode($_POST['attraction' . $i]));
    $i++;
}
$loops = array();
$i = 1;

                <li>
                    <a href="about.html">About</a>
                </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++) {
    ?>