fetch_row en fetch_assoc samenvoegen
Code (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
26
27
28
29
30
31
32
33
34
35
36
37
38
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
function strip($text){
if (strlen($text) > 100)
{
print substr(stripslashes($text), 0,100). "...";
}
else
{
print stripslashes($text);
}
}
strip($text);
$db = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $db)
or die ("FOUT: openen database mislukt");
$sql = "SELECT kop, UNIX_TIMESTAMP(datum) FROM nieuws ORDER BY datum DESC LIMIT 10;";
$resultaat = mysql_query($sql);
$dagen = array("zo", "ma", "di", "wo", "do",
"vr", "za");
$maanden = array("", "jan", "feb", "maart", "apr", "mei", "juni",
"juli", "aug", "sep", "okt", "nov", "dec");
$space = " ";
$result = mysql_query("SELECT id, artikel FROM nieuws", $db);
while ($row = mysql_fetch_assoc($result))
{
echo strip($row["artikel"]) . "<br>";
}
while (list($kop, $datum) = mysql_fetch_row($resultaat)){
echo $dagen[date("w",$datum)], $space, date("j",$datum), $space,
$maanden[date("n",$datum)], $space, ": ", $kop, "<br>\n";
}
?>
function strip($text){
if (strlen($text) > 100)
{
print substr(stripslashes($text), 0,100). "...";
}
else
{
print stripslashes($text);
}
}
strip($text);
$db = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $db)
or die ("FOUT: openen database mislukt");
$sql = "SELECT kop, UNIX_TIMESTAMP(datum) FROM nieuws ORDER BY datum DESC LIMIT 10;";
$resultaat = mysql_query($sql);
$dagen = array("zo", "ma", "di", "wo", "do",
"vr", "za");
$maanden = array("", "jan", "feb", "maart", "apr", "mei", "juni",
"juli", "aug", "sep", "okt", "nov", "dec");
$space = " ";
$result = mysql_query("SELECT id, artikel FROM nieuws", $db);
while ($row = mysql_fetch_assoc($result))
{
echo strip($row["artikel"]) . "<br>";
}
while (list($kop, $datum) = mysql_fetch_row($resultaat)){
echo $dagen[date("w",$datum)], $space, date("j",$datum), $space,
$maanden[date("n",$datum)], $space, ": ", $kop, "<br>\n";
}
?>
De uitvoer van dit script staat op http://81.59.96.207/expi/7-1/frameset%20site/nieuwsflits.php
Er zijn nog geen reacties op dit bericht.