include()文件,这样每个函数都可以访问


include() a file so every function has access

如果我执行此

include('orderConst_pdo_connect.php');
switch  ($type){
    case "retrieve":
        retrieve_address($customer_id);
        break;
    case "new":
        new_address($customer_id, $address);
        break;
    case "update":
        update_address($customer_id, $address_id);
        break;
    case "delete":
        delete_address($customer_id, $address_id);
        break;              
}
function retrieve_address($customer_id){
    $sth = $dbh->prepare("
    SELECT * 
    FROM   address 
    WHERE  customer_id = :customer_id 
    ORDER  BY CASE 
                WHEN use_frequency IS NULL THEN id 
                ELSE use_frequency 
              END ASC");
.... 
}

我得到错误

Fatal error: Call to a member function prepare() on a non-object

直到我将CCD_ 2放入函数中。有没有一种方法可以将文件包含在页面顶部并允许函数访问它,或者我需要将它包含在每个使用它的函数中?

include文件中定义的变量,默认情况下在函数中不可用。您可以使用global $dbh 授予函数访问此变量的权限

与其使用global,不如执行:

function retrieve_address($dbh, $customer_id) {
    // blah
}
相关文章: