Descrizione dinamica nella gallery

**cero76** · 22-03-2011, 14:09

Ciao a tutti ho postato ieri una richiesta per un problema di una gallery dinamica ma nessun mi ha riposto.... ho risolto da solo ma adesso ho un'altro problema:
Ho scricato una gallery fotografica e l'ho trasformata in dinamica creando una pagina di amministrazione per l'inserimento di descrizione e foto.Il problema è questo mentre riesco perfettamente a far scorrere le foto non riesco ad aggiungere la descrizione.... il codice funzionante dello scorrimento è questo (anche se non ordinato):
<div id="msg_slideshow" class="msg_slideshow">

<div id="msg_wrapper" class="msg_wrapper">

</div>
<div id="msg_controls" class="msg_controls">

</div>
<div id="msg_thumbs" class="msg_thumbs">
<div class="msg_thumb_wrapper">

<?php do { ?>

[img]<?php echo $dirname.($row_Recordset1['foto']);?>[/img]"/>
<?php }

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

</div>
<div class="msg_thumb_wrapper" style="display:none;">
</div>

</div>
</div>
<div>

</div>

Mentre il codice php che devo inserire è <?php echo $row_Recordset1['descrizione']; ?>
In qualsiasi parte del codice lo metto non mi crea nessun risultato.
Se lo metto prima mi dà la stringa di testo ma io ho necessità di metterlo all'interno del ciclo do\while.
Grazie Mille

**bstefano79** · 22-03-2011, 14:17

scusa ma io non vedo la query
potresti postare tutto il codice e se possibile aggiungere i tag php??

**cero76** · 22-03-2011, 15:41

<?php require_once('Connections/db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

mysql_select_db($database_db, $db);
$query_Recordset1 = "SELECT * FROM allestimenti";
$Recordset1 = mysql_query($query_Recordset1, $db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="it">
<head>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon"/>
<link rel="stylesheet" href="css/style.css" type="text/css" media="screen"/>
<style>
body{
font-family:Arial;
background-color: #CCC;
}

span.reference{
position:fixed;
left:10px;
bottom:10px;
font-size:12px;
}
span.reference a{
color:#666;
text-shadow:1px 1px 1px #fff;
text-transform:uppercase;
text-decoration:none;
margin-right:30px;
}
span.reference a:hover{
color:#333;
}
.content{
width:700px;
margin:0 auto;
}

.msg_slideshow{
margin:0 auto;
}
a.back{
background:transparent url(back.png) no-repeat top left;
height:13px;
width:248px;
display:block;
clear:both;
text-indent:-9000px;
margin:20px auto;
}
a.back:hover{
background-position:0px -13px;
}
#apDiv1 {
position:absolute;
width:200px;
height:115px;
z-index:1;
}
</style>
</head>
<?php $dirname="../admin/images/"; ?>
<?php $dirname2="../admin/images/thumbs/"; ?>
<body>

<?php echo $row_Recordset1['descrizione']; ?>
<div class="content">

<h1></h1>
<div id="msg_slideshow" class="msg_slideshow">

<div id="msg_wrapper" class="msg_wrapper">

</div>
<div id="msg_controls" class="msg_controls">

</div>
<div id="msg_thumbs" class="msg_thumbs">
<div class="msg_thumb_wrapper">

<?php do { ?>

[img]<?php echo $dirname.($row_Recordset1['foto']);?>[/img]"/>
<?php }

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

</div>
<div class="msg_thumb_wrapper" style="display:none;">
</div>

</div>
</div>
<div>

</div>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
$(function() {

* nmb_thumb_wrappers : total number of thumbs wrappers
* nmb_images_wrapper : the number of images inside of each wrapper
*/
var interval = 4000;
var playtime;
var current = 0;
var current_thumb = 0;
var nmb_thumb_wrappers = $('#msg_thumbs .msg_thumb_wrapper').length;
var nmb_images_wrapper = 6;
/**
* start the slideshow
*/
play();

/**
* show the controls when
* mouseover the main container
*/
slideshowMouseEvent();
function slideshowMouseEvent(){
$('#msg_slideshow').unbind('mouseenter')
.bind('mouseenter',showControls)
.andSelf()
.unbind('mouseleave')
.bind('mouseleave',hideControls);
}

/**
* clicking the grid icon,
* shows the thumbs view, pauses the slideshow, and hides the controls
*/
$('#msg_grid').bind('click',function(e){
hideControls();
$('#msg_slideshow').unbind('mouseenter').unbind('m ouseleave');
pause();
$('#msg_thumbs').stop().animate({'top':'0px'},500) ;
e.preventDefault();
});

/**
* closing the thumbs view,
* shows the controls
*/
$('#msg_thumb_close').bind('click',function(e){
showControls();
slideshowMouseEvent();
$('#msg_thumbs').stop().animate({'top':'-230px'},500);
e.preventDefault();
});

/**
* pause or play icons
*/
$('#msg_pause_play').bind('click',function(e){
var $this = $(this);
if($this.hasClass('msg_play'))
play();
else
pause();
e.preventDefault();
});

/**
* click controls next or prev,
* pauses the slideshow,
* and displays the next or prevoius image
*/
$('#msg_next').bind('click',function(e){
pause();
next();
e.preventDefault();
});
$('#msg_prev').bind('click',function(e){
pause();
prev();
e.preventDefault();
});

/**
* show and hide controls functions
*/
function showControls(){
$('#msg_controls').stop().animate({'right':'15px'} ,500);
}
function hideControls(){
$('#msg_controls').stop().animate({'right':'-110px'},500);
}

/**
* start the slideshow
*/
function play(){
next();
$('#msg_pause_play').addClass('msg_pause').removeC lass('msg_play');
playtime = setInterval(next,interval)
}

/**
* stops the slideshow
*/
function pause(){
$('#msg_pause_play').addClass('msg_play').removeCl ass('msg_pause');
clearTimeout(playtime);
}

/**
* show the next image
*/
function next(){
++current;
showImage('r');
}

/**
* shows the previous image
*/
function prev(){
--current;
showImage('l');
}

/**
* shows an image
* dir : right or left
*/
function showImage(dir){
/**
* the thumbs wrapper being shown, is always
* the one containing the current image
*/
alternateThumbs();

/**
* the thumb that will be displayed in full mode
*/
var $thumb = $('#msg_thumbs .msg_thumb_wrapper:nth-child('+current_thumb+')')
.find('a:nth-child('+ parseInt(current - nmb_images_wrapper*(current_thumb -1)) +')')
.find('img');
if($thumb.length){
var source = $thumb.attr('alt');
var $currentImage = $('#msg_wrapper').find('img');
if($currentImage.length){
$currentImage.fadeOut(function(){
$(this).remove();
$('<img />').load(function(){
var $image = $(this);
resize($image);
$image.hide();
$('#msg_wrapper').empty().append($image.fadeIn());
}).attr('src',source);
});
}
else{
$('<img />').load(function(){
var $image = $(this);
resize($image);
$image.hide();
$('#msg_wrapper').empty().append($image.fadeIn());
}).attr('src',source);
}

}
else{ //this is actually not necessary since we have a circular slideshow
if(dir == 'r')
--current;
else if(dir == 'l')
++current;
alternateThumbs();
return;
}
}

/**
* the thumbs wrapper being shown, is always
* the one containing the current image
*/
function alternateThumbs(){
$('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+current_thumb+')')
.hide();
current_thumb = Math.ceil(current/nmb_images_wrapper);
/**
* if we reach the end, start from the beggining
*/
if(current_thumb > nmb_thumb_wrappers){
current_thumb = 1;
current = 1;
}
/**
* if we are at the beggining, go to the end
*/
else if(current_thumb == 0){
current_thumb = nmb_thumb_wrappers;
current = current_thumb*nmb_images_wrapper;
}

$('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+current_thumb+')')
.show();
}

/**
* click next or previous on the thumbs wrapper
*/
$('#msg_thumb_next').bind('click',function(e){
next_thumb();
e.preventDefault();
});
$('#msg_thumb_prev').bind('click',function(e){
prev_thumb();
e.preventDefault();
});
function next_thumb(){
var $next_wrapper = $('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+parseInt(current_thumb+1)+')');
if($next_wrapper.length){
$('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+current_thumb+')')
.fadeOut(function(){
++current_thumb;
$next_wrapper.fadeIn();
});
}
}
function prev_thumb(){
var $prev_wrapper = $('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+parseInt(current_thumb-1)+')');
if($prev_wrapper.length){
$('#msg_thumbs').find('.msg_thumb_wrapper:nth-child('+current_thumb+')')
.fadeOut(function(){
--current_thumb;
$prev_wrapper.fadeIn();
});
}
}

/**
* clicking on a thumb, displays the image (alt attribute of the thumb)
*/
$('#msg_thumbs .msg_thumb_wrapper > a').bind('click',function(e){
var $this = $(this);
$('#msg_thumb_close').trigger('click');
var idx = $this.index();
var p_idx = $this.parent().index();
current = parseInt(p_idx*nmb_images_wrapper + idx + 1);
showImage();
e.preventDefault();
}).bind('mouseenter',function(){
var $this = $(this);
$this.stop().animate({'opacity':1});
}).bind('mouseleave',function(){
var $this = $(this);
$this.stop().animate({'opacity':0.5});
});

/**
* resize the image to fit in the container (400 x 400)
*/
function resize($image){
var theImage = new Image();
theImage.src = $image.attr("src");
var imgwidth = theImage.width;
var imgheight = theImage.height;

var containerwidth = 400;
var containerheight = 400;

if(imgwidth > containerwidth){
var newwidth = containerwidth;
var ratio = imgwidth / containerwidth;
var newheight = imgheight / ratio;
if(newheight > containerheight){
var newnewheight = containerheight;
var newratio = newheight/containerheight;
var newnewwidth =newwidth/newratio;
theImage.width = newnewwidth;
theImage.height= newnewheight;
}
else{
theImage.width = newwidth;
theImage.height= newheight;
}
}
else if(imgheight > containerheight){
var newheight = containerheight;
var ratio = imgheight / containerheight;
var newwidth = imgwidth / ratio;
if(newwidth > containerwidth){
var newnewwidth = containerwidth;
var newratio = newwidth/containerwidth;
var newnewheight =newheight/newratio;
theImage.height = newnewheight;
theImage.width= newnewwidth;
}
else{
theImage.width = newwidth;
theImage.height= newheight;
}
}
$image.css({
'width' :theImage.width,
'height':theImage.height
});
}
});
</script>

<td></td>
</p>

</p>

</p>

</p>

</p>

<div align="center">

</p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Discussione: Descrizione dinamica nella gallery

Strumenti discussione

Ricerca discussione

Visualizza

Descrizione dinamica nella gallery

ecco il codice

Permessi di invio