PHP medoo::count方法代码示例

 /**
  * @param      $table
  * @param null $where
  * @return int
  */
 public function count($table, $where = NULL)
 {
     if (empty($this->_reader)) {
         return $this->_writer->count($table, $where);
     } else {
         return $this->_reader->count($table, $where);
     }
 }

 function login()
 {
     if (session_id() == '') {
         session_start();
     }
     if (isset($_POST["mail"]) & isset($_POST["password"]) & isset($_POST["cre"])) {
         if ($_POST["mail"] != "" and $_POST["password"] != "" and $_POST["cre"] != "") {
             $mail = $_POST["mail"];
             $password = $_POST["password"];
             $role = $_POST["cre"];
             require_once 'SessionManager.php';
             $session_manager = new SessionManager();
             require_once 'medoo.min.php';
             $database = new medoo();
             $count = $database->count("triotrack_users", ["email" => "{$mail}"]);
             if ($count > 0) {
                 $profile = $database->get("triotrack_users", ["username", "password", "salt", "client"], ["email" => "{$mail}"]);
                 if ($role === "admin") {
                     if ($profile["password"] === sha1($password . $profile["salt"])) {
                         $username = $profile["username"];
                         $client = $profile["client"];
                         $cookie = array("email" => "{$mail}", "username" => "{$username}", "password" => "{$password}", "client" => "{$client}", "role" => "{$role}");
                         $encoded_cookie = $session_manager->encode_session(json_encode($cookie));
                         $_SESSION["user_id"] = $encoded_cookie;
                         setcookie("user_id", $encoded_cookie, time() + 86400 * 1, "/");
                         // 86400 = 1 day
                         echo "admin";
                         exit;
                     } else {
                         echo "failed";
                         exit;
                     }
                 } else {
                     if ($profile["client"] === $password) {
                         $username = $profile["username"];
                         $client = $profile["client"];
                         $cookie = array("email" => "{$mail}", "username" => "{$username}", "password" => "{$password}", "client" => "{$client}", "role" => "{$role}");
                         $encoded_cookie = $session_manager->encode_session(json_encode($cookie));
                         $_SESSION["user_id"] = $encoded_cookie;
                         setcookie("user_id", $encoded_cookie, time() + 86400 * 1, "/");
                         // 86400 = 1 day
                         echo "client";
                         exit;
                     } else {
                         echo "failed";
                         exit;
                     }
                 }
             }
         } else {
             echo "failed";
         }
         exit;
     }
 }

    }
    if (!preg_match("/^[0-9a-zA-ZÄÜÖ_.-]+@[0-9a-z.-]+\\.[a-z]{2,6}\$/", $email)) {
        $fehler['email'] = "<font color=#cc3333>Please enter a <strong>e-mail-address</strong>.\n<br /></font>";
    }
    if (!$password) {
        $fehler['password'] = "<font color=#cc3333>Please enter your Password.\n<br /></font>";
    }
    if (strlen($password) < 8) {
        $fehler['password'] = "<font color=#cc3333>Password too short.\n<br /></font>";
    }
    if ($repassword != $password) {
        $fehler['repassword'] = "<font color=#cc3333>The pasword is not matching.\n<br /></font>";
    }
    $database = new medoo(['database_type' => 'mysql', 'database_name' => $dbname, 'server' => $servername, 'username' => $username, 'password' => $dbpassword]);
    //$datas = $database->select("tmpapplicant", "*");
    $countuser = $database->count("applicant", ["username" => $name]);
    if ($countuser > 0) {
        $fehler['name'] = "<font color=#cc3333><strong>User Name</strong> already exists..<br /></font>";
    }
    $countemail = $database->count("tmpapplicant", ["email" => $email]);
    if ($countemail > 0) {
        $fehler['email'] = "<font color=#cc3333><strong>e-mail-address</strong> already exists.\n<br /></font>";
    }
    if (!isset($fehler)) {
        //echo "done";
        //include("validatelogin.php");
        $action = "upload.php";
        $passwordhash = md5($password);
    }
}
?>

 * Date: 02.02.2016
 * Time: 23:38
 */
require_once 'vendor/autoload.php';
//open database connection
$database = new medoo(['database_type' => 'mysql', 'database_name' => 'r8db', 'server' => '172.16.2.109', 'username' => 'admin', 'password' => 'admin', 'charset' => 'utf8']);
$user_id = $database->select("user", ["[>]entry" => "user_id"], ["entry.entry_id"], ["entry_id" => 10]);
$user = $database->get('user', ['[>]entry' => "user_id"], ['user_id', 'email', 'username', 'admin', 'nsfw'], ['entry_id' => 10]);
$html = '<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"><div class="container"><div class="row">';
$html .= '<form class="clearfix" method="get">
<div class="form-group col-sm-4"><label for="action">Action</label><select class="form-control" name="action" id="action"><option value="show">show</option><option value="delete">delete</option><option value="add">add</option><option value="set">set</option></select></div>
<div class="form-group col-sm-4"><label for="amount">Amount</label><input class="form-control" type="number" name="amount" id="amount" value=""></div>
<div class="form-group col-sm-4"><label>Functions</label><div><button type="submit" class="btn btn-primary">Submit</button> <button type="reset" class="btn btn-warning">Reset</button></div></div>
</form>';
$html .= '</div><div class="row"><div class="col-sm-12">';
$count = $database->count('entry');
$database->query('ALTER TABLE "entry" AUTO_INCREMENT = ' . ($count + 1));
if (isset($_GET['action'])) {
    $amount = isset($_GET['amount']) && is_numeric($_GET['amount']) ? intval($_GET['amount']) : 100;
    if ($_GET['action'] == 'delete' && $count != 0) {
        $database->delete('entry', ['ORDER' => 'entry_id DESC', 'LIMIT' => $amount]);
    } elseif ($_GET['action'] == 'delete') {
        $html .= 'Where nothing is, nothing can be removed.';
    } elseif ($_GET['action'] == 'add') {
        for ($i = $count + 1; $i < $count + $amount + 1; ++$i) {
            $data = ['user_id' => 1, 'category_id' => 1, 'title' => 'Dummy #' . $i, 'desc' => 'Lorem Ipsum', 'image' => 'https://placehold.it/400x400'];
            $database->insert('entry', $data);
        }
    } elseif ($_GET['action'] == 'set') {
        $database->delete('entry', ['LIMIT' => 99999999999999]);
        $count = $database->count('entry');

/**
 * Controlla che sia ancora possibile iscriversi all'aula studio
 * 
 * @param medoo $database Connessione con il database
 * @param int $id
 * @return boolean
 */
function tempopomeriggio($database, $id)
{
    return $database->count("aule", array("AND" => array("id" => $id, "#data[>]" => "NOW()"))) != 0;
}

 /**
  * @param string $table
  * @param array $join
  * @param string|array $column
  * @param array $where
  * @return bool|int
  *
  * Or,
  * @param string $table
  * @param array $where
  * @return bool|int
  */
 public function count($table, $join = null, $column = null, $where = null)
 {
     $re = parent::count($table, $join, $column, $where);
     $this->lastSql = $this->last_query();
     $this->lastError = $this->error();
     return $re;
 }

 /**
  * Return the number of rows in the table
  * @param string $where
  * @param bool $extCall
  * @return bool|int
  * @throws FatalError
  */
 public function getNumOfRows($where = '', $extCall = false)
 {
     $this->gp->checkAccess(__FUNCTION__, $extCall);
     return $this->dbConnection->count($this->dbTable, $where);
 }

$app = new \Slim\Slim(array('view' => new \Slim\Views\Twig()));
$app->view()->parserExtensions = array(new \Slim\Views\TwigExtension());
$database = new medoo($config['database']);
/*
 * Go away message for stray users
 */
$app->get('/', function () {
    echo 'This is the validation endpoint for the womath research project.';
    echo 'You need to use the link in the email to validate.';
})->name('root');
/*
 * Validation endpoints
 */
$app->get('/:uuid/correct', function ($uuid) use($app, $database) {
    // ID must exist
    if ($database->count('people', ['uuid' => $uuid]) !== 1) {
        return $app->render('error.twig');
    }
    // Mark entry as correct
    $database->update('people', ['validation' => 'correct'], ['uuid' => $uuid]);
    // Say thank you
    $company = $database->select('people', ['company_name'], ['uuid' => $uuid])[0]['company_name'];
    return $app->render('correct.twig', ['company' => $company, 'uuid' => $uuid]);
})->name('correct');
$app->get('/:uuid/wrong', function ($uuid) use($app, $database) {
    // ID must exist
    if ($database->count('people', ['uuid' => $uuid]) !== 1) {
        return $app->render('error.twig');
    }
    // Mark entry as wrong
    $database->update('people', ['validation' => 'wrong'], ['uuid' => $uuid]);

<?php

/**
 * Created by PhpStorm.
 * User: KeenSting
 * Date: 2015/7/8
 * Time: 16:18
 */
require_once '../../parameter/Medoo/Resource/medoo.php';
$mydb = new medoo('meetingmanage');
$num = $mydb->count('update');
$id = 90000 + $num;
$mydb->insert('update', array('ID' => $id, 'DATE' => date('Y/m/d')));
//获得room id 全部
$arr_id = $mydb->select('rooms', 'ROOM_ID', array('STATE[!]' => 0));
$num_id = count($arr_id);
//var_dump($arr_id);
//
//循环滚动{
for ($i = 0; $i < $num_id; $i++) {
    $sta = $mydb->select('rooms', array('ONE1', 'ONE2', 'ONE3', 'ONE4', 'ONE5', 'ONE6', 'TWO1', 'TWO2', 'TWO3', 'TWO4', 'TWO5', 'TWO6', 'THREE1', 'THREE2', 'THREE3', 'THREE4', 'THREE5', 'THREE6'), array('ROOM_ID' => $arr_id[$i]));
    $state = $sta[0];
    echo $state['TWO1'];
    $mydb->update('rooms', array('ONE1' => $state['TWO1'], 'ONE2' => $state['TWO2'], 'ONE3' => $state['TWO3'], 'ONE4' => $state['TWO4'], 'ONE5' => $state['TWO5'], 'ONE6' => $state['TWO6'], 'TWO1' => $state['THREE1'], 'TWO2' => $state['THREE2'], 'TWO3' => $state['THREE3'], 'TWO4' => $state['THREE4'], 'TWO5' => $state['THREE5'], 'TWO6' => $state['THREE6'], 'THREE1' => 0, 'THREE2' => 0, 'THREE3' => 0, 'THREE4' => 0, 'THREE5' => 0, 'THREE6' => 0), array('ROOM_ID' => $arr_id[$i]));
}

function controleer_email($email)
{
    $database = new medoo();
    $emailExists = $database->count("gebruikers", ["AND" => ["email" => $email]]);
    /* If exectly one user has been found */
    if ($emailExists == 1) {
        return false;
    } else {
        return true;
    }
}

if (isset($_SESSION['isLoggedIn'], $_SESSION['email']) && $_SESSION['isLoggedIn'] == "true") {
    $user = $database->get("gebruikers", "*", ["AND" => ["email" => $_SESSION['email']]]);
    //print_r($user);
    include 'assets/html/nav.html';
    include 'assets/html/login_success.html';
    include 'phpAPI/home.php';
    //header("Location: /wedstrijdplatform/#/spelpagina"); //dit mag hier niet, zorgt voor eindeloze redirect ( na post ziet hij dat er al een sessie is dus komt hij hier en gaat hij nogmaals doorverwijzen
    //naar spelpagina, en dit blijft zich herhalen, dit stond hier omdat je als je al ingelogd bent, dat je automatisch de spelpagina ziet en niet opnieuw moet inloggen)
    include "assets/html/footer.html";
    //session_destroy(); //moet weg, staat hier enkel voor test
} else {
    if (isset($_POST['inputEmail'], $_POST['inputPassword'])) {
        $database = new medoo();
        $email = trim($_POST['inputEmail']);
        /* Check for correct email and password */
        $emailExists = $database->count("gebruikers", ["AND" => ["email" => $email]]);
        /* If exectly one user has been found */
        if ($emailExists == 1) {
            $enteredPassword = trim($_POST['inputPassword']);
            $user = $database->get("gebruikers", "*", ["AND" => ["email" => $email]]);
            //print_r($user);
            $dbpassword = $user['wachtwoord'];
            if (password_verify($enteredPassword, $dbpassword)) {
                $_SESSION['email'] = $email;
                $_SESSION['isLoggedIn'] = "true";
                /*include 'html/nav.html';
                		echo "<h1>User was get from post!</h1>"; /////////////////////////////////delete
                		include 'html/login_success.html';
                		echo "<h1>Normal user logged in.</h1>";
                		include 'php/home.php';*/
                header("Location: /wedstrijdplatform/#/spelpagina");

 /**
  *获得自身的注册数和认证数&订单数,如果我是主管，将学校列表写入session
  */
 protected function get_self_counter()
 {
     $local = new medoo();
     $db = new maindb();
     $register = $db->count('p_user', '*', array('invite' => $_SESSION['userinfo']['ekey']));
     $authority = $db->count('p_user', '*', array('AND' => array('invite' => $_SESSION['userinfo']['ekey'], 'auth' => 1)));
     $orders = $local->count('orders', '*', array('ekey' => $_SESSION['userinfo']['ekey']));
     unset($db);
     unset($local);
     if ($_SESSION['userinfo']['auth'] == 1) {
         //主管，写入学校列表
         $_SESSION['school'] = school_handler::through_area_get_school($_SESSION['userinfo']['province']);
     }
     $_SESSION['userinfo']['register'] = $register;
     $_SESSION['userinfo']['authority'] = $authority;
     $_SESSION['userinfo']['orders'] = $orders;
 }

/**
 * Created by PhpStorm.
 * User: KeenSting
 * Date: 2015/10/15
 * Time: 17:09
 */
require_once '../../../medoo/medoo.php';
require_once '../../../medoo/maindb.php';
$type = $_POST['type'];
$begin = ($_POST['index'] - 1) * 20;
$local = new medoo();
$remote = new maindb();
//管理员查全部的
if ($type == 'admin') {
    $re = $local->select('ambassador', '*', array('auth[>]' => 0, 'LIMIT' => [$begin, 20]));
} elseif ($type == 'manager') {
    $province = $_POST['province'];
    $re = $local->select('ambassador', '*', array('AND' => array('province' => $province, 'auth' => 2), 'LIMIT' => [$begin, 20]));
}
//统一去远端数据库匹配数据
foreach ($re as &$v) {
    $reg = $remote->count('p_user', '*', array('invite' => $v['ekey']));
    $aut = $remote->count('p_user', '*', array('AND' => array('invite' => $v['ekey'], 'auth' => 1)));
    $orders = $local->count('orders', '*', array('ekey' => $v['ekey']));
    $v['reg'] = $reg;
    $v['aut'] = $aut;
    $v['ord'] = $orders;
}
unset($remote);
unset($local);
echo json_encode(array('index' => $_POST['index'], 'list' => $re));

        echo 'error';
    } else {
        if ($re[0]['province'] != $_SESSION['userinfo']['province'] && $_SESSION['userinfo']['auth'] == 1) {
            echo 'unauthrized';
            exit;
        }
        //key拥有者所在学校的数据
        $reg = $remote->count('p_user', '*', array('school' => $re[0]['school']));
        $aut = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'auth' => 1)));
        $reg_in = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'invite[!]' => '')));
        $aut_in = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'invite[!]' => '', 'auth' => 1)));
        $school_data = array('reg' => $reg, 'aut' => $aut, 'reg_in' => $reg_in, 'aut_in' => $aut_in, 'reg_na' => $reg - $reg_in, 'aut_na' => $aut - $aut_in);
        $re[0]['reg'] = $remote->count('p_user', '*', array('AND' => array('invite' => $re[0]['ekey'], 'reg_time[>]' => $begin, 'reg_time[<]' => $end)));
        $re[0]['aut'] = $remote->count('p_user', '*', array('AND' => array('invite' => $re[0]['ekey'], 'auth_time[>]' => $begin, 'auth' => 1, 'auth_time[<]' => $end)));
        $re[0]['my_auth'] = $_SESSION['userinfo']['auth'];
        $re[0]['ord'] = $local->count('orders', '*', array('AND' => array('ekey' => $re[0]['ekey'], 'u_time[>]' => $begin, 'u_time[<]' => $end)));
        echo json_encode(array('info' => $re[0], 'data' => $school_data));
    }
    exit;
} elseif ($type == 'school') {
    //按照学校查询
    $name = $_POST['name'];
    $begin = $_POST['begin'];
    $end = $_POST['end'];
    if ($_SESSION['userinfo']['auth'] == 2) {
        $name = $_SESSION['userinfo']['school'];
    }
    if ($_SESSION['userinfo']['auth'] == 1 && !in_array($name, $_SESSION['school'])) {
        echo 'noschool';
        exit;
    }

//查询一次远端数据库，匹配订单状态
$item = $remote->select('p_order', '*', array('id' => $id));
if (empty($item)) {
    echo 'noinfo';
} elseif ($item[0]['state'] < 2) {
    echo 'unfinish';
} else {
    //todo
    //可能会添加几个大使开放所有订单种类
    $sid = $item[0]['sid'];
    $sell_info = $remote->select('p_sell_goods', 'ccid', array('id' => $sid));
    $ccid = $sell_info[0];
    if ($ccid != 100) {
        echo 'type';
        exit;
    }
    $check = $local->count('orders', '*', array('order_id' => $id));
    if ($check == 1) {
        echo 'repeat';
        exit;
    }
    $re = $local->insert('orders', array('ekey' => $_SESSION['userinfo']['ekey'], 'state' => 0, 'price' => $item[0]['price'], 'u_time' => time(), 'c_time' => $item[0]['time'], 'order_id' => $id, 'type' => 0, 'act_id' => 0));
    if ($re != 0) {
        echo 'ok';
    } else {
        echo 'error';
    }
    //todo 写
    //入本地
}
//print_r($item);