Show data from the mysql database on a php / html page

Question

Show data from the mysql database on a php / html page

Navigation

#1 by (1 votes)

0

I have a problem while displaying data from a database table on the screen.

I was able to show the data but I can not skip the line, show the data sequentially, code below.

    $sql = $connection->query("Select * from  usuarios");
            if($sql)
           {
                while($exibe = $sql->fetch_assoc())
                    {
                        foreach($exibe as $key => $value)
                            {
                                echo "<td>". $value."</td>";
                            }
                    }
            }

php mysql html css

asked by anonymous 13.09.2018 / 21:17

1 answer

Assign NAV command on buttons - Owl.Carousel Validate fields from a select by jquery

score 1 · Accepted Answer

Try the following:

$sql = $connection->query("Select * from  usuarios");
        if($sql)
       {
            while($exibe = $sql->fetch_assoc())
                {
                    echo "<tr>"
                    foreach($exibe as $key => $value)
                        {
                            echo "<td>". $value."</td>";
                        }
                     echo "</tr>"
                }
        }