本文整理汇总了PHP中dbSFA函数的典型用法代码示例。如果您正苦于以下问题：PHP dbSFA函数的具体用法？PHP dbSFA怎么用？PHP dbSFA使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了dbSFA函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: dbSFA
<td align="center">
<input type="button" class="btn" onclick="close_fform()" value="Cancel"/>
<input type="button" class="btnx" value="Save" onclick="m_user('u',true,<?php
echo $cid;
?>
)"/>
</td>
</tr></table>
</div>
</div>
</td></tr></table>
<?php
} else {
if ($opt == 'df') {
// Delete Form
$r = dbSFA("*", "mstr_user", "W/dcid='{$cid}'");
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:500px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b>Delete <?php
echo $mtitle;
?>
</b>
</div>
<div style="text-align:left;padding:10px">
<table class="stable" cellspacing="0" cellpadding="4px" width="480px">
<tr><td><p class="line150">Are you sure you want to delete "<b><?php
echo $r['alias'];
?>
</b>"?</p></td></tr>示例2: tdLabel
<tr><td> </td><?php
echo tdLabel("Family");
?>
<td><?php
echo iText('sd_info4', $emps['info4'], "width:680px");
?>
</td></tr>
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td colspan="3" style="border-bottom:1px solid #aeaeae;padding-bottom:10px"><b>EMPLOYMENT APPLICATION</b></td></tr>
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr height="20px" valign="top"><td width="20px"><b>A.</b></td><td colspan="2"><b>Check Desired Employment (check all that applies):</b></td></tr>
<tr><td> </td><td colspan="3">
<?php
$empap = dbSFA("*", "emp_apos", "W/empid='{$dcid}'");
$apos = explode("~", $empap['option']);
$aposi = array('Playschool Principal/Teacher', 'Senior High Principal/Teacher', 'Kindergarten Principal/Teacher', 'Secretary/Administration', 'Elementary Principal/Teacher', 'Part Time Teacher', 'Junior High Principal/Teacher', 'Other:');
?>
<table id="apospt" cellspacing="0px" cellpadding="0" border="0">
<?php
for ($i = 0; $i < 8; $i += 2) {
?>
<tr height="24px">
<td width="20px"><input id="apos<?php
echo $i + 1;
?>
" type="checkbox" name="apos<?php
echo $i + 1;
?>
" <?php 示例3: while
while ($r = mysql_fetch_array($t)) {
$stat = gpost('syarat' . $r['syarat']);
$q = mysql_query("UPDATE psb_calonsiswa_syarat SET status='{$stat}' WHERE calonsiswa='{$cid}' AND syarat='" . $r['syarat'] . "'");
}
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
$fform->notif($q);
} else {
if ($opt == 'uf' || $opt == 'df') {
// Prepocessing form
$r = dbSFA("nama,nopendaftaran", $dbtable, "W/replid='{$cid}'");
} else {
}
//$fform->dimension(350);
$fform->lwidth = 150;
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Nama calon siswa', $r['nama']);
$fform->fl('Nomor pendaftaran', $r['nopendaftaran']);
$s = '';
//qarea();
$t = mysql_query("SELECT psb_calonsiswa_syarat.*,psb_syarat.wajib,psb_syarat.syarat as nama FROM psb_calonsiswa_syarat LEFT JOIN psb_syarat ON psb_syarat.replid=psb_calonsiswa_syarat.syarat WHERE psb_calonsiswa_syarat.calonsiswa='{$cid}' AND psb_syarat.wajib='1'");
if (mysql_num_rows($t) > 0) {
$si = '<table cellspacing="0" cellpaddin="0">';示例4: rapor_pelajaran_nilai
$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');
$doc->cell('', 0, '', 2);
$doc->nl();
$doc->cell('<b>Rata-Rata Nilai</b>', 0, '', 3);
$doc->cell('<b>' . number_format($rata, 2) . '</b>' . '[x:fmla="=AVERAGE(D8:D10)" x:num="' . number_format($rata, 2) . '"]', 0, 'c', 1, 1, -1, '', 'mso-number-format:\'0\\.00_ \'');
$doc->cell('', 0, '', 2);
$doc->nl();
$doc->cell('<b>Peringkat</b>', 0, '', 3);
$doc->cell(rapor_peringkatkelas_siswa($kls, $siswa['replid']) . ' dari ' . kelas_jumlahsiswa($kls) . ' siswa', 0, '', 3);
$doc->row_blank(6);
$komen = dbSFA("*", "aka_komenrapor", "W/ siswa='" . $siswa['replid'] . "' AND tahunajaran='{$tajar}'");
$doc->cell_format_reset();
$doc->nl();
$doc->cell('Keterangan hasil belajar:', 0, '', 6);
$doc->nl(100, 'top');
$doc->cell($komen['komen'], 0, '', 6, 1, 1);
$doc->end();示例5: mysql_query
$lheight = 1;
/*
if($plhead=='Y') $lheight+=9;
if($plcnum=='Y') $lheight+=14;
if($plbcode=='Y') $lheight+=10;
*/
$q = mysql_query("SELECT * FROM `p_label`");
$k = 0;
$kol = 0;
$row = 0;
$i = 0;
$nkol = floor($dcPageW / ($lwidth + 1));
$nrow = 99;
//$nrow=floor($dcPageH/$lheight);
while ($r = mysql_fetch_array($q)) {
$b = dbSFA("*", "book", "W/dcid='" . $r['book'] . "'");
// Print Label >>
$x = ($lwidth + 1) * $kol + $dcMarginL;
$y = $lheight * $row + $dcMarginT;
$pdf->SetXY($x, $y);
$pl = false;
if ($plhead == 'Y') {
$pl = true;
$pdf->setCellPaddings(0, 0.5, 0, 0);
$pdf->SetFont('dejavusans', '', 10, '', true);
$pdf->MultiCell($lwidth, 0, $title, 'LTR', 'C', 0, 1, '', '', true);
if ($k == 0) {
$lheight += $pdf->getLastH();
}
$pdf->SetX($x);
$pdf->setCellPaddings(0, 0, 0, 0.5);示例6: str_replace
}
}
}
}
}
require_once VWDIR . $fmod . '.php';
} else {
$sx = str_replace('f', '', $opt);
$nobtn = "Cancel";
// Form dimension
$fwidth = 400;
$lwidth = 100;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
// Preprocessing form
if ($opt == 'uf' || $opt == 'df') {
$r = dbSFA("*", $dbtable, "W/dcid='{$cid}'");
}
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b><?php
echo $mdialog[$opt] . " " . $mtitle;
?>
<br/></b>
</div>
<div style="text-align:left;padding:15px 10px;width:<?php
echo $fwidth;示例7: gpost
<?php
$opt = gpost('opt');
$cid = gpost('cid');
$ntable = gpost('lst');
if ($opt == 'nf') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("*", $ntable, "W/dcid='{$cid}' LIMIT 0,1");
$y = mysql_query("SELECT * FROM catalog WHERE dcid='" . $r['catalog'] . "' LIMIT 0,1");
$f = mysql_fetch_array($y);
$y1 = mysql_query("SELECT * FROM book WHERE barcode='" . $r['barcode'] . "' LIMIT 0,1");
$f1 = mysql_fetch_array($y1);
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="margin-top:-100px;width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Finish Stock Take
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php 示例8: gpost
<?php
$opt = gpost('opt');
$cid = gpost('cid');
if ($opt == 'df') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("title", "catalog", "W/dcid='{$cid}'");
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Delete catalog
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php
echo $fwidth;
?>
px">
<tr><td>Are you sure want to delete "<b><?php
echo $r['title'];示例9: gpost
<?php
$opt = gpost('opt');
$cid = gpost('cid');
if ($opt == 'df') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("nid", "book", "W/dcid='{$cid}'");
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Delete book
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php
echo $fwidth;
?>
px">
<tr><td>Are you sure want to delete book number "<b><?php
echo $r['nid'];示例10: dbSFA
$fform->foot();
} else {
if ($opt == 'uf') {
$r = dbSFA("*", "aka_alumni", "W/replid='{$cid}'");
$r1 = dbSFA("nama,nisn", "aka_siswa", "W/replid='" . $r['siswa'] . "'");
//$fform->reg['title_af']='<idata>';
//$fform->reg['btnlabel_a_y']='Pilih yg ditandai';
//$fform->reg['btnlabel_a_n']='Batal';
//$fform->dimension(500);
//$fform->ptop=20;
//$fform->globalkey='0';
$fform->head();
$fform->fl('Nama alumni', $r1['nama']);
$fform->fl('NISD', $r1['nisn']);
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
$fform->foot();
} else {
if ($opt == 'df') {
//$fform->reg['title_df']='Keluarkan Siswa Dari Rombongan Belajar';
//$fform->reg['btnlabel_u_n']='Tidak';
//$fform->reg['btnlabel_d_y']=' Ya ';
$fform->head();
$r1 = dbSFA("nama,nis", "aka_siswa", "W/replid='{$cid}'");
$fform->dlg_del($r1['nama']);
$fform->foot();
}
}
}
}
}
}示例11: array
$mstr_author = array();
$t = dbSel("*", "mstr_author", "O/ prefix LIMIT 0,20");
while ($r = dbFA($t)) {
$mstr_author[$r['dcid']] = $r['name'] . " (" . $r['prefix'] . ")";
}
$mstr_publisher = array();
$t = dbSel("*", "mstr_publisher", "O/ name LIMIT 0,20");
while ($r = dbFA($t)) {
$mstr_publisher[$r['dcid']] = $r['name'];
}
$mstr_class = MstrGetx("mstr_class", "code");
$mstr_language = MstrGet("mstr_language");
$txtWidth = "width:344px";
$dcid = gets('nid');
$r = dbSFA("*", "book", "W/`dcid`='{$dcid}' LIMIT 0,1");
?>
<script type="text/javascript" language="javascript">
function getBarcode(a){
var b=a.split("/");
E('barcode').value=b[0];
}
function getCallNumber(){
var classcode=E('class').value;
var author=getSelectedText('author');
var sa=author.indexOf("(")+1;
var sb=author.indexOf(")",sa);
auth=author.substring(sa,sb);
var title=E('title').value.substr(0,1);
title=title.toUpperCase();
var callnum=classcode+" "+auth+" "+title;示例12: dbDel
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
// echo $q;
$fform->notif($q);
// var_dump($q);exit();
} else {
// view form : update , delete , add
$a = 0;
if ($opt == 'uf' || $opt == 'df') {
// update / delete form
$sel = $dbtable . '.*';
$r = dbSFA($sel, $dbtable . ',departemen', "W/keu_budget.replid='{$cid}' and keu_budget.id_department=departemen.replid");
// shared/db.php
// $r=dbSFA("*",$dbtable.','.'departemen',"W/keu_budget.replid='$cid' and keu_budget.id_department=departemen.replid"); // shared/db.php
// $r=dbSFA("*",$dbtable,"W/replid='$cid'"); // shared/db.php
// $r=dbLJoin($dbtable,'replid','departemen','replid'); // shared/db.php
// var_dump($r);
$a = 0;
// $kategorirek=kategorirek_r($a);
$departemen = departemen_r($a);
// print_r($departemen);
} else {
// opt == 'af' // add form
// $r = farray('kategorirek','kode','nama','keterangan'); //shared/libraries/common.php
$r = farray('tahunbuku', 'nama', 'nominal', 'keterangan', 'id_department');
//shared/libraries/common.php
// $r['kategorirek'] = gpost('skategorirek'); // shared/libraries/common.php示例13: dbFetch
// Photo **
$rimg = dbFetch("photo", "emp_photo", "W/`empid`='{$dcid}'");
if (!empty($rimg)) {
$imgdata = base64_decode($rimg);
$pdf->Image('@' . $imgdata);
} else {
$pdf->Image('images/nophoto.png');
}
// Employee Data **
$pdf->SetFont('dejavusans', '', 9, '', true);
dc_EmployeeData('NIP', $r['nip']);
dc_EmployeeData('Level', $mstr_level[$r['level']]);
dc_EmployeeData('Division', $mstr_division[$r['division']]);
dc_EmployeeData('Group', $mstr_group[$r['group']]);
dc_EmployeeData('Position', $mstr_position[$r['position']]);
$a = dbSFA("date1,date2", "emp_status", "W/empid='{$dcid}'");
dc_EmployeeData('Status', $mstr_status[$r['status']]);
if ($r['status'] != 0) {
dc_EmployeeData('Status period', ftgl($a['date1']) . ($r['status'] == 1 ? '' : ' - ' . ftgl($a['date2'])));
}
$cy = dc_YDown(2);
$pdf->Line(65, $cy, $dcPaperW - $dcMarginR, $cy);
$cy = dc_YDown(2);
}
if ($dps[dp_Personalinformation] == '1') {
$dlbl = array();
$dlbl['Gender'] = $r['gender'];
$dlbl['Address'] = $r['address'];
$dlbl['Telepon/fax'] = $r['phonefax'];
$dlbl['Email'] = $r['email'];
$dlbl['Birth'] = $r['birthplace'] . ", " . fftgl($r['birthdate']);示例14: getStatus
<?php
$empstatus = getStatus();
$dcid = gpost('id');
$fname = gpost('name');
$r = dbSFA("*", "jbssdm.employment_app", "W/dcid='{$dcid}'");
?>
<script type="text/javascript" language="javascript">
</script>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:400px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b>Edit Data <?php
echo $fname;
?>
</b>
</div>
<div style="text-align:left;padding:10px">
<table class="stable" cellspacing="0" cellpadding="3px" width="380px">
<tr><td width="100px">NIP:</td><td><input type="text" class="ifield" id="nip" value="<?php
echo $r['nip'];
?>
" style="width:250px"/></td></tr>
<tr><td>Bagian:</td><td>
<select class="ifield" id="empbagian" style="width:140px">
<option value="Akademik"<?php
echo isSelect("Non Akademik", $r['empbagian']);
?>
>Akademik</option>
<option value="Non Akademik"<?php 示例15: mysql_query
<?php
$t = mysql_query("SELECT * FROM so_history WHERE status='1'");
if (mysql_num_rows($t) > 0) {
$stocktaking = true;
} else {
$stocktaking = false;
}
$r = dbSFA("*", "catalog", "W/`dcid`='{$dcid}' LIMIT 0,1");
if (!empty($r)) {
$publisher = dbFetch("name", "mstr_publisher", "W/`dcid`='" . $r['publisher'] . "'");
$lang = dbFetch("name", "mstr_language", "W/`dcid`='" . $r['language'] . "'");
$author = dbFetch("name", "mstr_author", "W/`dcid`='" . $r['author'] . "'");
?>
<table class="stable2" cellspacing="0" cellpadding="5px" width="240px" style="margin:auto;margin-top:10px">
<tr valign="top" style="height:110px">
<td width="60px">
<img src="<?php
echo IMGC . ($r['cover'] == '' ? "nocover.jpg" : $r['cover']);
?>
" width="60px"/>
</td>
<td style="padding-left:10px">
<div style="font-size:16px"><b><?php
echo str_replace("\\'", "'", $r['title']);
?>
</b></div>
<div>by <a class="linkl11" style="font:12px 'Segoe UI',Verdana,Arial" href="<?php
echo RLNK;
?>
book.php?get=author&getid=<?php