php datatable array results

Question

I am trying to extract data from mysql database into a datatable using ajax, and php.

The code for my response.php file is below:

<?php
$result = mysql_query("select * from orders");
while ($row = mysql_fetch_array($result)) {
    $data = array(
        array(
            'Name' => $row['jobnumber'],
            'Empid' => $row['ID'],
            'Salary' => $row['product']
        )
    );
}

$results = array(
    "sEcho" => 1,
    "iTotalRecords" => count($data),
    "iTotalDisplayRecords" => count($data),
    "aaData" => $data
);
/*while($row = $result->fetch_array(MYSQLI_ASSOC)){
$results["data"][] = $row ;
}*/

echo json_encode($results);

?>

Why is this only returning one result in my front end table?

http://orca.awaluminium.com/test.php

link above shows table.

Alok Patel · Accepted Answer · 2016-06-10 08:28:12Z

2

You're replacing value of $data instead of pushing new rows in an array.

Change the following line.

$data = array(
              array(
                    'Name'=>$row['jobnumber'],
                    'Empid'=>$row['ID'], 'Salary'=>$row['product']
              )
);

To

$data[] = array(
             'Name'=>$row['jobnumber'],
             'Empid'=>$row['ID'], 'Salary'=>$row['product'] 
);

Also put $data=array(); before string while() looop.

answered Jun 10, 2016 at 8:28

Alok Patel

8,0726 gold badges35 silver badges48 bronze badges

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

Comments

Amit Ray · Accepted Answer · 2016-06-10 08:28:12Z

1

You have to do foreach

while ($row = mysql_fetch_array($result)){

foreach($row as $a)
                                    {$data[] = array(
                        array('Name'=>$a['jobnumber'],     'Empid'=>$a['ID'], 'Salary'=>$a['product']),                            
                                                    );
                                    }
}

answered Jun 10, 2016 at 8:28

Amit Ray

3,4753 gold badges23 silver badges38 bronze badges

4 Comments

V5Nathan Over a year ago

I have changed it to this, and it seems to be working but not 100%.

V5Nathan Over a year ago

it is dragging through the correct amount of rows, it just isn't populating the table with data.

Amit Ray Over a year ago

How are you displaying the data? Paste test.php full code in pastebin.com

V5Nathan Over a year ago

Sorry for the delayed response, pastebin link is as follows: pastebin.com/4Zw3LJHg

Collectives™ on Stack Overflow

php datatable array results

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related