This is an old revision of the document!
<html>
<script src="https://code.jquery.com/jquery-2.2.0.min.js"></script>
<div id='liclass'>
</div>
<?php
require('db.php');
$dbh = get_db();
$person_list =
$dbh->query('select fullname, birthdate, country_code from person')
->fetch_all(MYSQLI_ASSOC);
// echo format_html_table($person_list, 'persontable');
?>
/*
<!-- uebergabe der Daten mittels einer "umwandlung" von php in JavaScript
auf diese art eher unueblich
-->
<script>
var person_list = <?php echo json_encode($person_list); ?>;
$(document).ready(function() {
$.each( person_list, function( key, person ) {
$('#liclass').append("<li>"+ person['fullname'] +"</li" );
});
} );
</script>
*/
// direkte Formatierung der Daten mit php in html
<div id="person_list">
<?php
foreach ($person_list as $person) {
printf ("<li> %s, %s, %s </li>\n",
$person['fullname'],
$person['birthdate'],
$person['country_code']
);
}
?>
</div>
<html>