Export from MYSQL to HTML

Question

I am new to MYSQL and i am trying to export my database to html, and put the data into specific html tables. I have looked around the site, but i cant get my code to work, can someone help me, and tell me if this code looks right ?

<?php

    $con=mysqli_connect("xxx","xxx","xxx","xxx","xxx");
    // Check connection
    if (mysqli_connect_errno())
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $result = mysqli_query($con,"SELECT * FROM xxx");

    while($row = mysqli_fetch_array($result)) 
    {
        <tr>
            <th bgcolor="#3281c6">" . $row["PO_nummer"]. "</th>
            <th bgcolor="#3281c6">" . $row["Varenummer"]. "</th>
            <th bgcolor="#3281c6">" . $row["Produkt_beskrivelse_"]. "</th>
            <th bgcolor="#3281c6">" . $row["Antal"]. "</th>
    }

    mysqli_close($con);
?>

what is the issue (exception/incorrect UI rendering etc), highlighting will not force people here to assume your problems. — Anil
– Anil, Commented Mar 8, 2017 at 6:54
duplicate question: stackoverflow.com/questions/17902483/… — Abdul Rafay
– Abdul Rafay, Commented Mar 8, 2017 at 6:55
It's a good start to write youre html and php with quotes, or outside <?php tags. Check on how to do that: stackoverflow.com/questions/18140270/… — Finduilas
– Finduilas, Commented Mar 8, 2017 at 7:15

a_at_cyber_dot_training · Accepted Answer · 2017-03-08 06:56:04Z

0

You seem to be expecting an associative array and not a regular (numbered) array, in this case try:

while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) { // code }

answered Mar 8, 2017 at 6:56

a_at_cyber_dot_training

4422 silver badges9 bronze badges

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

Comments

Web Dev Guy · Accepted Answer · 2017-03-08 06:58:13Z

0

Try and echo or print the html

echo "
<th bgcolor="#3281c6">" . $row["PO_nummer"]. "             </th>
<th bgcolor="#3281c6">" . $row["Varenummer"]. "</th>
<th bgcolor="#3281c6">" . $row["Produkt_beskrivelse_"]. "</th>
<th bgcolor="#3281c6">" . $row["Antal"]. "</th>";

And use single quotes here bgcolor='#3281c6'

answered Mar 8, 2017 at 6:58

Web Dev Guy

1,8393 gold badges25 silver badges50 bronze badges

Collectives™ on Stack Overflow

Export from MYSQL to HTML

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related