Using MySQLi to display results from query in PHP

Question

I am inputting data into MySQL tables using PHP forms and displaying the table when requested (this must be done using MySQLi).

I managed to insert the data without a problem, but I am having trouble displaying the table using MySQLi and PHP. I need to display the results in an XHTML table.

I tried to follow tutorials I found online, but they dont seem to work; my current code displays the header, and then a blank row beneath it instead of the data in my table.

I know it connect and like I said, it is able to insert. Could someone please show me (and explain please) how I would solve my issue?

                $query = "select * from $table_name;";
                if ($result = mysqli_query($db_link, $query)){

                    echo "<table>";
                    //header
                    echo "<tr><td>Date Added</td>";
                            echo "<td>Name</td>";
                            echo "<td>Email</td>";
                    echo "<td>Gender</td>";
                                echo "<td>Country</td>";
                    echo "<td>Subject</td>";
                            echo "<td>Comment</td>";
                    echo "<td>Subscription</td></tr>";
                        //data  
                         while ($row = $result->fetch_row())  {
                        $Row = mysqli_fetch_assoc($result);
                                echo "<tr><td>{$Row[0]}</td>";
                                echo "<td>{$Row[1]}</td>";
                                echo "<td>{$Row[2]}</td>";
                        echo "<td>{$Row[3]}</td>";
                                echo "<td>{$Row[4]}</td>";
                        echo "<td>{$Row[5]}</td>";
                                echo "<td>{$Row[6]}</td>";
                        echo "<td>{$Row[7]}</td></tr>";
                        } 

                        echo "</table>";
                }

                mysqli_free_result($result);
                mysqli_close($db_link);

What is the error you are getting??

Kedar B
– Kedar B

2015-03-02 04:47:54 +00:00
Commented Mar 2, 2015 at 4:47 — Kedar B
– Kedar B, Commented Mar 2, 2015 at 4:47
non thats the thing.

ShadowViper
– ShadowViper

2015-03-02 04:53:57 +00:00
Commented Mar 2, 2015 at 4:53 — ShadowViper
– ShadowViper, Commented Mar 2, 2015 at 4:53

Partha Mitra · Accepted Answer · 2015-03-02 04:43:29Z

1

Try mysqli_fetch_array()

            $query = "select * from $table_name;";
            if ($result = mysqli_query($db_link, $query)){

                echo "<table>";
                //header
                echo "<tr><td>Date Added</td>";
                        echo "<td>Name</td>";
                        echo "<td>Email</td>";
                echo "<td>Gender</td>";
                            echo "<td>Country</td>";
                echo "<td>Subject</td>";
                        echo "<td>Comment</td>";
                echo "<td>Subscription</td></tr>";
                    //data  
                     while ($row = mysqli_fetch_array($result))  {
                      echo "<tr><td>{$row[0]}</td>";
                      echo "<td>{$row[1]}</td>";
                      echo "<td>{$row[2]}</td>";
                      echo "<td>{$row[3]}</td>";
                      echo "<td>{$row[4]}</td>";
                      echo "<td>{$row[5]}</td>";
                      echo "<td>{$row[6]}</td>";
                      echo "<td>{$row[7]}</td></tr>";
                    } 

                    echo "</table>";
            }

            mysqli_free_result($result);
            mysqli_close($db_link);

answered Mar 2, 2015 at 4:43

Partha Mitra

1307 bronze badges

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

2 Comments

ShadowViper Over a year ago

Thank you that worked, but what is the different between mysqli_fetch_array and mysqli_fetch_assoc?

Partha Mitra Over a year ago

mysql_fetch_assoc This function will return a row as an associative array where the column names will be the keys storing corresponding value. mysql_fetch_array This function will actually return an array with both the contents of mysql_fetch_rowand mysql_fetch_assoc merged into one. It will both have numeric and string keys which will let you access your data in whatever way you'd find easiest.

Creaven · Accepted Answer · 2015-03-02 04:43:28Z

0

You have to escape you php

Echo "<td>".$row[6]."</td>";

http://www.w3schools.com/php/php_mysql_select.asp

answered Mar 2, 2015 at 4:43

Creaven

3192 silver badges16 bronze badges

2 Comments

ShadowViper Over a year ago

thats not the full code, i do escape php at the end.

Creaven Over a year ago

stackoverflow.com/questions/8347565/…

Sivasailanathan · Accepted Answer · 2015-03-02 04:54:32Z

0

Hope it works

    while($row = $result->fetch_assoc()) 
    {
            echo "<tr>";
            echo "<td>". $row["DateAdded"]."</td>";
            echo "<td>". $row["Name"]."</td>";
            echo "<td>".$row["Email"] ."</td>";
            echo "<td>".$row["Gender"] ."</td>";
            echo "<td>".$row["Country"] ."</td>";
            echo "<td>".$row["Subject"] ."</td>";
            echo "<td>".$row["Comment"] ."</td>";
            echo "<td>".$row["Subscription"] ."</td>";
            echo "</tr>";

    }

answered Mar 2, 2015 at 4:54

Sivasailanathan

1352 silver badges11 bronze badges

Collectives™ on Stack Overflow

Using MySQLi to display results from query in PHP

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related