Mefiu Mefiu - 3 months ago 8
HTML Question

Mysql and php w/ html database issue

I want to get data from my sql database into a table with html.

I have writed 1st part of code ended with

?>


and started with html table and end with html

My code getting only Empty table without getting data from my Database, here the Code, i dont know how to get data with that

<td>
<?php echo $result['nazwiskoimie'] ?>
</td>


Here's the full code :



<?php
$con=mysqli_connect("localhost","root","","listap");

if (mysqli_connect_errno()) {
echo "Blad przy polaczeniu z baza: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM 'lista'");
?>

<html>

<table border='1'>
<tr>
</tr>
<tr>
<td> <?php echo $result['nazwiskoimie'] ?> </td>
//in this part have problem to get my data from database
</html>





Here's also a screenshot of a result: Final After a Save my file

Ish Ish
Answer

Please try this:

$result = mysqli_query($con,"SELECT * FROM lista");;
?>
<html> 

<table border='1'>

<?php

if (mysqli_num_rows($result) > 0) {
// output data of each row
 while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
   <td><?php echo $row['nazwiskoimie']?></td>
</tr>
 <?php
 }
} ?>
</table>
</html>
Comments