php - 警告 : call_user_func_array() expects parameter 1 to be a valid callback mysqli

Question

我有这个脚本试图将数组放入 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);

Answer 1

确保 $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);