致命錯(cuò)誤：調(diào)用布爾值上的成員函數(shù)bindparam()我忙著處理一個(gè)從DB獲取設(shè)置的函數(shù)，突然，我遇到了以下錯(cuò)誤：Fatal error: Call to a member function bind_param() on boolean in C:\xampp2\htdocs\application\classes\class.functions.php on line 16通常情況下，這意味著我從不存在的表和東西中選擇一些東西。但在這種情況下，我不是.這是getSetting職能：public function getSetting($setting){
$query = $this->db->conn->prepare('SELECT value, param FROM ws_settings WHERE name = ?');
$query->bind_param('s', $setting);
$query->execute();
$query->bind_result($value, $param);
$query->store_result();
if ($query->num_rows() > 0)
{
while ($query->fetch())
{
return $value;
if ($param === '1')
{
$this->tpl->createParameter($setting, $value);
}
}
}
else
{
__('invalid.setting.request', $setting);
}}這個(gè)$this->db變量通過構(gòu)造函數(shù)傳遞。在需要的情況下，這是：public function __construct($db, $data, $tpl){
$this->db = $db;
$this->tpl = $tpl;
$this->data = $data;
$this->data->setData('global', 'theme', $this->getSetting('theme'));}此外，由于我使用的是數(shù)據(jù)庫，所以我的數(shù)據(jù)庫連接：class Database{
private $data;
public function __construct($data)
{
$this->data = $data;
$this->conn = new MySQLi(
$this->data->getData('database', 'hostname'),
$this->data->getData('database', 'username'),
$this->data->getData('database', 'password'),
$this->data->getData('database', 'database')
);
if ($this->conn->errno)
{
__('failed.db.connection', $this->conn->errno);
}
date_default_timezone_set('Europe/Amsterdam');}我已經(jīng)測試了連接，100%的陽性，它的工作原理。我在配置文件中設(shè)置DB連接：'database' => array(
'hostname' => '127.0.0.1',
'username' => 'root',
'password' => ******,
'database' => 'wscript')現(xiàn)在奇怪的是：表存在，請求的設(shè)置存在，DB存在，但是錯(cuò)誤不會(huì)留下。這里有一些證據(jù)證明DB是正確的：
3 回答
汪汪一只貓
TA貢獻(xiàn)1898條經(jīng)驗(yàn) 獲得超8個(gè)贊
$query = $this->db->conn->prepare('SELECT value, param FROM ws_settings WHERE name = ?');$query->bind_param('s', $setting);prepare()falsefalseSELECTWHERE
$this->db->conn->error_list
12345678_0001
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超5個(gè)贊
“致命錯(cuò)誤：對布爾值上的成員函數(shù)BIND_PARAM()的調(diào)用”
prepare()FALSE
<?php
error_reporting(E_ALL);ini_set('display_errors', 1);/var/log/apache2/error.logtail -f /path/to/log
$sql = "SELECT `foo` FROM `weird_words` WHERE `definition` = ?";$query = $mysqli->prepare($sql));
// assuming $mysqli is the connection$query->bind_param('s', $definition);$query->execute();prepare()
$sql = "SELECT `foo` FROM `weird_words` WHERE `definition` = ?";if($query = $mysqli->prepare($sql)) { // assuming $mysqli is the connection
$query->bind_param('s', $definition);
$query->execute();
// any additional code you need would go here.} else {
$error = $mysqli->errno . ' ' . $mysqli->error;
echo $error; // 1054 Unknown column 'foo' in 'field list'}foo
MYYA
TA貢獻(xiàn)1868條經(jīng)驗(yàn) 獲得超4個(gè)贊
prepareFALSETrue
$sql = 'SELECT value, param FROM ws_settings WHERE name = ?';if($query = $this->db->conn->prepare($sql)){
$query->bind_param('s', $setting);
$query->execute();
//rest of code here}else{
//error !! don't go further
var_dump($this->db->error);}添加回答
舉報(bào)
0/150
提交
取消