How to display MySQL table using php and edit it in a web browser

Question

i am using a while loop to display all the data in my MYSQL table. the problem is that its not showing the newest entry. after adding a record it does not show the record in my browser, but it would have been added in the database. it will show after i add another one. i have attached pictures.

Here is my code

  <table id="t02" width="100%" border="1px">
                    <tr>
                        <th>Ec Number</th> 
                        <th>Username</th>
                        <th>Email</th>
                        <th>Phone Number</th>
                        <th>Department</th>
                    </tr>
            <?php 

            $sql = "SELECT * FROM lecturer";

            $result = $conn->query($sql);

            $row = $result->fetch_assoc();

            while ($row = $result->fetch_assoc()){
                echo "<tr>";

                echo "<td>".$row['ecnumber']."</td>";
                echo "<td>".$row['username']."</td>";
                echo "<td>".$row['email']."</td>";
                echo "<td>".$row['phonenumb']."</td>";
                echo "<td>".$row['dept']."</td>";

                echo "</tr>";
            }

            ?>


                </table>

user3783243 · Accepted Answer · 2018-08-06 20:44:49Z

4

$row = $result->fetch_assoc();
while ($row = $result->fetch_assoc()){

Advances you to the second row everytime. Remove the first fetch call. Everytime you fetch you advance one row. So for example:

$row = $result->fetch_assoc();
$row = $result->fetch_assoc();
$row = $result->fetch_assoc();
print_r($row);

would print the third row.

answered Aug 6, 2018 at 20:44

user3783243

5,2125 gold badges27 silver badges45 bronze badges

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

4 Comments

Rayobeats Over a year ago

how do i do that i am new on stack overflow

user3783243 Over a year ago

There should be a check mark next to the vote mark, here's a link that shows details meta.stackexchange.com/questions/5234/…

Rayobeats Over a year ago

i just did Thanks

Rayobeats Over a year ago

how do i delete or edit directly that record without going to the phpmyadmin database?

Collectives™ on Stack Overflow

How to display MySQL table using php and edit it in a web browser

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related