Subversion Repositories eFlore/Archives.eflore-consultation-v2

Compare Revisions

Ignore whitespace Rev 2 → Rev 3

/trunk/eflore_photo.inc.php
New file
0,0 → 1,211
<?php
/*vim: set expandtab tabstop=4 shiftwidth=4: */
// +------------------------------------------------------------------------------------------------------+
// | PHP version 4.1 |
// +------------------------------------------------------------------------------------------------------+
// | Copyright (C) 2004 Tela Botanica (accueil@tela-botanica.org) |
// +------------------------------------------------------------------------------------------------------+
// | This library is free software; you can redistribute it and/or |
// | modify it under the terms of the GNU Lesser General Public |
// | License as published by the Free Software Foundation; either |
// | version 2.1 of the License, or (at your option) any later version. |
// | |
// | This library is distributed in the hope that it will be useful, |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
// | Lesser General Public License for more details. |
// | |
// | You should have received a copy of the GNU Lesser General Public |
// | License along with this library; if not, write to the Free Software |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
// +------------------------------------------------------------------------------------------------------+
// CVS : $Id: eflore_photo.inc.php,v 1.1 2004-06-17 13:23:16 linda Exp $
/**
* Titre
*
* Description
*
*@package nom_du_paquetage
*@subpackage nom_du_sous-paquetage_si_necessaire
//Auteur original :
*@author linda ANGAMA<linda_angama@yahoo.fr>
//Autres auteurs :
*@author Aucun
*@copyright Tela-Botanica 2000-2004
*@version $Revision: 1.1 $ $Date: 2004-06-17 13:23:16 $
*/
 
session_start();
$res="";
$res.="<HTML><HEAD><link rel=\"stylesheet\" type=\"text/css\" media=\"screen\" href=\"photo.css\" /></HEAD><BODY>";
 
error_reporting(E_ALL);
include_once "DB.php";
 
if (isset($agrandit))
{
$res.="<div align=\"center\">";
$res.="<p><a href=\"photo.php?".SID."&deb=".$_SESSION['dep']."\">Retour &agrave la miniature</a></p>";
$res.="<img src=\"".$agrandit."\"></div>";
unset($agrandit);
echo $res;
}
 
$_SESSION['dep']=$deb;
echo $deb;
$path_rdf="/home/linda/Documents/testphp/rdf/";
$sep="\"\n";
if (!isset($deb)){$deb=0;}
$img_pg=6;
$prec=null;
$suiv=null;
 
//en-tete commune a tous les fichiers rdf
$en_tete="<rdf=RDF";
$en_tete .="\n";
$en_tete .="xmls:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#";
$en_tete .=$sep;
$en_tete .="xmls:dc=\"http://purl.org/dc/elements/1.1/".$sep;
$en_tete .="xmls:dcterms=\"http://purl.org/dc/terms".$sep;
$en_tete .=">"."\n\n";
 
//connexion a la base
$dsn="mysql://root:0000@localhost/test";
$db=DB::connect($dsn);
if (DB::isError($db))
{
echo "<ERREUR>";
echo "Impossible d'&eacutetablir de connexion ",$db->getMessage();
echo "</ERREUR>";
exit;
}
 
 
//requete sql
$req="select * from images";
$cond="where identifier<=7";
if(!$cond=="")
{
$resultat=$db->query($req." ".$cond);
$cpt=$db->query("select count('identifier') from images ".$cond);
$nbre_ligne=$cpt->fetchRow(DB_FETCHMODE_ORDERED);
print("nombre de lignes r&eacutesultat de la requ&ecircte : ".$nbre_ligne[0]."<br>");
}
else
{
$resultat=$db->query($req);
$cpt=$db->query("select count('identifier') from images ");
$nbre_ligne=$cpt->fetchRow(DB_FETCHMODE_ORDERED);
}
 
//selection des lignes de la requete &agrave traiter
 
if (($deb+$img_pg+1)<=($nbre_ligne[0]))
{
$fin=$deb+$img_pg-1;
}
else
{
$fin=$nbre_ligne[0]-1;
}
 
 
 
//affichage des miniatures et g&eacuten&eacuteration des fichiers rdf
if ($fin!==0)
{
foreach (range($deb, $fin) as $num_ligne)
{
if (!$ligne = $resultat->fetchrow(DB_FETCHMODE_ORDERED, $num_ligne))
{
break;
}
$url_img=$ligne[8];
$url_img_mini=$url_img."mini_photos/mini_";
$url_img_mini .=$ligne[1];
$url_img .=$ligne[1];
$res.="<div class=\"float\">";
$res.="<map name=\"mini".$url_img."\">";
$res.="<area shape=\"rect\" coords=\"0,0,175,175\" href=\"gde_photo.php?agrandit=".$url_img."&".SID."\">";
$res.="</map>";
$res.="<img src=\"".$url_img_mini."\" border=0 usemap=\"#mini".$url_img."\">";
$res.="<p>num_ligne : ".$num_ligne." id: ".$ligne[0]."->".$ligne[1]."</p></div>";
//g&eacuten&eacuteration d'un fichier rdf pour chaque resultat de la requete
$fic=$path_rdf;
$fic .=$ligne[0];
$fic .=".rdf";
if(!file_exists($fic))
{
$fp=fopen($fic,"w+");
$text_rdf="";
if(!$fp)
{
$res.="erreur de cr&eacuteation du fichier rdf";
exit;
}
$text_rdf .=$en_tete;
$text_rdf .="<rdf:Description rdf:about=\"";
$url_img=$ligne[8];
$url_img .=$ligne[1];
$text_rdf .=$url_img .$sep;
$text_rdf .="dc:identifier=\"";
$text_rdf .=$ligne[0];
$text_rdf .=$sep;
$text_rdf .="dc:title=\"";
$text_rdf .=$ligne[1];
$text_rdf .=$sep;
$text_rdf .="dc:creator=\"";
$text_rdf .=$ligne[2];
$text_rdf .=$sep;
$text_rdf .="dc:type=\"";
$text_rdf .=$ligne[3];
$text_rdf .=$sep;
if(!(is_null($ligne[4])))
{
$text_rdf .="dcterms:created=\"";
$text_rdf .=$ligne[4];
$text_rdf .=$sep;
}
$text_rdf .=">\n</rdf:Description>\n</rdf:RDF>\n";
$i=fwrite($fp,$text_rdf);
fclose($fp);
}
}
if ($deb!=0)
{
if (($deb-$img_pg-1)>=0)
{
$prec="<a href=photo.php?deb=".($deb-$img_pg-1).">Pr&eacutec&eacutedent</a>";
$res.="<div class=\"prec\">".$prec."</div>";
}
else
{
$prec="<a href=photo.php?deb=0>Pr&eacutec&eacutedent</a>";
}
$res.="<div class=\"prec\">".$prec."</div>";
}
if ($deb+$img_pg<$nbre_ligne[0])
{
$suiv="<a href=photo.php?deb=".($fin+1).">Suivant</a>";
$res.="<div class=\"suiv\">".$suiv."</div>";
}
 
}
 
DB::disconnect();
echo $res;
 
?>
</BODY>
</HTML>