本文整理汇总了PHP中getDbRows函数的典型用法代码示例。如果您正苦于以下问题：PHP getDbRows函数的具体用法？PHP getDbRows怎么用？PHP getDbRows使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getDbRows函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getDbRows
$p = $p ? $p : 1;
?>
<div id="smsWrap">
<table id="history">
<thead>
<tr>
<th scope="col" width="40">구분</th>
<th scope="col" width="60">전송시간</th>
<th scope="col">내용</th>
<th scope="col" width="80">전화번호</th>
<th scope="col" width="50">작성자</th>
</tr>
</thead>
<tbody>
<?php
$cntHistory = getDbRows($table['smshistory'], "");
?>
<?php
$tpage = ceil($cntHistory / $recnum);
?>
<?php
$resHistory = getDbArray($table['smshistory'], "", "*", "idx", "desc", $recnum, $p);
?>
<?php
while ($infoHistory = db_fetch_array($resHistory)) {
?>
<?php
$cpnumber = substr($infoHistory['cp'], 0, 3) . "-" . substr($infoHistory['cp'], 3, 4) . "-" . substr($infoHistory['cp'], 7, 4);
?>
<?php 示例2: getSearchSql
}
if ($notice) {
$_WHERE .= ' and notice=1';
}
if ($hidden) {
$_WHERE .= ' and hidden=1';
}
if ($where && $keyw) {
if (strstr('[name][nic][id][ip]', $where)) {
$_WHERE .= " and " . $where . "='" . $keyw . "'";
} else {
$_WHERE .= getSearchSql($where, $keyw, $ikeyword, 'or');
}
}
$RCD = getDbArray($table[$module . 'data'], $_WHERE, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table[$module . 'data'], $_WHERE);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="bbslist">
<div class="sbox">
<form name="procForm" action="<?php
echo $g['s'];
?>
/" method="get">
<input type="hidden" name="r" value="<?php
echo $r;
?>示例3: getDbRows
<?php
if ($type == 'menu') {
?>
<?php
include_once $g['path_core'] . 'function/menu.func.php';
$ISCAT = getDbRows($table['s_menu'], 'site=' . $s);
$catcode = '';
if ($cat) {
$CINFO = getUidData($table['s_menu'], $cat);
$ctarr = getMenuCodeToPath($table['s_menu'], $cat, 0);
$ctnum = count($ctarr);
for ($i = 0; $i < $ctnum; $i++) {
$CXA[] = $ctarr[$i]['uid'];
}
}
$is_fcategory = $CINFO['uid'] && $vtype != 'sub';
$is_regismode = !$CINFO['uid'] || $vtype == 'sub';
if ($is_regismode) {
$CINFO['menutype'] = '';
$CINFO['name'] = '';
$CINFO['joint'] = '';示例4: getSearchSql
$type = $type ? $type : 'point';
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'desc';
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
$sqlque = 'my_mbruid=' . $my['uid'];
if ($price == '1') {
$sqlque .= ' and price > 0';
}
if ($price == '2') {
$sqlque .= ' and price < 0';
}
if ($where && $keyword) {
$sqlque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
$RCD = getDbArray($table['s_' . $type], $sqlque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_' . $type], $sqlque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="pointlist">
<div class="info">
<div class="article">
<span class="tx">
<a class="<?php
if ($type == 'point') {
?>
b <?php 示例5: getDbRows
?>
<option value="<?php
echo $_catexp[$i];
?>
"<?php
if ($_catexp[$i] == $cat) {
?>
selected="selected"<?php
}
?>
>ㆍ<?php
echo $_catexp[$i];
if ($d['theme']['show_catnum']) {
?>
(<?php
echo getDbRows($table[$m . 'data'], 'site=' . $s . ' and notice=0 and bbs=' . $B['uid'] . " and category='" . $_catexp[$i] . "'");
?>
)<?php
}
?>
</option>
<?php
}
?>
</select>
<?php
}
?>
</div>
<div class="clear"></div>
</div>示例6: getSearchSql
<?php
include_once $g['dir_module_skin'] . '_menu.php';
$sort = $sort ? $sort : 'gid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 200 ? $recnum : $d['search']['s_num2'];
$bbsque = 'site=' . $s . " and type=2 and ext='jpg' and d_regis > " . $d['search']['date'];
$bbsque .= getSearchSql('name|caption', $keyword, $ikeyword, 'or');
$RCD = getDbArray($table['s_upload'], $bbsque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_upload'], $bbsque);
$TPG = getTotalPage($NUM, $recnum);
?>
<?php
if ($NUM) {
?>
<div id="s_image">
<div class="subtitle">
<div class="xleft">이미지(검색결과 <?php
echo number_format($NUM);
?>
개)</div>
<div class="xright"><a href="<?php
echo $g['url_reset'];
?>
">통합검색</a></div>
<div class="clear"></div>
</div>示例7: array
<?php
$R = array();
$mtype = $mtype ? $mtype : 'admin';
$recnum = $recnum ? $recnum : 10;
$sendsql = 'admin=' . ($mtype == 'admin' ? 1 : 0);
$RCD = getDbArray($table['s_mbrdata'], $sendsql, '*', 'memberuid', 'asc', $recnum, $p);
$NUM = getDbRows($table['s_mbrdata'], $sendsql);
$TPG = getTotalPage($NUM, $recnum);
$_authset = array('', _LANG('aa001', 'admin'), _LANG('aa002', 'admin'), _LANG('aa003', 'admin'), _LANG('aa004', 'admin'));
?>
<div id="admin-users">
<div class="page-header">
<h4><?php
echo _LANG('aa005', 'admin');
?>
</h4>
</div>
<form name="listForm" action="<?php
echo $g['s'];
?>
/" method="post" onsubmit="return false;">
<input type="hidden" name="r" value="<?php
echo $r;
?>
">
<input type="hidden" name="m" value="<?php
echo $module;
?>示例8: array
<?php
$R = array();
$recnum = $recnum ? $recnum : 15;
$sendsql = 'gid';
if ($keyw) {
$sendsql .= " and (id like '%" . $keyw . "%' or name like '%" . $keyw . "%')";
}
$RCD = getDbArray($table['s_module'], $sendsql, '*', 'gid', 'asc', $recnum, $p);
$NUM = getDbRows($table['s_module'], $sendsql);
$TPG = getTotalPage($NUM, $recnum);
if (!$id) {
$id = 'site';
}
?>
<div class="row">
<div class="col-md-5 col-lg-4" id="tab-content-list">
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading rb-icon">
<div class="icon">
<i class="fa kf kf-module fa-2x"></i>
</div>
<h4 class="dropdown panel-title">
<a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion" href="#collapmetane">전체모듈</a>
<span class="pull-right" style="position:relative;left:-15px;top:3px;">
<button type="button" class="btn btn-default btn-xs<?php
if (!$_SESSION['sh_site_page_search']) {
?>
collapsed<?php 示例9: getDbArray
<?php
$recnum = 10;
$catque = 'uid';
if ($_keyw) {
$catque .= " and " . $where . " like '" . $_keyw . "%'";
}
$PAGES = getDbArray($table[$smodule . 'list'], $catque, '*', 'gid', 'asc', $recnum, $p);
$NUM = getDbRows($table[$smodule . 'list'], $catque);
$TPG = getTotalPage($NUM, $recnum);
$tdir = $g['path_module'] . $smodule . '/theme/';
?>
<div id="mjointbox">
<div class="title">
<form name="bbsSform" class="form-horizontal rb-form" action="<?php
echo $g['s'];
?>
/" method="get">
<input type="hidden" name="system" value="<?php
echo $system;
?>
" />
<input type="hidden" name="r" value="<?php
echo $r;
?>
" />
<input type="hidden" name="iframe" value="<?php
echo $iframe;
?>示例10: getSearchSql
<?php
include_once $g['dir_module_skin'] . '_menu.php';
$sort = $sort ? $sort : 'gid';
$orderby = $orderby ? $orderby : 'asc';
$recnum = $recnum && $recnum < 200 ? $recnum : $d['search']['s_num2'];
$bbsque = 'site=' . $s . ' and display=1 and d_regis > ' . $d['search']['date'];
if ($bbsuid) {
$bbsque .= ' and bbs=' . $bbsuid;
}
$bbsque .= getSearchSql('subject|tag', $keyword, $ikeyword, 'or');
$RCD = getDbArray($table['bbsdata'], $bbsque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['bbsdata'], $bbsque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="s_post">
<div class="subtitle">
<div class="xleft">
<select onchange="goHref('<?php
echo $g['url_reset'];
?>
post&bbsuid='+this.value);">
<option value=""> + 게시판(전체)</option>
<option value="">---------------------</option>
<?php
echo $_BBS = getDbArray($table['bbslist'], '', '*', 'gid', 'asc', 0, 1);
?>
<?php 示例11: getLink
if ($d['member']['form_nic'] && !$check_nic || !$check_email) {
getLink('', '', '정상적인 접근이 아닙니다.', '');
}
if (strstr(',' . $d['member']['join_cutid'] . ',', ',' . $id . ',') || getDbRows($table['s_mbrid'], "id='" . $id . "'")) {
getLink('', '', '사용할 수 없는 아이디입니다.', '');
}
if (!$d['member']['join_rejoin']) {
if (is_file($g['path_tmp'] . 'out/' . $id . '.txt')) {
getLink('', '', '사용할 수 없는 아이디입니다.', '');
}
}
if (getDbRows($table['s_mbrdata'], "email='" . $email . "'")) {
getLink('', '', '이미 존재하는 이메일입니다.', '');
}
if ($d['member']['form_nic']) {
if (strstr(',' . $d['member']['join_cutnic'] . ',', ',' . $nic . ',') || getDbRows($table['s_mbrdata'], "nic='" . $nic . "'")) {
getLink('', '', '사용할 수 없는 닉네임입니다.', '');
}
}
getDbInsert($table['s_mbrid'], 'site,id,pw', "'{$s}','{$id}','" . md5($pw1) . "'");
$memberuid = getDbCnt($table['s_mbrid'], 'max(uid)', '');
$auth = $d['member']['join_auth'];
$sosok = $d['member']['join_group'];
$level = $d['member']['join_level'];
$comp = $d['member']['form_comp'] && $comp ? 1 : 0;
$admin = 0;
$name = trim($name);
$photo = '';
$home = $home ? strstr($home, 'http://') ? str_replace('http://', '', $home) : $home : '';
$birth1 = $birth_1;
$birth2 = $birth_2 . $birth_3;示例12: getSearchSql
$sort = $sort ? $sort : 'uid';
$orderby = $orderby ? $orderby : 'desc';
$recnum = $recnum && $recnum < 200 ? $recnum : 20;
if ($inbox == 3) {
$sqlque = 'by_mbruid=' . $my['uid'];
} else {
$sqlque = 'my_mbruid=' . $my['uid'];
if ($inbox) {
$sqlque .= " and inbox='" . $inbox . "'";
}
if ($where && $keyword) {
$sqlque .= getSearchSql($where, $keyword, $ikeyword, 'or');
}
}
$RCD = getDbArray($table['s_paper'], $sqlque, '*', $sort, $orderby, $recnum, $p);
$NUM = getDbRows($table['s_paper'], $sqlque);
$TPG = getTotalPage($NUM, $recnum);
?>
<div id="paperlist">
<div class="info">
<div class="article">
<?php
echo number_format($NUM);
?>
개(<?php
echo $p;示例13: getDbSelect
$DAT = getDbSelect($table['s_menu'], $subQue, '*');
while ($R = db_fetch_array($DAT)) {
getDbDelete($table['s_menu'], 'uid=' . $R['uid']);
getDbDelete($table['s_seo'], 'rel=1 and parent=' . $R['uid']);
$_xfile = $g['path_page'] . 'menu/' . sprintf('%05d', $R['uid']);
unlink($_xfile . '.php');
unlink($_xfile . '.widget.php');
@unlink($_xfile . '.mobile.php');
@unlink($_xfile . '.css');
@unlink($_xfile . '.js');
@unlink($_xfile . '.header.php');
@unlink($_xfile . '.footer.php');
@unlink($_xfile . '.txt');
@unlink($_xfile . '.cache');
@unlink($_xfile . '.widget.cache');
@unlink($_xfile . '.mobile.cache');
@unlink($g['path_var'] . 'menu/' . $R['imghead']);
@unlink($g['path_var'] . 'menu/' . $R['imgfoot']);
}
if ($parent) {
if (!getDbRows($table['s_menu'], 'parent=' . $parent)) {
getDbUpdate($table['s_menu'], 'isson=0', 'uid=' . $parent);
}
}
db_query("OPTIMIZE TABLE " . $table['s_menu'], $DB_CONNECT);
}
if ($backc == 'user') {
getLink($g['s'] . '/?r=' . $r . '&iframe=' . $iframe . '&system=edit.all&type=menu&cat=' . $parent, 'parent.', '', '');
} else {
getLink($g['s'] . '/?r=' . $r . '&m=admin&module=' . $m . '&front=menu&account=' . $account . '&cat=' . $parent, 'parent.', '', '');
}示例14: unlink
unlink($vfile . '.header.php');
}
}
if (trim($codfoot)) {
$fp = fopen($vfile . '.footer.php', 'w');
fwrite($fp, trim(stripslashes($codfoot)));
fclose($fp);
@chmod($vfile . '.footer.php', 0707);
} else {
if (is_file($vfile . '.footer.php')) {
unlink($vfile . '.footer.php');
}
}
$backUrl = $g['s'] . '/?r=' . $r . '&m=admin&module=' . $m . '&front=makebbs&iframe=Y&uid=' . $R['uid'];
} else {
if (getDbRows($table[$m . 'list'], "id='" . $id . "'")) {
getLink('', '', '이미 같은 아이디의 게시판이 존재합니다.', '');
}
$imgset = array('head', 'foot');
for ($i = 0; $i < 2; $i++) {
$tmpname = $_FILES['img' . $imgset[$i]]['tmp_name'];
$realname = $_FILES['img' . $imgset[$i]]['name'];
$fileExt = strtolower(getExt($realname));
$fileExt = $fileExt == 'jpeg' ? 'jpg' : $fileExt;
$userimg = $id . '_' . $imgset[$i] . '.' . $fileExt;
$saveFile = $g['dir_module'] . 'var/files/' . $userimg;
if (is_uploaded_file($tmpname)) {
if (!strstr('[gif][jpg][png][swf]', $fileExt)) {
getLink('', '', '헤더/풋터파일은 gif/jpg/png/swf 파일만 등록할 수 있습니다.', '');
}
move_uploaded_file($tmpname, $saveFile);示例15: getDbInsert
if (!getDbRows($table[$m . 'month'], "date='" . $date['month'] . "' and site=" . $s . ' and bbs=' . $bbsuid)) {
getDbInsert($table[$m . 'month'], 'date,site,bbs,num', "'" . $date['month'] . "','" . $s . "','" . $bbsuid . "','0'");
}
}
if ($uid) {
$R = getUidData($table[$m . 'data'], $uid);
if (!$R['uid']) {
getLink('', '', '존재하지 않는 게시물입니다.', '');
}
if ($reply == 'Y') {
if (!$my['admin'] && !strstr(',' . ($d['bbs']['admin'] ? $d['bbs']['admin'] : '.') . ',', ',' . $my['id'] . ',')) {
if ($d['bbs']['perm_l_write'] > $my['level'] || strstr($d['bbs']['perm_g_write'], '[' . $my['sosok'] . ']')) {
getLink('', '', '정상적인 접근이 아닙니다.', '');
}
}
$RNUM = getDbRows($table[$m . 'idx'], 'gid >= ' . $R['gid'] . ' and gid < ' . (intval($R['gid']) + 1));
if ($RNUM > 98) {
getLink('', '', '죄송합니다. 더이상 답글을 달 수 없습니다.', '');
}
getDbUpdate($table[$m . 'idx'], 'gid=gid+0.01', 'gid > ' . $R['gid'] . ' and gid < ' . (intval($R['gid']) + 1));
getDbUpdate($table[$m . 'data'], 'gid=gid+0.01', 'gid > ' . $R['gid'] . ' and gid < ' . (intval($R['gid']) + 1));
if ($R['hidden'] && $hidden) {
if ($R['mbruid']) {
$pw = $R['mbruid'];
} else {
$pw = $my['uid'] ? $R['pw'] : ($pw == $R['pw'] ? $R['pw'] : md5($pw));
}
} else {
$pw = $pw ? md5($pw) : '';
}
$gid = $R['gid'] + 0.01;