PHP:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| include("login.php"); $db = mysql_select_db ("mijn_database") or die("Kan geen database selecteren"); $query = "SELECT id,story FROM news"; $result = mysql_query($query) or die("Fout bij uitvoeren query"); // Printen resultaten in HTML print "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t<tr>\n"; foreach ($line as $col_value) { print "\t\t<td><a href=\"news.php?id=>$col_value</a></td>\n"; } print "\t</tr>\n"; } print "</table>\n"; // Resultaat-set vrij maken mysql_free_result($result); // Verbinding afsluiten mysql_close($link); |