PHP fetchOne函数代码示例

function get_recipe($recipe)
{
    global $doc, $xpath;
    $url = 'http://www.marmiton.org/recettes/recherche.aspx?aqt=' . urlencode($recipe);
    $pageList = file_get_contents($url);
    // get response list and match recipes titles
    if (preg_match_all('#m_titre_resultat[^\\<]*<a .*title="(.+)".* href="(.+)"#isU', $pageList, $matchesList)) {
        // echo"<xmp>";print_r($matchesList[1]);echo"</xmp>";
        // for each recipes titles
        // foreach($matchesList[1] as $recipeTitle) {
        // }
        // take first recipe
        $n = 0;
        $url = 'http://www.marmiton.org' . $matchesList[2][$n];
        $pageRecipe = file_get_contents($url);
        // get recipe (minimize/clean before dom load)
        if (preg_match('#<div class="m_content_recette_main">.*<div id="recipePrevNext2"></div>\\s*</div>#isU', $pageRecipe, $match)) {
            $recipe = $match[0];
            $recipe = preg_replace('#<script .*</script>#isU', '', $recipe);
            $doc = loadDOC($pageRecipe);
            $xpath = new DOMXpath($doc);
            $recipeTitle = fetchOne('//h1[@class="m_title"]');
            $recipeMain = fetchOne('//div[@class="m_content_recette_main"]');
            return '<div class="recipe_root">' . $recipeTitle . $recipeMain . '</div>';
        }
    }
}

function login()
{
    $username = $_POST['username'];
    //防sql注入语句
    //第一种方法：addslashes():使用反斜线引用特殊字符
    //$username=addslashes($username);
    //第二种方法：mysql_escape_string():转换一个字符串，用于mysql_query
    $username = mysql_escape_string($username);
    $password = md5($_POST['password']);
    $sql = "select * from imooc_user where username='{$username}' and password='{$password}'";
    /*以下语句打印出的sql语句，看出恶意攻击的sql注入
    	//如有人在账户名中输入“ ' or 1=1 # ”
    	//这段代码，那语句会变成select * from imooc_user where username='‘ or 1 = 1 #' and password='d41d8cd98f00b204e9800998ecf8427e'
    	//那等于用户名为空或者1=1的sql语句，这句永远为空，则返回ture，那根据下面语句，就会直接登录
    	//echo $sql;exit;
    	*/
    //$resNum=getResultNum($sql);
    $row = fetchOne($sql);
    //echo $resNum;
    if ($row) {
        $_SESSION['loginFlag'] = $row['id'];
        $_SESSION['username'] = $row['username'];
        $mes = "登陆成功！<br/>3秒钟后跳转到首页<meta http-equiv='refresh' content='3;url=index.php'/>";
    } else {
        $mes = "登陆失败！<a href='login.php'>重新登陆</a>";
    }
    return $mes;
}

function month_total_fee($month)
{
    $year = explode('-', $month)[0];
    $mon = explode('-', $month)[1];
    //获取需要的月份相应交费记录并计算总费用
    $sql = "select fee,date,dueDate from hh_fee";
    $rows = fetchAll($sql);
    $total = 0;
    foreach ($rows as $row) {
        $day1 = $row['date'];
        $day2 = $row['dueDate'];
        $fee = $row['fee'];
        $T = ceil($fee / days_dis($day1, $day2));
        //$T为 该笔学费每天的收入
        $days = month_days($day1, $day2, $month);
        if ($days) {
            $total = $days * $T + $total;
        }
    }
    $arr = array('year' => $year, 'month' => $mon, 'total' => $total);
    //如果已存在相应日期记录，则进行更新操作，否则进行插入
    $sql = "select count(total) from hh_totalFee where year={$year} and month={$mon}";
    $result = fetchOne($sql)['count(total)'];
    if ($result >= 1) {
        update('hh_totalFee', $arr, "year={$year} and month={$mon}");
    } else {
        insert('hh_totalFee', $arr);
    }
}

function login()
{
    $username = $_POST['username'];
    //addslashes():使用反斜线引用特殊字符
    //$username=addslashes($username);
    //$username=mysql_escape_string($username);
    /*Deprecated: 
    			mysql_escape_string(): This function is deprecated; 
    								   use mysql_real_escape_string() instead
    		*/
    $username = mysql_real_escape_string($username);
    $password = md5($_POST['password']);
    $sql = "select * from user where username='{$username}' and password='{$password}'";
    //$resNum=getResultNum($sql);
    //var_dump($sql);exit;
    $row = fetchOne($sql);
    //echo $resNum;
    if ($row) {
        $_SESSION['loginFlag'] = $row['id'];
        $_SESSION['username'] = $row['username'];
        $mes = "登陆成功！<br/>3秒钟后跳转到首页<meta http-equiv='refresh' content='3;url=index.php'/>";
    } else {
        $mes = "登陆失败！<a href='login.php'>重新登陆</a>";
    }
    return $mes;
}

function notify_fee($type)
{
    $rows_member = getAllActiveMid();
    //循环出一个含有所有激活用户的mid和最新dueDate的$arrs_durDate[]
    foreach ($rows_member as $row_member) {
        $mid = $row_member['mid'];
        $sql = "select mid,dueDate,fee from hh_fee where mid={$mid} order by dueDate desc limit 1";
        $row_dueDate = fetchOne($sql);
        if ($row_dueDate) {
            $arrs_dueDate[] = $row_dueDate;
        }
    }
    // return $arrs_dueDate;
    $i = 0;
    //格式化时间,运算后输出 费交期 与 今日 的差值(天)
    foreach ($arrs_dueDate as $arr_dueDate) {
        $due = strtotime($arr_dueDate['dueDate']);
        $now = time();
        $day[$i]['mid'] = $arr_dueDate['mid'];
        $day[$i]['name'] = getMemberInfo($arr_dueDate['mid'])['name'];
        $day[$i]['day'] = ceil(($due - $now) / 86400);
        $day[$i]['fee'] = $arr_dueDate['fee'];
        $i++;
    }
    $n = 0;
    $output = array();
    // return $day;
    foreach ($day as $day1) {
        if ($type == 1) {
            //5天之内该交费的
            if ($day1['day'] <= 5 && $day1['day'] > 0) {
                $output[$n]['mid'] = $day1['mid'];
                $output[$n]['name'] = $day1['name'];
                $output[$n]['day'] = $day1['day'];
                $output[$n]['fee'] = $day1['fee'];
            }
        } elseif ($type == 2) {
            //今天该交费的
            if ($day1['day'] == 0) {
                $output[$n]['mid'] = $day1['mid'];
                $output[$n]['name'] = $day1['name'];
                $output[$n]['day'] = $day1['day'];
                $output[$n]['fee'] = $day1['fee'];
            }
        } elseif ($type == 3) {
            //超过交费期的
            if ($day1['day'] < 0) {
                $output[$n]['mid'] = $day1['mid'];
                $output[$n]['name'] = $day1['name'];
                $output[$n]['day'] = $day1['day'];
                $output[$n]['fee'] = $day1['fee'];
            }
        }
        $n++;
    }
    $output = sort_array($output, 'day');
    return $output;
}

function deleteAction()
{
    $id = $_GET['id'];
    // 获取图像的相关信息
    $sql = "SELECT proImage AS image FROM products WHERE id=" . $id;
    $row = fetchOne($sql);
    unlink('../proimages/' . $row['image']);
    // 删除记录
    delete('products', 'id=' . $id);
    $message = '商品已经成功删除';
    $redirect = '<a href="recyclePro.php">返回回收站</a>';
    require_once 'thems/a.html';
}

function editAdmin($id)
{
    $arr = $_POST;
    $row = fetchOne("select * from admin where id={$id}");
    // 只有修改了密码，才使用md5加密
    if ($row != null && $row["password"] != $arr["password"]) {
        $arr["password"] = md5($arr["password"]);
    }
    if (update("admin", $arr, "id={$id}")) {
        $msg = "更新成功!<br/> <a href='listAdmin.php'>查看管理员列表</a>";
    } else {
        $msg = "更新失败!<br/> <a href='listAdmin.php'>查看管理员列表</a>";
    }
    return $msg;
}

 function reader_excel($destination, $phonebook_id)
 {
     // Set output Encoding.
     $data = new Spreadsheet_Excel_Reader();
     $data->setOutputEncoding('utf-8');
     //”data.xls”是指要导入到mysql中的excel文件
     $data->read($destination);
     echo $phonebook_id;
     echo '<br/>';
     echo "<table style='border-collapse:collapse;border-spacing:0;border:1px solid #000'>";
     for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
         //以下注释的for循环打印excel表数据
         $array = array();
         $contacts_arr = array();
         echo "<tr  style='border:1px solid #000'>";
         for ($j = 1; $j <= 3; $j++) {
             if (empty($data->sheets[0]['cells'][$i][$j])) {
                 $array[$j - 1] = null;
                 echo "<td style='border:1px solid #000'></td>";
             } else {
                 $array[$j - 1] = $data->sheets[0]['cells'][$i][$j];
                 echo "<td style='border:1px solid #000'>" . $data->sheets[0]['cells'][$i][$j] . "</td>";
             }
         }
         echo '</tr>';
         var_dump($array);
         echo '<br/>';
         $sql_fetchlongnum = "SELECT * FROM contacts where longnum ='{$array[1]}'";
         $old_phonebook_id = fetchOne($sql_fetchlongnum)['phonebook_id'];
         if ($old_phonebook_id) {
             $new_phonebook_id = $old_phonebook_id . '|' . $phonebook_id;
             $contacts_arr = array('phonebook_id' => $new_phonebook_id);
             update('contacts', $contacts_arr, "longnum=" . "'{$array['1']}'");
         } else {
             $contacts_arr = array('phonebook_id' => $phonebook_id, 'name' => $array[0], 'longnum' => $array[1], 'shortnum' => $array[2]);
             echo insert('contacts', $contacts_arr);
         }
     }
     echo "</table>";
 }

<?php 
require_once 'include.php';
require_once 'header.php';
@($sql = "select user_type from tg_user_login where user_id='{$_SESSION['user_id']}'");
@($row = fetchOne($sql));
@($type = $row['user_type']);
?>

    <!-- Page Content -->
    <div class="container">

        <!-- Page Heading/Breadcrumbs -->
        <div class="row">
            <div class="col-lg-12">
                <h1 class="page-header">How it works
                    <small>Guest</small>
                </h1>
                <ol class="breadcrumb">
                    <li><a href="index.php">Home</a>
                    </li>
                    <li class="active">How it works (guest)</li>
                </ol>
            </div>
        </div>
        <!-- /.row -->

    <div class="row">
        <a href="host-how-it-works.php" class="btn btn-success fr">I am a Host</a>
    </div>

function articlePage($section, $filePath)
{
    // -----[ CACHE LITE ]-----
    // Cache Lite is optional but recommended as it rolls and stores the page as HTML
    // and avoids having to rebuild the page everytime it is called. You will need to clear
    // the cache if you update the page. You could create a seperate "clearcache.php" page.
    // See: "/site/orgile/clearcache.php".
    require_once 'Cache/Lite/Output.php';
    $options = array('cacheDir' => '/srv/www/' . SITEURL . '/www/site/ramcache/', 'lifeTime' => '604800');
    // Define cache directory and cache lifetime (168 hours).
    $cache = new Cache_Lite_Output($options);
    // Begin cache lite.
    if (!$cache->start($filePath)) {
        if (is_file($filePath)) {
            $fileData = file_get_contents($filePath, NULL, NULL, 0, 1000);
            // This reads the first 1000 chars for speed.
            // Pulls details from .org file header.
            $regex = '/^#\\+\\w*:(.*)/m';
            preg_match_all($regex, $fileData, $matches);
            $title = trim($matches[1][0]);
            $author = trim($matches[1][1]);
            $date = trim($matches[1][2]);
            $date = date('c', cleanDate($date));
            $description = trim($matches[1][3]);
            $description = strip_tags($description);
            // Create HTML header.
            $htmlHeader = htmlHeader($date, $author, $description, $title, dropDash($section));
            // Starts the object buffer.
            ob_start();
            pageHeader();
            print '<div id="columnX">';
            fetchOne($filePath, 'orgile');
            print '</div>';
            print '<div id="columnY">';
            print '<aside>';
            print '<div class="content">';
            print '<h2><a href="/' . spaceDash($section) . '/" title="' . spaceDash($section) . '">' . spaceDash($section) . '</a>:</h2>';
            print '<ul class="side">';
            fetchSome($section, 'list', '0', 'sort');
            // See function below.
            print '</ul><br>';
            print '</div>' . sideContent();
            print '</aside>';
            print '</div>';
            pageFooter();
            // End the object buffer.
            $content = ob_get_contents();
            ob_end_clean();
            $content = $htmlHeader . $content;
        }
        // End: is_file($filePath).
        print $content;
        // End cache.
        $cache->end();
    }
    // End: cache lite.
}

    $numRows = getResultNum($sql1);
    $totalPage = ceil($numRows / $pageSize);
} elseif ($type == 'sending') {
    $data = sending($id, $pageSize, '');
    $goods = 3;
    $username1 = fetchOne("select username from tuhao_user where id={$id}");
    $sql1 = "select * from tuhao_pro where username='{$username}' and receiver is null order by reg_time desc ";
    $numRows = getResultNum($sql1);
    $totalPage = ceil($numRows / $pageSize);
}
$arr = array('status' => 1);
update("tuhao_pro", $arr, "username='{$username}' and is_send=1 and status =0");
$sql = "select user_id,college,head_photo,levell,score from tuhao_info where user_id={$id}";
$user = fetchOne($sql);
$sql1 = "select username from tuhao_user where id={$user['user_id']}";
$username1 = fetchOne($sql1);
$user['src'] = "uploads/" . $user['head_photo'];
$user['username'] = $username1['username'];
$smarty->assign('username', $username);
$smarty->assign('study', $study);
$smarty->assign('clothes', $clothes);
$smarty->assign('digital', $digital);
$smarty->assign('transportation', $transportation);
$smarty->assign('entertainment', $entertainment);
$smarty->assign('others', $others);
$smarty->assign('activity', $activity);
$smarty->assign('loginFlag', $loginFlag);
$smarty->assign('data', $data);
$smarty->assign('sentNum', $sentNum);
$smarty->assign('mesNum', $mesNum);
$smarty->assign('goods', $goods);

}
function truncate($table)
{
    $sql = 'TRUNCATE TABLE' . $table;
    mysql_query($sql);
}
function fetchAll($sql, $result_type = MYSQL_ASSOC)
{
    $result = mysql_query($sql);
    $rowCount = mysql_num_rows($result);
    if ($rowCount) {
        while ($row = mysql_fetch_array($result, $result_type)) {
            $rows[] = $row;
        }
        return $rows;
    }
    return FALSE;
}
function fetchOne($sql, $result_type = MYSQL_ASSOC)
{
    $result = mysql_query($sql);
    $rowCount = mysql_num_rows($result);
    if ($rowCount) {
        return mysql_fetch_array($result, $result_type);
    }
    return FALSE;
}
connection('localhost', 'root', 'root', 'test');
$sql = 'SELECT * FROM users';
$rowset = fetchOne($sql);
print_r($rowset);

function getPostBypid($pid)
{
    $sql = "select * from zhx_post where pid={$pid}";
    $row = fetchOne($sql);
    return $row;
}

$clothes = catePro('衣服配饰');
$digital = catePro('数码产品');
$transportation = catePro('交通工具');
$entertainment = catePro('生活娱乐');
$others = catePro('其他');
$activity = catePro('11.11');
if (isset($_SESSION['id']) && isset($_SESSION['username'])) {
    $id = $_SESSION['id'];
    $username = $_SESSION['username'];
    $loginFlag = $_SESSION['id'];
    $sql = "select head_photo from tuhao_info where user_id={$_SESSION['id']}";
    $src = fetchOne($sql);
    $headPhoto = "uploads/" . $src['head_photo'];
} elseif (autoLogin()) {
    $sql = "select * from tuhao_user where auto_token='{$_COOKIE['autoToken']}'";
    $data = fetchOne($sql);
    $username = $data['username'];
    $loginFlag = $data['id'];
    $id = $data['id'];
} else {
    $username = '';
    $loginFlag = 0;
    $id = 0;
}
$sql2 = "select * from tuhao_pro where username='{$username}' and is_send=1 and status =0";
$sentNum = getResultNum($sql2);
$sql3 = "select * from tuhao_comm where receiver_id={$id} and status = 0";
$mesNum = getResultNum($sql3);
$smarty->assign('username', $username);
//$smarty->assign('headPhoto',$headPhoto);
$smarty->assign('study', $study);

/**
 * 根据ID得到指定分类信息
 * @param int $id
 * @return array
 */
function getCateById($id)
{
    $sql = "select id,cName from imooc_cate where id={$id}";
    return fetchOne($sql);
}