Mysql和php用/ html数据库问题

问题描述：

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

</div>

答

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>

Mysql和php用/ html数据库问题

相关推荐