如果我执行此
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
}