marcelklip
Terugkerende gebruiker
- Lid geworden
- 2 jan 2005
- Berichten
- 1.010
Hallo
Ik zou graag de eerst komende drie evenementen willen laten zien.
Hoe kan ik dat doen.
Ik heb zelf al enige dingen geprobeerd maar ik krijg het niet voorelkaar.
Hoop dat iemand mij kan helpen.
Ik zou graag de eerst komende drie evenementen willen laten zien.
Hoe kan ik dat doen.
Ik heb zelf al enige dingen geprobeerd maar ik krijg het niet voorelkaar.
Hoop dat iemand mij kan helpen.
PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="events.css" rel="stylesheet" type="text/css">
<title>Evenementen kalender</title>
</head>
<body>
<center>
</center>
<div class="main_area">
<?php
// define variables
$current_month = date(m);
$current_day = date(d);
$current_year = date(Y);
$next_year = ($current_year + 1);
//Connect To Database
include("admin/config.php");
mysql_connect($dbhost,$dbuser,$dbpass) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname) or die( "Unable to select database");
//if the event is in the future, print it out
$query="SELECT * FROM events WHERE (year >= $current_year AND month > $current_month) OR (year >= $current_year AND month = $current_month AND day > $current_day) OR (year > $current_year) ORDER BY year, month, day";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
//Get all the data and assign variables
$id=mysql_result($result,$i,"id");
$event=mysql_result($result,$i,"event");
$hour=mysql_result($result,$i,"hour");
$minute=mysql_result($result,$i,"minute");
$ampm=mysql_result($result,$i,"ampm");
$month=mysql_result($result,$i,"month");
$day=mysql_result($result,$i,"day");
$year=mysql_result($result,$i,"year");
$location=mysql_result($result,$i,"location");
$email=mysql_result($result,$i,"email");
$phone=mysql_result($result,$i,"phone");
$link=mysql_result($result,$i,"link");
$link_name=mysql_result($result,$i,"link_name");
$description=mysql_result($result,$i,"description");
$html=mysql_result($result,$i,"html");
// removes slashes
$description=stripslashes($description);
//replaces carriage returns with html line breaks
if ($html =="0") {
$description=preg_replace("/\n/","<br>", ($description));
}
// removes the first zero from the hour. We need the zero at first, to keep the numbering in order.
//Of course the number ten needs the zero left in.
if ($hour !="10") {
$hour=preg_replace("/0/","", ($hour));
}
// Here is where we actually print out the events.
echo "
<a href='event.php?id=$id'>$event</a></a><br>
Plaats: $location <br>";
echo " Datum: $day/$month/$year <br><br>";
// looks for the next event id and if it exists, prints it out.
$i++;
}
// If there are no scheduled events, print the no events message
if (!mysql_num_rows($result)) {
mysql_connect($dbhost,$dbuser,$dbpass) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname) or die( "Unable to select database");
$query2="SELECT * FROM no_events WHERE id=1";
$result2=mysql_query($query2);
$num2=mysql_numrows($result2);
mysql_close();
$k=0;
while ($k < $num2) {
$description2=mysql_result($result2,$k,"description");
$description2=stripslashes($description2);
$description2=preg_replace("/\n/","<br>", ($description2));
echo "$description2";
$k++;
}
}
?>
</div>
</body>
</html>
Laatst bewerkt:
