Datei1: connect2db.inc.php (Stellt Verbindung zur DB her und macht SQL Abfragen)
<?php
$conn = "";
connect2db();
function connect2db(){
global $conn;
$server = "localhost";
$user = "root";
$db = "test";
$conn = @mysql_connect($server, $user) or die("Fehler beim Verbinden mit Datenbank auf ".$server."
");
@mysql_select_db($db, $conn) or die("Fehler beim Auswählen der ".$db."Datenbank
");
}
function getLVA($sql_statement){
global $conn;
$result = mysql_query( "SELECT * FROM wt_lva, wt_lva_prof, wt_prof
WHERE wt_lva.nr = wt_lva_prof.lva_nr
AND wt_lva.bezeichnung = wt_lva_prof.lva_bezeichnung
AND wt_lva.semester = wt_lva_prof.lva_semester
AND wt_prof.id = wt_lva_prof.prof_id
".$sql_statement."
ORDER BY wt_lva.nr asc",$conn );
if( ! $result ){
die ( "getRows fatal error: ".mysql_error() );
}
else{
return $result;
}
}
?>
Datei 2: suche_lva.php (Formular zur Filterung)
<?php
include("fileadmin/scripts/includes/connect2db.inc.php");
?>
<?php
print "<table align='left' border='0' cellspacing='0' cellpadding='0'>";
print "<tr><td colspan='6'>";
print "<form action='index.php?id=3' method='POST'>";
print "Studium: <select name='studium' width='150'><option selected='selected'>Alle Studienrichtungen</option>";
print "<option value='WINF'>Wirtschaftsinformatik</option>";
print "<option value='INF'>Informatik</option>";
print "</select>";
print "<br><br>Semester: <select name='semester' width='150'><option value='Alle Semester'>Alle Semester</option>";
print "<option value='WS 03/04'>Wintersemester</option>";
print "<option value='SS 04'>Sommersemester</option>";
print "</select>";
print "<br><br>Typ: <select name='typ' width='150'><option selected='selected'>Alle Lehrveranstaltungstypen</option>";
print "<option value='VO'>VO</option>";
print "<option value='VU'>VU</option>";
print "<option value='UE'>UE</option>";
print "<option value='LU'>LU</option>";
print "<option value='PR'>PR</option>";
print "<option value='PS'>PS</option>";
print "<option value='VL'>VL</option>";
print "</select>";
print "<br><br>Empfohlenes Semester: <select name='empfohlenes_semester' width='150'><option selected='selected'>Alle Semester</option>";
print "<option value='1'>1.</option>";
print "<option value='2'>2.</option>";
print "<option value='3'>3.</option>";
print "<option value='4'>4.</option>";
print "<option value='5'>5.</option>";
print "<option value='6'>6.</option>";
print "<option value='7'>7.</option>";
print "<option value='8'>8.</option>";
print "<option value='9'>9.</option>";
print "</select>";
print "<br><br>Forschungsgruppe: <select name='forschungsgruppe' width='150'><option selected='selected'>Alle Forschungsgruppen</option>";
print "<option value='1'>Grp 1</option>";
print "<option value='2'>Grp 2</option>";
print "<option value='3'>Grp 3</option>";
print "<option value='4'>Grp 4</option>";
print "<option value='5'>Grp 5</option>";
print "</select>";
print " <br><br><input type='submit' name='formaction' value='LVA suchen' class='submit'>";
print "</form>";
print "</td></tr>";
if(isset($studium)){
if($studium == "Alle Studienrichtungen"){
$sql_statement = "";
}
else{
$sql_statement = "AND wt_lva.details ='".$studium."'";
}
if($semester == "Alle Semester"){
}
else{
$sql_statement .= "AND wt_lva.semester ='".$semester."'";
}
if($typ == "Alle Lehrveranstaltungstypen"){
}
else{
$sql_statement .= "AND wt_lva.typ ='".$typ."'";
}
if($empfohlenes_semester == "Alle Semester"){
}
else{
$sql_statement .= "AND wt_lva.semester_empfehlung ='".$empfohlenes_semester."'";
}
if($forschungsgruppe == "Alle Forschungsgruppen"){
}
else{
$sql_statement .= "AND wt_lva.forschungsgruppe ='".$forschungsgruppe."'";
}
$checkrow = getLVA($sql_statement);
print "<td align='left'>Nr.:</td><td align='left'>LVA Nr.:</td><td>Bezeichnung</td><td align='left'>Typ</td><td align='left'>Stunden</td><td align='left'>Leitung</td>";
print "</tr>";
print "<tr><td colspan='6'><hr width='100%' size='1'></td><tr>";
$i = 1;
while($row = mysql_fetch_array($checkrow)){
print "<tr>";
print "<td align='left'>".$i."</td><td align='left'>".$row['nr']."</td><td><a href='index.php?id='>".$row['bezeichnung']."</a></td><td align='left'>".$row['typ']."</td><td align='center'>".$row['wochenstunden']."</td><td align='left'><a href='index.php?id='>".$row['vorname']." ".$row['nachname']."</a></td>";
print "</tr>";
$i++;
}
}
print "</table>";
?>
die Datei 2 ist völlig ident über die php extension in typo3 integriert.
