Viewing file:  Alpha.php (18.21 KB) -rw----r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<style type="text/css">
<!--
body {
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style></head>
<body>
<p class="Style3">LISTE DES CHAMPIGNONS</span>
<?php
include ("connect.php");
$get = mysql_query("SELECT * FROM presentation WHERE ID='7'");
$i=1;
while ($row = mysql_fetch_assoc($get))
{
// obtenir données
$i++;
$texte = $row['TEXTE'];
if (isset($_SESSION['identifiant']))
{
if (isset($_GET['valider']))
{
$text2 = mysql_real_escape_string($_POST['text2']);
$num = '7';
$query = mysql_query("UPDATE presentation SET TEXTE='$text2' WHERE ID='$num'");
echo "<p class='Style2'>Modification réussis</p>";
$get4 = mysql_query("SELECT * FROM presentation WHERE ID='$num'");
while ($row4 = mysql_fetch_assoc($get4))
{
$texte4 = $row4['TEXTE'];
echo "<p class='Style2'>$texte4</p>";
}
}
else
{echo '<table><form action="index.php?page=Alpha&valider=1" method="POST" enctype="multipart/form-data"><td><tr>
<textarea name="text2" cols="80" rows="4">'.$texte.'</textarea></tr>
<tr><input type="submit" name="sup2" value="Enregistrer"></tr></td>
</form></table>';
}
}
else
{
echo "<p class='Style2'>$texte</p>";
}
}
?></ br>
<?php
//connection à la database
include ("connect.php");
// on vérifie que l'information existe
if ( isset($_POST['genre']) && !empty($_POST['genre']) )
// si c'est bien le cas
{
$selection = $_POST['genre'];
echo("$selection");
}
else
{
}
?>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form id="form1" name="form1" method="GET" action="index.php?page=Alpha">
<select name='subdivision'>
<?php if ((isset($_GET['subdivision'])) && ($_GET['subdivision']!=""))
{
$subdivisionf = $_GET["subdivision"];
echo '<option value='.$subdivisionf.'>'.$subdivisionf.'</option>';
}
else
{
echo '<option value="">Sub-division</option>';
$subdivisionf = "";
}
$get = mysql_query('SELECT * FROM subdivision ORDER BY subdivision');
echo '<option value="">Déselectionner</option>';
while ($row = mysql_fetch_assoc($get))
{
$subdivision = $row['SUBDIVISION'];
$id = $row['ID'];
echo "<option value=".$subdivision.">".$subdivision."</option>";
}
echo '</select> ';
?>
<select name='genre'>
<?php
if (isset($_GET['alph']))
$alph = $_GET["alph"];
else $alph ="";
if ((isset($_GET['genre'])) && ($_GET['genre']!=""))
{
$genref = $_GET["genre"];
echo '<option value='.$genref.'>'.$genref.'</option>';
}
else
{
echo '<option value="">Genres</option>';
$genref ="";
}
$get = mysql_query('SELECT * FROM genre ORDER BY genre');
echo '<option value="">Déselectionner</option>';
while ($row = mysql_fetch_assoc($get))
{
$genre = $row['GENRE'];
$id = $row['ID'];
echo "<option value=".$genre.">".$genre."</option>";
}
echo '</select>';
?>
<select name='espece'>
<?php if ((isset($_GET['espece'])) && ($_GET['espece']!=""))
{
$especef = $_GET["espece"];
echo '<option value='.$especef.'>'.$especef.'</option>';
}
else
{
echo '<option value="">Especes</option>';
$especef = "";
}
$get = mysql_query('SELECT * FROM espece ORDER BY espece');
echo '<option value="">Déselectionner</option>';
while ($row = mysql_fetch_assoc($get))
{
$espece = $row['ESPECE'];
$id = $row['ID'];
echo "<option value=".$espece.">".$espece."</option>";
}
echo '</select> ';
if ((isset($_GET['nomrecherche'])) && ($_GET['nomrecherche']!=""))
{
$varietef = $_GET["nomrecherche"];
echo '<input name="nomrecherche" type="text" value='.$varietef.' size="15" maxlength="30" />';
}
else
{
echo '<input name="nomrecherche" type="text" value="" size="15" maxlength="30" />';
$varietef = "";
}
?>
<input name="page" type="hidden" value="Alpha" maxlength="40" />
<select name='classement'>
<option value=2>Tri par date</option>
<option value=1>Déselectionner</option>
</select>
<td> <input type="submit" value="Chercher" title="Valider" /></form></td>
<td> <?php if (isset($_SESSION['identifiant']))
{
echo "<img src='image/transparent.png' width='10' height='10' /></td><td><form action='index.php?page=Modification articles&creation=1' method='POST' enctype='multipart/form-data'>
<input type='submit' name='sup' value='Ajouter un Champignon'>
</form>";
}
?>
</td>
</tr>
</table>
<?php
echo "<p class='Style8'><strong>";
if ($alph=="a")
echo "<span class='Style9'><strong>A</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=a&nomrecherche=$varietef&page=Alpha'>A</a> ";
if ($alph=="b")
echo "<span class='Style9'><strong>B</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=b&nomrecherche=$varietef&page=Alpha'>B</a> ";
if ($alph=="c")
echo "<span class='Style9'><strong>C</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=c&nomrecherche=$varietef&page=Alpha'>C</a> ";
if ($alph=="d")
echo "<span class='Style9'><strong>D</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=d&nomrecherche=$varietef&page=Alpha'>D</a> ";
if ($alph=="e")
echo "<span class='Style9'><strong>E</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=e&nomrecherche=$varietef&page=Alpha'>E</a> ";
if ($alph=="f")
echo "<span class='Style9'><strong>F</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=f&nomrecherche=$varietef&page=Alpha'>F</a> ";
if ($alph=="g")
echo "<span class='Style9'><strong>G</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=g&nomrecherche=$varietef&page=Alpha'>G</a> ";
if ($alph=="h")
echo "<span class='Style9'><strong>H</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=h&nomrecherche=$varietef&page=Alpha'>H</a> ";
if ($alph=="i")
echo "<span class='Style9'><strong>I</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=i&nomrecherche=$varietef&page=Alpha'>I</a> ";
if ($alph=="J")
echo "<span class='Style9'><strong>J</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=j&nomrecherche=$varietef&page=Alpha'>J</a> ";
if ($alph=="k")
echo "<span class='Style9'><strong>K</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=k&nomrecherche=$varietef&page=Alpha'>K</a> ";
if ($alph=="l")
echo "<span class='Style9'><strong>L</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=l&nomrecherche=$varietef&page=Alpha'>L</a> ";
if ($alph=="m")
echo "<span class='Style9'><strong>M</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=m&nomrecherche=$varietef&page=Alpha'>M</a> ";
if ($alph=="n")
echo "<span class='Style9'><strong>N</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=n&nomrecherche=$varietef&page=Alpha'>N</a> ";
if ($alph=="o")
echo "<span class='Style9'><strong>O</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=o&nomrecherche=$varietef&page=Alpha'>O</a> ";
if ($alph=="p")
echo "<span class='Style9'><strong>P</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=p&nomrecherche=$varietef&page=Alpha'>P</a> ";
if ($alph=="q")
echo "<span class='Style9'><strong>Q</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=q&nomrecherche=$varietef&page=Alpha'>Q</a> ";
if ($alph=="r")
echo "<span class='Style9'><strong>R</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=r&nomrecherche=$varietef&page=Alpha'>R</a> ";
if ($alph=="s")
echo "<span class='Style9'><strong>S</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=s&nomrecherche=$varietef&page=Alpha'>S</a> ";
if ($alph=="t")
echo "<span class='Style9'><strong>T</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=t&nomrecherche=$varietef&page=Alpha'>T</a> ";
if ($alph=="u")
echo "<span class='Style9'><strong>U</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=u&nomrecherche=$varietef&page=Alpha'>U</a> ";
if ($alph=="v")
echo "<span class='Style9'><strong>V</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=v&nomrecherche=$varietef&page=Alpha'>V</a> ";
if ($alph=="w")
echo "<span class='Style9'><strong>W</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=w&nomrecherche=$varietef&page=Alpha'>W</a> ";
if ($alph=="x")
echo "<span class='Style9'><strong>X</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=x&nomrecherche=$varietef&page=Alpha'>X</a> ";
if ($alph=="y")
echo "<span class='Style9'><strong>Y</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=y&nomrecherche=$varietef&page=Alpha'>Y</a> ";
if ($alph=="z")
echo "<span class='Style9'><strong>Z</strong></span> ";
else
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=z&nomrecherche=$varietef&page=Alpha'>Z</a> ";
echo "</strong></p>";
?>
</p>
<table border="0" cellpadding="0" cellspacing="0">
<?php
//Nombre maximun d'articles par page
$per_page = 5000000;
//d'ou on commence pour la variable
if (isset($_GET['start']))
$start = $_GET['start'];
else
{
$start = 0;
}
// compter le nombre de réponse
$record_count = mysql_num_rows(mysql_query("SELECT * FROM champignons WHERE GENRE LIKE '%$genref%' AND GENRE LIKE '$alph%' AND ESPECE LIKE '%$especef%' AND SUBDIVISION LIKE '%$subdivisionf%' AND (VARIETE LIKE '%$varietef%' || GENRE LIKE '%$varietef%' || ESPECE LIKE '%$varietef%' || SUBDIVISION LIKE '%$varietef%') ORDER BY genre,espece,variete")); // a modifier pour la sélection de donnée (SELECT ..... FROM articles
// compter le nombre maximal de page
$max_pages = $record_count / $per_page; //mais cela peut être décimal
$compteur = 0;
//apparition des données
if (isset($_GET['classement']))
{
$classement = $_GET['classement'];
}
else
{ $classement = "1";
}
if ($classement==2)
{
$get = mysql_query("SELECT * FROM champignons WHERE GENRE LIKE '%$genref%' AND GENRE LIKE '$alph%' AND ESPECE LIKE '%$especef%' AND SUBDIVISION LIKE '%$subdivisionf%' AND (VARIETE LIKE '%$varietef%' || GENRE LIKE '%$varietef%' || ESPECE LIKE '%$varietef%' || SUBDIVISION LIKE '%$varietef%') ORDER BY DATE_INSCRIPTION DESC LIMIT $start, $per_page");
}
else
{
$get = mysql_query("SELECT * FROM champignons WHERE GENRE LIKE '%$genref%' AND GENRE LIKE '$alph%' AND ESPECE LIKE '%$especef%' AND SUBDIVISION LIKE '%$subdivisionf%' AND (VARIETE LIKE '%$varietef%' || GENRE LIKE '%$varietef%' || ESPECE LIKE '%$varietef%' || SUBDIVISION LIKE '%$varietef%') ORDER BY genre,espece,variete LIMIT $start, $per_page");
}
while ($row = mysql_fetch_assoc($get))
{
// obtenir données
$compteur = $compteur + 1;
$id = $row['ID'];
$espece = $row['ESPECE'];
$name = $row['VARIETE'];
$genre = $row['GENRE'];
$dateajour = $row['DATE_INSCRIPTION'];
$subdivision = $row['SUBDIVISION'];
$pdf1 = $row['PDF1'];
$pdf2 = $row['PDF2'];
$pdf3 = $row['PDF3'];
$pdf4 = $row['PDF4'];
$pdf5 = $row['PDF5'];
$pdf6 = $row['PDF6'];
$tempor3 = explode("-", $dateajour);
$dateajourfinal = $tempor3[2]."-".$tempor3[1]."-".$tempor3[0];
echo '<tr>
<td width="500"> <table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="120"><div align="left">'.$subdivision.' </div></td>
<td><div align="left">'.$genre.' '.$espece.' '.$name.'</div></td>
</tr>
</table></td>';
if (isset($_SESSION['identifiant']))
{ ?> <td width="130"> <?php }
else
{ ?> <td width="100"> <?php }
?>
<?php
if ($row['PDF1'])
echo '<a href="'.$pdf1.'" target="_blank"><img src="image/pdf1.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?>
<A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=1','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf1n.png" width="20" height="20" border="0" /></A><?php
}
}
if ($row['PDF2'])
echo '<a href="'.$pdf2.'" target="_blank"><img src="image/pdf2.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?><A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=2','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf2n.png" width="20" height="20" border="0"/></A><?php
}
}
if ($row['PDF3'])
echo '<a href="'.$pdf3.'" target="_blank"><img src="image/pdf3.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?><A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=3','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf3n.png" width="20" height="20" border="0"/></A><?php
}
}
if ($row['PDF4'])
echo '<a href="'.$pdf4.'" target="_blank"><img src="image/pdf4.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?><A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=4','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf4n.png" width="20" height="20" border="0"/></A><?php
}
}
if ($row['PDF5'])
echo '<a href="'.$pdf5.'" target="_blank"><img src="image/pdf5.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?><A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=5','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf5n.png" width="20" height="20" border="0"/></A><?php
}
}
if ($row['PDF6'])
echo '<a href="'.$pdf6.'" target="_blank"><img src="image/pdf6.png" width="20" height="20" border="0" /></a>';
else
{
if (isset($_SESSION['identifiant']))
{
?><A HREF="#" onClick="window.open('ajoutpdf.php?variete=<?php echo"$id";?>&pdf=6','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=80');return(false)"><img src="image/pdf6n.png" width="20" height="20" border="0" /></A><?php
}
}
?>
</td>
<?php
if (isset($_SESSION['identifiant']))
{ ?>
<td width="80" align="left">
<?php echo $dateajourfinal; ?>
</td>
<?php
}
else
{
?>
<td width="200" align="left">
<?php echo $dateajourfinal; ?>
</td>
<?php
}
if (isset($_SESSION['identifiant']))
{
echo "<td><form action='index.php?page=Modification articles&id=".$id."&supprimer=1' method='POST' enctype='multipart/form-data'>
<input type='submit' name='sup' value='Sup'></form></td><td><a href='index.php?page=deletepdf&delete=2&id=".$id."'><img src='image/deletepdf.png' width='20' height='20' border='0' /></a></td></tr>
";
}
}
if (isset($_SESSION['identifiant']))
{
echo "<br><strong>Nombre total d'espèces créées: ".$record_count.".</strong><br>";
}
?>
</table>
<br>
<?php
if ($record_count==0)
echo "<strong><em>Aucun Champignon.</em></strong><br>";
//installer le bouton avant et après
$prev = $start - $per_page;
$next = $start + $per_page;
//montrer le bouton previous
if (!($start<=0))
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=$alph&nomrecherche=$varietef&page=Alpha&start=$prev'>Précédent</a> ";
// montrer le numéro des pages
// programmer la première page
//$i=1;
//for ($x=0;$x<$record_count;$x=$x+$per_page)
//{
// if ($start!=$x)
// echo"<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=$alph&nomrecherche=$varietef&page=Alpha&start=$x'>[$i]</a> ";
// else
// echo"<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=$alph&nomrecherche=$varietef&page=Alpha&start=$x'><b>[$i]</b></a> ";
// $i++;
//}
//montrer le bouton next
if (!($start>=$record_count-$per_page))
echo "<a href='index.php?subdivision=$subdivisionf&genre=$genref&espece=$especef&alph=$alph&nomrecherche=$varietef&page=Alpha&start=$next'>Suivant</a> ";
?>
<br><br>
|
