include ("include_fns.php");
include ("header.php");
include ("header_login.php");
displayHeader( "Recherche par mot clé | Keyword Search" );
echo "
";
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 "
Il y a $foundNum résultat(s) pour '$keyword' |
|
";
$i = 1;
while( $row = mysql_fetch_array( $result ) )
{
$lien = $row["lien"];
echo "
|
$i.{$row[ 'nom' ]} Domaine: {$row[ 'domaine' ]} |
|
{$row[ 'debut' ]} |
";
$i++;
}
echo "
|
";
}
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 "
Il y a $foundNum résultat(s) pour '$keyword' |
|
";
$i = 1;
while( $row = mysql_fetch_array( $result ) )
{
$lien = $row["lienVersDoc"];
$resume = substr($row[ 'resume' ],0,150);
echo "
|
$i.{$row[ 'titre' ]} Détails: {$resume} ...
|
|
{$row[ 'heureDebut' ]} |
";
$i++;
}
echo "
|
";
}
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 "
Il y a $foundNum résultat(s) pour '$keyword' |
|
";
$i = 1;
while( $row = mysql_fetch_array( $result ) )
{
$lien = $row["lienVersAbsDoc"];
echo "
|
$i.{$row[ 'titreEng' ]} {$row[ 'titreFr' ]} {$row[ 'institution' ]} {$row[ 'pays' ]} |
|
{$row[ 'heureDebut' ]} |
";
$i++;
}
echo "
|
";
}
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 "
Il y a $foundNum résultat(s) pour '$keyword' |
|
";
$i = 1;
while( $foundNum != 0 )
{
while ($row = mysql_fetch_array( $result1 ) )
{
$lien = $row["lienVersDoc"];
$resume = substr($row[ 'details' ],0,150);
echo "
|
$i.{$row[ 'titre' ]} {$row[ 'journal' ]} {$row[ 'resume' ]} {$row[ 'langue' ]} |
|
{$row[ 'date' ]} |
";
$i++;
}
while ($row = mysql_fetch_array( $result2 ) )
{
$lien = $row["lienVersDoc"];
$resume = substr($row[ 'details' ],0,150);
echo "
|
$i.{$row[ 'titre' ]} {$row[ 'proceeding' ]} {$row[ 'resume' ]} {$row[ 'langue' ]} |
|
{$row[ 'date' ]} |
";
$i++;
}
while ($row = mysql_fetch_array( $result3 ) )
{
$lien = $row["lienVersDoc"];
$resume = substr($row[ 'details' ],0,150);
echo "
|
$i.{$row[ 'titre' ]} {$row[ 'maison_edition' ]} {$row[ 'resume' ]} {$row[ 'langue' ]} |
|
{$row[ 'annee' ]} |
";
$i++;
}
while ($row = mysql_fetch_array( $result4 ) )
{
$lien = $row["lienVersDoc"];
$resume = substr($row[ 'details' ],0,150);
echo "
|
$i.{$row[ 'titre' ]} {$row[ 'maison_edition' ]} {$row[ 'resume' ]} {$row[ 'langue' ]} |
|
{$row[ 'annee' ]} |
";
$i++;
}
$foundNum--;
}
echo "
|
";
}
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 "
Il y a $foundNum résultat(s) pour '$keyword' |
|
";
$i = 1;
while( $foundNum != 0 )
{
while ($row = mysql_fetch_array( $result1 ) )
{
$lien = $row["site"];
$resume = substr($row[ 'domaine' ],0,150);
echo "
|
$i.{$row[ 'nom' ]} {$row[ 'prenom' ]}, Professeur {$row[ 'titre' ]} {$resume}... |
|
{$row[ 'date' ]} |
";
$i++;
}
while ($row = mysql_fetch_array( $result2 ) )
{
$lien = $row["site"];
$resume = substr($row[ 'details' ],0,150);
echo "
|
$i.{$row[ 'nom' ]} {$row[ 'prenom' ]}, Étudiant(e) {$row[ 'niveau' ]} {$resume}... |
|
{$row[ 'date' ]} |
";
$i++;
}
while ($row = mysql_fetch_array( $result3 ) )
{
$lien = $row["lien"];
echo "
|
$i.{$row[ 'nom' ]} |
";
$i++;
}
$foundNum--;
}
echo "
|
";
}
}
}
echo "
[Haut]
";
include ("footer.php");
?>