Menu déroulant en PHP
Jen_na
-
AzErTy -
AzErTy -
Bonjour, je souhaiterais créer des sous menus à mon menu généré par ma base de données MYSQL en PHP, mais je ne vois absolument pas comment intervenir sur mon menu, qui est une liste, voici mon code :
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Portfolio</title>
<link href="portfolioHome.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="css/jquery.lightbox-0.5.css" media="screen" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery.lightbox-0.5.js"></script>
<script type="text/javascript">
$(function() {
$('.photos a').lightBox();
});
</script>
<style type="text/css">
.photos {margin-top:10px;
background-color:#333;
}
.photos { list-style: none; }
.photos { display:compact; }
.photos img {
border: 2px solid #00ffc6;
}
.photos a:hover img {
border: 2px solid #fff; }
.photos a:hover { color: #fff; }
</style>
<script type="text/javascript">
$(document).ready(function(){
$('.photos img').mouseover(function(){
$('#BlockInfos').text($(this).attr('alt'));
});
});
</script>
</head>
<body>
<div id="Container">
<div id="Maincontainer">
<div id="HautDePage">
<div id="Noms"><strong>Jenna Haugmard : graphiste & webdesigner.</strong></div>
<div id="cv"><a href="Cv.pdf">*télécharger le CV*</a></div>
<div id="Competences">Bienvenue sur mon portfolio</div>
<div id="mailto"><a href="mailto:haugmardjenna@aol.com">///Contact</a></div>
</div>
<?php
mysql_connect("localhost", "root", "root") or die ("erreur de connexion au serveur");
mysql_select_db("portfolio")or die("erreur de connexion à base de données");
?>
<div id="menu">
<?php
$requete=mysql_query('SELECT DISTINCT cat FROM travaux');
while($donnees = mysql_fetch_array($requete)){
echo "<a href='portfolioHome.php?cat=".$donnees['cat']."'>".$donnees['cat']."</a><br/>";
}
?>
<div id="Home"><a href='portfolioHome.php'>>>>>>Home</a></div>
</div> <div id="ComBlockInfos"><div id="Block"><div id="BlockInfos">
<div id="Commentaires"></div></div>
<?php
$nbimage="SELECT * FROM travaux";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
if(empty($_GET['cat']) AND empty($_GET['page'])){
$requete=mysql_query("SELECT * FROM travaux LIMIT 0,21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?page=".$i."'>".$i."</a></div></div>";
}
}
if(isset($_GET['page'])AND empty($_GET['cat'])) {
$requete=mysql_query("SELECT * FROM travaux LIMIT ".((($_GET['page'])*21)-21).",21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?page=".$i."'>".$i."</a></div></div>";
}\
}
if(isset($_GET['cat']) AND empty($_GET['page'])) {
$cat=$_GET['cat'];
$nbimage="SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
$requete=mysql_query("SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'LIMIT 0,21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?cat=".$cat."&page=".$i."'>".$i."</a></div></div>";
}
}
if(isset($_GET['cat']) AND isset($_GET['page'])) {
$cat=$_GET['cat'];
$nbimage="SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
$requete=mysql_query("SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'LIMIT ".((($_GET['page'])*21)-21).",21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?cat=".$cat."&page=".$i."'>".$i."</a></div>";
}
}
?>
</div>
</div>
</div>
</div>
</div>
</body>
Merci merci et merci !!!!!!!!
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Portfolio</title>
<link href="portfolioHome.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="css/jquery.lightbox-0.5.css" media="screen" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery.lightbox-0.5.js"></script>
<script type="text/javascript">
$(function() {
$('.photos a').lightBox();
});
</script>
<style type="text/css">
.photos {margin-top:10px;
background-color:#333;
}
.photos { list-style: none; }
.photos { display:compact; }
.photos img {
border: 2px solid #00ffc6;
}
.photos a:hover img {
border: 2px solid #fff; }
.photos a:hover { color: #fff; }
</style>
<script type="text/javascript">
$(document).ready(function(){
$('.photos img').mouseover(function(){
$('#BlockInfos').text($(this).attr('alt'));
});
});
</script>
</head>
<body>
<div id="Container">
<div id="Maincontainer">
<div id="HautDePage">
<div id="Noms"><strong>Jenna Haugmard : graphiste & webdesigner.</strong></div>
<div id="cv"><a href="Cv.pdf">*télécharger le CV*</a></div>
<div id="Competences">Bienvenue sur mon portfolio</div>
<div id="mailto"><a href="mailto:haugmardjenna@aol.com">///Contact</a></div>
</div>
<?php
mysql_connect("localhost", "root", "root") or die ("erreur de connexion au serveur");
mysql_select_db("portfolio")or die("erreur de connexion à base de données");
?>
<div id="menu">
<?php
$requete=mysql_query('SELECT DISTINCT cat FROM travaux');
while($donnees = mysql_fetch_array($requete)){
echo "<a href='portfolioHome.php?cat=".$donnees['cat']."'>".$donnees['cat']."</a><br/>";
}
?>
<div id="Home"><a href='portfolioHome.php'>>>>>>Home</a></div>
</div> <div id="ComBlockInfos"><div id="Block"><div id="BlockInfos">
<div id="Commentaires"></div></div>
<?php
$nbimage="SELECT * FROM travaux";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
if(empty($_GET['cat']) AND empty($_GET['page'])){
$requete=mysql_query("SELECT * FROM travaux LIMIT 0,21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?page=".$i."'>".$i."</a></div></div>";
}
}
if(isset($_GET['page'])AND empty($_GET['cat'])) {
$requete=mysql_query("SELECT * FROM travaux LIMIT ".((($_GET['page'])*21)-21).",21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?page=".$i."'>".$i."</a></div></div>";
}\
}
if(isset($_GET['cat']) AND empty($_GET['page'])) {
$cat=$_GET['cat'];
$nbimage="SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
$requete=mysql_query("SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'LIMIT 0,21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?cat=".$cat."&page=".$i."'>".$i."</a></div></div>";
}
}
if(isset($_GET['cat']) AND isset($_GET['page'])) {
$cat=$_GET['cat'];
$nbimage="SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'";
$reponse=mysql_query($nbimage);
$nb=mysql_num_rows($reponse);
$np=ceil($nb/21);
$requete=mysql_query("SELECT adresse, thumb, commentaires FROM travaux WHERE cat='".$cat."'LIMIT ".((($_GET['page'])*21)-21).",21");
while($donnees = mysql_fetch_array($requete)){
echo "<div class='photos'><a href='image/".$donnees['adresse']."'><img src='image/".$donnees['thumb']."' alt=\"".$donnees['commentaires']."\"/></a></div>";
}
for($i=1; $i<=$np; $i++){
echo "<div class='pagination'><div class='nbPage'><a href='portfolioHome.php?cat=".$cat."&page=".$i."'>".$i."</a></div>";
}
}
?>
</div>
</div>
</div>
</div>
</div>
</body>
Merci merci et merci !!!!!!!!
A voir également:
- Menu déroulant en PHP
- Menu déroulant excel - Guide
- Excel menu déroulant en cascade - Guide
- Menu déroulant google sheet - Accueil - Guide bureautique
- Easy php - Télécharger - Divers Web & Internet
- Canon quick menu - Télécharger - Utilitaires
1 réponse
Je n'ai pas appliqué mon code au tien mais je pense que ça t'aidera tout de même.
Si tu veux des explication n'hésite pas ;)
<?php
$conn=mysql_connect("localhost", "root", "root");
mysql_select_db("gesinter");
$sql="SELECT IdUser,NomUser,PrenomUser,MailUser,Password,It FROM utilisateur";
$curseur=mysql_query($sql);
echo "<select name='contact' id='Contact'>";
while ($ligne=mysql_fetch_array($curseur))
{
echo "<option value=".$ligne[0].">".$ligne[1]." ".$ligne[2]."</option>";
}
echo "</select>";
mysql_close($conn);
?>
Si tu veux des explication n'hésite pas ;)
<?php
$conn=mysql_connect("localhost", "root", "root");
mysql_select_db("gesinter");
$sql="SELECT IdUser,NomUser,PrenomUser,MailUser,Password,It FROM utilisateur";
$curseur=mysql_query($sql);
echo "<select name='contact' id='Contact'>";
while ($ligne=mysql_fetch_array($curseur))
{
echo "<option value=".$ligne[0].">".$ligne[1]." ".$ligne[2]."</option>";
}
echo "</select>";
mysql_close($conn);
?>