123456/ajax/includes/boekinfoza.php

<?php if($boeknr){ $query = "select b.boeknr, a.achternaam, a.voorletters, titel, pub_jaar, aantalpags, genre, rubriek from boeken b, auteurs a where b.auteurnr = a.auteurnr and b.boeknr=$boeknr"; $result = mysqli_query($db_link, $query) or die(mysqli_error($db_link)); $row = mysqli_fetch_array($result); $prijs = number_format(round($row['aantalpags']/10,2),2); echo "<div><span class='label'>Auteur :</span><span class='info'>$row[achternaam], $row[voorletters]</span></div>\n"; echo "<div><span class='label'>Titel :</span><span class='info'>$row[titel]</span></div>\n"; echo "<div><span class='label'>Jaar :</span><span class='info'>$row[pub_jaar]</span></div>\n"; echo "<div><span class='label'>Pagina's :</span><span class='info'>$row[aantalpags]</span></div>\n"; echo "<div><span class='label'>Genre :</span><span class='info'>$row[genre]</span></div>\n"; echo "<div><span class='label'>Rubriek :</span><span class='info'>$row[rubriek]</span></div>\n"; echo "<div><span class='label'>Prijs :</span><span class='info'>&euro; $prijs</span></div>\n"; echo "<p><span class='label'>&nbsp;</span><span class='info'><input type='submit' value='Bestelllen' onclick=\"bestel($boeknr, $prijs)\"></span></p>"; } else{ //echo "Kies eerst een boek\n"; } ?>

Resultaat

Made by Thijs Aarnoudse