本文整理汇总了PHP中ibase_fetch_row函数的典型用法代码示例。如果您正苦于以下问题：PHP ibase_fetch_row函数的具体用法？PHP ibase_fetch_row怎么用？PHP ibase_fetch_row使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ibase_fetch_row函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: NumRows
function NumRows($result)
{
if (!is_resource($result)) {
return false;
}
return ibase_fetch_row($result);
}
开发者ID:ofarias，项目名称:phpPegaso，代码行数:7，代码来源:database.php
示例2: Buscar
function Buscar($q)
{
$conn = ibase_connect($this->src, $this->user, $this->password);
$query = "SELECT INVE03.CVE_ART, INVE03.DESCR FROM inve03 where INVE03.DESCR LIKE '%" . $q . "%' AND INVE03.STATUS='A' OR INVE03.CVE_ART LIKE '%" . $q . "%' AND INVE03.STATUS='A' ORDER BY INVE03.CVE_ART";
$inv = ibase_query($conn, $query);
print "<table width='100%' border='0' cellspacing='0' cellpadding='0' style='font-family:Verdana; font-size:10; font-color:#CDCD'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td></td>\n\t\t\t\t</tr>";
while ($IN = ibase_fetch_row($inv)) {
print "<tr>" . "<td>" . $IN[1] . "</td>" . "<td><input style='border:0; background-color: #f9f9f9; font-family:Verdana; font-size:10; font-color:#CDCD; cursor:pointer' type='submit' id='valor2' value='" . $IN[0] . "' onClick='Resultado(\"" . $IN[0] . "\");'/></td>" . "</tr>";
}
print "</table>";
}
开发者ID:kailIII，项目名称:Inventarios-1，代码行数:11，代码来源:findinv.php
示例3: searchRow
function searchRow($table, $idfield, $idvalue, $pparkir_id)
{
$sql = 'select count(*) as jumlah from ' . $table . ' where ' . $idfield . ' = ' . $idvalue . ' and pparkir_id = ' . $pparkir_id;
$result = ibase_query($sql);
$row = ibase_fetch_row($result);
if ($row[0]) {
return true;
} else {
return false;
}
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:11，代码来源:pendataan_parkir.asyc.php
示例4: ValidarUsuario
public function ValidarUsuario($login, $senha) {
$sql = parent::execute_query("SELECT UCIDUSER, UCUSERNAME, UCLOGIN, UCINATIVE, UCPROFILE FROM UCTABUSERS WHERE UCLOGIN = " . "'$login'" . "AND PASSWORD_MD5 = " . "'$senha'");
$usuario = FALSE;
if (ibase_fetch_row($sql)) {
$sql = parent::execute_query("SELECT UCIDUSER, UCUSERNAME, UCLOGIN, UCPROFILE, UCINATIVE FROM UCTABUSERS WHERE UCLOGIN = " . "'$login'" . "AND PASSWORD_MD5 = " . "'$senha'");
$linha = parent::criaObjetoConsulta($sql);
//Verifica se o usuário tem acesso ao modulo financeiro
if ($linha->UCLOGIN != 'ADMIN') {
$linha2 = parent::criaObjetoConsulta(parent::execute_query("SELECT PERMITIR_ACESSO_FINANCEIRO_WEB FROM UCTABUSERS WHERE CHAVE_USER = " . $linha->UCPROFILE));
if (trim($linha2->PERMITIR_ACESSO_FINANCEIRO_WEB) != "S") {
$this->setMotivoErro("Usuário não possui acesso ao módulo financeiro, solicite permissão ao administrador");
return FALSE;
}
}
//Verifica se o usuário possui acesso somente ao módulo recepção para lançamentos de contas a receber
if ($linha->UCLOGIN != 'ADMIN') {
$linha3 = parent::criaObjetoConsulta(parent::execute_query("SELECT PERMITIR_ACESSO_RECEPCAO_WEB FROM UCTABUSERS WHERE CHAVE_USER = " . $linha->UCPROFILE));
}
//Verifica se o usuário encontra ativo
if ($linha->UCINATIVE == 1) {
$this->setMotivoErro("Usuário encontra-se inativo no sistema");
return FALSE;
}
//Cria o objeto usuario
$usuario = new Musuario();
$usuario->setId($linha->UCIDUSER);
$usuario->setNome($linha->UCUSERNAME);
$usuario->setLogin($linha->UCLOGIN);
$usuario->setAtivo($linha->UCINATIVE);
//Recupera a filial padrão
$usuario->setFilialUsuario(parent::RecuperaCampo("MY_PARAMETRO_ID", "PARAMETRO", "PARAMETRO_ID", 1));
//Verifica se é usuário recepção
if ($usuario->getLogin() != 'ADMIN')
$usuario->setModuloRecepcao(trim($linha3->PERMITIR_ACESSO_RECEPCAO_WEB));
return $usuario;
}
$this->setMotivoErro("Usuário ou senha incorreto");
return FALSE;
}
开发者ID:helbertfurbino，项目名称:sgmofinanceiro，代码行数:49，代码来源:Musuario.php
示例5: select
function select($sql)
{ $j=0;
$Row=array(array());
$this->sql_connect();
$this->sql_query=$sql;
$this->sql_execute();
while($Mas = ibase_fetch_row($this->sql_result))
{
for ($i=0;$i<count($Mas);$i++){
$Row[$j][$i] = $Mas[$i];
}
$j++;
}
return $Row;
}
开发者ID:semteacher，项目名称:tdmu-vidomosti2，代码行数:16，代码来源:class_firebird.php
示例6: Count
function Count()
{
$_count_command = "SELECT COUNT(*) FROM (" . $this->SelectCommand . ") {where}";
$_where = "";
$_filters = $this->Filters;
for ($i = 0; $i < sizeof($_filters); $i++) {
$_where .= " and " . $this->GetFilterExpression($_filters[$i]);
}
if ($_where != "") {
$_where = "WHERE " . substr($_where, 5);
}
$_count_command = str_replace("{where}", $_where, $_count_command);
$_result = ibase_query($this->_Link, $_count_command);
$_row = ibase_fetch_row($_result);
ibase_free_result($_result);
return $_row[0];
}
开发者ID:skydel，项目名称:universal-online-exam，代码行数:17，代码来源:FirebirdDataSource.php
示例7: fetch_row
function fetch_row()
{
return ibase_fetch_row($this->_result);
}
开发者ID:tlandn，项目名称:akvo-sites-zz-template，代码行数:4，代码来源:firebird.inc.php
示例8: Connectqro
}
}
//CONECTA QUERETARO
$conn10 = Connectqro();
$sql10 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC ";
$ent10 = ibase_query($conn10, $sql10);
while ($QRO = ibase_fetch_row($ent10)) {
if ($S[3] == $QRO[3] and $S[0] == $QRO[0]) {
$qro = 1;
}
}
//CONECTA TUXTLA
$conn11 = Connecttgz();
$sql11 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC ";
$ent11 = ibase_query($conn11, $sql11);
while ($TGZ = ibase_fetch_row($ent11)) {
if ($S[3] == $TGZ[3] and $S[0] == $TGZ[0]) {
$tgz = 1;
}
}
if ($mex == 0 and $gto == 0 and $gdl == 0 and $mty == 0 and $pue == 0 and $ver == 0 and $cun == 0 and $mid == 0 and $cuu == 0 and $qro == 0 and $tgz == 0) {
echo "<tr><td>{$S['0']}</td><td>{$S['3']}</td>";
echo "<td>{$S['4']}</td>";
echo "<td>{$maskSAL}</td><td>Sin Coincidencia</td></tr>";
$count = $count + 1;
}
if ($mex == 1) {
$mex = 0;
}
if ($gto == 1) {
$gto = 0;
开发者ID:kailIII，项目名称:Inventarios-1，代码行数:31，代码来源:TRASPASOS_C.php
示例9: 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
示例10: while
while ($E = ibase_fetch_row($ent)) {
if ($S[2] == $E[2] and $S[0] == $E[0]) {
$fechasale = ibase_query($conn, $sqlF);
while ($F = ibase_fetch_row($fechasale)) {
if ($S[2] == $F[2] and $S[0] == $F[0]) {
$encontro = $F[1];
}
}
$cantDifsal = ibase_query($conn, $sql3);
while ($SD = ibase_fetch_row($cantDifsal)) {
if ($S[2] == $SD[2] and $S[0] == $SD[0]) {
$difSal = $SD[3];
}
}
$cantDifent = ibase_query($conn2, $sql4);
while ($SE = ibase_fetch_row($cantDifent)) {
if ($E[2] == $SE[2] and $E[0] == $SE[0]) {
$difEnt = $SE[3];
}
}
//Calculo diferencias en montos de Salidas
$maskCantS = $S[3] * -1;
$totalDifsal = $maskCantS + $difSal;
$totalDifent = $E[3] - $difEnt;
$dif = $totalDifsal + $totalDifent;
$fechasal = $encontro;
$maskSAL = $fechasal[8] . $fechasal[9] . $fechasal[7] . $fechasal[5] . $fechasal[6] . $fechasal[4] . $fechasal[0] . $fechasal[1] . $fechasal[2] . $fechasal[3];
$count = $count + 1;
if ($dif == 0) {
echo "<tr style='font-size:9px; color:#000000'><td style='font-family:Verdana'>{$count}</td><td style='font-family:Consolas;font-size:11px'>{$S['0']}</td><td style='font-family:Verdana'>{$S['2']}</td><td align='center' style='font-family:Verdana'>{$totalDifsal}</td><td align='center' style='font-family:Verdana'>{$maskSAL}</td><td style='font-family:Verdana'>{$E['2']}</td><td align='center' style='font-family:Verdana'>{$totalDifent}</td><td style='font-family:Verdana'>{$dif}</td>";
} else {
开发者ID:kailIII，项目名称:Inventarios-1，代码行数:31，代码来源:TRASPASOS.php
示例11: ibase_free_result
}
$kdl .= "~ \\footnotesize " . $row[0] . " & \\footnotesize " . $ress . " & \\footnotesize " . $unit . " & \\footnotesize " . $charlimits . " \\\\ \n";
$kdl .= "\\hline" . "\n";
}
ibase_free_result($res);
}
}
}
$kdluser = "";
$restm = "select distinct u.fullname from ordtask o inner join users u on u.usernam = o.appruser where o.ordersid in(" . $ordersid . ") and o.testcode in (791, 1974) order by o.apprdate desc";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$kdluser .= $row[0] . " ";
}
ibase_free_result($res);
$kdlcomments = "";
$restm = "select distinct f.comments from foldercomments f inner join orders o on o.folderno = f.folderno inner join ordtask ord on ord.ordersid=o.id where o.id in(" . $ordersid . ") and ord.testcode in (791,1974) and f.flag = 'Y' and f.ordtaskid =ord.id order by f.id";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$kdlcomments .= "\\small \\quad " . $row[0] . "\n\n";
}
ibase_free_result($res);
$kdlhead = "\n\\begin{longtable}[h]{|m{160px}|>{\\centering\\arraybackslash}p{105px}|m{55px}|m{122.5px}|}\n\\hline\nИсследование & Результат & Единицы \\newline измерения & Референты \\\\\n\\hline";
$kdlcomments = str_replace('%', '\\%', $kdlcomments);
$restm = "select r.finalresult from results r inner join ordtask o on o.id = r.ordtaskid where o.ordersid in ( " . $ordersid . ") and r.analyteid= 2884";
$res = ibase_query($dbh, $restm);
$row = ibase_fetch_row($res);
$data = " ВПЧ HPVвкр-б/о типа-кач-ДНК & " . $row[0] . " & & \\\\ \\end{longtable} \\vspace{-24px}";
$kdlend = "\\end{longtable} \\vspace{-5px} Комментарии: " . $kdlcomments . "\n \\begin{center} \\textbf{Цитологические исследования} \n\n \\end{center}";
$end = "\n\n\\ \\flushleft \\textbf{Исследования проводили}:\n\\flushleft Маркеры опухолевого роста: " . $kdluser . " \\vspace{-3px}\n\\flushleft Цитологические исследования: " . $apprusergist . " \\vspace{-3px} \n\\flushleft ПЦР-исследования: " . $apprpcr . " \\vspace{-3px}\n\\flushright Дата выдачи: " . $apprdate;
$response = $head . $kdlhead . $kdl . $kdlend . $results . $headpcr . $kdlhead . $data . $pcr . $endpcr . $end;
开发者ID:KhasanOrsaev，项目名称:work_nacpp，代码行数:31，代码来源:form37.php
示例12: 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
示例13: form30
function form30($orders, $dbh, $crd)
{
$curdate = date("m.d.Y");
$ordersid = "";
$n = count($orders);
for ($i = 1; $i < $n; $i++) {
$ordersid .= $orders[$i];
if ($i != $n - 1) {
$ordersid .= ",";
}
}
$results = "";
$stmt = "select t.testname, t.id, o.id from ordtask o inner join tests t on t.id = o.testcode inner join orders ord on ord.id = o.ordersid inner join panels p on p.id = ord.panelid where ord.id in (" . $ordersid . ") order by p.priority ";
$result = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_row($result)) {
$restm = "select count(*) from results where ordtaskid = " . $row[2] . " and finalresult is not null and status in ('O','E') and show = 'Y'";
$res = ibase_query($dbh, $restm);
$n = ibase_fetch_row($res);
$n = $n[0];
ibase_free_result($res);
if ($n == 1) {
$restm = "select a.analyte, case a.analtype when 3 then replace(r.finalresult,'.',',') else coalesce(pos.inreport, r.finalresult) end, u.short, r.charlimits, r.status from results r left join units u on u.id = r.unit inner join analytes a on a.id = r.analyteid left join possibleresults pos on pos.analyte = r.analyteid and r.rawresult = pos.result where r.ordtaskid = " . $row[2] . " and finalresult is not null order by a.sorter ";
$res = ibase_query($dbh, $restm);
$row = ibase_fetch_row($res);
$ress = $row[1];
if ($row[4] == "O") {
$ress = "\\textbf{" . $row[1] . "}";
}
$row[0] = str_replace('%', '\\%', $row[0]);
$row[0] = str_replace('β', '$\\beta$', $row[0]);
$results .= "\\textbf{" . $row[0] . "} & " . $ress . " & " . $row[2] . " & " . $row[3] . " \\\\ \n";
$results .= "\\hline" . "\n";
ibase_free_result($res);
} else {
$row[0] = str_replace('%', '\\%', $row[0]);
$row[0] = str_replace('β', '$\\beta$', $row[0]);
$results .= "\\textbf{" . $row[0] . "} & & & \\\\ \n\\hline \n";
$restm = "select a.analyte, case a.analtype when 3 then replace(r.finalresult,'.',',') else coalesce(pos.inreport, r.finalresult) end, coalesce(u.short, ' '), coalesce(r.charlimits, ' '), r.status from results r left join units u on u.id = r.unit inner join analytes a on a.id = r.analyteid left join possibleresults pos on pos.analyte = r.analyteid and pos.result = r.rawresult where r.ordtaskid = " . $row[2] . " and finalresult is not null order by a.sorter";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$unit = $row[2];
//$unit = str_replace('%','\\%',$row[2]);
//$unit = str_replace('^','\\^{}',$unit);
$charlimits = str_replace('%', '\\%', $row[3]);
$charlimits = str_replace('^', '\\^{}', $charlimits);
$ress = $row[1];
if ($row[4] == "O") {
$ress = "\\textbf{" . $row[1] . "}";
}
$results .= "~ \\footnotesize " . $row[0] . " & \\footnotesize " . $ress . " & \\footnotesize " . $unit . " & \\footnotesize " . $charlimits . " \\\\ \n";
$results .= "\\hline" . "\n";
}
ibase_free_result($res);
}
}
$user = "";
$restm = "select distinct coalesce(u.fullname, '') from users u inner join results r on r.usernam = u.usernam inner join ordtask o on o.id = r.ordtaskid inner join orders ord on ord.id = o.ordersid where ord.id in (" . $ordersid . ") ";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$user .= $row[0];
}
ibase_free_result($res);
$appruser = "";
$restm = "select distinct u.fullname from ordtask o inner join users u on u.usernam = o.appruser where o.ordersid in(" . $ordersid . ")";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$appruser .= $row[0] . " ";
}
ibase_free_result($res);
$comments = "";
$restm = "select distinct f.comments from foldercomments f inner join orders o on o.folderno = f.folderno where o.id in(" . $ordersid . ") and f.flag = 'Y' order by f.id";
$res = ibase_query($dbh, $restm);
while ($row = ibase_fetch_row($res)) {
$comments .= "\\small \\quad " . $row[0] . "\n\n";
}
ibase_free_result($res);
$biomat = find_biomat($ordersid, $dbh);
$panelname = find_panel($ordersid, $dbh);
$head = "\\vspace{-10px} \\flushleft \\normalsize Биоматериал: " . $biomat . "\n\n\\vspace{3px}";
$head .= "\n\n\\vspace{1px}";
$head .= "\\begin{center} ";
$head .= "\\textbf{" . $panelname . "}\\end{center} \n\n\\vspace{-5px}";
$head .= "\n\\begin{longtable}[h]{|m{160px}|>{\\centering\\arraybackslash}p{100px}|m{60px}|m{112px}|}\n\\hline\nИсследование & Результат & Единицы \\newline измерения & Референты \\\\\n\\hline";
$apprdate = find_apprdate($ordersid, $dbh);
$comments = str_replace('%', '\\%', $comments);
$end = "\\end{longtable}\n\\vspace{-15px}\n\\flushleft Комментарии:" . $comments . "\n\\vspace{-4px}\n\\flushleft Исследования проводил: " . $user . " \n\\vspace{-4px}\n\\flushleft Выпускающий врач: " . $appruser . " \n\\newline\n\\flushright Дата выдачи: " . $apprdate;
return $head . $results . $end;
}
开发者ID:KhasanOrsaev，项目名称:work_nacpp，代码行数:88，代码来源:form32.php
示例14: fetchInto
/**
* Places a row from the result set into the given array
*
* Formating of the array and the data therein are configurable.
* See DB_result::fetchInto() for more information.
*
* This method is not meant to be called directly. Use
* DB_result::fetchInto() instead. It can't be declared "protected"
* because DB_result is a separate object.
*
* @param resource $result the query result resource
* @param array $arr the referenced array to put the data in
* @param int $fetchmode how the resulting array should be indexed
* @param int $rownum the row number to fetch (0 = first row)
*
* @return mixed DB_OK on success, NULL when the end of a result set is
* reached or on failure
*
* @see DB_result::fetchInto()
*/
function fetchInto($result, &$arr, $fetchmode, $rownum = null)
{
if ($rownum !== null) {
return $this->ibaseRaiseError(DB_ERROR_NOT_CAPABLE);
}
if ($fetchmode & DB_FETCHMODE_ASSOC) {
if (function_exists('ibase_fetch_assoc')) {
$arr = @ibase_fetch_assoc($result);
} else {
$arr = get_object_vars(ibase_fetch_object($result));
}
if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) {
$arr = array_change_key_case($arr, CASE_LOWER);
}
} else {
$arr = @ibase_fetch_row($result);
}
if (!$arr) {
return null;
}
if ($this->options['portability'] & DB_PORTABILITY_RTRIM) {
$this->_rtrimArrayValues($arr);
}
if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) {
$this->_convertNullArrayValuesToEmpty($arr);
}
return DB_OK;
}
开发者ID:ryo88c，项目名称:BEAR.Saturday，代码行数:48，代码来源:ibase.php
示例15: NumberOfRows
function NumberOfRows($result)
{
$result_value = intval($result);
if (!isset($this->current_row[$result_value])) {
return $this->SetError("Number of rows", "attemped to obtain the number of rows contained in an unknown query result");
}
if (!isset($this->rows[$result_value])) {
if (!$this->GetColumnNames($result, $column_names)) {
return 0;
}
if (isset($this->limits[$result_value])) {
if (!$this->SkipFirstRows($result)) {
$this->rows[$result_value] = 0;
return 0;
}
$limit = $this->limits[$result_value][1];
} else {
$limit = 0;
}
if ($limit == 0 || $this->current_row[$result_value] + 1 < $limit) {
if (isset($this->row_buffer[$result_value])) {
$this->current_row[$result_value]++;
$this->results[$result_value][$this->current_row[$result_value]] = $this->row_buffer[$result_value];
unset($this->row_buffer[$result_value]);
}
for (; ($limit == 0 || $this->current_row[$result_value] + 1 < $limit) && GetType($this->results[$result_value][$this->current_row[$result_value] + 1] = @ibase_fetch_row($result)) == "array"; $this->current_row[$result_value]++) {
}
}
$this->rows[$result_value] = $this->current_row[$result_value] + 1;
}
return $this->rows[$result_value];
}
开发者ID:BackupTheBerlios，项目名称:zvs，代码行数:32，代码来源:metabase_ibase.php
示例16: fetch_array
/**
* Devuelve fila por fila el contenido de un select
*
* @param resource $result_query
* @param int $opt
* @return array
*/
public function fetch_array($result_query = '', $opt = MYSQL_BOTH)
{
if (!$this->id_connection) {
return false;
}
if (!$result_query) {
$result_query = $this->last_result_query;
if (!$result_query) {
return false;
}
}
if ($opt == db::DB_BOTH) {
$fetch = ibase_fetch_assoc($result_query);
$result = array();
$i = 0;
foreach ($fetch as $key => $value) {
$result[$key] = $value;
$result[$i++] = $value;
}
return $result;
}
if ($opt == db::DB_ASSOC) {
return ibase_fetch_assoc($result_query);
}
if ($opt == db::DB_NUM) {
return ibase_fetch_row($result_query);
}
return $result;
}
开发者ID:slrondon，项目名称:MikrotikCenter，代码行数:36，代码来源:firebird.php
示例17: ibase_query
}
}
$fechasale = ibase_query($conn, $sqlF);
while ($F = ibase_fetch_row($fechasale)) {
if ($C[2] == $F[2] and $C[0] == $F[0]) {
$encontro = $F[1];
}
}
$invcosto = ibase_query($conninv, $sqlCosto);
while ($COSTO = ibase_fetch_row($invcosto)) {
if ($C[0] == $COSTO[0]) {
$ult_costo = $COSTO[1];
}
}
$enlace = ibase_query($conn, $sqlDoctoE);
while ($ENC = ibase_fetch_row($enlace)) {
if ($C[0] == $ENC[0] and $C[2] == $ENC[1]) {
$enlazado = $ENC[2];
}
}
$fechasal = $encontro;
$maskSAL = $fechasal[8] . $fechasal[9] . $fechasal[7] . $fechasal[5] . $fechasal[6] . $fechasal[4] . $fechasal[0] . $fechasal[1] . $fechasal[2] . $fechasal[3];
$counter = $count + 1;
$count = $counter;
$diferencia = $C[3] - $dif;
//Convierte
$kardex2 = $kardex;
@touch($kardex2);
if (filesize($kardex2) > 1024000) {
rename($kardex2, $kardex2 . '_' . date(Ymdhis));
}
开发者ID:kailIII，项目名称:Inventarios-1，代码行数:31，代码来源:generatedev.php
示例18: 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
示例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: alert
$cant = 0;
$dif = 0;
$ult_costo = 0;
$kardex = "D:/SAE50/MOVIMIENTOS/" . "{$nombreTXT}" . ".txt";
if (file_exists($kardex)) {
?>
<script language='JavaScript'>
alert('ERROR!!! NO SE GENERO EL ARCHIVO: Un archivo ya existe con ese nombre. Revisar carpeta de movimientos.');
window.location="indexexporta.php";
</script>
<?php
$kardex = null;
}
while ($C = ibase_fetch_row($cedis)) {
$invcosto = ibase_query($conninv, $sqlCosto);
while ($COSTO = ibase_fetch_row($invcosto)) {
if ($C[0] == $COSTO[0]) {
$ult_costo = $COSTO[1];
}
}
$fechaE = $C[2];
$fechaDocu = $fechaE[8] . $fechaE[9] . $fechaE[7] . $fechaE[5] . $fechaE[6] . $fechaE[4] . $fechaE[0] . $fechaE[1] . $fechaE[2] . $fechaE[3] . $fechaE[10];
if (!$conninv) {
?>
<script language='JavaScript'>
alert('ERROR DE CONEXION: VUELVE A GENERAR TU REPORTE');
window.location="indexexporta.php";
</script>
<?php
} else {
//Convierte
开发者ID:kailIII，项目名称:Inventarios-1，代码行数:31，代码来源:ajustes.php
注：本文中的ibase_fetch_row函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论