Adding elements from a MYSQL query to a HTML Table using PHP

Question

I want to output results from a MYSQL query into a HTML table using PHP. I am very new to this field and I read all the related questions but cant figure it out. I am sure the error is just a minor one.

Here is my PHP

$mysqli = new mysqli($db);

if($mysqli -> connect_error)
{
    die("Connect Error (".$mysqli -> connect_errno.") ".$mysqli -> connect_error);
}

$result = $mysqli->query("SELECT * FROM 'Users'");

$row = mysqli_fetch_row($result);

$mysqli->close();

And here is the snippet of the HTML table

<tr>
    <td><?php echo "$row[1]"; ?></td>
    <td>9</td>
    <td>48</td>
</tr>

Oh, well, its not appearing on the webpage. So, the echo statement is not working. I dont know how. — pestopasta
– pestopasta, Commented Mar 5, 2017 at 13:30

morteza kavakebi · Accepted Answer · 2017-03-03 19:17:13Z

1

you shouldn't put table name in quotes.

$result = $mysqli->query("SELECT * FROM Users");
echo '<table>';
while($row = mysqli_fetch_assoc($result)){
    echo '<tr>';
    // assuming table(User) have fields like id,name
    echo '<td>'.$row['id'].'</td>'; 
    echo '<td>'.$row['name'].'</td>'; //name is column name
    echo '</tr>';
  }
  echo '</table>';
  $mysqli->close();

edited Mar 3, 2017 at 19:17

morteza kavakebi

1,6803 gold badges19 silver badges40 bronze badges

answered Mar 3, 2017 at 19:01

Bhaskar Jain

1,6811 gold badge12 silver badges21 bronze badges

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

1 Comment

Anthony Rutledge Over a year ago

For a more flexible and robust answer, look here. stackoverflow.com/questions/42471993/…

Collectives™ on Stack Overflow

Adding elements from a MYSQL query to a HTML Table using PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related