Query doesn't work on my Raspberry Pi 2B

Question

I'm trying to get my raspberry working like a webserver.

It all works, except the queries of my mysql database. The values are correct, the query is correct and my database works fine.

But when I want to get information from my database with PHP it gives an empty result.

The code:

<?php

$dbCon = new mysqli($servername, $username, $password, $database);

$Query = "SELECT * FROM `machineuptime`";

if($stmt = $dbCon->prepare($Query))
{
    $stmt->execute();

    $result = $stmt->get_result();

    while($row = $result->fetch_assoc())
    {
        $ArrayData2[] = $row;
    }
}

echo "this is de first row of the array: " . $ArrayData2[0]['ID'] . ". Thats nice!";
?>

the result:

this is de first row of the array: . Thats nice!

Even when I use the query in phpmyadmin, it gives the values back, so the Query isn't wrong.

So how can I solve this issue?

Edit:

The error that I get is.

Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/html/Stramit/index.php on line 59

try enabling error reporting add this: `error_reporting(E_ALL); ini_set('display_errors', -1);` to the top of the php part — BRoebie, Jan 22 '16 at 08:38
you didn't end your query with " - is that a typo, or actually in the source? — Franz Gleichmann, Jan 22 '16 at 08:42
> Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/html/Stramit/index.php on line 59 is the error what I get now..... — Bart88, Jan 22 '16 at 08:42
look at [this answer](http://stackoverflow.com/a/8343970/5396496) — BRoebie, Jan 22 '16 at 08:44

score 0 · Accepted Answer · edited May 23 '17 at 11:44

0

you don't close the query at:

$Query = "SELECT * FROM `machineuptime`;

change it to:

$Query = "SELECT * FROM `machineuptime`";

also for the error

Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/html/Stramit/index.php on line 59

look at this answer.

Look at the user notes for http://php.net/manual/en/mysqli-stmt.get-result.php

It requires mysqlnd driver.Make sure you have that driver installed. If you do not have them installed use BIND_RESULT & FETCH

uncommented the extension=php_mysqli_mysqlnd.dll in php.ini; and restarted Apache2.2 and MySQL services. says it in the comment of the answer.

Here is the link to the driver: http://php.net/manual/en/book.mysqlnd.php

after you have installed it you should be able to use $stmt->get_result(); ofcourse reboot your raspberry pi.

Note: your php version must be above php 5.3.0

edited May 23 '17 at 11:44

Community

1
1

answered Jan 22 '16 at 08:47

BRoebie

374
3
13

it isn't fetch_assoc it is get_result and I will add the links for it. – BRoebie Jan 22 '16 at 08:51
Ye I found a how to install the mysqlnd driver in here: http://blog.ahughes.org/?p=602. It works now. Thanks for the help – Bart88 Jan 22 '16 at 09:15
Good, no problem mate. Always glad to help:D – BRoebie Jan 22 '16 at 09:20

Query doesn't work on my Raspberry Pi 2B

1 Answers1