suche in datenbank

[-


$conditional_query = "";


if ($fdat{datum}) {

	$conditional_query .= " AND (mc_rd3_icd.datum = '$fdat{datum}')";
} 


if ($fdat{projekt}) {


	$conditional_query .= " AND (mc_rd3_projekt.projekt = '$fdat{projekt}')";
}


if ($fdat{autor}) {


	$conditional_query .= " AND (mc_rd3_autor.autor = '$fdat{autor}')";
}


if ($fdat{titel}) {


	$conditional_query .= " AND (mc_rd3_icd.titel = '$fdat{titel}')";
}


if ($fdat{stichwort1}) {


	$conditional_query .= " AND (mc_rd3_icd.stichwort1 = '$fdat{stichwort1}')";
}


if ($fdat{stichwort2}) {


	$conditional_query .= " AND (mc_rd3_icd.stichwort2 = '$fdat{stichwort2}')";
}


if ($fdat{stichwort3}) {


	$conditional_query .= " AND (mc_rd3_icd.stichwort3 = '$fdat{stichwort3}')";
}


if ($fdat{dateiname}) {


	$conditional_query .= " AND (mc_rd3_icd.dateiname = '$fdat{dateiname}')";
}


if ($fdat{version}) {


	$conditional_query .= " AND (mc_rd3_icd.version = '$fdat{version}')";
}




$sql = qq{SELECT datum, projekt, name, vorname, titel, stichwort1, stichwort2, stichwort3, dateiname, version
                                 FROM mc_rd3_projekt, mc_rd3_autor, mc_rd3_icd, mc_rd3_autorprojekt
                                 WHERE  mc_rd3_projekt.pid	=	mc_rd3_autorprojekt.pid 
                                 and 	mc_rd3_autor.aid	=	autorID 
                                 and	mc_rd3_autor.aid 	= 	mc_rd3_autorprojekt.aid
                                 and 	mc_rd3_icd.projektID	=	mc_rd3_projekt.pid 
                                 and 	$conditional_query
                                 ORDER BY datum
                                 };


$icd_suche = $dbh->prepare($sql) or die WebCenter::error($DBI::err); 
$icd_suche->execute() or die WebCenter::error($DBI::err); 


suchergebnis()


-]


hier noch das Unterprogramm:




# Unterprogramm zur Darstellung des bzw. der Suchergebnisse      
        #[$ sub suchergebnis $]

        [$ while (@suche = $icd_suche->fetchrow_array()) $]


 # <table border="2" borderstyle="solid" bgcolor="#FFFF80" rules="none">
      <form name="icd" method="post" enctype="multipart/form-data">

   <tr>

       <tr>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
       </tr>

       <tr>
          <td>[b]Datum[/b]</td>
          <td>[b]Projekt[/b]</td>
          <td>[b]Name[/b]</td>
          <td>[b]Vorname[/b]</td>
          <td>[b]Titel[/b]</td>
          <td></td>
       </tr>

       <tr>

          <td><input type="text" name="datum" maxlength="10" value="[+ $suche[0] +]" /></td>
          <td><input type="text" name="projekt" maxlength="30" value="[+ $suche[1] +]" /></td>
          <td><input type="text" name="name" maxlength="30" value="[+ $suche[2] +]" /></td>
          <td><input type="text" name="vorname" maxlength="30" value="[+ $suche[3] +]" /></td>
          <td><input type="text" name="titel" maxlength="30" value="[+ $suche[4] +]" /></td>
          <td></td>    
       </tr>

       </tr>  
          <td></td>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
       </tr>

       <tr>  
          <td>[b]Stichwort1[/b]</td>
          <td>[b]Stichwort2[/b]</td>
          <td>[b]Stichwort3[/b]</td>
          <td>[b]Dateiname[/b]</td>
          <td>[b]Version[/b]</td>
          <td>[b]Datei[/b]</td>
       </tr>

       <tr>   
          <td><input type="text" name="stichwort1" maxlength="30" value="[+ $suche[5] +]" /></td>
          <td><input type="text" name="stichwort2" maxlength="30" value="[+ $suche[6] +]" /></td>
          <td><input type="text" name="stichwort3" maxlength="30" value="[+ $suche[7] +]" /></td>
          <td><input type="text" name="dateiname" maxlength="20"  value="[+ $suche[8] +]" /></td>
          <td><input type="text" name="version" maxlength="5" value="[+ $suche[9] +]" /></td>
          <td>[url='']<input type="file" name="dateiupload" value="[+ $suche[10] +]">[/url]</td>
       </tr>

       <tr>
          <td></td>
          <td></td>
          <td></td>
          <td></td>
          <td><input type="submit" name="&Auml;ndern" value="&Auml;ndern" /></td>
          <td><input type="submit" name="L&ouml;schen" value="L&ouml;schen" /></td> 
       </tr> 

   </tr>   



    </form>
# </table> 
</div>                     
    [$ endwhile $]


    #    [$ endsub $]