Why is this php and MySQL not displaying results

Question

I am currently trying to connect to a database and display the first names of all the students in the table "STUDENTS". I seem to be connecting fine, as my ping() seems to go through fine. I am not receiving an error message of any sort, but my query/displaying the results seems to not be working. Can anyone help me to solve this issue?

  <?php
    $user = 'root';
    $password = 'root';
    $db = 'gradebook';
    $host = 'localhost';
    $port = 8889;

    $link = mysqli_init();
    $connection = mysqli_real_connect($link, $host, $user, $password, $db, $port)
        or die("Cannot connect to database server.");

    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }

    /* check if server is alive */
    if (mysqli_ping($link)) {
        printf ("Our connection is ok!\n </br>");
    } else {
        printf ("Error: %s\n", mysqli_error($link));
    }

    $query = "SELECT * FROM STUDENTS";

    $statement = $connection->prepare($query);
    $statement->execute();
    $statement->bind_result($First_name);
    while ($statement->fetch()) {
        print $First_name . '</br>';
    }

    mysqli_close($link);

    ?>

There's no mysqli_fetch funciton. It's fetch().

u_mulder
– u_mulder

2015-12-09 18:16:28 +00:00
Commented Dec 9, 2015 at 18:16 — u_mulder
– u_mulder, Commented Dec 9, 2015 at 18:16
Even when using fetch() it does not work..

Pseudo Sudo
– Pseudo Sudo

2015-12-09 18:22:16 +00:00
Commented Dec 9, 2015 at 18:22 — Pseudo Sudo
– Pseudo Sudo, Commented Dec 9, 2015 at 18:22
Do you see Our connection is ok!?

u_mulder
– u_mulder

2015-12-09 18:25:05 +00:00
Commented Dec 9, 2015 at 18:25 — u_mulder
– u_mulder, Commented Dec 9, 2015 at 18:25
Yes, that appears but nothing else

Pseudo Sudo
– Pseudo Sudo

2015-12-09 20:00:15 +00:00
Commented Dec 9, 2015 at 20:00 — Pseudo Sudo
– Pseudo Sudo, Commented Dec 9, 2015 at 20:00

u_mulder · Accepted Answer · 2015-12-09 18:31:02Z

2

Please, start with turning on error reporting.

Then - read mysqli-manuals carefully.

$link = mysqli_init(); returns object. mysqli_real_connect returns bool.

And you're trying to execute prepare method on bool variable:

$statement = $connection->prepare($query);

Surely it doesn't work. And if you had error reporting on - you would see a relevant error message. So, assuming everything else is fine:

$statement = $link->prepare($query);  // NOT $connection
$statement->execute();
$statement->bind_result($First_name);
while ($statement->fetch()) {
    print $First_name . '</br>';
}

answered Dec 9, 2015 at 18:31

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Why is this php and MySQL not displaying results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related