PHP mysqli_fetch_assoc working on localhost but not on godaddy server

Asked Apr 11 '19 at 19:44

Active Apr 11 '19 at 19:45

Viewed 41 times

I have this code that works on my localhost but not on godaddy server

$sql = 'SELECT hash FROM user_for_activation where registeredDate = ?;';
$stmt = mysqli_stmt_init($conn);

if(!mysqli_stmt_prepare($stmt,$sql)){
    echo "SQL Connection Failed";
}
else{
    mysqli_stmt_bind_param($stmt,"s",$dateRegistered);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);

    while($row = mysqli_fetch_assoc($result)){
        $hash = $row['hash'];
    }

}

I am getting an error on line mysqli_fetch_assoc($result) but this works on my localhost. Is this a compatibility issue?

edited Apr 11 '19 at 19:45

u_mulder

53,091
5
44
59

asked Apr 11 '19 at 19:44

Vian Ojeda Garcia

1

Error text says what? – u_mulder Apr 11 '19 at 19:44
@u_mulder statusText says 'Internal Server Error' – Vian Ojeda Garcia Apr 11 '19 at 19:57
You might not have mysqlnd. The function mysqli_stmt_get_result is available only with mysqlnd. – Dharman Apr 11 '19 at 19:57
1

Then read error logs and clarify error. Noone can guess it. – u_mulder Apr 11 '19 at 19:58
it says `Call to undefined function mysqli_stmt_get_result()` – Vian Ojeda Garcia Apr 11 '19 at 19:59
1

Possible duplicate of [Call to undefined method mysqli\_stmt::get\_result](https://stackoverflow.com/questions/8321096/call-to-undefined-method-mysqli-stmtget-result) – miken32 Apr 11 '19 at 20:03
@Dharman upon checking mysqlnd is enabled – Vian Ojeda Garcia Apr 11 '19 at 20:18
How did you check that? Did you see it in the result of `phpinfo`? – Dharman Apr 11 '19 at 20:23
@Dharman yes I checked inside the control panel. I tried disabling mysqli but still throw some errors – Vian Ojeda Garcia Apr 11 '19 at 21:32

PHP mysqli_fetch_assoc working on localhost but not on godaddy server

0 Answers0