:::

4-5 function.php

<?php
//連線資料庫
function link_db()
{
    //實體化資料庫物件
    $mysqli = new mysqli(_DB_LOCATION, _DB_ID, _DB_PASS, _DB_NAME);
    if ($mysqli->connect_error) {
        throw new Exception('無法連上資料庫:' . $mysqli->connect_error);
    }
    $mysqli->set_charset("utf8");
    return $mysqli;
}

//檢查並傳回欲拿到資料使用的變數
function clean_var($var = '', $title = '', $filter = '')
{
    global $db;
    $clean_var = $db->real_escape_string($_REQUEST[$var]);
    if (empty($clean_var)) {
        throw new Exception("{$title}為必填!");
    }
    if ($filter) {
        $clean_var = filter_var($clean_var, $filter);
        if (!$clean_var) {
            throw new Exception("不合法的{$title}");
        }
    }
    return $clean_var;
}

 


:::

書籍目錄

展開 | 闔起

http%3A%2F%2Fcampus-xoops.tn.edu.tw%2Fmodules%2Ftad_book3%2Fpage.php%3Ftbsn%3D30%26tbdsn%3D819

計數器

今天: 1315131513151315
昨天: 2138213821382138
總計: 7322597732259773225977322597732259773225977322597