Gegeven niet uitlezen?
Ik ben een beginner dus heb hier niet zo veel ervaring mee.
Ik heb een website en nou wou ik een simpel nieuwssysteempje gebruiken voor mijn home page, dit is de code de ik gebruikt heb.
in config.php staat alleen de gegevens om in de database in te loggen.
Hij geeft een error weet iemand hoe dit kan?
hieronden de pagina:
http://www.bobbob.nl/test/nieuws.php
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
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
<?php include("config.php"); ?>
<?php
$news_SQL="SELECT * FROM news ORDER BY news_datetime DESC";
$news_result=mysql_query($news_SQL);
?>
<?php
while($news=mysql_fetch_array($news_result)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $news['news_datetime'] ?></span>
<br /><b><?php echo $news['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $news['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
mysql_close();
?>
<?php
$news_SQL="SELECT * FROM news ORDER BY news_datetime DESC";
$news_result=mysql_query($news_SQL);
?>
<?php
while($news=mysql_fetch_array($news_result)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $news['news_datetime'] ?></span>
<br /><b><?php echo $news['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $news['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
mysql_close();
?>
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
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
<?php
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
if(!($res = mysql_query($sql))){
echo "Helaas, de database verbinding is mislukt.";
}
else{
while($link = mysql_fetch_assoc($res)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $link['news_datetime'] ?></span>
<br /><b><?php echo $link['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $link['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
?>
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
if(!($res = mysql_query($sql))){
echo "Helaas, de database verbinding is mislukt.";
}
else{
while($link = mysql_fetch_assoc($res)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $link['news_datetime'] ?></span>
<br /><b><?php echo $link['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $link['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
?>
Dit is niet getest, maar ik denk dat het zo ongeveer wel werkt.
nou krijg ik een andere error.
check: http://www.bobbob.nl/test/nieuws.php
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
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
<?php
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
if(!($res = mysql_query($sql))){
echo "Helaas, de database verbinding is mislukt.";
}
else{
while($link = mysql_fetch_assoc($res)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $link['news_datetime'] ?></span>
<br /><b><?php echo $link['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $link['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
?>
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
if(!($res = mysql_query($sql))){
echo "Helaas, de database verbinding is mislukt.";
}
else{
while($link = mysql_fetch_assoc($res)){
?>
<table with="400" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<span class="kleiner"><?php echo $link['news_datetime'] ?></span>
<br /><b><?php echo $link['news_header'] ?></b>
</td>
</tr>
<tr>
<td>
<span class="kleiner"><?php echo $link['news_main'] ?></span>
</td>
</tr>
<tr>
<td>
<hr width="400" size="1" noshade />
</td>
</tr>
</table>
<?php
}
?>
Betekend meestal dat de hij niet goed wordt afgesloten zoals je ziet eerst de else {
dan de while {
en dan sluit je af met 1 }
dus
if {
} else {
while {
}
neem aan dat je probleem nu ziet.
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
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
<?php
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
$query = mysql_query($sql) or die(mysql_error());
while($link = mysql_fetch_assoc($query)){
echo "
<table with='400' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td> <span class='kleiner'> $link['news_datetime'] </span><br /> <b> $link['news_header'] </b></td>
</tr>
<tr>
<td> <span class='kleiner'> $link['news_main'] </span> </td>
</tr>
<tr>
<td><hr width='400' size='1' noshade /></td>
</tr>
</table>";
}
?>
include ('config.php');
$sql = "SELECT * FROM news ORDER BY news_datetime DESC";
$query = mysql_query($sql) or die(mysql_error());
while($link = mysql_fetch_assoc($query)){
echo "
<table with='400' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td> <span class='kleiner'> $link['news_datetime'] </span><br /> <b> $link['news_header'] </b></td>
</tr>
<tr>
<td> <span class='kleiner'> $link['news_main'] </span> </td>
</tr>
<tr>
<td><hr width='400' size='1' noshade /></td>
</tr>
</table>";
}
?>
Gewijzigd op 01/01/1970 01:00:00 door daan
Ik heb gewoon de code gebruikt die ik als eerste zij, er zat een fout in de database.
Groetjes,