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

PHP dbFA函数代码示例

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


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

示例1: dbFetch

function dbFetch($s,$t,$f=""){
	$t=dbSel($s,$t,$f." LIMIT 0,1");
	if(dbNRow($t)==1){
		$r=dbFA($t);
		return $r[$s];
	}else{
		return '';
	}
}
开发者ID:nickohappy7，项目名称:sister，代码行数:9，代码来源:db.php

示例2: MstrGetNextUrut

function MstrGetNextUrut($t, $a, $o = "")
{
    $ts = dbSel("dcid,urut", $t, "O/ urut " . $o);
    $lid = array(-1, 0, 0);
    while ($rs = dbFA($ts)) {
        if ($rs['dcid'] == $a) {
            $lid[2] = $rs['urut'];
            return $lid;
        }
        $lid[0] = $rs['dcid'];
        $lid[1] = $rs['urut'];
    }
    return $lid;
}
开发者ID:epiii，项目名称:siadu-epiii，代码行数:14，代码来源:masterdb.php

示例3: mysql_query

						<?php 
$tpf = mysql_query("SELECT * FROM emp_training WHERE empid='" . $r['dcid'] . "' ORDER BY dcid");
$npf = mysql_num_rows($tpf);
if ($npf > 0) {
    $rpf = mysql_fetch_array($t);
    $filelist = array();
    $tf = dbSel("dcid,file", "emp_files", "W/empid='" . $r['dcid'] . "'");
    while ($rf = dbFA($tf)) {
        $filelist[$rpf['dcid']] = $rf['file'];
    }
    ?>
						<div class="sfont" style="padding:5px 0 5px 0;background:#ededff;">
							<b><?php 
    echo $r['fname'];
    ?>
's Training record<?php 
    echo $npf > 1 ? "s" : "";
    ?>
:</b>
						</div><br/>
						<table class="tablex" border="0" cellspacing="1px" width="885px">
						<tr class="tablexhead">
							<th>Title</th>
							<th>Type</th>
							<th>Host</th>
							<th>Place</th>
							<th>Date</th>
							<th>Speaker</th>
							<th>Participant</th>
							<th style="text-align:center">Certified</th>
							<th style="text-align:center">Option</th>
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:pf_train.php

示例4: mysql_query

px;margin-right:4px;margin-top:10px;margin-bottom:4px">
<?php 
$t1 = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'");
$k = 0;
while ($r1 = mysql_fetch_array($t1)) {
    $n = mysql_num_rows(mysql_query("SELECT * FROM psb_calonsiswa WHERE kelompok='" . $r1['replid'] . "' AND status<>0"));
    $w = intval($n * $barw / $kapasitas);
    echo '<div style="float:left;background:' . $bcolor[$k++] . ';height:4px;width:' . $w . 'px"></div>';
}
?>
</div>
<?php 
//$t=dbQSql($token);
$no = 1;
$doc->head('No{C}', '@Kelompok', '@Tanggal Pendaftaran', '@Biaya Pendaftaran', '@calon Siswa', '@Siswa diterima', 'Keterangan');
while ($r = dbFA($query)) {
    $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'");
    $n1 = mysql_num_rows($q);
    $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0");
    $n2 = mysql_num_rows($q);
    $doc->nl();
    $doc->cell($no++, 20, 'c');
    $doc->cell($r['kelompok'], 80);
    $doc->cell(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 50);
    $doc->cell(fRp($r['biaya']), 50);
    //$doc->cell($r['biaya'],50);
    $doc->cell($n1, 50);
    $doc->cell($n2, 50);
}
$doc->cell($r['keterangan'], 50);
$doc->end();
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:kelompok.php

示例5: appmod_use

<?php

appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor');
// cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='')
$token = gets('token');
$db = siswa_db_byID($token, 'nisn,kelamin,tmplahir,tgllahir,alamat,telpon');
$db->field("mst_agama.agama as nagama");
$db->joinother("aka_siswa", "agama", "mst_agama");
$t = $db->query();
$siswa = dbFA($t);
$doc = new doc(1);
$doc->dochead("DATA SISWA", 4);
$doc->nl();
$doc->cell('<b>' . strtoupper($siswa['nama']) . '</b>', 0, '', 4, 1, 'b');
$doc->nl(5);
$doc->cell('', 0, '', 3);
$lw = 120;
$doc->nl();
$doc->cell('Departemen', $lw, '');
$doc->cell(': ' . $siswa['ndepartemen'], 0, '', 2);
$img = '<img src="photo/siswa.php?id=' . $siswa['replid'] . '" width="120px" />';
$doc->cell($img, 200, 'r', 1, 10);
$doc->nl();
$doc->cell('NIS', $lw, '');
$doc->cell(': ' . $siswa['nis'], 0, '', 2);
$doc->nl();
$doc->cell('NISN', $lw, '');
$doc->cell(': ' . $siswa['nisn'], 0, '', 2);
$doc->nl();
$doc->cell('', 0, '', 3);
$doc->nl();
开发者ID:nickohappy7，项目名称:sister，代码行数:31，代码来源:siswa_detil.php

示例6: cetak_kolom

// Table body formatting
$pdf->SetFont(mydeffont, '', 8, '', true);
$pdf->setCellPaddings(1, 1, 1, 1);

$row=1;

function cetak_kolom($ik){
	global $pdf,$twx,$tax,$my,$i;
	$pdf->MultiCell($twx[$i], 0, $ik, 0, $tax[$i++], 0, 0, '', '', true);
	if($pdf->getLastH()>$my)$my=$pdf->getLastH();
}

$fst=true; $LCEK='';

while($r=dbFA($t)){ $i=0;
	if($pdf->GetY()>180) {
		$pdf->AddPage();
		page_header();
		
		$pdf->SetTextColor(255);
		$pdf->SetFillColor(0);
		for($i=0;$i<$thx_n;$i++){
			$pdf->MultiCell($twx[$i], 0, $thx[$i], 1, $tax[$i], 1, 0, '', '', true);
		}
		$pdf->Ln();
		$pdf->SetTextColor(0);
	}
	
	if($LCEK!=''){
		if($r['cek']!=$LCEK){
开发者ID:nickohappy7，项目名称:sister，代码行数:30，代码来源:stocktake.php

示例7: dbQSql

$doc->cell('<b>: ' . $siswa['nkelas'] . '</b>', 0, '', 4);
$doc->nl();
$doc->cell('', 40);
$doc->cell('', 60);
$doc->cell('', 0, '', 4);
$doc->cell_format('border:1,align:c');
$doc->nl(30);
$doc->cell('<b>NO</b>', 40);
$doc->cell('<b>MATA PELAJARAN</b>', 0, '', 2);
$doc->cell('<b>NILAI</b>', 80);
$doc->cell('<b>KKM</b>', 80);
$doc->cell('<b>KETUNTASAN</b>', 120);
$no = 1;
$jmlnilai = 0;
$tpel = dbQSql("SELECT aka_pelajaran.replid,aka_pelajaran.nama FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE aka_sks.kelas='" . $siswa['idkelas'] . "' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama");
while ($rpel = dbFA($tpel)) {
    $doc->nl();
    // cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='')
    $nilai = rapor_pelajaran_nilai($rpel['replid'], $kls, $siswa['replid']);
    $skm = pelajaran_skm($rpel['replid']);
    $doc->cell($no++, 40);
    $doc->cell($rpel['nama'], '244#', 'l', 2, 1);
    $doc->cell(number_format($nilai, 2), 80);
    $doc->cell(number_format($skm, 2), 80);
    $doc->cell($nilai < $skm ? 'Tidak tuntas' : 'Tuntas', 120);
    $jmlnilai += $nilai;
}
$rata = $jmlnilai / ($no - 1);
$doc->nl();
$doc->cell('<b>Jumlah Nilai</b>', 0, '', 3);
$doc->cell('<b>' . $jmlnilai . '</b>' . '[x:fmla="=SUM(D8:D10)" x:num]', 'c');
开发者ID:sofiasrifin，项目名称:sistermetta，代码行数:31，代码来源:nilairapor.php

示例8: dbSel

     // Reference** name	address	phone	job	know	relation
     $q = dbSel("*", "emp_reference", "W/empid='{$dcid}'");
     if (dbNRow($q) == 0) {
         $pdf->SetFont('dejavusans', 'B', 9, '', true);
         $pdf->MultiCell($dcPageW, 0, "References: N/A", 0, 'L', 0, 1, '', '', true);
         $pdf->Ln();
     } else {
         $pdf->SetFont('dejavusans', 'B', 9, '', true);
         $pdf->MultiCell($dcPageW, 0, "References", 0, 'L', 0, 1, '', '', true);
         $pdf->SetFont('dejavusans', '', 9, '', true);
         dc_YDown(1);
         $th = array('Name', 'Address', 'Phone', 'Job', 'Since', 'Relation');
         $tw = array(0, 60, 20, 30, 20, 20);
         $pdf->setCellPaddings(0.5, 0.5, 0.5, 0.5);
         dc_tableHead($th, $tw);
         while ($f = dbFA($q)) {
             $i = 0;
             $pdf->MultiCell($tw[$i++], 0, $f['name'], 0, 'L', 0, 0, '', '', true);
             $pdf->MultiCell($tw[$i++], 0, $f['address'], 0, 'L', 0, 0, '', '', true);
             $pdf->MultiCell($tw[$i++], 0, $f['phone'], 0, 'L', 0, 0, '', '', true);
             $pdf->MultiCell($tw[$i++], 0, $f['job'], 0, 'L', 0, 0, '', '', true);
             $pdf->MultiCell($tw[$i++], 0, $f['know'], 0, 'L', 0, 0, '', '', true);
             $pdf->MultiCell($tw[$i++], 0, $f['relation'], 0, 'L', 0, 0, '', '', true);
             $pdf->Ln();
         }
         $pdf->setCellPaddings(0, 0, 0, 0);
         $pdf->Ln();
     }
 }
 if ($dps[dp_Generalinformation]) {
     // General Info
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:report_individual.php

示例9: while

$k = 0;
while ($f = dbFA($t)) {
    $k++;
    ?>
	<div id="box<?php 
    echo $k;
    ?>
" class="box1"><?php 
    echo $f['barcode'];
    ?>
</div>
<?php 
}
$t = mysql_query("SELECT * FROM `" . $r['ntable'] . "` WHERE cek='N'");
$i = 0;
while ($f = dbFA($t)) {
    ?>
	<div class="box0"><?php 
    echo $f['barcode'];
    ?>
</div>
<?php 
}
?>
</div>
<script type="text/javascript" language="javascript">
var bk=<?php 
echo $k;
?>
;
if(bk > 50) {
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:bookcek.php

示例10: array

 if ($xtable->ndata > 0) {
     // Table head
     $heads = array('@!NIS', '@Nama');
     $t1 = dbQSql("SELECT * FROM aka_penilaian WHERE guru='{$gid}' AND pelajaran='{$pel}' AND kelas='{$kls}'");
     while ($r1 = dbFA($t1)) {
         array_push($heads, '!' . $r1['kode'] . '{C}');
     }
     $heads = array_merge($heads, array('!JML Nilai{C}', 'Nilai akhir{C}', '@Ketuntasan', 'Keterangan'));
     //array_push($heads,'Keterangan');
     $xtable->head($heads);
     while ($r = mysql_fetch_array($t)) {
         $xtable->row_begin($r['replid']);
         $xtable->td($r['nis'], 60);
         $xtable->td($r['nama'], 250);
         $t1 = dbQSql("SELECT * FROM aka_penilaian WHERE guru='{$gid}' AND pelajaran='{$pel}' AND kelas='{$kls}'");
         while ($r1 = dbFA($t1)) {
             //$db->field("IF(aka_daftarnilai.penilaian = '".$r1['replid']."', aka_daftarnilai.nilai, 0) as ".$r1['kode']);
             //$db->join_cust("aka_daftarnilai ON aka_daftarnilai.penilaian='".$r1['replid']."'");
             //array_push($heads,$r1['kode']);
             $nil = $r["T" . $r1['kode']];
             if ($nil < $SKM) {
                 $nil = '<span style="color:#ff0000">' . $nil . '</span>';
             }
             $xtable->td($nil, 50, 'c', $r['B' . $r1['kode']] == 0 ? 'style="color:#aaa;background:#eee"' : '');
         }
         $xtable->td($r["JMLNILAI"], 70, 'c');
         $xtable->td(number_format($r["TNILAI"], 2), 70, 'c');
         $xtable->td($r['TLULUS'] == 1 ? 'Tuntas ' : '<span style="color:#ff0000">Belum tuntas</span>', 80);
         $xtable->td($r['komen'], '', '', 'id="ket_' . $r['replid'] . '"');
         $s = '<button class="btn" title="Edit keterangan" onclick="nilairapor_komen_form(\'uf\',' . $r['replid'] . ')"><div class="bi_editb">&nbsp;</div></button>';
         $xtable->td($s, 50, 'c');
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:nilairapor.php

示例11: dbSel

    }
    $t = dbSel("*", "employee", "W/dcid='{$dcid}' LIMIT 0,1");
    $r = dbFA($t);
    require_once VWDIR . $fmod . '.php';
} else {
    $sx = str_replace('f', '', $opt);
    $nobtn = "Cancel";
    // Preprocessing form
    $doctype = $mstr_document;
    if ($opt == 'uf' || $opt == 'df') {
        $r = dbSFA("*", $dbtable, "W/dcid='{$cid}'");
    } else {
        $r['date1'] = date("Y-m-d");
        $r['date2'] = date("Y-m-d");
        $td = dbSel("*", "emp_document");
        while ($rd = dbFA($td)) {
            unset($doctype[$rd['docid']]);
        }
    }
    // Form dimension
    $fwidth = $opt == 'df' ? 500 : 400;
    $lwidth = 100;
    $iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
    ?>
	<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
	<div class="fformbox" style="width:<?php 
    echo $fwidth + 30;
    ?>
px;overflow:hidden">
		<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
			<b><?php
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:pf_files.php

示例12: dbFetch

function dbFetch($sel, $tbl, $filter = "")
{
    $t = dbSel($sel, $tbl, $filter . " LIMIT 0,1");
    if (dbNRow($t) == 1) {
        $res = dbFA($t);
        return $res[$sel];
    } else {
        return '';
    }
}
开发者ID:epiii，项目名称:siadu-epiii，代码行数:10，代码来源:db.php

示例13: array_merge

 $heads = array_merge($heads, array('@!JML Nilai{C,2}', '@Rata-rata{C,2}', '@Peringkat{C,2}', 'Keterangan{2}'));
 //array_push($heads,'Keterangan');
 $xtable->head_addrow($heads);
 $heads2 = array();
 $n = count($SSKM);
 foreach ($SSKM as $k => $v) {
     array_push($heads2, '!SKM: ' . $v . '{C}');
 }
 $xtable->head_addrow($heads2);
 $xtable->head_multi();
 while ($r = mysql_fetch_array($t)) {
     $xtable->row_begin($r['replid']);
     $xtable->td($r['nis'], 60);
     $xtable->td($r['nama'], 200);
     $t0 = dbQSql("SELECT aka_sks.*,aka_pelajaran.kode as kodepel FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE kelas='{$kls}' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama");
     while ($r0 = dbFA($t0)) {
         $pelid = $r0['pelajaran'];
         if (isset($r["TNILAI_" . $pelid])) {
             $nil = number_format($r["TNILAI_" . $pelid], 2);
             if ($r['TLULUS_' . $pelid] != 1) {
                 $nil = '<span style="color:#ff0000">' . $nil . '</span>';
             }
         } else {
             $nil = '';
         }
         $xtable->td($nil, 50, 'c');
     }
     $xtable->td(number_format($r["TNRAPOR"], 2), 70, 'c');
     $xtable->td(number_format($r["AVGRAPOR"], 2), 70, 'c');
     $xtable->td($rank[$r['replid']], 60, 'c');
     $xtable->td(nl2br($r['komen']), '', '', 'id="ket_' . $r['replid'] . '"');
开发者ID:nickohappy7，项目名称:sister，代码行数:31，代码来源:nilairapor.php

示例14: dbFetch

function dbFetch($sel, $tbl, $filter = "")
{
    $res = dbFA(dbSel($sel, $tbl, $filter));
    return $res[$sel];
}
开发者ID:epiii，项目名称:siadu-epiii，代码行数:5，代码来源:db.php

示例15: mysql_query

<?php

/* Pre Data Processing */
require_once MODDIR . 'masterdb.php';
require_once MODDIR . 'pagelink.php';
require_once MODDIR . 'control.php';
require_once SYDIR . 'xtable.php';
$t = mysql_query("SELECT * FROM so_history WHERE status='1'");
if (mysql_num_rows($t) > 0) {
    $stocktaking = true;
} else {
    $stocktaking = false;
}
$mstr_shelf = array();
$ts = dbSel("dcid,name", "mstr_shelf", "O/ dcid");
while ($f = dbFA($ts)) {
    $mstr_shelf[$f['dcid']] = $f['name'];
}
$nid = getsx('nid');
$t = mysql_query("SELECT * FROM catalog WHERE dcid='{$nid}' LIMIT 0,1");
$f = dbFAx($t);
$author = dbFetch("name", "mstr_author", "W/`dcid`='" . $f['author'] . "'");
$publisher = dbFetch("name", "mstr_publisher", "W/`dcid`='" . $f['publisher'] . "'");
$cla = dbSFA("name,code", "mstr_class", "W/dcid='" . $f['class'] . "'");
// Sorting:
$sortby = getsx('sortby');
$sortmode = getsx('mode');
$sf = false;
$sm = $sortmode == '1' ? " DESC" : "";
if ($sortby == 'shelf') {
    $sql = "SELECT t1.* FROM book t1 JOIN mstr_shelf t2 ON t1.shelf = t2.dcid WHERE catalog='{$nid}' ORDER BY t2.name" . $sm;
开发者ID:epiii，项目名称:siadu-epiii，代码行数:31，代码来源:v_catalog_view.php


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