本文整理汇总了PHP中ibase_fetch_assoc函数的典型用法代码示例。如果您正苦于以下问题:PHP ibase_fetch_assoc函数的具体用法?PHP ibase_fetch_assoc怎么用?PHP ibase_fetch_assoc使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ibase_fetch_assoc函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getModelConfigImposto
public function getModelConfigImposto($id){
$sql = "SELECT
CONFIG_IMPOSTO_ID,
NOME_TABELA,
COALESCE(ISS,0) AS ISS,
COALESCE(INSS,0) AS INSS,
COALESCE(PIS,0) AS PIS,
COALESCE(COFINS,0) AS COFINS,
COALESCE(CSLL,0) AS CSLL,
COALESCE(IRPJ,0) AS IRPJ,
COALESCE(RETENCAO_FONTE,'N') AS RETENCAO_FONTE
FROM CONFIG_IMPOSTO
WHERE CONFIG_IMPOSTO.CONFIG_IMPOSTO_ID =".$id;
$rs = parent::execute_query($sql);
while($row = ibase_fetch_assoc($rs)){
$this->CONFIG_IMPOSTO_ID = $row['CONFIG_IMPOSTO_ID'];
$this->NOME_TABELA = $row['NOME_TABELA'];
$this->ISS = $row['ISS'];
$this->PIS = $row['PIS'];
$this->INSS= $row['INSS'];
$this->COFINS = $row['COFINS'];
$this->CSll = $row['CSLL'];
$this->IRPJ = $row['IRPJ'];
$this->RENTENCAO_FONTE = $row['RETENCAO_FONTE'];
$this->SYNC = $rs['SYNC'];
}
return $this;
}
开发者ID:helbertfurbino,项目名称:sgmofinanceiro,代码行数:28,代码来源:ModelConfigImposto.php
示例2: FetchAs
function FetchAs($result)
{
if (!is_resource($result)) {
return false;
}
return ibase_fetch_assoc($result);
}
开发者ID:ofarias,项目名称:phpPegaso,代码行数:7,代码来源:database.php
示例3: execute
public function execute($sql, $bindParams = array(), $additionalParameters = array())
{
$connection = $this->connection;
if (empty($bindParams)) {
$result = ibase_query($connection, $sql);
} else {
$holderRegex = "/@[a-zA-Z0-9_]+@/";
preg_match_all($holderRegex, $sql, $matches);
$args = array($connection, preg_replace($holderRegex, "?", $sql));
foreach ($matches[0] as $holder) {
$args[] = $bindParams[$holder];
}
$result = call_user_func_array("ibase_query", $args);
}
if (!$result) {
$this->executeError($sql);
}
$rows = array();
if (is_resource($result)) {
while ($row = ibase_fetch_assoc($result, IBASE_TEXT)) {
$rows[] = array_change_key_case($row);
}
ibase_free_result($result);
} else {
$this->affectedRows = $result === true ? 0 : $result;
}
if ($this->autoCommit) {
ibase_commit($connection);
}
return empty($rows) ? null : $rows;
}
开发者ID:reoring,项目名称:sabel,代码行数:31,代码来源:Driver.php
示例4: select_sql
function select_sql($sql)
{ $j=1;
$Row=array(array());
$this->sql_connect();
$this->sql_query=$sql;
$this->sql_execute();
while($Mas = ibase_fetch_assoc($this->sql_result))
{$i=0;
foreach($Mas as $key => $value) {
$Row[0][$i] = $key;
$Row[$j][$i] = $value;
//echo $key.": ".$value.", ";
$i++;
}
$j++;
}
return $Row;
}
开发者ID:semteacher,项目名称:tdmu-vidomosti2,代码行数:18,代码来源:class_firebird.php
示例5: next
/**
* Iterator function. Returns a rowset if called without parameter,
* the fields contents if a field is specified or FALSE to indicate
* no more rows are available.
*
* @param string field default NULL
* @return var
*/
public function next($field = NULL)
{
if (!is_resource($this->handle) || FALSE === ($row = ibase_fetch_assoc($this->handle))) {
return FALSE;
}
foreach (array_keys($row) as $key) {
if (NULL === $row[$key] || !isset($this->fields[$key])) {
continue;
}
if ('TIMESTAMP' == $this->fields[$key]) {
$row[$key] = Date::fromString($row[$key], $this->tz);
}
}
if ($field) {
return $row[$field];
} else {
return $row;
}
}
开发者ID:melogamepay,项目名称:xp-framework,代码行数:27,代码来源:InterBaseResultSet.class.php
示例6: next
/**
* Iterator function. Returns a rowset if called without parameter,
* the fields contents if a field is specified or FALSE to indicate
* no more rows are available.
*
* @param string field default NULL
* @return [:var]
*/
public function next($field = null)
{
if (!is_resource($this->handle) || false === ($row = ibase_fetch_assoc($this->handle))) {
return null;
}
foreach (array_keys($row) as $key) {
if (null === $row[$key] || !isset($this->fields[$key])) {
continue;
}
if ('TIMESTAMP' == $this->fields[$key]) {
$row[$key] = new \util\Date($row[$key], $this->tz);
}
}
if ($field) {
return $row[$field];
} else {
return $row;
}
}
开发者ID:xp-framework,项目名称:rdbms,代码行数:27,代码来源:InterBaseResultSet.class.php
示例7: dbQuery
function dbQuery($query, $show_errors = true, $all_results = true, $show_output = true)
{
if ($show_errors) {
error_reporting(E_ALL);
} else {
error_reporting(E_PARSE);
}
// Connect to the Firebird/Interbase Sybase database management system
$link = ibase_pconnect("/var/www/sqlmap/dbs/firebird/testdb.fdb", "SYSDBA", "testpass");
if (!$link) {
die(ibase_errmsg());
}
// Print results in HTML
print "<html><body>\n";
// Print SQL query to test sqlmap '--string' command line option
//print "<b>SQL query:</b> " . $query . "<br>\n";
// Perform SQL injection affected query
$result = ibase_query($link, $query);
if (!$result) {
if ($show_errors) {
print "<b>SQL error:</b> " . ibase_errmsg() . "<br>\n";
}
exit(1);
}
print "<b>SQL results:</b>\n";
print "<table border=\"1\">\n";
while ($line = ibase_fetch_assoc($result)) {
// This must stay here for Firebird
if (!$show_output) {
exit(1);
}
print "<tr>";
foreach ($line as $col_value) {
print "<td>" . $col_value . "</td>";
}
print "</tr>\n";
if (!$all_results) {
break;
}
}
print "</table>\n";
print "</body></html>";
}
开发者ID:dieface,项目名称:testenv,代码行数:43,代码来源:firebird.inc.php
示例8: VerificaCalculo
private function VerificaCalculo($id) {
$SQL = "
SELECT imposto.imposto_id
FROM F_REL_F_LANCA_CR2_F_IMPOSTO RELIMP
INNER JOIN imposto ON imposto.imposto_id = RELIMP.imposto_id
WHERE RELIMP.F_LANCA_CR2_ID =
(
SELECT MAX(CR2.F_LANCA_CR2_ID)
FROM F_LANCA_CR CR
INNER JOIN F_LANCA_CR2 CR2 ON CR2.f_lanca_cr_id = CR.f_lanca_cr_id
INNER JOIN F_REL_F_LANCA_CR2_F_IMPOSTO RELIMP ON RELIMP.f_lanca_cr2_id = CR2.f_lanca_cr2_id
INNER JOIN imposto IMP ON IMP.imposto_id = RELIMP.imposto_id
WHERE CR.f_lanca_cr_id = $id
AND CR2.acao_faturar = 'S'
)";
$rsVerificaCalcular = ibase_fetch_assoc(parent::execute_query($SQL));
if (count($rsVerificaCalcular) > 0) {
return true;
} else {
return false;
}
}
开发者ID:helbertfurbino,项目名称:sgmofinanceiro,代码行数:22,代码来源:CImposto.php
示例9: _performFetch
function _performFetch($result)
{
// Select fetch mode.
$flags = $this->fetchFlags;
if (empty($this->attributes['BLOB_OBJ'])) {
$flags = $flags | IBASE_TEXT;
} else {
$flags = $flags & ~IBASE_TEXT;
}
$row = @ibase_fetch_assoc($result, $flags);
if (ibase_errmsg()) {
return $this->_setDbError($this->_lastQuery);
}
if ($row === false) {
return null;
}
return $row;
}
开发者ID:saqar,项目名称:tc_aowow,代码行数:18,代码来源:Ibase.php
示例10: fetch
/**
* Fetches a row from the result set.
*
* @param int $style OPTIONAL Fetch mode for this fetch operation.
* @param int $cursor OPTIONAL Absolute, relative, or other.
* @param int $offset OPTIONAL Number for absolute or relative cursors.
* @return mixed Array, object, or scalar depending on fetch mode.
* @throws Zend_Db_Statement_Exception
*/
public function fetch($style = null, $cursor = null, $offset = null)
{
if (!$this->_stmtResult) {
return false;
}
if ($style === null) {
$style = $this->_fetchMode;
}
switch ($style) {
case Zend_Db::FETCH_NUM:
$row = ibase_fetch_row($this->_stmtResult, IBASE_TEXT);
break;
case Zend_Db::FETCH_ASSOC:
$row = ibase_fetch_assoc($this->_stmtResult, IBASE_TEXT);
break;
case Zend_Db::FETCH_BOTH:
$row = ibase_fetch_assoc($this->_stmtResult, IBASE_TEXT);
if ($row !== false) {
$row = array_merge($row, array_values($row));
}
break;
case Zend_Db::FETCH_OBJ:
$row = ibase_fetch_object($this->_stmtResult, IBASE_TEXT);
break;
case Zend_Db::FETCH_BOUND:
$row = ibase_fetch_assoc($this->_stmtResult, IBASE_TEXT);
if ($row !== false) {
$row = array_merge($row, array_values($row));
$row = $this->_fetchBound($row);
}
break;
default:
/**
* @see ZendX_Db_Adapter_Firebird_Exception
*/
require_once 'ZendX/Db/Statement/Firebird/Exception.php';
throw new ZendX_Db_Statement_Firebird_Exception("Invalid fetch mode '{$style}' specified");
break;
}
return $row;
}
开发者ID:JosefinaArayaTapia,项目名称:Capicua-Restobar,代码行数:50,代码来源:Firebird_3.php
示例11: getAll
/**
+----------------------------------------------------------
* 获得所有的查询数据
+----------------------------------------------------------
* @access private
+----------------------------------------------------------
* @return array
+----------------------------------------------------------
* @throws ThinkExecption
+----------------------------------------------------------
*/
private function getAll()
{
//返回数据集
$result = array();
while ($row = ibase_fetch_assoc($this->queryID)) {
$result[] = $row;
}
//剑雷 2007.12.30 自动解密BLOB字段
//取BLOB字段清单
$bloblist = array();
$fieldCount = ibase_num_fields($this->queryID);
for ($i = 0; $i < $fieldCount; $i++) {
$col_info = ibase_field_info($this->queryID, $i);
if ($col_info['type'] == 'BLOB') {
$bloblist[] = trim($col_info['name']);
}
}
//如果有BLOB字段,就进行解密处理
if (!empty($bloblist)) {
$i = 0;
foreach ($result as $row) {
foreach ($bloblist as $field) {
if (!empty($row[$field])) {
$result[$i][$field] = $this->BlobDecode($row[$field]);
}
}
$i++;
}
}
return $result;
}
开发者ID:dalinhuang,项目名称:concourse,代码行数:42,代码来源:DbIbase.class.php
示例12: fetch_array
/**
*@package db_firebird
*@method fetch_array()
*@desc Fetch a result row as an associative array, a numeric array, or both depending on query() or query_assoc() method
*@since v0.3.1
* */
public function fetch_array($rs = '')
{
$Resource = $rs != '' ? $rs : $this->resource;
if ($this->query_is_assoc == true) {
return ibase_fetch_assoc($Resource);
} else {
return ibase_fetch_row($Resource);
}
}
开发者ID:mmendoza000,项目名称:freekore,代码行数:15,代码来源:db_firebird.php
示例13: getLastId
/**
* Retorna o ultimo ID da tabela para campos auto-increment
* @author Hugo Ferreira da Silva
* @param string $campo Nome do campo da tabela de auto-increment
* @return int Valor da ultima insercao
*/
public function getLastId($campo)
{
//////////////////////////////////////////////////////////////////
// GAMBIARRA FORTE!
// Aqui pegamos as triggers relacionadas a tabela
// e procuramos no corpo da trigger uma linha semelhante a
// new.nome_campo = gen_id(nome_sequencia, 1)
// para pegarmos o nome da sequencia e consequentemente
// podermos recuperar o ultimo valor
//////////////////////////////////////////////////////////////////
$cn = $this->getConnection();
$sql = "SELECT RDB\$TRIGGER_SOURCE AS triggers FROM RDB\$TRIGGERS\n\t\t\t\t WHERE (RDB\$SYSTEM_FLAG IS NULL\n\t\t\t\t\tOR RDB\$SYSTEM_FLAG = 0)\n\t\t\t\t AND RDB\$RELATION_NAME='" . $this->getTablename() . "'";
$rs = $cn->executeSQL($sql);
while ($row = ibase_fetch_assoc($rs, IBASE_FETCH_BLOBS)) {
// oba! achamos o lance
$exp = '@new\\.' . $campo . '\\s+=\\s+gen_id\\((\\w+)@is';
$res = preg_match($exp, trim($row['TRIGGERS']), $reg);
if ($res) {
ibase_free_result($rs);
$sql = "SELECT GEN_ID(" . $reg[1] . ", 0) as lastid FROM RDB\$DATABASE";
$rs = $cn->executeSQL($sql);
$row = ibase_fetch_row($rs);
ibase_free_result($rs);
return $row[0];
}
}
ibase_free_result($rs);
return 0;
}
开发者ID:bladerangel,项目名称:aplicacao,代码行数:35,代码来源:Firebird.php
示例14: gcms_fetch_assoc
function gcms_fetch_assoc($nresult)
{
return ibase_fetch_assoc($nresult);
}
开发者ID:ibnoe,项目名称:simpatda-thinkfrogs,代码行数:4,代码来源:firebird.php
示例15: _fetch_assoc
/**
* Result - associative array
*
* Returns the result set as an array
*
* @return array
*/
protected function _fetch_assoc()
{
return ibase_fetch_assoc($this->result_id, IBASE_FETCH_BLOBS);
}
开发者ID:sacsand,项目名称:abcd,代码行数:11,代码来源:ibase_result.php
示例16: fetchResultLimit
/**
* Devuelve $limit filas encontradas a partir de la fila $offset
* Este metodo es similar a fetchResult.
* @param integer $limit
* @param integer $offset
* @return array Las filas encontradas
*/
public function fetchResultLimit($limit, $rowNumber = '')
{
$rows = array();
$nfilas = 0;
if ($rowNumber < 0) {
$rowNumber = 1;
}
switch (self::$dbEngine) {
case 'mysql':
@mysql_data_seek($this->result, $rowNumber);
while ($row = mysql_fetch_array($this->result, MYSQL_ASSOC) and $nfilas < $limit) {
$nfilas++;
$rows[] = $row;
}
break;
case 'mssql':
//NO ESTA BIEN IMPLEMENTADO
while ($row = mssql_fetch_array($this->result, MYSQL_ASSOC)) {
$rows[] = $row;
}
break;
case 'interbase':
//NO ESTA BIEN IMPLEMENTADO
while ($row = ibase_fetch_assoc($this->result)) {
$rows[] = $row;
}
break;
case 'pgsql':
$valores = explode(",", $limit);
if (count($valores) == 1) {
$limit = "LIMIT {$valores[0]}";
} elseif (count($valores) == 2) {
$limit = "LIMIT {$valores[1]} OFFSET {$valores[0]}";
}
$query = "{$select} WHERE {$filtro} ORDER BY {$orderBy} {$limit}";
break;
default:
$this->setError("fetchResultLimit", "No se ha indicado el tipo de base de datos");
break;
}
return $rows;
}
开发者ID:albatronic,项目名称:hermes,代码行数:49,代码来源:EntityManager.class.php
示例17: _fetch_assoc
/**
* Result - associative array
*
* Returns the result set as an array
*
* @return array
*/
protected function _fetch_assoc()
{
if (($row = @ibase_fetch_assoc($this->result_id, IBASE_FETCH_BLOBS)) !== FALSE) {
//Increment row count
$this->num_rows++;
}
return $row;
}
开发者ID:rittidate,项目名称:sbobet-dev,代码行数:15,代码来源:interbase_result.php
示例18: GeraVersaoRelatorios
//.........这里部分代码省略.........
"rpt_cdate" TIMESTAMP NOT NULL,
"rpt_mdate" TIMESTAMP,
"rpt_content" BLOB SUB_TYPE 1 SEGMENT SIZE 80,
"rpt_owner" VARCHAR(100),
"rpt_status" VARCHAR(10),
"rpt_type" VARCHAR(10) NOT NULL
);
ALTER TABLE "webreports" ADD PRIMARY KEY ("rpt_id");
SET TERM ^ ;
CREATE OR ALTER TRIGGER "t_webreports" FOR "webreports"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW."rpt_id" IS NULL)
THEN NEW."rpt_id" = GEN_ID("g_webreports", 1);
END
^
SET TERM ; ^
';
//Populando a tabela webreports webreport_admin
$sqlQuery = "SELECT * FROM " . '"webreport_admin"';
if ($result = parent::execute_query($sqlQuery)) {
while ($linha = ibase_fetch_assoc($result, IBASE_TEXT)){
$Script .= 'INSERT INTO'
. '"webreport_admin"'
. '('
. '"id", '
. '"tablename", '
. '"db_type" , '
. '"group_name" '
. ')'
. 'VALUES'
. '('
. $linha['id'] . ', '
. "'" . $linha['tablename'] . "'" . ','
. "'" . $linha['db_type'] . "'" . ','
. "'" . $linha['group_name'] . "'"
. ");";
//echo $Insert . "<br>";
}
}
########################################################################################
//Populando a tabela webreport_settings
$sql = "SELECT * FROM " . '"webreport_settings"';
if ($result = parent::execute_query($sql)) {
while ($linha = ibase_fetch_assoc($result, IBASE_TEXT)){
$Script .= 'INSERT INTO'
. '"webreport_settings" '
开发者ID:helbertfurbino,项目名称:sgmofinanceiro,代码行数:67,代码来源:geraVersaoRelatorio.php
示例19: fetchInto
function fetchInto($result, &$ar, $fetchmode, $rownum = null)
{
if ($rownum !== NULL) {
return $this->ibaseRaiseError(DB_ERROR_NOT_CAPABLE);
}
if ($fetchmode & DB_FETCHMODE_ASSOC) {
if (function_exists('ibase_fetch_assoc')) {
$ar = @ibase_fetch_assoc($result);
} else {
$ar = get_object_vars(ibase_fetch_object($result));
}
if ($ar && $this->options['optimize'] == 'portability') {
$ar = array_change_key_case($ar, CASE_LOWER);
}
} else {
$ar = @ibase_fetch_row($result);
}
if (!$ar) {
if ($errmsg = ibase_errmsg()) {
return $this->ibaseRaiseError(null, $errmsg);
} else {
return null;
}
}
return DB_OK;
}
开发者ID:amjadtbssm,项目名称:website,代码行数:26,代码来源:ibase.php
示例20: nextr
public function nextr($result)
{
return ibase_fetch_assoc($result, IBASE_TEXT);
}
开发者ID:roychoo,项目名称:jstree,代码行数:4,代码来源:class.db.php
注:本文中的ibase_fetch_assoc函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论