本文整理汇总了PHP中mysql::getone方法的典型用法代码示例。如果您正苦于以下问题:PHP mysql::getone方法的具体用法?PHP mysql::getone怎么用?PHP mysql::getone使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysql
的用法示例。
在下文中一共展示了mysql::getone方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: intval
$id = intval($_GET['id']);
if ($id > 0) {
$show = false;
if ($_CFG['showjobcontact_wap'] == '0') {
$show = true;
} elseif ($_CFG['showjobcontact_wap'] == '1') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$show = true;
} else {
$show = false;
$html = '<div class="job_show_box telbox"><h2>联系方式</h2>';
$html .= '<div class="nolog_txt">个人会员请<a href="wap_login.php">[登录]</a>后查看联系方式<br />没有帐号?<a href="wap_user_reg.php">[免费注册]</a></div></div>';
}
} elseif ($_CFG['showjobcontact_wap'] == '2') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$val = $db->getone("select uid from " . table('resume') . " where uid='{$_SESSION['uid']}' LIMIT 1");
if (!empty($val)) {
$show = true;
} else {
$show = false;
$html = '<div class="job_show_box telbox"><h2>联系方式</h2>';
$html .= '<div class="nolog_txt">您没有发布简历或者简历无效,发布简历后才可以查看联系方式。</div></div>';
}
} else {
$show = false;
$html = '<div class="job_show_box telbox"><h2>联系方式</h2>';
$html .= '<div class="nolog_txt">个人会员请<a href="wap_login.php">[登录]</a>后查看联系方式<br />没有帐号?<a href="wap_user_reg.php">[免费注册]</a></div></div>';
}
}
if ($show) {
$sql = "select * from " . table('jobs_contact') . " where pid='{$id}' LIMIT 1";
示例2: exit
require_once QISHI_ROOT_PATH . 'include/fun_company.php';
$user = get_user_info($_SESSION['uid']);
if ($user['status'] == "2") {
exit('<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableall">
<tr>
<td width="20" align="right"></td>
<td>
您的账号处于暂停状态,请联系管理员设为正常后进行操作!
</td>
</tr>
</table>');
}
$resume_id = $_REQUEST['resume_id'] ? intval($_REQUEST['resume_id']) : exit("简历ID丢失!");
$setarr['resume_state'] = $_REQUEST['resume_state'] ? intval($_REQUEST['resume_state']) : exit("标记状态错误!");
$setarr['resume_state_cn'] = $_REQUEST['resume_state_cn'] ? iconv('utf-8', 'gbk', trim($_REQUEST['resume_state_cn'])) : exit("标记状态错误!");
$p_uid = $db->getone("SELECT uid FROM " . table('resume') . " WHERE id={$resume_id} LIMIT 1 ");
$uid = intval($_SESSION['uid']);
$row = $db->getone("select resume_id from " . table("company_label_resume") . " where uid={$uid} and resume_id={$resume_id} limit 1");
if (empty($row)) {
$setarr['resume_id'] = $resume_id;
$setarr['uid'] = $uid;
$setarr['personal_uid'] = $p_uid['uid'];
$db->inserttable(table('company_label_resume'), $setarr);
//将查看状态更新成已经查看
$db->updatetable(table('personal_jobs_apply'), array('personal_look' => '2', 'is_reply' => $setarr['resume_state']), array("company_uid" => $uid, "resume_id" => $resume_id));
} else {
$db->updatetable(table('company_label_resume'), $setarr, array("uid" => $uid, "resume_id" => $resume_id));
//将查看状态更新成已经查看
$db->updatetable(table('personal_jobs_apply'), array('personal_look' => '2', 'is_reply' => $setarr['resume_state']), array("company_uid" => $uid, "resume_id" => $resume_id));
}
exit("ok");
示例3: elseif
</tr>
</table>
<?php
} elseif ($act == "download_save") {
$ruser = get_user_info($resumeshow['uid']);
$pms_notice = intval($_GET['pms_notice']);
if ($_CFG['operation_mode'] == "2") {
if ($resumeshow['talent'] == '2') {
if ($setmeal['download_resume_senior'] > 0 && add_down_resume($id, $_SESSION['uid'], $resumeshow['uid'], $resumeshow['resume_name'])) {
action_user_setmeal($_SESSION['uid'], "download_resume_senior");
$setmeal = get_user_setmeal($_SESSION['uid']);
write_memberslog($_SESSION['uid'], 1, 9002, $_SESSION['username'], "下载了 {$ruser['username']} 发布的高级简历,还可以下载 {$setmeal['download_resume_senior']} 份高级简历", 2, 1005, "下载高级简历", "1", "{$setmeal['download_resume_senior']}");
write_memberslog($_SESSION['uid'], 1, 4001, $_SESSION['username'], "下载了 {$ruser['username']} 发布的简历");
//站内信
if ($pms_notice == '1') {
$company = $db->getone("select id,companyname from " . table('company_profile') . " where uid ={$_SESSION['uid']} limit 1");
// $user=$db->getone("select username from ".table('members')." where uid ={$resumeshow['uid']} limit 1");
$resume_url = url_rewrite('QS_resumeshow', array('id' => $id));
$company_url = url_rewrite('QS_companyshow', array('id' => $company['id']));
$message = $_SESSION['username'] . "下载了您发布的简历:<a href=\"{$resume_url}\" target=\"_blank\">{$resumeshow['resume_name']}</a>,<a href=\"{$company_url}\" target=\"_blank\">点击查看公司详情</a>";
write_pmsnotice($resumeshow['uid'], $ruser['username'], $message);
}
exit("ok");
}
} else {
if ($setmeal['download_resume_ordinary'] > 0 && add_down_resume($id, $_SESSION['uid'], $resumeshow['uid'], $resumeshow['resume_name'])) {
action_user_setmeal($_SESSION['uid'], "download_resume_ordinary");
$setmeal = get_user_setmeal($_SESSION['uid']);
write_memberslog($_SESSION['uid'], 1, 9002, $_SESSION['username'], "下载了 {$ruser['username']} 发布的普通简历,还可以下载 {$setmeal['download_resume_ordinary']} 份普通简历", 2, 1004, "下载普通简历", "1", "{$setmeal['download_resume_ordinary']}");
write_memberslog($_SESSION['uid'], 1, 4001, $_SESSION['username'], "下载了 {$ruser['username']} 发布的简历");
//站内信
示例4: isset
</table>');
}
$id = isset($_GET['id']) ? intval($_GET['id']) : exit("err");
$user_jobs = get_auditjobs($_SESSION['uid']);
if (count($user_jobs) == 0) {
exit('<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableall">
<tr>
<td width="20" align="right"></td>
<td class="ajax_app">
邀请失败,你没有发布招聘信息或者信息没有审核通过!
</td>
</tr>
</table>');
}
$setmeal = get_user_setmeal($_SESSION['uid']);
$resume = $db->getone("select * from " . table('resume') . " WHERE id ='{$id}' LIMIT 1");
if ($_CFG['operation_mode'] == "3") {
if ($_CFG['setmeal_to_points'] == "1") {
if (empty($setmeal) || $setmeal['endtime'] < time() && $setmeal['endtime'] != "0") {
$_CFG['operation_mode'] = "1";
} else {
$_CFG['operation_mode'] = "2";
}
} else {
$_CFG['operation_mode'] = "2";
}
}
if ($_CFG['operation_mode'] == "2") {
if (empty($setmeal) || $setmeal['endtime'] < time() && $setmeal['endtime'] != "0") {
$str = "<a href=\"" . get_member_url(1, true) . "company_service.php?act=setmeal_list\">[申请服务]</a>";
exit('<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableall">
示例5: dirname
define('IN_QISHI', true);
require_once dirname(__FILE__) . '/../include/common.inc.php';
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : '';
$email = trim($_POST['email']);
$send_key = trim($_POST['send_key']);
if (empty($send_key) || $send_key != $_SESSION['send_email_key']) {
exit("效验码错误");
}
if ($act == "send_code") {
if (empty($email) || !preg_match("/^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]w+)*\$/", $email)) {
exit("邮箱格式错误");
}
$sql = "select * from " . table('members') . " where email = '{$email}' LIMIT 1";
$userinfo = $db->getone($sql);
if ($userinfo && $userinfo['uid'] != $_SESSION['uid']) {
exit("邮箱已经存在!请填写其他邮箱");
} elseif (!empty($userinfo['email']) && $userinfo['email_audit'] == "1" && $userinfo['email'] == $email) {
exit("你的邮箱 {$email} 已经通过验证!");
} else {
if ($_SESSION['sendemail_time'] && time() - $_SESSION['sendemail_time'] < 10) {
exit("请60秒后再进行验证!");
}
$rand = mt_rand(100000, 999999);
if (smtp_mail($email, "{$_CFG['site_name']}邮件认证", "{$QISHI['site_name']}提醒您:<br>您正在进行邮箱验证,验证码为:<strong>{$rand}</strong>")) {
$_SESSION['verify_email'] = $email;
$_SESSION['email_rand'] = $rand;
$_SESSION['sendemail_time'] = time();
exit("success");
} else {
示例6: empty
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " as a {$wheresql}";
$count = $db->get_total($total_sql);
$joinsql .= " LEFT JOIN " . table('jobs') . " AS j ON a.jobs_id=j.id ";
$smarty->assign('apply', get_apply_jobs($start, $perpage, $joinsql, $wheresql));
$smarty->display("m/personal/m-apply.html");
} elseif ($act == 'apply_add') {
$jobsid = intval($_POST["jobs_id"]) ? intval($_POST["jobs_id"]) : exit("出错了");
$resumeid = intval($_POST["resume_id"]) ? intval($_POST["resume_id"]) : exit("出错了");
$_POST = array_map("utf8_to_gbk", $_POST);
$sql = "select * from " . table("personal_jobs_apply") . " where personal_uid=" . intval($_SESSION['uid']) . " and resume_id=" . intval($_POST["resume_id"]) . " and jobs_id=" . intval($_POST["jobs_id"]) . "";
$row = $db->getone($sql);
$resume_basic = get_resume_basic($_SESSION['uid'], $resumeid);
$resume_basic = array_map("addslashes", $resume_basic);
if (empty($resume_basic)) {
exit("简历丢失");
}
if ($_SESSION['utype'] != 2) {
exit("个人会员请登录后申请职位");
} elseif ($row) {
exit("您已经申请过此职位!");
} else {
if (check_jobs_apply($jobs['id'], $resumeid, $_SESSION['uid'])) {
continue;
}
if ($resume_basic['display_name'] == "2") {
$personal_fullname = "N" . str_pad($resume_basic['id'], 7, "0", STR_PAD_LEFT);
示例7: intval
}
$setsqlarr['audit'] = intval($_CFG['simple_add_audit']);
$setsqlarr['uname'] = trim($_POST['uname']) ? trim($_POST['uname']) : showmsg('您没有填写姓名!', 1);
$setsqlarr['age'] = intval($_POST['age']);
$setsqlarr['sex'] = intval($_POST['sex']);
switch ($setsqlarr['sex']) {
case 1:
$setsqlarr['sex_cn'] = "男";
break;
case 2:
$setsqlarr['sex_cn'] = "女";
break;
}
$setsqlarr['category'] = trim($_POST['category']) ? trim($_POST['category']) : showmsg('您没有填写意向职位!', 1);
$setsqlarr['experience'] = intval($_POST['experience']) ? intval($_POST['experience']) : showmsg('您没有选择工作经验!', 1);
$experience = $db->getone("select c_name from " . table('category') . " where c_id=" . $setsqlarr['experience']);
$setsqlarr['experience_cn'] = $experience['c_name'];
$setsqlarr['tel'] = trim($_POST['tel']) ? trim($_POST['tel']) : showmsg('您没有填写联系电话!', 1);
if (preg_match("/^\\d*\$/", $setsqlarr['tel'])) {
if ($captcha['simple_tel_repeat'] == '0') {
$sql = "select id from " . table('simple_resume') . " where tel = '{$setsqlarr['tel']}' LIMIT 1";
$info = $db->getone($sql);
if (!empty($info)) {
showmsg('电话号码已经存在!', 1);
}
}
} else {
showmsg('电话号码格式错误!', 1);
}
$setsqlarr['district'] = intval($_POST['district']);
$setsqlarr['sdistrict'] = intval($_POST['sdistrict']);
示例8: check_m_subsite_url
function check_m_subsite_url()
{
global $dbhost, $dbuser, $dbpass, $dbname;
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
unset($dbhost, $dbuser, $dbpass, $dbname);
$districtinfo = getIpLookup();
if ($districtinfo === false) {
return false;
}
$province = utf8_to_gbk($districtinfo['province']);
$city = utf8_to_gbk($districtinfo['city']);
$subinfo = $db->getone("select * from " . table('subsite') . " where s_effective=1 and (s_districtname like '%" . $province . "%' or s_districtname like '%" . $city . "%') order by s_id desc limit 1");
if ($subinfo) {
return array('disname' => $subinfo['s_districtname'], 'sitename' => $subinfo['s_sitename'], 'url' => 'http://' . ($subinfo['s_m_domain'] ? $subinfo['s_m_domain'] : $subinfo['s_domain'] . '/m/'));
} else {
return false;
}
}
示例9: isset
</table>');
}
$id = isset($_GET['id']) ? intval($_GET['id']) : exit("err");
$user_jobs = get_auditjobs($_SESSION['uid']);
if (count($user_jobs) == 0) {
exit('<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableall">
<tr>
<td width="20" align="right"></td>
<td class="ajax_app">
邀请失败,你没有发布招聘信息或者信息没有审核通过!
</td>
</tr>
</table>');
}
$setmeal = get_user_setmeal($_SESSION['uid']);
$resume = $db->getone("select * from " . table('resume') . " WHERE id ='{$id}' LIMIT 1");
$resume = array_map("addslashes", $resume);
if ($act == "invited") {
if ($_CFG['operation_hunter_mode'] == "2") {
if (empty($setmeal) || $setmeal['endtime'] < time() && $setmeal['endtime'] != "0") {
$str = "<a href=\"" . get_member_url(3, true) . "hunter_service.php?act=setmeal_list\">[申请服务]</a>";
exit('<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableall">
<tr>
<td width="20" align="right"></td>
<td class="ajax_app">
您的服务已到期。您可以 ' . $str . '
</td>
</tr>
</table>');
} elseif ($resume['talent'] == '2' && $setmeal['interview_senior'] <= 0) {
$str = "<a href=\"" . get_member_url(3, true) . "hunter_service.php?act=setmeal_list\">[申请服务]</a>";
示例10: COUNT
}
$theurl = "news-list.php";
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} " . $wheresql . $orderbysql;
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT * FROM {$jobstable} " . $wheresql . $orderbysql . $limit);
$article = array();
while ($row = $db->fetch_array($idresult)) {
$row['url'] = wap_url_rewrite("news-show", array("id" => $row['id']));
$row['addtime'] = daterange(time(), $row['addtime'], 'Y-m-d', "#FF3300");
$row['bimg'] = $_CFG['upfiles_dir'] . $row['Small_img'];
$row['content'] = strip_tags($row['content']);
$row['content'] = cut_str($row['content'], 100, 0, "...");
$article[] = $row;
}
$smarty->assign('article', $article);
//新闻资讯分类
if ($type > 0) {
$category_first = $db->getone("SELECT id,parentid,categoryname FROM " . table('article_category') . " where id=" . $type);
$category_more = $db->getall("SELECT id,parentid,categoryname FROM " . table('article_category') . " where parentid!=0 and id!=" . $type . " ORDER BY id asc");
} else {
$category = $db->getall("SELECT id,parentid,categoryname FROM " . table('article_category') . " where parentid!=0 ORDER BY id asc");
$category_first = $category[0];
for ($i = 1; $i < count($category); $i++) {
$category_more[] = $category[$i];
}
}
$smarty->assign('category_first', $category_first);
$smarty->assign('category_more', $category_more);
$smarty->display("m/news-list.html");
示例11: elseif
if ($id > 0) {
$show = false;
if ($_CFG['showjobcontact'] == '0') {
$show = true;
} elseif ($_CFG['showjobcontact'] == '1') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$show = true;
} else {
$show = false;
$html = '<div class="title"><h2>联系方式</h2></div><div class="txt">';
$html .= '个人会员请<a href="wap_login.php">[登录]</a>后查看联系方式<br />没有帐号?<a href="wap_user_reg.php">[免费注册]</a>';
$html .= '</div><div class="telimg"></div>';
}
} elseif ($_CFG['showjobcontact'] == '2') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$val = $db->getone("select uid from " . table('resume') . " where uid='{$_SESSION['uid']}' LIMIT 1");
if (!empty($val)) {
$show = true;
} else {
$show = false;
$html = '<div class="title"><h2>联系方式</h2></div><div class="txt">';
$html .= "您没有发布简历或者简历无效,发布简历后才可以查看联系方式。<a href=\"" . get_member_url($_SESSION['utype'], true) . "personal_resume.php?act=resume_list\">[查看我的简历]</a>";
$html .= '</div><div class="telimg"></div>';
}
} else {
$show = false;
$html = '<div class="title"><h2>联系方式</h2></div><div class="txt">';
$html .= '个人会员请<a href="wap_login.php">[登录]</a>后查看联系方式<br />没有帐号?<a href="wap_user_reg.php">[免费注册]</a>';
$html .= '</div><div class="telimg"></div>';
}
}
示例12: elseif
</tr>
</table>
<?php
} elseif ($act == "download_save") {
$ruser = get_user_info($resumeshow['uid']);
$pms_notice = intval($_GET['pms_notice']);
if ($_CFG['operation_hunter_mode'] == "2") {
$setmeal = get_user_setmeal($_SESSION['uid']);
if ($resumeshow['talent'] == '2' && $setmeal['download_resume_senior'] > 0 && add_hunter_down_resume($id, $_SESSION['uid'], $resumeshow['uid'], $resumeshow['resume_name'])) {
action_user_setmeal($_SESSION['uid'], "download_resume_senior");
$setmeal = get_user_setmeal($_SESSION['uid']);
write_memberslog($_SESSION['uid'], 3, 9202, $_SESSION['username'], "下载了 {$ruser['username']} 发布的高级简历,还可以下载 {$setmeal['download_resume_senior']} 份高级简历");
write_memberslog($_SESSION['uid'], 3, 4001, $_SESSION['username'], "下载了 {$ruser['username']} 发布的高级简历");
//站内信
if ($pms_notice == '1') {
$hunter = $db->getone("select id,huntername from " . table('hunter_profile') . " where uid ={$_SESSION['uid']} limit 1");
$resume_url = url_rewrite('QS_resumeshow', array('id' => $id));
$message = $_SESSION['username'] . "下载了您发布的高级简历:<a href=\"{$resume_url}\" target=\"_blank\">{$resumeshow['resume_name']}</a>,猎头姓名:{$hunter['huntername']}";
write_pmsnotice($resumeshow['uid'], $ruser['username'], $message);
}
exit("ok");
} elseif (($resumeshow['talent'] == '1' || $resumeshow['talent'] == '3') && $setmeal['download_resume_ordinary'] > 0 && add_hunter_down_resume($id, $_SESSION['uid'], $resumeshow['uid'], $resumeshow['resume_name'])) {
action_user_setmeal($_SESSION['uid'], "download_resume_ordinary");
$setmeal = get_user_setmeal($_SESSION['uid']);
write_memberslog($_SESSION['uid'], 3, 9202, $_SESSION['username'], "下载了 {$ruser['username']} 发布的简历,还可以下载 {$setmeal['download_resume_ordinary']} 份简历");
write_memberslog($_SESSION['uid'], 3, 4001, $_SESSION['username'], "下载了 {$ruser['username']} 发布的简历");
//站内信
if ($pms_notice == '1') {
$hunter = $db->getone("select id,huntername from " . table('hunter_profile') . " where uid ={$_SESSION['uid']} limit 1");
// $user=$db->getone("select username from ".table('members')." where uid ={$resumeshow['uid']} limit 1");
$resume_url = url_rewrite('QS_resumeshow', array('id' => $id));
示例13: exit
$resume_basic = array_map("addslashes", $resume_basic);
if (empty($resume_basic)) {
exit("简历丢失");
}
$i = 0;
foreach ($jobsarr as $jobs) {
if (check_hunter_jobs_apply($jobs['id'], $resumeid, $_SESSION['uid'])) {
continue;
}
$addarr['resume_id'] = $resumeid;
$addarr['resume_name'] = $resume_basic['fullname'];
$addarr['personal_uid'] = intval($_SESSION['uid']);
$addarr['jobs_id'] = $jobs['id'];
$addarr['jobs_name'] = $jobs['jobs_name'];
$hunter_info_sql = "SELECT * FROM " . table('hunter_profile') . " WHERE uid=" . $jobs['uid'] . " LIMIT 1";
$hunter_info = $db->getone($hunter_info_sql);
if (empty($hunter_info)) {
exit("职位所属猎头会员异常 ! ");
}
$addarr['huntet_id'] = $hunter_info['id'];
$addarr['huntet_name'] = $hunter_info['huntername'];
$addarr['huntet_uid'] = $hunter_info['uid'];
$addarr['notes'] = $notes;
$addarr['apply_addtime'] = time();
$addarr['personal_look'] = 1;
$addarr['is_apply'] = 1;
if ($db->inserttable(table('personal_hunter_jobs_apply'), $addarr)) {
$mailconfig = get_cache('mailconfig');
$weixinconfig = get_cache('weixin_config');
$jobs['contact'] = $db->getone("select * from " . table('jobs_contact') . " where pid='{$jobs['id']}' LIMIT 1 ");
$sms = get_cache('sms_config');
示例14: exit
$district_cn = $li['district_cn'];
}
$simplelisthtml .= $district_cn . '</div>
</div>
</div>
<div class="bottom"></div>
</section>';
}
exit($simplelisthtml);
} else {
exit('-1');
}
} elseif ($act == 'jobs_contact') {
$id = intval($_GET['id']);
if ($id > 0) {
$jobs_one = $db->getone("select * from " . table("jobs") . " where id={$id} ");
$jobs_tmp = $db->getone("select * from " . table("jobs_tmp") . " where id={$id} ");
$jobs = empty($jobs_one) ? $jobs_tmp : $jobs_one;
$show = false;
if ($_CFG['showjobcontact_wap'] == '0') {
$show = true;
} elseif ($_CFG['showjobcontact_wap'] == '1') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$show = true;
} else {
$show = false;
$html = '<section class="company-content">
<h2 class="company-title">联系方式</h2>
<div class="contact-login">
<div class="login-tips">个人会员登录后才可以查看联系方式!</div>
<div class="button-group layout-box">
示例15: elseif
$value['fullname'] = "N" . str_pad($value['id'], 7, "0", STR_PAD_LEFT);
$value['fullname_'] = $value['fullname'];
} elseif ($value['display_name'] == "3") {
if ($value['sex'] == 1) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "先生");
} elseif ($value['sex'] == 2) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "女士");
}
$value['fullname_'] = $value['fullname'];
} else {
$value['fullname_'] = $value['fullname'];
$value['fullname'] = $value['fullname'];
}
$resume[$key]['url'] = wap_url_rewrite("resume-show", array("id" => $value["id"]));
$resume[$key]['fullname_'] = $value['fullname_'];
$resume[$key]['fullname'] = $value['fullname'];
$resume[$key]['refreshtime_cn'] = daterange(time(), $value['refreshtime'], 'Y-m-d', "#FF3300");
//检测该会员的手机认证状态
$user_info = $db->getone("SELECT mobile_audit FROM " . table('members') . " WHERE uid=" . $value['uid']);
$resume[$key]['mobile_audit'] = $user_info['mobile_audit'];
}
} else {
$resume = array();
}
$smarty->assign('resume', $resume);
$smarty->assign('pagehtml', wapmulti($count, $perpage, $page, $theurl));
//热门关键字
$sql = "select w_word,w_hot from " . table("hotword") . " order by w_hot desc limit 15 ";
$hotword_list = $db->getall($sql);
$smarty->assign('hotword', $hotword_list);
$smarty->display("m/m-resume-list.html");