call_user_func_array not working on php 5.6

Question

I recently tried using an old code I wrote for PHP 5.3 on a project that's running on a server that runs PHP 5.6. Though my code runs on my local machine (windows - PHP 5.3), it shows the error below when i try to use on my online host:

Warning: call_user_func_array() expects parameter 1 to be a valid callback, first array member is not a valid class name or object in /home/lj7mxu21cx3y/public_html/crud/datamodel.php on line 54

Fatal error: Call to a member function execute() on boolean in /home/lj7mxu21cx3y/public_html/crud/datamodel.php on line 55

this is my code below:

function useRecord($mysqli,$query_string="",$type="",$vars=[]){

$query = $mysqli->prepare($query_string);
// create an empty array
$parameters = array();
// push the type string into the array by reference
$parameters[] = & $type;
// push the items from $vars array into the array by reference
for ($i = 0; $i < count($vars); $i++) {
    $parameters[] = & $vars[$i];
}

// call mysqli_stmt::bind_param with the $parameters array, which contains [type, var1, var2, ...]
call_user_func_array(array($query, "bind_param"), $parameters);
$query->execute();
$result = null;
preg_match("/^[A-Z]+/", $query_string, $command);
switch ($command[0]) {
    case "SELECT":
        $result = $query->get_result();
        break;
    case "INSERT":
    case "UPDATE":
    case "DELETE":
        $result = $query->affected_rows;
        break;
}
$query->close();
return $result;



 }

i am using the mysql native driver for php -- mysqlnd on my WebHost (Godaddy). EDIT:: Also, this function is used within a namespaced class

sorry for late response, the question was a little slow to get responses. $query returns a valid statement object, or at least much like this object(mysqli_stmt)#3 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(1) ["field_count"]=> int(0) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(1) } object(mysqli_stmt)#3 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(1) ["field_count"]=> int(4) ["errno"]=> int(0) — Ndy daniel
– Ndy daniel, Commented Dec 5, 2019 at 21:55

Álvaro González · Accepted Answer · 2019-12-06 09:25:06Z

4

If $query is not an object you need to scroll up to its definition:

$query = $mysqli->prepare($query_string);

Checking documentation we can see the function can return two data types (emphasis mine):

mysqli_prepare() returns a statement object or FALSE if an error occurred.

Your code doesn't handle error conditions. You need to at least detect them:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

A shorter test case (demo):

call_user_func_array(array(false, 'whatever'), array());

edited Dec 6, 2019 at 9:25

answered Dec 5, 2019 at 18:41

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ndy daniel Over a year ago

$query returns a valid statement object

Álvaro González Over a year ago

@Ndydaniel If that's the case, are you positively sure the code you've shared is exactly the code that exhibits the issue? Is there a chance you're calling the function more than once and only some calls fail? Can you edit the question and show the exact method you've used to determine that $query is a valid statement object?

Ndy daniel Over a year ago

failure to use this mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); cause the error message to be rather ambiguous. it help me locate a wayward column that wasn't defined on my db. thanks a lot

Collectives™ on Stack Overflow

call_user_func_array not working on php 5.6

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related