当前位置: 首页>>代码示例>>PHP>>正文


PHP DataBase类代码示例

本文整理汇总了PHP中DataBase的典型用法代码示例。如果您正苦于以下问题:PHP DataBase类的具体用法?PHP DataBase怎么用?PHP DataBase使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


在下文中一共展示了DataBase类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: get

 public function get($id)
 {
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN GETRUTACONDUCTOR(:p_id, :rc); END;";
     $sent = oci_parse($data->getConn(), $sql);
     $refcur = oci_new_cursor($data->getConn());
     $this->id = $id;
     oci_bind_by_name($sent, ':p_id', $this->id);
     oci_bind_by_name($sent, ':rc', $refcur, -1, OCI_B_CURSOR);
     if (!oci_execute($sent)) {
         return false;
     }
     if (!oci_execute($refcur)) {
         return false;
     }
     while (($row = oci_fetch_array($refcur, OCI_ASSOC + OCI_RETURN_NULLS)) != false) {
         $this->ruta = $row['ID_RUTA'];
         $this->conductor = $row['ID_CONDUCTOR'];
         $this->kilometraje = $row['KILOMETRAJE'];
         $this->descripcion = $row['DESCRIPCION'];
     }
     oci_free_statement($refcur);
     $data->free($sent);
     $data->close();
     return true;
 }
开发者ID:CEMZ,项目名称:Privado,代码行数:28,代码来源:RutaConductor.php

示例2: loadAtendente

 function loadAtendente()
 {
     include_once 'app.ado/DataBase.php';
     $db = new DataBase();
     $aten = $db->getConn()->query('select nome_usuario from usuarios where id_usuario = ' . $this->usuario_id . ';')->fetchAll(PDO::FETCH_CLASS, "Item");
     return $aten;
 }
开发者ID:laiello,项目名称:almoxarifadocedup,代码行数:7,代码来源:Emp.class.php

示例3: render

 public function render()
 {
     if (!$this->conteudo) {
         include_once 'app.ado/DataBase.php';
         $pdo = new DataBase();
         $db = $pdo->getConn();
         $sql = 'select * from ctrl_chaves';
         if ($this->dt_inicial or $this->dt_final) {
             $this->dt_inicial = $this->dt_inicial ? $this->dt_inicial : '2012/01/01';
             $this->dt_final = $this->dt_final ? $this->dt_final : date('Y/m/d');
             $sql .= ' where ((dt_inicial_controle between ? and ?) or (dt_final_controle between ? and ?))';
             $exec[] = $this->dt_inicial;
             $exec[] = $this->dt_final;
             if ($this->id) {
                 $sql .= ' and id_controle = ?';
                 $exec[] = $this->id;
             }
         } elseif ($this->id) {
             $sql .= ' where id_controle = ?';
             $exec[] = $this->id;
         }
         if ($this->order) {
             $sql .= ' order by ?';
             $exec[] = $this->order;
         }
         $sth = $db->prepare($sql);
         $conteudo = $sth->execute($exec);
         $this->conteudo = $conteudo->fetchAll(PDO::FETCH_CLASS, 'CrlChave');
     }
     $tabela = new TTableChave($this->conteudo);
     $pdf = new TRelatorio();
     $pdf->writeHTML($tabela->render());
     $pdf->render();
     $pdf->exit();
 }
开发者ID:laiello,项目名称:almoxarifadocedup,代码行数:35,代码来源:TRelChave.class.php

示例4: getTable

    function getTable($news_id, $hotelType, $hotelLocation, $impactType)
    {
        $mydatabase = new DataBase();
        //$news = $mydatabase->getNews_by_game($game,$period);
        $news = $mydatabase->getNews_by_id($news_id);
        //print_r("Game: ".$game.", Period: ".$period);
        if (!isset($news) || count($news) == 0) {
            return "fail";
        }
        $parameters = $mydatabase->getAllNews_parameters($news['id']);
        $count = 0;
        $result = '<h3 align="center"> News Affects Parameters</h3>' . '<br />' . '<table class="table table-bordered">
						<thead>
							<tr>
								<th>#</th>
								<th>Hotel Type</th>
								<th>Hotel Location</th>
								<th>Impact</th>
							</tr>
					</thead>';
        if (isset($parameters) && count($parameters) > 0) {
            foreach ($parameters as $key => $temp) {
                $result .= "<tbody>" . "<tr>" . "<td>" . ++$count . "</td>" . "<td>" . $temp['hotel_type'] . "</td>" . "<td>" . $mydatabase->getLocation($temp['hotel_location'])['type'] . "</td>" . "<td>" . $temp['effect'] . "</td>" . "</tr>" . "</tbody>";
            }
        }
        if (isset($hotelType) && isset($hotelLocation) && isset($impactType)) {
            for ($counter = 0; $counter < count($impactType); $counter++) {
                $result .= "<tbody>" . "<tr>" . "<td>" . ($counter + 1 + $count) . "</td>" . "<td>" . $hotelType[$counter] . "</td>" . "<td>" . $hotelLocation[$counter] . "</td>" . "<td>" . $impactType[$counter] . "</td>" . "</tr>" . "</tbody>";
            }
        }
        $result .= "</table><br />";
        return $result;
    }
开发者ID:jandr018,项目名称:StragicMarketingSimulator,代码行数:33,代码来源:NewsController.php

示例5: search_matrix

 public function search_matrix($idMatrix = FALSE)
 {
     $objData = new DataBase();
     $sth = $objData->prepare('SELECT * FROM matrix M inner join users U ' . 'on M.id_matrix = U.id_matrix WHERE M.id_matrix = :idMatrix');
     $sth->execute(array(':idMatrix' => $idMatrix));
     return $result = $sth->fetchAll();
 }
开发者ID:dareyesm,项目名称:paginadorPHP,代码行数:7,代码来源:matrix.php

示例6: PollMessage

function PollMessage()
{
    include 'config/config.php';
    require_once 'libs/database.php';
    $db = new DataBase($db_server, $db_user, $db_password);
    $db->Select($db_name);
    $db->Query("SELECT * FROM messages ORDER BY id DESC LIMIT 2");
    $data = $db->ReadNext();
    //no message in queue - return nop
    if ($data == null) {
        echo "none";
        return;
    }
    /*		echo "<pre>";
    		print_r($data);
    		echo "</pre>";*/
    $id = $data['id'];
    $message = $data['message'];
    //return the command to client
    echo $message;
    //delete message from queue
    $db = new DataBase($db_server, $db_user, $db_password);
    $db->Select($db_name);
    $db->Query("DELETE FROM messages WHERE id = '{$id}';");
}
开发者ID:kybernetyk,项目名称:Tune-Buddy,代码行数:25,代码来源:poll_message.php

示例7: listaUnidades

 public static function listaUnidades($sql)
 {
     $db = new DataBase();
     $db->setQuery(" \n            SELECT\n                  codUnidad\n                , nombre\n            FROM e_unidad\n            WHERE {$sql}\n                AND estado=2\n        ");
     //f::message($db->getQuery());
     $db->executeQuery();
     return $db->getTable('encode');
 }
开发者ID:eddyn73,项目名称:SURP,代码行数:8,代码来源:DAO_Unidad.php

示例8: loadLaboratorio

 function loadLaboratorio()
 {
     include_once 'app.ado/DataBase.php';
     $db = new DataBase();
     $lab = $db->getConn()->query('select nome_laboratorio from laboratorios where id_laboratorio = ' . $this->laboratorio_id . ';')->fetch(PDO::FETCH_COLUMN);
     unset($db);
     return $lab;
 }
开发者ID:laiello,项目名称:almoxarifadocedup,代码行数:8,代码来源:CrlChave.class.php

示例9: tearDown

 function tearDown()
 {
     $db = new DataBase();
     $db->Clear();
     $db->Close();
     unset($_SESSION['user']);
     unset($_SESSION['pw']);
 }
开发者ID:nomeata,项目名称:L-seed,代码行数:8,代码来源:BuisnessLogicTest.php

示例10: getCurrentUser

 public static function getCurrentUser($id)
 {
     $class = static::class;
     $sql = 'SELECT * FROM users WHERE id=:id';
     $db = new DataBase();
     $res = $db->findOne($class, $sql, [':id' => $id]);
     return $res;
 }
开发者ID:semho,项目名称:customer-DB,代码行数:8,代码来源:App.php

示例11: EnqueueMessage

function EnqueueMessage($message)
{
    include 'config/config.php';
    require_once 'libs/database.php';
    $db = new DataBase($db_server, $db_user, $db_password);
    $db->Select($db_name);
    $query = "INSERT INTO messages (\n\t\t\t\t\tmessage\n\t\t\t\t\t)\n\t\t\t\t\tVALUES (\n\t\t\t\t\t'{$message}'\n\t\t\t\t\t);";
    $db->Query($query);
}
开发者ID:kybernetyk,项目名称:Tune-Buddy,代码行数:9,代码来源:index.php

示例12: get_feed_items

 public function get_feed_items()
 {
     $db = new DataBase();
     $result = $db->get_all();
     $feed = array();
     foreach ($result as $feed_item) {
         array_push($feed, new FeedItem($feed_item));
     }
     return $feed;
 }
开发者ID:megazalrock,项目名称:nhkrss,代码行数:10,代码来源:feed.php

示例13: get_siteInfo

function get_siteInfo($TcName)
{
    //    Busca en la tabla de configuraciones el valor establecido
    $query = "SELECT valor,tipo FROM Configuracion WHERE idConfiguracion = '{$TcName}'";
    include_once './dataBaseClass/connection.php';
    $cDb = new DataBase();
    $result = $cDb->query($query);
    $row = mysqli_fetch_assoc($result);
    return $row["valor"];
}
开发者ID:ggarzam88,项目名称:CobranzaWeb,代码行数:10,代码来源:Funciones.php

示例14: insertNews

		public function insertNews() {
			$db = new DataBase();
			//$db->setClassName(get_called_class());
			$news = [];
			foreach ($this->data['news'] as $key => $value) {
				$news[] = '(' . $key . ', ' . $value . ')';
			}
			$sql = 'INSERT INTO ' . $this->table . '(Owner, Post) VALUES ' . implode(', ', array_values($news)) . ' ON DUPLICATE KEY UPDATE Owner = Owner';
			return $db->execute($sql);
		}
开发者ID:Narrator69,项目名称:why-not,代码行数:10,代码来源:class_engine.php

示例15: get_dataByLogin

 function get_dataByLogin($login)
 {
     $db = new DataBase();
     $mysqli = $db->getMysqli();
     $sql = 'SELECT * FROM users WHERE login ="' . $login . '"';
     if ($result = $mysqli->query($sql)) {
         return $result->fetch_assoc();
     } else {
         return null;
     }
 }
开发者ID:nakiden,项目名称:quicksilk,代码行数:11,代码来源:model_login.php


注:本文中的DataBase类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。