Javascript in While Loop PHP

Question

I have some code and when i click in the "+" button of the table it will display the ID of the row. But, the Javascript code only stores the last result from the DB.

<script type="text/javascript">

function fnFormatDetails ( oTable, nTr )
{
var aData = oTable.fnGetData( nTr );
var sOut = '<table cellpadding="5" cellspacing="0" border="0" style="padding-left:50px;">';
sOut += '<tr><td>Estado:</td><td><?php echo $row['ID'] ?></td></tr>';
sOut += '</table>';

return sOut;
}
</script>

<table>
<thead>
<tr>
<th>ID</th>
<th>Evento</th>
<th>Nome</th>
</tr>
</thead>
<tbody>

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

echo
"   <tr>
<td>{$row['ID']}</td>
<td>{$row['Evento']}</td>
<td>{$row['Nome']}</td>

</tr>\n";
}
?>
</tbody>
</table>

I'm kind of stuck in this... Thanks for any help.

there is a + button?

messerbill
– messerbill

2015-10-29 16:00:25 +00:00
Commented Oct 29, 2015 at 16:00 — messerbill
– messerbill, Commented Oct 29, 2015 at 16:00

DaveyBoy · Accepted Answer · 2015-10-29 16:16:44Z

2

PHP runs on the server before the resultant page is sent to the client's machine. Therefore, the only entry present in the JavaScript is the last one retrieved (the previous ones are overwritten). You have two ways to sort this out:

concatenate the entries to a string and insert that into your JavaScript code
use an AJAX call out to a PHP script to build the HTML that you want. This is then returned to the calling JavaScript which echos it to the screen

Personally, I follow method 2 nowadays as it's easier to remember. PHP on server being called by JavaScript on the client

edited Oct 29, 2015 at 16:16

answered Oct 29, 2015 at 16:03

DaveyBoy

2,9162 gold badges19 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Javascript in While Loop PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related