//------------------------------------ // fonctions qui permettent de créer les différents types de DIV //------------------------------------ function div1(){ echo "<div class='toto'> blablabla </div>"; } function divtruc(){ echo "<div class='tutu'><h3>test</h3> autre blablabla </div>"; } //------------------------------------ //recup des div à afficher en bdd par exemple stockées dans un array $a_afficher = array(); $a_afficher[] = array('quellediv'=>'div1'); $a_afficher[] = array('quellediv'=>'div1'); $a_afficher[] = array('quellediv'=>'div2'); //------------------------------------ //Et là... je génère l'affichage //... via une BOUCLE !!!! for ($i=0;$i<3;$i++){ $a_afficher[$i](); }
// connexion BD
require_once('db.php');
$sql = 'SELECT * FROM maTable ORDER BY position';
$req = $db->prepare($sql);
$req->execute($q) or die(print_r($req->errorInfo()));
$row = $req->fetchAll();
switch ($row['id']) {
case 1:
function div1(){
echo "<div class='toto'>$row['contenu_div1']</div>";
}
break;
case 2:
function div2(){
echo "<div class='tutu'>$row['contenu_div2']</div>";
}
break;
case 3:
function div3(){
echo "<div class='tata'>$row['contenu_div3']</div>";
}
break;
...
default:
code to be executed
}
$row = $req->fetchAll();
foreach ($rows as $row){
switch ($row['id']) {
case 1:
function div1(){
echo "<div id='div_1'>$row['contenu_div1']</div>";
}
break;
case 2:
function div2(){
echo "<div id='div_2'>$row['contenu_div2']</div>";
}
break;
case 3:
function div3(){
echo "<div id='div_3'>$row['contenu_div3']</div>";
}
break;
...
default:
echo '';
}
}
//------------------------------------
//recup des div à afficher en bdd par exemple stockées dans un array
$a_afficher = array('div_1','div_2','div_3');
for($i=1;$i<count($a_afficher);$i++){
UPDATE maTable SET position = $i WHERE id = $a_afficher [$i];
}
// connexion BD
require_once('db.php');
$sql = 'SELECT * FROM maTable ORDER BY position';
$req = $db->prepare($sql);
$req->execute($q) or die(print_r($req->errorInfo()));
$rows = $req->fetchAll();
<div id="container">
<div id="bloc_1">
<div id='div_1'>contenu_div1</div>
<div id='div_2'>contenu_div2</div>
<div id='div_3'>contenu_div3</div>
</div>
<div id="bloc_2">
foreach ($rows as $row){
switch ($row['id']) {
case 1:
<div id='div_1'>contenu_div1</div>
break;
case 2:
<div id='div_2'>contenu_div2</div>
break;
case 3:
<div id='div_3'>contenu_div3</div>
break;
...
default:
echo '';
}
}
</div>
</div>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
// connexion BD
require_once('db.php');
$sql = 'SELECT * FROM maTable ORDER BY position';
$req = $db->prepare($sql);
$req->execute($q) or die(print_r($req->errorInfo()));
$rows = $req->fetchAll();
<!-- menu gauche -->
<div id="modules">
<div id="menu">
<div id="mod01"><img src="image-mod01.jpg"></div>
<div id="mod02"><img src="image-mod02.jpg"></div>
<div id="mod03"><img src="image-mod03.jpg"></div>
</div>
<div id="dropdown">
<div class="div_mod" data-type="mod01" data-id="1">nouveau contenu 1</div>
<div class="div_mod" data-type="mod02" data-id="2">nouveau contenu 2</div>
<div class="div_mod" data-type="mod03" data-id="3">nouveau contenu 3</div>
</div>
</div>
<div id="container">
<div id="bloc_1">
<div id="div_mod01" class="row" data-id="1">contenu div 1</div>
<div id="div_mod02" class="row" data-id="2">contenu div 2</div>
<div id="div_mod03" class="row" data-id="3">contenu div 3</div>
</div>
<div id="bloc_2">
foreach ($rows as $row){
switch ($row['id']) {
case 1:
<div id="div_1">contenu_div1</div>
break;
case 2:
<div id="div_2">contenu_div2</div>
break;
case 3:
<div id="div_3">contenu_div3</div>
break;
...
default:
echo '';
}
}
</div>
</div>
function(){
$("#mod01").hover(function() {
$(".div_mod[data-type='mod01']").show();
$(".div_mod[data-type='mod02']").hide();
$(".div_mod[data-type='mod03']").hide();
});
$("#mod02").hover(function() {
$(".div_mod[data-type='mod01']").hide();
$(".div_mod[data-type='mod02']").show();
$(".div_mod[data-type='mod03']").hide();
});
$("#mod03").hover(function() {
$(".div_mod[data-type='mod01']").hide();
$(".div_mod[data-type='mod02']").hide();
$(".div_mod[data-type='mod03']").show();
});
$(".div_mod").hover(
function() {
$(this).append('<div class="add"><i class="fa fa-plus"></i>Insert</div>');
$('.add').click(function() {
$("#div_1").prepend($("#bloc_1 .row[data-id='"+$(this).parent().attr("data-id")+"']").clone());
$("#dropdown").fadeOut(200);
});
}, function() {
$(this).children(".add").remove();
}
);
})();