我有这个脚本试图将数组放入mysqli_stmt_bind_param,我用谷歌搜索并找到了这个解决方案,但是,代码似乎无法正常工作。我没有收到来自数据库的结果和警告。
Warning: call_user_func_array() expects parameter 1 to be a valid callback, first array member is not a valid class name or object
这是我的代码:-
$sql_param = array();
$params = array();
$query = "SELECT campname,url,views,leads,subs,country,affid FROM camp WHERE";
if (isset($_POST['fromdatetime']) && isset($_POST['todatetime'])) {
$datefrom = $_POST['fromdatetime'].":00";
$dateto = $_POST['todatetime'].":59";
$sql_param[] = $datefrom;
$sql_param[] = $dateto;
$bindparam = "ss";
$query .= "datevisit between (?) AND (?)";
}
if (isset($_POST['affidcode'])) {
$affidcode = $_POST['affidcode'];
$sql_param[] = $affidcode;
$bindparam .= "s";
$query .= " AND affid = (?)";
}
$sql_param_count = count($sql_param);
$params[] = &$bindparam;
for($i = 0; $i < $sql_param_count; $i++) {
$params[] = &$sql_param[$i];
}
/* create a prepared statement */
$stmt = mysqli_prepare($mysqli, $query);
call_user_func_array(array($stmt, 'mysqli_stmt_bind_param'), $params);
/* execute query */
$status = mysqli_stmt_execute($stmt);
确保$stmt
在此块之后mysqli_stmt
对象(不是false
)有效:
/* create a prepared statement */
$stmt = mysqli_prepare($mysqli, $query);
然后试试这个:
array_unshift($params, $stmt);
call_user_func_array('mysqli_stmt_bind_param', $params);