PHP défiler des info depuis une base mysql
developper55
Messages postés
130
Statut
Membre
-
developper55 Messages postés 130 Statut Membre -
developper55 Messages postés 130 Statut Membre -
Bonjour,
j'ai besoin de défiler plusieurs ligne en mysql :
<div id="marquee1" style="position:absolute; overflow:hidden; left:19px; top:377px; width:300px; height:108px; z-index:7">
<marquee width="300" height="108" direction="Up" scrolldelay="1">
<div class="wpmd">
<div><font class="ws9" color="#666699"><B><BR></B></font></div>
<div><font class="ws9" color="#666699"> 'Phrase qui tourne'</font></div>
<div><font class="ws9" color="#666699"><BR></font></div>
</div></marquee>
</div> ';
I try this:
while($row = mysql_fetch_array($result)) {
echo '<div id="marquee1" style="position:absolute; overflow:hidden; left:19px; top:377px; width:300px; height:108px; z-index:7">
<marquee width="300" height="108" direction="Up" scrolldelay="1">
<div class="wpmd">
<div><font class="ws9" color="#666699"><B><BR></B></font></div>
<div><font class="ws9" color="#666699"> '.substr(html_entity_decode($row['description']), 0, 10).'</font></div>
<div><font class="ws9" color="#666699"><BR></font></div>
</div></marquee>
</div> ';
}
il a affiché tous les lignes ensembles,
comment dois je faire?
merci
j'ai besoin de défiler plusieurs ligne en mysql :
<div id="marquee1" style="position:absolute; overflow:hidden; left:19px; top:377px; width:300px; height:108px; z-index:7">
<marquee width="300" height="108" direction="Up" scrolldelay="1">
<div class="wpmd">
<div><font class="ws9" color="#666699"><B><BR></B></font></div>
<div><font class="ws9" color="#666699"> 'Phrase qui tourne'</font></div>
<div><font class="ws9" color="#666699"><BR></font></div>
</div></marquee>
</div> ';
I try this:
while($row = mysql_fetch_array($result)) {
echo '<div id="marquee1" style="position:absolute; overflow:hidden; left:19px; top:377px; width:300px; height:108px; z-index:7">
<marquee width="300" height="108" direction="Up" scrolldelay="1">
<div class="wpmd">
<div><font class="ws9" color="#666699"><B><BR></B></font></div>
<div><font class="ws9" color="#666699"> '.substr(html_entity_decode($row['description']), 0, 10).'</font></div>
<div><font class="ws9" color="#666699"><BR></font></div>
</div></marquee>
</div> ';
}
il a affiché tous les lignes ensembles,
comment dois je faire?
merci
Configuration: Windows XP Internet Explorer 7.0
1 réponse
-
Bonjour,
j'ai trouvé ceci
<?php
include ("database.php");
$arrValue=10;
$chercheServ = mysql_query("SELECT * FROM `files` ORDER BY `files`.`index_files` DESC LIMIT 0 , 3 ");
$ServArray = array ();
while($servicetab= mysql_fetch_array($chercheServ)) {
$ServNom = $servicetab[1];
$ServId = $servicetab[0];
array_unshift ($ServArray, $servicetab[5]);
// array_push($ServArray,$ServNom);
}
//echo ($ServArray[1]);
/*
for($i=0; $i<10; $i++){
echo $i.$j.$result[$i][$j] ;
echo '<br>';
$j++;
}
echo $description[1][1];
echo '<br>';
*/
?>
<script language="JavaScript1.2">
//Translucent scroller- By Dynamic Drive
//For full source code and more DHTML scripts, visit http://www.dynamicdrive.com
//This credit MUST stay intact for use
//var scroller_width='150px'
var scroller_width='550px'
var scroller_height='100px'
//var scroller_height='115px'
var bgcolor='#E0EFD1'
var pause=3000 //SET PAUSE BETWEEN SLIDE (3000=3 seconds)
var scrollercontent=new Array()
//Define scroller contents. Extend or contract array as needed
/*
scrollercontent[0]='Visit our partner site <a href="http://freewarejava.com">Freewarejava.com </a>for free Java applets!'
scrollercontent[1]='Got JavaScript? <a href="http://www.javascriptkit.com">JavaScript Kit</a> is the most comprehensive JavaScript site online.'
scrollercontent[2]='Link to Dynamic Drive on your site. Please visit our <a href="http://www.dynamicdrive.com/link.htm">links page</a>.'
*/
//var test=<?php echo $servicetab[1] ?>
scrollercontent[0]=<?php echo $servicetab[1] ?>
//scrollercontent[1]='Got JavaScript? <a href="http://www.javascriptkit.com">JavaScript Kit</a> is the most comprehensive JavaScript site online.'
//scrollercontent[0]=' <?php echo substr(html_entity_decode($description[1]), 0, 104) . " ..." ?>';
/*scrollercontent[1]='<?php echo $result[1][1] ?>';
scrollercontent[2]='<?php echo $result[2][2] ?>';
*/
////NO need to edit beyond here/////////////
var ie4=document.all
var dom=document.getElementById&&navigator.userAgent.indexOf("Opera")==-1
if (ie4||dom)
document.write('<div style="position:relative;width:'+scroller_width+';height:'+scroller_height+';overflow:hidden"><div id="canvas0" style="position:absolute;background-color:'+bgcolor+';width:'+scroller_width+';height:'+scroller_height+';top:'+scroller_height+';filter:alpha(opacity=20);-moz-opacity:0.2;"></div><div id="canvas1" style="position:absolute;background-color:'+bgcolor+';width:'+scroller_width+';height:'+scroller_height+';top:'+scroller_height+';filter:alpha(opacity=20);-moz-opacity:0.2;"></div></div>')
else if (document.layers){
document.write('<ilayer id=tickernsmain visibility=hide width='+scroller_width+' height='+scroller_height+' bgColor='+bgcolor+'><layer id=tickernssub width='+scroller_width+' height='+scroller_height+' left=0 top=0>'+scrollercontent[0]+'</layer></ilayer>')
}
var curpos=scroller_height*(1)
var degree=10
var curcanvas="canvas0"
var curindex=0
var nextindex=1
function moveslide(){
if (curpos>0){
curpos=Math.max(curpos-degree,0)
tempobj.style.top=curpos+"px"
}
else{
clearInterval(dropslide)
if (crossobj.filters)
crossobj.filters.alpha.opacity=100
else if (crossobj.style.MozOpacity)
crossobj.style.MozOpacity=1
nextcanvas=(curcanvas=="canvas0")? "canvas0" : "canvas1"
tempobj=ie4? eval("document.all."+nextcanvas) : document.getElementById(nextcanvas)
tempobj.innerHTML=scrollercontent[curindex]
nextindex=(nextindex<scrollercontent.length-1)? nextindex+1 : 0
setTimeout("rotateslide()",pause)
}
}
function rotateslide(){
if (ie4||dom){
resetit(curcanvas)
crossobj=tempobj=ie4? eval("document.all."+curcanvas) : document.getElementById(curcanvas)
crossobj.style.zIndex++
if (crossobj.filters)
document.all.canvas0.filters.alpha.opacity=document.all.canvas1.filters.alpha.opacity=20
else if (crossobj.style.MozOpacity)
document.getElementById("canvas0").style.MozOpacity=document.getElementById("canvas1").style.MozOpacity=0.2
var temp='setInterval("moveslide()",50)'
dropslide=eval(temp)
curcanvas=(curcanvas=="canvas0")? "canvas1" : "canvas0"
}
else if (document.layers){
crossobj.document.write(scrollercontent[curindex])
crossobj.document.close()
}
curindex=(curindex<scrollercontent.length-1)? curindex+1 : 0
}
function resetit(what){
curpos=parseInt(scroller_height)*(1)
var crossobj=ie4? eval("document.all."+what) : document.getElementById(what)
crossobj.style.top=curpos+"px"
}
function startit(){
crossobj=ie4? eval("document.all."+curcanvas) : dom? document.getElementById(curcanvas) : document.tickernsmain.document.tickernssub
if (ie4||dom){
crossobj.innerHTML=scrollercontent[curindex]
rotateslide()
}
else{
document.tickernsmain.visibility='show'
curindex++
setInterval("rotateslide()",pause)
}
}
if (ie4||dom||document.layers)
window.onload=startit
</script>
mais le prob;
vient dans Bonjour,
j'ai trouvé ceci
<?php
include ("database.php");
$arrValue=10;
$chercheServ = mysql_query("SELECT * FROM `files` ORDER BY `files`.`index_files` DESC LIMIT 0 , 3 ");
$ServArray = array ();
while($servicetab= mysql_fetch_array($chercheServ)) {
$ServNom = $servicetab[1];
$ServId = $servicetab[0];
array_unshift ($ServArray, $servicetab[5]);
// array_push($ServArray,$ServNom);
}
//echo ($ServArray[1]);
/*
for($i=0; $i<10; $i++){
echo $i.$j.$result[$i][$j] ;
echo '<br>';
$j++;
}
echo $description[1][1];
echo '<br>';
*/
?>
<script language="JavaScript1.2">
//Translucent scroller- By Dynamic Drive
//For full source code and more DHTML scripts, visit http://www.dynamicdrive.com
//This credit MUST stay intact for use
//var scroller_width='150px'
var scroller_width='550px'
var scroller_height='100px'
//var scroller_height='115px'
var bgcolor='#E0EFD1'
var pause=3000 //SET PAUSE BETWEEN SLIDE (3000=3 seconds)
var scrollercontent=new Array()
//Define scroller contents. Extend or contract array as needed
/*
scrollercontent[0]='Visit our partner site <a href="http://freewarejava.com">Freewarejava.com </a>for free Java applets!'
scrollercontent[1]='Got JavaScript? <a href="http://www.javascriptkit.com">JavaScript Kit</a> is the most comprehensive JavaScript site online.'
scrollercontent[2]='Link to Dynamic Drive on your site. Please visit our <a href="http://www.dynamicdrive.com/link.htm">links page</a>.'
*/
//var test=<?php echo $servicetab[1] ?>
scrollercontent[0]=<?php echo $servicetab[1] ?>
//scrollercontent[1]='Got JavaScript? <a href="http://www.javascriptkit.com">JavaScript Kit</a> is the most comprehensive JavaScript site online.'
//scrollercontent[0]=' <?php echo substr(html_entity_decode($description[1]), 0, 104) . " ..." ?>';
/*scrollercontent[1]='<?php echo $result[1][1] ?>';
scrollercontent[2]='<?php echo $result[2][2] ?>';
*/
////NO need to edit beyond here/////////////
var ie4=document.all
var dom=document.getElementById&&navigator.userAgent.indexOf("Opera")==-1
if (ie4||dom)
document.write('<div style="position:relative;width:'+scroller_width+';height:'+scroller_height+';overflow:hidden"><div id="canvas0" style="position:absolute;background-color:'+bgcolor+';width:'+scroller_width+';height:'+scroller_height+';top:'+scroller_height+';filter:alpha(opacity=20);-moz-opacity:0.2;"></div><div id="canvas1" style="position:absolute;background-color:'+bgcolor+';width:'+scroller_width+';height:'+scroller_height+';top:'+scroller_height+';filter:alpha(opacity=20);-moz-opacity:0.2;"></div></div>')
else if (document.layers){
document.write('<ilayer id=tickernsmain visibility=hide width='+scroller_width+' height='+scroller_height+' bgColor='+bgcolor+'><layer id=tickernssub width='+scroller_width+' height='+scroller_height+' left=0 top=0>'+scrollercontent[0]+'</layer></ilayer>')
}
var curpos=scroller_height*(1)
var degree=10
var curcanvas="canvas0"
var curindex=0
var nextindex=1
function moveslide(){
if (curpos>0){
curpos=Math.max(curpos-degree,0)
tempobj.style.top=curpos+"px"
}
else{
clearInterval(dropslide)
if (crossobj.filters)
crossobj.filters.alpha.opacity=100
else if (crossobj.style.MozOpacity)
crossobj.style.MozOpacity=1
nextcanvas=(curcanvas=="canvas0")? "canvas0" : "canvas1"
tempobj=ie4? eval("document.all."+nextcanvas) : document.getElementById(nextcanvas)
tempobj.innerHTML=scrollercontent[curindex]
nextindex=(nextindex<scrollercontent.length-1)? nextindex+1 : 0
setTimeout("rotateslide()",pause)
}
}
function rotateslide(){
if (ie4||dom){
resetit(curcanvas)
crossobj=tempobj=ie4? eval("document.all."+curcanvas) : document.getElementById(curcanvas)
crossobj.style.zIndex++
if (crossobj.filters)
document.all.canvas0.filters.alpha.opacity=document.all.canvas1.filters.alpha.opacity=20
else if (crossobj.style.MozOpacity)
document.getElementById("canvas0").style.MozOpacity=document.getElementById("canvas1").style.MozOpacity=0.2
var temp='setInterval("moveslide()",50)'
dropslide=eval(temp)
curcanvas=(curcanvas=="canvas0")? "canvas1" : "canvas0"
}
else if (document.layers){
crossobj.document.write(scrollercontent[curindex])
crossobj.document.close()
}
curindex=(curindex<scrollercontent.length-1)? curindex+1 : 0
}
function resetit(what){
curpos=parseInt(scroller_height)*(1)
var crossobj=ie4? eval("document.all."+what) : document.getElementById(what)
crossobj.style.top=curpos+"px"
}
function startit(){
crossobj=ie4? eval("document.all."+curcanvas) : dom? document.getElementById(curcanvas) : document.tickernsmain.document.tickernssub
if (ie4||dom){
crossobj.innerHTML=scrollercontent[curindex]
rotateslide()
}
else{
document.tickernsmain.visibility='show'
curindex++
setInterval("rotateslide()",pause)
}
}
if (ie4||dom||document.layers)
window.onload=startit
</script>
mais le prob vient dans mysql_fetch_array,, et dans scrollercontent[0]=<?php echo $servicetab[1] ?>
il m'affiche : Chaine incomplete
que pensez vous, merci
