本文整理汇总了PHP中b_fetch函数的典型用法代码示例。如果您正苦于以下问题：PHP b_fetch函数的具体用法？PHP b_fetch怎么用？PHP b_fetch使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了b_fetch函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: unset
} else {
}
unset($exception);
unset($other_request);
}
}
}
if ($_REQUEST['sender'] == "entri_pendaftaran_bu") {
$cek = b_fetch('select count(*) from pendaftaran where no_pendaftaran=' . quote_smart($_REQUEST['no_pendaftaran']));
if (!$cek) {
$nomor = $_REQUEST['no_pendaftaran'];
$nmax = (int) substr($_REQUEST['no_pendaftaran'], 1);
} else {
$nomor = setNomorPendaftaran($_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd']);
$message = $_REQUEST['no_pendaftaran'] . ' sudah terdaftar, ' . "\n" . 'diganti dengan ' . $nomor . "\n";
$nmax = b_fetch('select max(nurut) from pendaftaran where jenis_pendaftaran=' . quote_smart($_REQUEST['jenis_pendaftaran']) . ' and objek_pdrd=' . quote_smart($_REQUEST['objek_pdrd']));
//$nmax = b_fetch('select max(nurut) from pendaftaran where jenis_pendaftaran='.quote_smart($_REQUEST['jenis_pendaftaran']).' ');
$nmax++;
}
$npwp = setNoNPWP($nmax, $_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd'], $_REQUEST['pemohon']);
$nokartu = setNoKartu($nmax, $_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd'], $_REQUEST['tanggal_kartu']);
$arr_field = array('id_pemohon', 'jenis_pendaftaran', 'nurut', 'no_pendaftaran', 'no_kartu', 'npwp', 'objek_pdrd', 'kode_usaha', 'tanggal_kartu', 'tanggal_terima', 'tanggal_kembali', 'tanggal_kirim', 'tanggal_tutup');
$field = implode(',', $arr_field);
$qy = 'insert into pendaftaran (' . $field . ') values (';
$qy .= quote_smart($_REQUEST['pemohon']) . ',' . quote_smart($_REQUEST['jenis_pendaftaran']) . ",'{$nmax}'" . ',' . quote_smart($nomor) . ',' . quote_smart($nokartu) . ',' . quote_smart($npwp) . ',' . quote_smart($_REQUEST['objek_pdrd']) . ',' . quote_smart($_REQUEST['kode_usaha']) . ',' . quote_smart($_REQUEST['tanggal_kartu']) . ',' . quote_smart(blkDate($_REQUEST['tanggal_terima'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_kembali'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_kirim'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_tutup'])) . ')';
if (gcms_query($qy)) {
echo $message . 'Data telah tersimpan ';
} else {
echo '!';
}
}示例2: b_fetch
<?php
if (isset($_POST['submit']) and b_admin(b_getuserlogin())) {
if ($_POST['submit'] == "Disable") {
if (b_checkdisabledependency($_POST['path'])) {
$csql = "select nid from " . PREFIX . "moduls where cpath='" . $_POST['path'] . "'";
$nid_moduls = b_fetch($csql);
$csql = "delete from " . PREFIX . "granted where nid_moduls='{$nid_moduls}'";
gcms_query($csql);
if ($_POST['premove'] == "remove") {
$csql = "select * from " . PREFIX . "tableinstalled where nid_moduls='{$nid_moduls}'";
$nresult = gcms_query($csql);
while ($otable = gcms_fetch_object($nresult)) {
$csql2 = "drop table " . $otable->ctable;
gcms_query($csql2);
}
}
$csql = "delete from " . PREFIX . "tableinstalled where nid_moduls='{$nid_moduls}'";
gcms_query($csql);
$csql = "delete from " . PREFIX . "moduls where cpath='" . $_POST['path'] . "'";
} else {
$ainfoerror = b_readinit(str_replace(".php", ".init.php", strtolower($_POST['path'])));
$cerror = "Extension <b>" . $ainfoerror['name'] . " " . $ainfoerror['version'] . "</b> can't be disabled, \r\n please check extension's dependency from the others<br/>";
}
}
if ($_POST['submit'] == "Enable") {
include "./../config.php";
if (b_checkenabledependency($_POST['path'])) {
// create list of current tables before process
$nresult = gcms_list_tables(DATABASE);
while ($atables = gcms_fetch_row($nresult)) {示例3: substr
$rows->nama_rekening = substr($rows->nama_rekening, 0, 24);
}
$nama_rek = strtolower($rows->nama_rekening);
$str .= '<option value="' . $rows->persen_tarif . '">' . $rows->kode_rekening . " - " . $nama_rek . '</option>';
}
$str .= '</select>';
?>
var kodeRek='<?php
echo $str;
?>
';
<?php
}
if (!empty($_GET['DataForm'])) {
$idPendataan = b_fetch("select pendataan_id from pendataan_restoran where restoran_id ='" . $_GET['DataForm'] . "'");
$count = b_fetch("select count(*) from pendataan_restoran_detail where pendataan_id ='" . $idPendataan . "'");
if ($count) {
?>
/* $("tr.isi_detail").remove();
for(id=1; id <= <?php
echo $count;
?>
; id++){
//alert(id);
var str = " <tr id='" + id + "' "
+" class='isi_detail'> ";
//var data = kodeRek;
str += "<td><input type='hidden' id=\"DetailHid"+id+"\" name=\"DetailHid"+id+"\" ><input id=\"jumlah_meja"+id+"\" type='text' name=\"jumlah_meja"+id+"\" value='' size='30'></td><td><input class='field_angka' id=\"jumlah_kursi"+id+"\" type='text' name=\"jumlah_kursi"+id+"\" size='10'></td><td><input class='field_angka' id=\"jumlah_tamu"+id+"\" type='text' name=\"jumlah_tamu"+id+"\" size='20' /></td>";
str += "<td><input type='button' onclick=\"hapus_data('"+id+"');\" name='hapus' value='hapus' />";
示例4: unset
unset($other_request);
if ($b) {
ibase_commit();
echo 'Data Telah Diupdate..';
} else {
ibase_rollback();
echo 'Gagal Di Content';
}
} else {
ibase_rollback();
echo 'Gagal d Header ';
}
} else {
$cek = b_fetch('select count(*) from pendataan_spt where pendataan_no=' . quote_smart((int) $_REQUEST['nomor']));
if (!$cek) {
$next_no = b_fetch('select max(pendataan_no) from pendataan_spt ');
$next_no++;
$no_spt = $next_no;
} else {
$message = 'Nomor ' . $_REQUEST['nomor'] . 'Sudah Ada !' . "\n" . 'Diganti dengan ' . sprintf('%05d', $next_no);
$no_spt = (int) $_REQUEST['nomor'];
}
$ID_HEADER = $fbird->setGenerator('GEN_PENDATAAN_SPT');
if ($_REQUEST['spt'] == '') {
$exception = array('spt_id', 'nama_kegiatan');
$other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $no_spt, 'jenis_pendataan' => 'LISTRIK');
} else {
$exception = array('nama_kegiatan');
$other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $no_spt, 'jenis_pendataan' => 'LISTRIK', 'spt_id' => $_REQUEST['spt']);
}
ibase_trans();示例5: b_fetch
<ul id="adminmenu">
<?php
if (!$_REQUEST['cact']) {
$cact = 0;
} else {
$cact = $_REQUEST['cact'];
}
$csql = "select cgroup from " . PREFIX . "groupmenus where nid='" . $cact . "'";
$cgroup = b_fetch($csql);
if ($_REQUEST['cact'] > 0) {
$creff = "<a href=\"?cact=0\">Dashboard</a>";
} else {
$creff = "<a href=\"?cact=0\" class=\"current\">Dashboard</a>";
}
?>
<li <?php
echo $ccurrent;
?>
><?php
echo $creff;
?>
</li>
<?php
if ($bv_level > bc_inactive or true) {
$csubmenu = "<ul id=\"submenu\">";
$ccurrent = "";
$creff = "";
if ($_REQUEST['cact'] == 1) {
if ($_REQUEST['csub'] > 0) {
$creff = "<a href=\"?cact=" . $_REQUEST['cact'] . "&csub=0\">Extensions</a>\n";
} else {示例6: b_startup
/**
* Fungsi untuk memanggil fungsi-fungsi start-up
*
*/
function b_startup()
{
$afunction = get_defined_functions();
foreach ($afunction['user'] as $cfunction) {
if (strtolower(substr($cfunction, 0, 2)) == "s_") {
if (function_exists($cfunction)) {
$ctempath = PATHEXTENSION;
}
$ctemp = substr($cfunction, 2, strlen($cfunction) - 2);
$csql = "select cpath from " . PREFIX . "moduls where cpath like '%" . substr($ctemp, 0, strpos($ctemp, "_")) . ".php'";
$initfile = str_replace(".php", ".init.php", strtolower(b_fetch($csql)));
$initfile = translate_modul_path($initfile);
$GLOBALS['bv_pathextension'] = dirname($initfile) . "/";
define('PATHEXTENSION_STARTUP', dirname($initfile) . "/");
call_user_func($cfunction, "");
}
}
}示例7: b_fetch
<?php
if (basename(__FILE__) == basename($_SERVER['PHP_SELF'])) {
die;
}
if ($_REQUEST['proses'] == 'Simpan') {
$n = b_fetch("select count(*) from info_pemda");
/*
Cek Nilai n,
Jika kosong berarti Buat Baru,
else Update
*/
if (!$n) {
$id = 1;
// inisialisasi, bahwa hanya ada satu data yang tersimpan
$img_path = './images/pemda';
//target penyimpanan file logo
$csql = 'insert into info_pemda(id,pemda_nama,kode_lokasi,opt_kab,pejabat,pemda_alamat,pemda_kabupaten,
ibu_kota,pemda_telp,pemda_fax,nama_bank,no_rekening,logo,tipe_gambar)
values(' . quote_smart($id) . ',' . "''," . quote_smart($_REQUEST['kodeLokasi']) . ',' . quote_smart($_REQUEST['kabKota']) . ',' . quote_smart($_REQUEST['pejabat']) . ',' . quote_smart($_REQUEST['alamat']) . ',' . quote_smart($_REQUEST['namaKab']) . ',' . quote_smart($_REQUEST['ibukotaKab']) . ',' . quote_smart($_REQUEST['telp']) . ',' . quote_smart($_REQUEST['fax']) . ',' . quote_smart($_REQUEST['namaBank']) . ',' . quote_smart($_REQUEST['noRek']);
if (!empty($_FILES['logo']['tmp_name'])) {
$tmpName = $_FILES['logo']['tmp_name'];
$fileType = $_FILES['logo']['type'];
global $fbdb;
$blh = ibase_blob_create($fbdb);
if ($_FILES['logo']['tmp_name'] != '') {
ibase_blob_add($blh, file_get_contents($_FILES['logo']['tmp_name']));
}
$blobid = ibase_blob_close($blh);
$csql .= ',?,' . sqlvalue($fileType, true) . ')';
$target_file = $img_path . basename($_FILES['logo']['name']);示例8: unset
}
//echo print_r($_REQUEST);
unset($exception);
unset($other_request);
$exception = array('penetapan_pr_content_id');
$other_request = array('penetapan_pr_id' => $ID_HEADER, 'pendataan_id' => $_REQUEST['id']);
$a = $fbird->FBInsert('penetapan_pr_content', $other_request, $exception);
if ($a && $_REQUEST['rows'] == $_REQUEST['count']) {
ibase_commit();
}
if (!$a) {
ibase_rollback();
}
unset($exception);
unset($other_request);
$jenis_pendataan = b_fetch('select jenis_pendataan from pendataan_spt where pendataan_id=' . quote_smart($_REQUEST['id']));
//echo $jenis_pendataan;
/*switch $jenis_pendataan {
case 'LISTRIK':
$table_name='pendataan_listrik';
break;
case 'GALIAN C':
$table_name='pendataan_galianc';
break;
case 'AIR':
$table_name='pendataan_air';
break;
}*/
/*$qy = 'select * from '.$table_name;
$result = gcms_query($qy);
while($rs = gcms_fetch_object($result)){示例9: setNomor
function setNomor()
{
$no = b_fetch('select max(spt_no) from spt');
$no++;
return sprintf('%05d', $no);
}示例10: b_fetch
echo $rows->kode_rekening . " - " . $nama_rek;
?>
",
"persen" : "<?php
echo $rows->persen_tarif;
?>
" },
<?php
}
?>
]
<?php
}
if ($_GET['persentarif']) {
$sql = "SELECT a.PERSEN_TARIF from rekening_kode a where a.ID = " . $_GET['persentarif'];
$persentarif = b_fetch($sql);
echo "[{ 'tarif' : '" . $persentarif . "' }]";
}
if ($_GET['setnomor']) {
$query = "select max(pendataan_no) from pendataan_spt where jenis_pendataan = 'PARKIR';";
$result = gcms_query($query);
$str = "[";
while ($rows = gcms_fetch_object($result)) {
$nomor = $rows->max;
$nomor += 1;
$str .= "{ \"nomor\" : \"" . sprintf("%06d", $nomor) . "\"},";
}
$str .= "]";
echo $str;
}
//if( $_GET['edit'] && $_GET['edit'] == 'umum' ) {示例11: gcms_query
$firephp->info($sql, 'query');
}
gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
break;
case $crudConfig['delete']:
/* ----====|| ACTION = DELETE ||====----*/
if ($DEBUGMODE == 1) {
$firephp->info('DELETE', 'action');
}
if ($postConfig['q'] != q) {
$crudColumnValues[$crudFK] = $postConfig[$crudFK];
}
$val = substr(trim($crudColumnValues['id']), 1, count($crudColumnValues['id']) - 2);
$id_del = explode(',', $val);
foreach ($id_del as $del) {
$cek = b_fetch('select count(*) from penerimaan_pr where penetapan_pr_id=' . quote_smart($del) . '');
if (!$cek) {
$qy_del2 = 'delete from penetapan_pr_content where penetapan_pr_id=' . quote_smart($del) . '';
$qy_del1 = 'delete from penetapan_pr where penetapan_pr_id=' . quote_smart($del) . '';
//echo $qy_del2."\n".$qy_del1."\n\n";
gcms_query($qy_del2);
gcms_query($qy_del1);
} else {
echo 'Gak Bisa' . "\n";
}
}
$sql = 'Delete from ' . $crudTableName . ' where ' . $crudFK . ' = ' . $crudColumnValues['id'];
//echo $crudColumnValues['id'];die;
if ($DEBUGMODE == 1) {
$firephp->info($sql, 'query');
}示例12: b_fetch
?>
" <?php
echo $ccheck;
?>
> <?php
echo $omenus->cgroup . " - " . $omenus->cmenu;
?>
</td>
<td> Menu Level <select name="clevel[<?php
echo $i;
?>
]">
<?php
for ($ii = 0; $ii < USERLEVEL; $ii++) {
if ($check = "checked") {
$nstatus = b_fetch("select nstatus from " . PREFIX . "grantedfrontmenus where nid_users='" . $_POST['nid'] . "' and nid_frontmenus='{$omenus->nid}'");
$nstatus == $ii ? $cselected = "selected" : ($cselected = "");
}
?>
<option value="<?php
echo $ii;
?>
" <?php
echo $cselected;
?>
><?php
echo ucfirst($GLOBALS['bva_levelname'][$ii]);
?>
</option>
<?php
}示例13: sprintf
<fieldset>
<legend>FORM PENETAPAN</legend>
<div>
<div class="form_master">
<fieldset class="form_frame">
<!--<div><label>Duplikasi Nomor</label><input type='checkbox' name='cnomor' id='cnomor' checked /></div>-->
<div><label>No. Penetapan</label><input type="text" name="nomor_reg" id='nomor_reg' size='10' value="<?php
echo sprintf('%05d', getNoKohir());
?>
" readonly/></div>
<div><label>Tgl. Penetapan<b class="wajib">*</b></label><input type="text" name="tgl_penetapan" title='Tgl. Penetapan' id="tgl_penetapan" value='<?php
echo date('d/m/Y');
?>
' onchange="" size="10"/></div>
<div><label>Tgl. Batas Setor<b class="wajib">*</b></label><input type="text" name="tgl_setor" title='Tgl. Batas Setor' id="tgl_setor" value='<?php
echo getExpired(date('d/m/Y'), b_fetch('select jatem_bayar from ref_jatuh_tempo'));
?>
' onchange="" size="10"/></div>
<!--<div><label>Jenis Penetapan</label><select name='jenis_penetapan' id='jenis_penetapan'><?php
echo getKeteranganSPT();
?>
</select></div>-->
<div><label>No. Pendataan<input type='checkbox' name='cinput' id='cinput' ></label><input type='text' name='no_data_awal' id='no_data_awal' size='5' readonly /> S/D <input type='text' name='no_data_akhir' id='no_data_akhir' size='5' readonly /></div>
<div><label>Keterangan</label><textarea name='memo' id='memo'></textarea></div>
<div><label> </b></label><input type='button' id='proses' class='btn' value='Simpan'></input></div>
</fieldset>
<fieldset class="form_frame">
<div><label>Jenis Pendaftaran </label><select name="jenis_pendaftaran" id='jenis_pendaftaran'><option value=''></option><option value="PAJAK">Pajak</option><option value="RETRIBUSI">Retribusi</option></select></div>
<div><label>Sistem Pemungutan </label><select name="pungutan" id='pungutan'><option value=''></option><option value="SELF">Selft Assesment</option><option value="OFFICE">Office Assesment</option></select></div>
<div><label>Tanggal Pendataan </label><input type="text" name="tgl_kirim" id="tgl_kirim" onchange="" size="10"/> S/D <input type="text" name="tgl_kembali" id="tgl_kembali" onchange="" size="10"/></div>
<div><label> </label><input type='button' class='btn' id='cari' name='cari' value='Cari'></input></input></div>示例14: str_replace
<?php
include 'config.php';
include 'global.php';
$expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/";
if ($_REQUEST['sender'] == 'kategori') {
$crudColumns = array('id' => 'id', 'kode' => 'tipe_kategori', 'nama' => 'nama_kategori', 'saldo' => 'saldo_normal');
$crudTableName = 'rekening_kategori';
include 'jqGridCrud.php';
} elseif ($_REQUEST['sender'] == 'getiperekening') {
if ($_REQUEST['val'] != '') {
$kode = b_fetch('select id from rekening_kategori where tipe_kategori=' . quote_smart($_REQUEST['val']));
} else {
$kode = b_fetch('select tipe_kategori from rekening_kategori where id=' . quote_smart($_REQUEST['id']));
}
echo $kode;
} elseif ($_REQUEST['sender'] == 'getkoderekening') {
/*if($_REQUEST['val']!=''){
$kode = b_fetch('select id from rekening_kategori where tipe_kategori='.quote_smart($_REQUEST['val']));
}else{
$kode = b_fetch('select tipe_kategori from rekening_kategori where id='.quote_smart($_REQUEST['id']));
}*/
echo $_REQUEST['id'];
} elseif ($_REQUEST['sender'] == 'rekening') {
$crudColumns = array('id' => 'id', 'tipe' => 'tipe', 'kelompok' => 'kelompok', 'jenis' => 'jenis', 'objek' => 'objek', 'rincian' => 'rincian', 'sub1' => 'sub1', 'sub2' => 'sub2', 'sub3' => 'sub3', 'kode' => 'kode_rekening', 'nama' => 'nama_rekening', 'kategori' => 'id_kategori');
$crudFK = 'id';
$crudTableName = 'rekening_kode';
$table1 = 'rekening_kode';
$pk_table1 = 'id';
$table2 = 'rekening_kategori';
$pk_table2 = 'id';示例15: menu_get_title
/**
* Mendapatkan title berdasarkan menu yang dipilih
*
* @param string $cpage
* @return unknown
*/
function menu_get_title($cpage)
{
if (b_antisqlinjection($cpage) and $cpage != "") {
if (b_admin(b_getuserlogin())) {
$csql = "select * from " . PREFIX . "frontmenus where nid='" . $cpage . "'";
} else {
$csql = "select a.* from " . PREFIX . "frontmenus as a\r\n\t\t left join " . PREFIX . "grantedfrontmenus as b on a.nid=b.nid_frontmenus\r\n\t\t where a.nid='" . $cpage . "' and \r\n\t\t (b.nid_users='" . b_getuserlogin() . "' or a.bsecure=0)";
}
$nresult = gcms_query($csql);
$opage = gcms_fetch_object($nresult);
$csql = "select cgroup from " . PREFIX . "groupfrontmenus where nid='" . $opage->nid_groupfrontmenus . "'";
$creturn = b_fetch($csql) . " - " . $opage->cmenu;
return $creturn;
}
}