Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // start MySQL connection
- $mysql_server = "*****";
- $mysql_user = "******";
- $mysql_pass = "*****";
- $mysql_db = "******";
- mysql_connect($mysql_server, $mysql_user, $mysql_pass);
- mysql_select_db($mysql_db);
- ?>
- <html>
- <head>
- <title>PHP-test</title>
- </head>
- <body>
- <?php
- // do query
- if (!isset($_GET["id"]))
- {
- echo("
- <h2>Proefwerkgegevens in de database</h2>
- <ol>");
- $res = mysql_query("SELECT `ll_id`, `Voornaam`, `Achternaam` FROM `Proefwerken`");
- while($row=mysql_fetch_array($res))
- {
- echo("<li><a href=\"?id=".$row['ll_id']."\">".htmlentities($row['Voornaam'])." ".htmlentities($row['Achternaam'])."</a></li>");
- }
- echo("</ol>");
- }
- else
- {
- $res = mysql_query("SELECT * FROM `Proefwerken` WHERE `ll_id`='".$_GET['id']."'");
- while($row=mysql_fetch_array($res))
- {
- echo("<h2>Detail-gegevens voor: ".htmlentities($row['Voornaam'])." ".htmlentities($row['Achternaam'])."</h2>
- leerling-id: <b>".htmlentities($row['ll_id'])."</b><br>
- naam: <b>".htmlentities($row['Voornaam'])." ".htmlentities($row['Achternaam'])."</b><br>
- cijfer: <b>".htmlentities($row['Cijfer'])."</b><br>
- <hr>
- <a href=\"?\">
- Terug naar het overzicht</a>");
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement