Controle wat er in de database zit
kben aan het proberen een programma te maken die controleerd als er iets in de database zit.
hier is de code:
"telkens geeft hij een fout omtrent de EXIT
code:
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
include("connect.php");
$query="SELECT * FROM popup";
$result = mysql_query($query) or die (mysql_error());
?>
include("connect.php");
$query="SELECT * FROM popup";
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
if (empty($result)){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
exit();
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
if (empty($result)){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
exit();
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td>
<p>hier komt de rest van de pagina!!!</p>
</td>
</tr>
</table>
</body>
</html>
Gewijzigd op 17/01/2006 18:26:00 door Gregory
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$counter = mysql_num_rows($result);
if ($counter==0){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
$counter = mysql_num_rows($result);
if ($counter==0){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
Code (php)
1
2
3
2
3
<?php
echo '<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">';
?>
echo '<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">';
?>
Robert:
Haal die exit eens gewoon weg en herscrijf de code een beetje:
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$counter = mysql_num_rows($result);
if ($counter==0){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
$counter = mysql_num_rows($result);
if ($counter==0){
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow('popup.htm','','width=400,height=225')">");
}else{
echo ("<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">");
}
?>
Het idee is zeer goed, maar foutmelding:
Parse error: syntax error, unexpected '}' in c:\inetpub\wwwroot\popuptest.php on line 31
Gewijzigd op 17/01/2006 22:26:00 door - SanThe -
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$counter = mysql_num_rows($result);
if ($counter==0){
echo ('<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow(\'popup.htm\',\'\',\'width=400,height=225\')">');
}else{
echo ('<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">');
}
?>
$counter = mysql_num_rows($result);
if ($counter==0){
echo ('<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_openBrWindow(\'popup.htm\',\'\',\'width=400,height=225\')">');
}else{
echo ('<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"">');
}
?>
daarmee, nu werkt het perfect, en heb ik de denkwijze begrepen.
Bedankt voor de snelle reactie.