CODEWITHSUNDEEP
phphtmlmysql
Kate
Kate

Reputation: 57

Print all table data from mysql into a html table

I've been trying to print all users into a html table. The objective is that the site administrator can edit the information. I've done the following code so far, but I can't understand how I will print User1_Name, User1_Email and password into a table row. I want this for every user on the database.

<body>
    <div class="edituser"> 
      <h1> Edit Users </h1>

      <table>
          <tr>
              <th>User Name</th>
              <th>Email</th>
              <th>Password</th>

          </tr>
   <?php include("include/headerhomeadmin.php");?>


        <?php while($row = mysqli_fetch_assoc($result)) {
        /*$line[]=$row;*/  

        echo 

        $userusername =$row['username'];
        $useremail =$row['email'];
        $userpassword=$row['password'];

        ?>
      <td><?php echo implode(" ", $line)?></td> 

        <?php } ?>

        </table>       

    </div>

Can someone help me?

UPDATE: My code is now printing the first username, the email from the second user and the password from de third user. The code is the following:

<body>
<div class="edituser"> 
  <h1> Editar Utilizadores </h1>

  <table>
      <tr>
          <th>Nome de Utilizador</th>
          <th>Email</th>
          <th>Password</th>

      </tr>

      <tr>     

    <?php while($row =  mysqli_fetch_assoc($result)) { 

            $userusername =$row['username'];
    ?>

          <td> <?php echo $userusername ?>  </td>

      <?php while($row =  mysqli_fetch_assoc($result)) { 

            $useremail =$row['email'];

    ?>

          <td> <?php echo $useremail ?>  </td>

      <?php while($row =  mysqli_fetch_assoc($result)) { 

            $userpassword=$row['password'];

    ?>
          <td> <?php echo $userpassword ?>  </td>


    <?php }
    }

}?>

How can I fix this?

Upvotes: 0

Views: 315

Answers (1)

Reza
Reza

Reputation: 328

if ($result->num_rows > 0) {?>
<table border=1>
  <tr>
      <th>Name</th>
      <th>Email</th>
      <th>Password</th>

  </tr>
 <?php while($row =  mysqli_fetch_assoc($result)) { ?> 

   <tr> 
          <td><?php echo $row['username']; ?></td>
          <td><?php echo $row['email']; ?></td>
          <td><?php echo $row['password']; ?></td>

   </tr>

 <?php }?>
 </table>
 <?php
 }

 else{
 echo "0 results";
 }
 ?>

Upvotes: 5

Related Questions