PHP MysqliDb::getOne方法代码示例

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

 /**
  * Convinient function to fetch one object. Mostly will be togeather with where()
  *
  * @access public
  * @param array|string $fields Array or coma separated list of fields to fetch
  *
  * @return dbObject
  */
 private function getOne($fields = null)
 {
     $results = $this->db->getOne($this->dbTable, $fields);
     $this->processArrays($results);
     $this->processWith($results);
     if ($this->returnType == 'Array') {
         return $results;
     }
     $item = new static($results);
     $item->isNew = false;
     return $item;
 }

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

echo '	<body>' . "\n";
if (isset($_POST['submitted'])) {
    $submited = $_POST['submitted'];
    $name = explode(" ", $_POST['name']);
    $pass = $_POST['pass'];
    if (isset($pass) && !empty($pass)) {
        if (isset($name) && !empty($name[0])) {
            if (count($name) >= 1 && count($name) <= 2) {
                if (count($name) > 1) {
                    $db->where('fName', $name[0]);
                    $db->where('lName', $name[1]);
                } else {
                    $db->where('fName', $name);
                    $db->orWhere('lName', $name);
                }
                $user = $db->getOne("Users");
                $hash = $user['password'];
                if (password_verify($pass, $hash)) {
                    echo 'Password is valid!';
                    $_SESSION['user'] = new User($user['id'], $user['fName'], $user['lName'], $user['admin']);
                } else {
                    echo 'Invalid password.';
                }
            } else {
                echo "invalid Name given";
            }
        } else {
            echo "You must enter a name";
        }
        //header('Location: index.php');
    } 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;
             }
         }
     }
     $query = $bd->getOne(TABLA_CATEGORIA);
     $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);
         $id_nuevo = $bd->insert(TABLA_CATEGORIA, $datos);
         if (!$id_nuevo) {
             $arr = array(RESPUESTA_ERROR => $bd->getLastError());
         } else {
             $datos[COLUMNA_ID] = $id_nuevo;
             $arr = array(RESPUESTA_DATA => $datos, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
         }

                 $bd->delete(TABLA_REL_PRODUCTO_CATEGORIA);
                 $query = $bd->get(TABLA_PRODUCTO);
                 $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) {
                         foreach ($parametro_valor as $key => $val) {
                             switch ($key) {
                                 case PARAMETRO_ID:
                                     $bd->where(COLUMNA_ID, (int) $val);
                                     break;
                             }
                         }
                     }
                     $query = $bd->getOne(TABLA_PRODUCTO);
                     $bd->where(COLUMNA_ID_PRODUCTO, $query[COLUMNA_ID_M]);
                     $referencias = $bd->get(TABLA_REL_PRODUCTO_CATEGORIA);
                     foreach ($referencias as $parametro_key => $parametro_valor) {
                         // AGREGOS LAS CATEGORIAS A LA QUE PERTENECE CADA PRODUCTO
                         $bd->where(COLUMNA_ID, $parametro_valor[COLUMNA_ID_CATEGORIA]);
                         $referencias_aux = $bd->getOne(TABLA_CATEGORIA);
                         $referencias[$parametro_key] = $referencias_aux;
                     }
                     $query[VALOR_CATEGORIAS] = $referencias;
                     $arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
                 }
             }
         }
     }
 }

 public function getTranslation($lang, $format)
 {
     if ($this->trailID == "undefined") {
         return "Trail ID has not been defined. Call setID({$ID}) before requesting data.";
     } else {
         $db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
         $db->where("trail_id", $this->trailID);
         $db->where("lang", $lang);
         if ($db->has("translations")) {
             $db->where("trail_id", $this->trailID);
             $db->where("lang", $lang);
             $result = $db->getOne("translations");
             $attractions = json_decode(stripslashes($result['attractions']));
             $result['attractions'] = $attractions;
             $loops = json_decode(stripslashes($result['loops']));
             $result['loops'] = $loops;
             if ($format == "JSON") {
                 return json_encode($result);
             } elseif ($format == "XML") {
                 return "Maybe someday..";
             } else {
                 return $result;
             }
         } else {
             return "Elang";
         }
     }
 }

    error_log("خطا در دریافت اطلاعات\n\n" . $e->getMessage());
}
$text = strtolower($text);
$bot = new TelegramBot\Api\BotApi(TOKEN);
try {
    switch ($text) {
        case '/start':
        case '/start@softwaretalkbot':
            $message = "سلام\nبه ربات جلسات باز نرم افزاری خوش آمدید.\nجهت اطلاع از جلسه آتی عبارت next را ارسال کنید.";
            $bot->sendMessage($chatid, $message);
            break;
        case '/next':
        case '/next@softwaretalkbot':
        case 'next':
            $db->orderBy('ID', 'DESC');
            $q = $db->getOne('nextMessages');
            $message = $q['text'];
            $bot->sendMessage($chatid, $message);
            break;
        case '/about':
        case '/about@softwaretalkbot':
        case 'about':
            $bot->sendMessage($chatid, "من اطلاعات جلسات باز نرم افزاری مشهد را برایتان ارسال میکنم.\n" . "سورس من روی گیت هاب قرار دارد. می توانید از طریق لینک زیر آن را مشاهده کنید:\n" . "https://github.com/mnameghi/SoftwareTalks");
            break;
            //set next message
        //set next message
        case COMMAND1:
        case '/' . COMMAND1:
            if (!isAdmin($chatid, $db)) {
                return;
            }

 public function checkSession()
 {
     $db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
     $db->where("user_id", $_SESSION['user_id']);
     $user = $db->getOne("logged_in_member");
     if ($user) {
         //Check ID and Token
         if (session_id() == $user['session_id'] && $_SESSION['token'] == $user['token']) {
             //Id and token match, refresh the session for the next request
             $this->refreshSession();
             return "auth";
         } else {
             return "unauth";
         }
     } else {
         return "unauth";
     }
 }

<?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 systemStatusUpdateEmail($id, $message)
{
    $db = new MysqliDb();
    $db->where('id', $_GET['id']);
    $contract = $db->getOne('contracts');
    $to = $contract['client_email'];
    $subject = "";
    $encrypt = new Encryption();
    $link = $encrypt->encode($id);
    $message = "Updates have been made to one or more of your documents. Please click the link below to review and approve the changes.\n http://" . $_SERVER['HTTP_HOST'] . "/contract_gen/contract.php?id=" . $link;
    $headers = 'From: support@ignitorlabs.com' . "\r\n" . 'Reply-To: ' . $contract['ignitor_email'] . "\r\n" . 'X-Mailer: PHP/' . phpversion();
    mail($to, $subject, $message, $headers);
}

require_once 'MysqliDb.php';
//Extracts question from forms and stores into database
$question_username = "oliver";
//$_POST['question_username'];
$question = "college canteen needs to be improved";
//$_POST['question'];
$description = "details";
//$_POST['description'];
$type = "general";
//$_POST['branch'];                //branch or general
$timestamp = date('Y-m-d H:i:s');
$db = new MysqliDb('localhost', 'root', 'hack123', 'colgpolls');
$data = array("question" => $question, "description" => $description, "question_username" => $question_username, "timestamp" => $timestamp);
$id = $db->insert('polls', $data);
$db->where("timestamp", $timestamp);
$user = $db->getOne("polls");
$data = array("pid" => $user['pid']);
/* There are two types of question category : general or branch based
	Store values according catogery in database */
if ($type == 'general') {
    $db->insert('CSE', $data);
    $db->insert('MECH', $data);
    $db->insert('TCE', $data);
    $db->insert('ECE', $data);
} else {
    if ($type == 'CSE') {
        $db->insert('CSE', $data);
    } else {
        if ($type == 'TCE') {
            $db->insert('TCE', $data);
        } else {

 /** Returns the given database connector for a given database connector type */
 public function getDatabaseConnectorOfType($type, $dbhost = null, $dbname = null, $dbuser = null, $dbpass = null, $dbport = null)
 {
     if (empty($dbhost) && defined('DB_HOST')) {
         $dbhost = DB_HOST;
     }
     if (empty($dbname) && defined('DB_NAME')) {
         $dbname = DB_NAME;
     }
     if (empty($dbuser) && defined('DB_USERNAME')) {
         $dbuser = DB_USERNAME;
     }
     if (empty($dbpass) && defined('DB_PASSWORD')) {
         $dbpass = DB_PASSWORD;
     }
     if (empty($dbport) && defined('DB_PORT')) {
         $dbport = DB_PORT;
     }
     if ($type == CRM_DB_CONNECTOR_TYPE_MYSQL) {
         // MySQL Database connector
         require_once "db_connectors/MysqliDb.php";
         try {
             @($mysqldb = new \MysqliDb($dbhost, $dbuser, $dbpass, $dbname, $dbport));
             if (empty($mysqldb)) {
                 throw new \Exception("Database access failed. Incorrect credentials or missing parameters.");
                 return null;
             }
             // try to set the timezone (for dates).
             $mysqldb->where("setting", CRM_SETTING_TIMEZONE);
             $mysqldb->where("context", CRM_SETTING_CONTEXT_CREAMY);
             if ($result = $mysqldb->getOne(CRM_SETTINGS_TABLE_NAME)) {
                 $timezone = $result["value"];
                 if (isset($timezone)) {
                     date_default_timezone_set($timezone);
                 }
             } else {
                 // fallback.
                 if (defined('CRM_TIMEZONE')) {
                     $timezone = CRM_TIMEZONE;
                 }
                 if (defined('CRM_LOCALE')) {
                     date_default_timezone_set($timezone);
                 }
             }
             // return MySQL database connector
             return $mysqldb;
         } catch (\Exception $e) {
             throw new \Exception("Incorrect credentials. Access denied or incorrect parameters.");
             return null;
         }
     } else {
         throw new \Exception("Database connector {$type} not supported yet!");
     }
 }

    define('DB_NAME', '');
}
require 'constants.php';
require 'DB.php';
$db = new MysqliDb(array('host' => DB_HOST, 'username' => DB_USER, 'password' => DB_PASSWORD, 'db' => DB_NAME, 'port' => 3306, 'prefix' => '', 'charset' => 'utf8'));
if (!isset($_SESSION['user']) && strpos($_SERVER['REQUEST_URI'], 'login.php') === FALSE) {
    header('Location: ' . HTTP_PATH . 'user/login.php');
    die;
} else {
    if (strpos($_SERVER['REQUEST_URI'], 'logout.php') !== FALSE) {
        unset($_SESSION);
        header('Location: ' . HTTP_PATH . 'user/login.php');
        die;
    } else {
        if (isset($_POST['username']) && $_POST['username'] != '') {
            global $db;
            $db->where("name", $_POST['username']);
            $db->where("password", $_POST['password']);
            $user = $db->getOne('users');
            if ($user != '') {
                unset($user['password']);
                $_SESSION['user'] = $user;
                header('Location: ' . HTTP_PATH . '/user/dashboard.php');
                die;
            } else {
                $err = 'User not found!';
            }
        }
    }
}
require 'functions.php';

    // Page footer
    public function Footer()
    {
        // Position at 15 mm from bottom
        $this->SetY(-15);
        // Set font
        $this->SetFont('helvetica', 'I', 8);
        // Page number
        $this->Cell(60, 10, $this->date, 0, false, 'L', 0, '', 0, false, 'T', 'M');
        $this->Cell(60, 10, 'V ' . $this->version, 0, false, 'C', 0, '', 0, false, 'T', 'M');
        $this->Cell(60, 10, 'Page ' . $this->getAliasNumPage() . '/' . $this->getAliasNbPages(), 0, false, 'R', 0, '', 0, false, 'T', 'M');
    }
}
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$history = $db->getOne('history');
$pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->setVersion((string) $_GET['version'] . ".0");
$pdf->setDate($_GET['date']);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Ignitor Labs');
$pdf->setHeaderFont(false);
$pdf->setPrintHeader(false);
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
// $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);