How can i display MYSQL Data using DataTables using While Loop

Question

How can i display Data from MYSQL table using DataTables I tried but Top part shown me

Bottom Shows Records from MYSQL table.

I want DataTables to read Mysql data display as shown in the picture below

//bottstrap html code

<div class="panel-body">
            <div class="dataTable_wrapper">
                <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                       <thead>
                          <tr>
                            <th>Brand Name</th>
                             <th>Size</th>
                          </tr>
                         </thead>

// php

       $record = mysqli_query($con,"SELECT * FROM ts127 ORDER BY Manufacturer");
    while ($row = mysqli_fetch_array($record)) {

       if()
         {
         }
       elseif ($row['field1']==$XXX) 
{   
     echo'<table style="table-layout:fixed;" class="table table-striped table-bordered table-hover" id="dataTables-example">';
     // When i remove the above table code works fine for the first record or first row but other listed as a normal text
                echo "<tr'>";                 
                  echo "<td style=' width:150px;  text-align:left; padding: 10px;vertical-align: middle;'>";echo $row['Brand_Name'];echo"</td>";
                  echo "<td style='width:110px;  text-align:left; vertical-align: middle;'>";echo $row['Size'];"</td>";
                       ....

    echo '<tr/></tbody></table>';
 }

//JS Code

  <script>
$(document).ready(function() {
    $('#dataTables-example').DataTable({
            responsive: true
    });
});
</script>

@FahedAlkaabi i added it to the question or you want to see the content of jquery.dataTables.min.js — user5225773
– user5225773, Commented Dec 6, 2015 at 5:51
If I'm not mistaken, You doing a lot of things of PHP and the code is not completed. So I can't judge you PHP code. - Js code and html nothing wrong with it - On you browser check the console on the developing tools (Google Chrome F12) and see if there is any errors — Fahed Alkaabi
– Fahed Alkaabi, Commented Dec 6, 2015 at 5:55
Your PHP code is not clear, what is this $XXX, or $YYY or the reset values in if condition. Also in while loop you should repeat the tr tag not table tag — Gouda Elalfy
– Gouda Elalfy, Commented Dec 6, 2015 at 5:57
@GoudaElalfy Yes When i remove this line echo'<table style="table-layout:fixed;" class="table table-striped table-bordered table-hover" id="dataTables-example">'; it works but for the first row only — user5225773
– user5225773, Commented Dec 6, 2015 at 6:06

Fahed Alkaabi · Accepted Answer · 2015-12-06 06:28:42Z

1

You mistake was looping the table and tbody, you should be more careful about opening and closing the HTML tags

<?php
$record = mysqli_query($con,"SELECT * FROM ts127 ORDER BY Manufacturer");
echo'<table style="table-layout:fixed;" class="table table-striped table-bordered table-hover" id="dataTables-example">';
    echo '<thead>';
        echo '<tr>';
            echo '<th>Brand Name</th>';
            echo '<th>Size/th>';
        echo '</tr>';
    echo '</thead>';
    echo '<tbody>';
    while ($row = mysqli_fetch_array($record)) {
        if (($row['field1']==$XXX || $row['field1']==$YYY ) && ($row['field2']>=$field1sw && $row['field1']<=$largesw) && ($txtbrand != "" && $size1=="" && $row['field2'] != "" && $row['Brand_Name']!="") ) 
        {   
            echo "<tr'>";                 
                echo "<td style=' width:150px;  text-align:left; padding: 10px;vertical-align: middle;'>";echo $row['Brand_Name'];echo"</td>";
                echo "<td style='width:110px;  text-align:left; vertical-align: middle;'>";echo $row['Size'];"</td>";
                   ....
            echo '</tr>';
        }
    }
    echo '</tbody>';
echo '</table>';
?>

if NOT, I would recommend you to use server-side DataTable

edited Dec 6, 2015 at 6:28

answered Dec 6, 2015 at 6:06

Fahed Alkaabi

2692 silver badges10 bronze badges

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

5 Comments

user5225773 Over a year ago

That Works only for the first record.

Fahed Alkaabi Over a year ago

So you need to double check on your if statement

Fahed Alkaabi Over a year ago

I forget to add Thead, have a look please

user5225773 Over a year ago

But the Sort icon on the heading and Paginations are gone

Fahed Alkaabi Over a year ago

stackoverflow.com/a/26564457/5154084 here is the answer, try to check if sorting icons is exist also if requested well

Gouda Elalfy · Accepted Answer · 2015-12-06 06:10:31Z

0

Update this

echo '<tr/></tbody></table>';

To be

echo '</tr>';

Then close the tbody, and table tag outside while loop

edited Dec 6, 2015 at 6:10

answered Dec 6, 2015 at 6:06

Gouda Elalfy

7,0833 gold badges28 silver badges38 bronze badges

1 Comment

Fahed Alkaabi Over a year ago

Do you mean echo '</tr>';

Collectives™ on Stack Overflow

How can i display MYSQL Data using DataTables using While Loop

2 Answers 2

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related