KulturbüroRiehen

".mysql_error($conn); } ?>

Jahresagenda Veranstaltungen in Riehen

Melden Sie Ihre Veranstaltung

"); for ($i=date('Y');$i<2015;$i++) { echo("

"); if ($selectedYear==$i) { echo("

"); } if ($selectedYear==$i) echo(" $i"); else echo(" $i"); if ($selectedYear==$i) { echo("

"); } echo("

"); } // echo("

Für Veranstalter >>>

"); echo("

"); // month display echo("\n"); /* // date display echo("

"); if ($selectedMonth!=-1) { $daysdefault=31; // generate time in php $timestamp=mktime(12,00,00,$selectedMonth,1,$selectedYear); //echo(date("Y m d ",$timestamp)); $daysdefault=intval(date("t",$timestamp)); echo("

"); for ($i=1;$i<($daysdefault+1);$i++) { echo("

"); if ($selectedDate==$i) { echo("

"); } echo(" $i"); if ($selectedDate==$i) { echo("

"); } echo("

"); */ // ------------------------------------ // display all places & categories // ------------------------------------ // echo("

"); echo("

"); echo(""); echo(""); echo(""); // konzert / veranstaltung echo(" Kategorie: "); echo(""); // placeref echo(" Ort der Veranstaltung: "); echo(""); echo("

"); // echo("

"); // search /* echo("

"); echo(""); echo("

"); */ // -------------------------------- // selection // -------------------------------- if ($search=="") { // ----------------------------- // display results // ----------------------------- $placesearch=""; if ($selectedplaceref!=-1) $placesearch=" AND placeref=$selectedplaceref "; $categorysearch=""; if ($category!="") $placesearch=" AND category='$category' "; // year ? $yearcondition=" (Year(datebeg)=$selectedYear OR Year(dateend)=$selectedYear)"; // display echo("

"); // WHERE Now()<=datebeg OR Now()<=dateend // default .. if (!$somethingSelected) $sql = "SELECT * FROM kalendar WHERE $yearcondition order by datebeg asc,time asc"; // normal if ($somethingSelected) $sql = "SELECT * FROM kalendar WHERE $yearcondition $monthcondition $datecondition $placesearch $selectNow order by datebeg asc,time asc"; // echo("

".str_replace("<","<",$sql)."

"); $result = mysql_query($sql, $conn); if($result) { $number = mysql_num_rows($result); // if ($number>0) { // ------------------------------------------------------------ // store results into array so we can look through it // ------------------------------------------------------------ $dateArray=array(); $dateArrayIndex=array(); for ($it=0;$it<$number;++$it) { $datebeg=mysql_result($result,$it,"datebeg"); $dateTimestamp=mktime(12,0,0,intval(substr($datebeg,5,7)),intval(substr($datebeg,8,10)),intval(substr($datebeg,0,4))); $dateend=mysql_result($result,$it,"dateend"); $dateEndTimestamp=mktime(12,0,0,intval(substr($dateend,5,7)),intval(substr($dateend,8,10)),intval(substr($dateend,0,4))); if (($dateTimestamp<$dateEndTimestamp) || ($dateTimestamp==$dateEndTimestamp)) { // echo("
***$datebeg-$dateend"); $counter=0; do { $dateTempTimestamp=mktime(12,0,0,intval(substr($datebeg,5,7)),intval(substr($datebeg,8,10))+$counter,intval(substr($datebeg,0,4))); $dateArray[count($dateArray)]=$dateTempTimestamp; $dateArrayIndex[count($dateArrayIndex)]=$it; // echo("
- ".$counter." ".date("Y m d ",$dateTempTimestamp)); $counter++; if ($counter>365) break; } while (($dateTempTimestamp<$dateEndTimestamp)); } else if ($dateTimestamp>$dateEndTimestamp) { // just take as one day // echo("
$datebeg-$dateend"); $dateArray[count($dateArray)]=$datebeg; $dateArrayIndex[count($dateArrayIndex)]=$it; } // display dates } // year $stryear=""; $stryear=$stryear.""; // start table // what was selected ? // // calendar $stryearcalendar="

"; $monthCounter=0; // month for ($month=1;$month<13;$month++) { // if (($selectedMonth==-1) || ($selectedMonth==$month)) { // timestamp $timestamp=mktime(12,00,00,$month,1,$selectedYear); //echo(date("Y m d ",$timestamp)); $daysdefault=intval(date("t",$timestamp)); $strmonth=""; $monthName=NameOfMonth($month); if (($selectedMonth==-1) || ($selectedMonth==$month)) $strmonth=$strmonth.""; // -------------------------- // calendar display // -------------------------- // find first day $strmonthcalendar=""; $strmonthcalendar=$strmonthcalendar."

"; // selected year if ($selectedYear!=-1) { $stryear=$stryear."
$selectedYear
$monthName

"; $strmonthcalendar=$strmonthcalendar.">"; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; $strmonthcalendar=$strmonthcalendar." "; // fill the calendars $start=date('w',$timestamp); if ($start==0) $start=6; else $start=$start-1; $strmonthcalendar=$strmonthcalendar.""; for ($t=0;$t<$start;$t++) { $strmonthcalendar=$strmonthcalendar.""; } // echo($strmonthcalendar); // -------------------------- // default display // -------------------------- // datetmp $datetmp=-1; // found $foundMonth=false; for ($datex=1;$datex<($daysdefault+1);$datex++) { $timestamp=mktime(12,00,00,$month,$datex,$selectedYear); $foundDates=0; // datex // if (($selectedDate==-1)||($selectedDate==$datex)) { // ok check if there is something // go through the array $foundEventForThisDate=false; $strdate=""; for ($dat=0;$dat0) { $placeId=mysql_result($resultPlace,0,"id"); $placeName=mysql_result($resultPlace,0,"name"); } } // $datebeg - 2007-03-24 $arr=explode("-",$datebeg); // $arr[0]=2007 $year=$arr[0]; $montht=intval($arr[1]); $date_day=intval($arr[2]); $monthName=NameOfMonth($montht); $arr=explode("-",$dateend); // $arr[0]=2007 $yearStop=$arr[0]; $monthStop=intval($arr[1]); $date_dayStop=intval($arr[2]); $monthNameStop=NameOfMonth($monthStop); $strdate=$strdate.""; // start with the line $strdate=$strdate.""; $strdate=$strdate.""; $strdate=$strdate.""; // string manipulation // "12:13:15" $time=substr($time,0,5); $strdate=$strdate.""; $timeend=substr($timeend,0,5); $strdate=$strdate.""; $strdate=$strdate.""; // end of line } } if ($foundEventForThisDate==false) { $strdate=$strdate.""; // start with the line $strdate=$strdate.""; $strdate=$strdate.""; $strdate=$strdate.""; $strdate=$strdate.""; $strdate=$strdate.""; $strdate=$strdate.""; } // strmonth if (($selectedMonth==-1) || ($selectedMonth==$month)) { $strmonth=$strmonth.$strdate; } // ------------------------- // calendar display top // ------------------------- $strmonthcalendar=$strmonthcalendar.""; if (intval(date("w",$timestamp))==0) $strmonthcalendar=$strmonthcalendar.""; } } // dates // calendar $strmonthcalendar=$strmonthcalendar.""; $strmonthcalendar=$strmonthcalendar."

".$href.$monthName."
Mo	Di	Mi	Do	Fr	Sa	So
	"; $strdate=$strdate." "; if ($datetmp!=$datex) { $strdate=$strdate." $datex "; // $monthName $datetmp=$datex; } $strdate=$strdate." "; $strdate=$strdate."	"; $strdate=$strdate." "; if (($url!="")&&($url!="http")) $strdate=$strdate.""; $strdate=$strdate."$title"; $strdate=$strdate." ($category) "; if (($url!="")&&($url!="http")) $strdate=$strdate.""; // stop //if (($yearStop!=$year)&&($monthName!=$monthNameStop)&&($date_dayStop!=$date_day)) if ($datebeg!=$dateend) { $strdate=$strdate." ".$date_day.". ".$monthName." "; $strdate=$strdate."- ".$date_dayStop.". ".$monthNameStop." "; // if ($year!=$yearStop) $strdate=$strdate.$yearStop; $strdate=$strdate." ".$yearStop; } $strdate=$strdate." "; $strdate=$strdate."	"; $strdate=$strdate." "; $strdate=$strdate."$placeName"; $strdate=$strdate." "; $strdate=$strdate."	"; $strdate=$strdate." "; $strdate=$strdate."$time"; $strdate=$strdate." "; $strdate=$strdate."	"; $strdate=$strdate." "; $strdate=$strdate."$timeend"; $strdate=$strdate." "; $strdate=$strdate."
"; $strdate=$strdate." "; if ($datetmp!=$datex) { $strdate=$strdate." $datex "; // $monthName $datetmp=$datex; } $strdate=$strdate." "; $strdate=$strdate."
0) { if ($foundDates<2) $strmonthcalendar=$strmonthcalendar." bgcolor=#663333 "; // style='border: 1px solid white' else $strmonthcalendar=$strmonthcalendar." bgcolor=#883333 "; // style='border: 1px solid white' } else $strmonthcalendar=$strmonthcalendar." bgcolor=#224422 "; // style='border: 1px solid white' $datext=round($datex/6)*6; if ($datext%6==0) $datext=$datext-6; if ($datext<1) $datext=1; $anchor="#$monthName$datext"; if ($datext<5) $anchor="#$monthName"; // if ($selectedMonth!=$month) $href=""; // else // $href=""; $strmonthcalendar=$strmonthcalendar." class='whitenewwebsitetext'>$href$datex

"; $stryearcalendar=$stryearcalendar."\n".$strmonthcalendar; // $stryearcalendar=$stryearcalendar."\ntest"; if (($monthCounter+1)%4==0) $stryearcalendar=$stryearcalendar.""; else $stryearcalendar=$stryearcalendar.""; // normal $stryear=$stryear.$strmonth; $monthCounter++; } } } $stryear=$stryear.""; // ----------------------- // output // ----------------------- // calendar $stryearcalendar=$stryearcalendar.""; echo($stryearcalendar); // normal display echo($stryear); } // ... } echo("

"); } ?>