當前位置: 首頁>>代碼示例>>PHP>>正文

PHP mysql::getone方法代碼示例

本文整理匯總了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";
開發者ID:source-hunter，項目名稱:74cms，代碼行數:31，代碼來源:wap_ajax.php

示例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");
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:user_label_resume.php

示例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']} 發布的簡曆");
                //站內信
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:user_download_resume.php

示例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">
開發者ID:winiceo，項目名稱:fenzhan，代碼行數:31，代碼來源:user_invited.php

示例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 {
開發者ID:dalinhuang，項目名稱:yy，代碼行數:31，代碼來源:ajax_verify_email.php

示例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);
開發者ID:winiceo，項目名稱:fenzhan，代碼行數:31，代碼來源:apply.php

示例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']);
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:ajax_simple_resume.php

示例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;
    }
}
開發者ID:winiceo，項目名稱:fenzhan，代碼行數:19，代碼來源:common.fun.php

示例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>";
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:user_hunter_invited.php

示例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");
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:news-list.php

示例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>';
         }
     }
開發者ID:source-hunter，項目名稱:74cms，代碼行數:31，代碼來源:wap_ajax.php

示例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));
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:user_hunter_download_resume.php

示例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');
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:user_apply_hunter_jobs.php

示例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">
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:ajax.php

示例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");
開發者ID:winiceo，項目名稱:job，代碼行數:31，代碼來源:resume-list.php


注：本文中的mysql::getone方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。