' . $ligne['annee_publi'] . ''."\n";
$annee = $ligne['annee_publi'];
}
echo ''."\n";
echo ''.$ligne['publi_auteurs'].' : '."\n";
echo '"'.$ligne['titre_publi'].'", '."\n";
echo ''.$ligne['revue_publi'].', '."\n";
echo 'vol.'.$ligne['volume_publi'].''."\n";
echo ''.$ligne['session_publi'].', '."\n";
echo 'pp.'.$ligne['page_publi'].', '."\n";
echo ''.$ligne['annee_publi'].'.'."\n";
echo '
'."\n";
}
mysql_close($link);
}
function recherche_cible()
{
$link = mysql_connect("mes infos") or die("erreur de connexion au serveur");
mysql_select_db("ma db") or die("erreur de connexion a la base de donnees");
$recherche = mysql_real_escape_string(trim($_POST['status']));
switch ($choix_recherche)
{
case 'mot_clef':
$requete = "SELECT * FROM publications
WHERE publi_auteurs LIKE '%$recherche%'
OR titre_publi LIKE '%$recherche%'
OR revue_publi LIKE '%$recherche%'
OR annee_publi LIKE '%$recherche%'
ORDER BY annee_publi";
break;
case 'auteurs':
$requete = "SELECT * FROM publications
WHERE publi_auteurs LIKE '%$recherche%'
ORDER BY annee_publi";
break;
case 'titre':
$requete = "SELECT * FROM publications
WHERE titre_publi LIKE '%$recherche%'
ORDER BY annee_publi";
break;
case 'revue':
$requete = "SELECT * FROM publications
WHERE revue_publi LIKE '%$recherche%'
ORDER BY annee_publi";
break;
case 'annee':
$requete = "SELECT * FROM publications
WHERE annee_publi LIKE '%$recherche%'
ORDER BY annee_publi";
break;
default:
$requete = "SELECT * FROM publications ORDER BY annee_publi";
}
affiche($requete, $link);
echo 'Retour'."\n";
}
function formulaire()
{
echo 'Rechercher une publication
'."\n";
echo ' '."\n";
echo ' '."\n";
echo '
'."\n";
}
?>