How i can fetch data from database by using mysqli_fetch_assoc?

Question

I want to fetch this result from the database that i've already created and has value i've added. After researching some old codes (1 yr ago) and searching at stackoverflow. I'm using this source: how to fetch all the row of the result in php mysql?

I tried with same writing code, and the results never shown. Already tried to troubleshoot by: - Checking it's number of row by using mysqli_num_rows and find 2 rows and that is correct. - Reverse if from ($count > 0) to ($count < 0), and it seems no logical problem

    <?php

    $query_call = "SELECT * FROM ass";
    $result = mysqli_query($conn, $query_call) or die(mysqli_error($conn));
    $count = mysqli_num_rows($result);
    if (mysqli_num_rows($result))
    {
        while ($row = mysqli_fetch_assoc($result));
        {
            //echo "Double";

            echo $row['stand'];


        }
    }
    else
    {
        echo "<tr><td colspan='7'>Data Did not found</td></tr>";
    }


    ?>

The result i want is as same as the value that stored at database.

i think its a typo.remove the ; in the while loop.Do like this while ($row = mysqli_fetch_assoc($result)){ //do stuff } — prasanth
– prasanth, Commented Apr 29, 2019 at 6:07
thanks for the correction, my bad i wasn't notice that semicolon. — Natsume Shido
– Natsume Shido, Commented Apr 29, 2019 at 6:13

Rahul · Accepted Answer · 2019-04-29 06:01:33Z

1

Map your code like this,

$mysqli = new mysqli("localhost", "my_user", "my_password", "db_name");
$query_call = "SELECT * FROM ass";
if ($result = $mysqli->query($query_call)) {
    /* fetch associative array */
    while ($row = $result->fetch_assoc()) {
        printf ("%s\n", $row["stand"]);
    }
    /* free result set */
    $result->free();
} else {
    echo "<tr><td colspan='7'>Data Did not found</td></tr>";
}

It should work.

I mapped your snippet with official documentation.

answered Apr 29, 2019 at 6:01

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

How i can fetch data from database by using mysqli_fetch_assoc?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related