Mot clé:
Section:

"; if( isset( $keyword) && isset($section) ) { $keyword = trim( $keyword ); $section = trim( $section ); if( strlen( $keyword ) == 1 ) $keyword = ""; if( $keyword != "" ) { db_Connect(); if ($section == "Projets") { $result = mysql_query( "SELECT * FROM projet WHERE nom LIKE '%$keyword%' || domaine LIKE '%$keyword%' || description LIKE '%$keyword%' || lien LIKE '%$keyword%' || debut LIKE '%$keyword%' " ); $foundNum = mysql_num_rows( $result ); $keyword = stripslashes( $keyword ); echo "
"; $i = 1; while( $row = mysql_fetch_array( $result ) ) { $lien = $row["lien"]; echo " "; $i++; } echo "
Il y a $foundNum résultat(s) pour '$keyword'
$i.{$row[ 'nom' ]}
Domaine: {$row[ 'domaine' ]}
{$row[ 'debut' ]}
"; } if ($section == "Séminaires") { $result = mysql_query( "SELECT * FROM seminaire WHERE titre LIKE '%$keyword%' || resume LIKE '%$keyword%' || lieu LIKE '%$keyword%' || date LIKE '%$keyword%' || heureDebut LIKE '%$keyword%' " ); $foundNum = mysql_num_rows( $result ); $keyword = stripslashes( $keyword ); echo "
"; $i = 1; while( $row = mysql_fetch_array( $result ) ) { $lien = $row["lienVersDoc"]; $resume = substr($row[ 'resume' ],0,150); echo " "; $i++; } echo "
Il y a $foundNum résultat(s) pour '$keyword'
$i.{$row[ 'titre' ]}
Détails: {$resume} ...
{$row[ 'heureDebut' ]}
"; } if ($section == "Thèses") { $result = mysql_query( "SELECT * FROM thesis WHERE titreEng LIKE '%$keyword%' || titreFr LIKE '%$keyword%' || institution LIKE '%$keyword%' || ville LIKE '%$keyword%' || pays LIKE '%$keyword%' || date LIKE '%$keyword%' " ); $foundNum = mysql_num_rows( $result ); $keyword = stripslashes( $keyword ); echo "
"; $i = 1; while( $row = mysql_fetch_array( $result ) ) { $lien = $row["lienVersAbsDoc"]; echo " "; $i++; } echo "
Il y a $foundNum résultat(s) pour '$keyword'
$i.{$row[ 'titreEng' ]}
{$row[ 'titreFr' ]}
{$row[ 'institution' ]} {$row[ 'pays' ]}
{$row[ 'heureDebut' ]}
"; } if ($section == "Publications") { $result1 = mysql_query( "SELECT * FROM articleJournal WHERE titre LIKE '%$keyword%' || journal LIKE '%$keyword%' || details LIKE '%$keyword%' " ); $foundNum1 = mysql_num_rows( $result1 ); $result2 = mysql_query( "SELECT * FROM articleProceedings WHERE titre LIKE '%$keyword%' || proceeding LIKE '%$keyword%' || details LIKE '%$keyword%' " ); $foundNum2 = mysql_num_rows( $result2 ); $result3 = mysql_query( "SELECT * FROM livre WHERE titre LIKE '%$keyword%' || isbn LIKE '%$keyword%'|| maison_edition LIKE '%$keyword%' || details LIKE '%$keyword%' " ); $foundNum3 = mysql_num_rows( $result3 ); $result4 = mysql_query( "SELECT * FROM articleChapitre WHERE titre LIKE '%$keyword%' || chapitre LIKE '%$keyword%'|| maison_edition LIKE '%$keyword%' || details LIKE '%$keyword%' " ); $foundNum4 = mysql_num_rows( $result4 ); $foundNum = $foundNum1 + $foundNum2 + $foundNum3 + $foundNum4;; $keyword = stripslashes( $keyword ); echo "
"; $i = 1; while( $foundNum != 0 ) { while ($row = mysql_fetch_array( $result1 ) ) { $lien = $row["lienVersDoc"]; $resume = substr($row[ 'details' ],0,150); echo " "; $i++; } while ($row = mysql_fetch_array( $result2 ) ) { $lien = $row["lienVersDoc"]; $resume = substr($row[ 'details' ],0,150); echo " "; $i++; } while ($row = mysql_fetch_array( $result3 ) ) { $lien = $row["lienVersDoc"]; $resume = substr($row[ 'details' ],0,150); echo " "; $i++; } while ($row = mysql_fetch_array( $result4 ) ) { $lien = $row["lienVersDoc"]; $resume = substr($row[ 'details' ],0,150); echo " "; $i++; } $foundNum--; } echo "
Il y a $foundNum résultat(s) pour '$keyword'
$i.{$row[ 'titre' ]}
{$row[ 'journal' ]}
{$row[ 'resume' ]} {$row[ 'langue' ]}
{$row[ 'date' ]}
$i.{$row[ 'titre' ]}
{$row[ 'proceeding' ]}
{$row[ 'resume' ]} {$row[ 'langue' ]}
{$row[ 'date' ]}
$i.{$row[ 'titre' ]}
{$row[ 'maison_edition' ]}
{$row[ 'resume' ]} {$row[ 'langue' ]}
{$row[ 'annee' ]}
$i.{$row[ 'titre' ]}
{$row[ 'maison_edition' ]}
{$row[ 'resume' ]} {$row[ 'langue' ]}
{$row[ 'annee' ]}
"; } if ($section == "Équipe") { $result1 = mysql_query( "SELECT * FROM professeur WHERE nom LIKE '%$keyword%' || prenom LIKE '%$keyword%'|| courriel LIKE '%$keyword%' || domaine LIKE '%$keyword%' || biographie LIKE '%$keyword%' " ); $foundNum1 = mysql_num_rows( $result1 ); $result2 = mysql_query( "SELECT * FROM etudiant WHERE nom LIKE '%$keyword%' || prenom LIKE '%$keyword%'|| courriel LIKE '%$keyword%' || domaine LIKE '%$keyword%' " ); $foundNum2 = mysql_num_rows( $result2 ); $result3 = mysql_query( "SELECT * FROM partenaire WHERE nom LIKE '%$keyword%' || lien LIKE '%$keyword%' " ); $foundNum3 = mysql_num_rows( $result3 ); $foundNum = $foundNum1 + $foundNum2 + $foundNum3; $keyword = stripslashes( $keyword ); echo "
"; $i = 1; while( $foundNum != 0 ) { while ($row = mysql_fetch_array( $result1 ) ) { $lien = $row["site"]; $resume = substr($row[ 'domaine' ],0,150); echo " "; $i++; } while ($row = mysql_fetch_array( $result2 ) ) { $lien = $row["site"]; $resume = substr($row[ 'details' ],0,150); echo " "; $i++; } while ($row = mysql_fetch_array( $result3 ) ) { $lien = $row["lien"]; echo " "; $i++; } $foundNum--; } echo "
Il y a $foundNum résultat(s) pour '$keyword'
$i.{$row[ 'nom' ]} {$row[ 'prenom' ]}, Professeur {$row[ 'titre' ]}
{$resume}...
{$row[ 'date' ]}
$i.{$row[ 'nom' ]} {$row[ 'prenom' ]}, Étudiant(e) {$row[ 'niveau' ]}
{$resume}...
{$row[ 'date' ]}
$i.{$row[ 'nom' ]}
"; } } } echo "

[Haut] 


"; include ("footer.php"); ?>