Member Avatar for lerix20
lerix20 0 Newbie Poster

Hello Guys,

Please i have finding it very hard to convert this javascript snippet to php where values or content can be retrieved from DB. SELECT SQL Statement to retrieve the value from the DB is listed below. I also attached an external script (scroller.js) to make the scroller run. Please any help....Will be grateful.

<script type="text/javascript">                                                                                      var pausecontent=new Array()                    

        pausecontent[0]='<p align="justify"></p><p style="text-align: justify; font: 13px candara; line-height: 19px; margin-top: -20px;"><span style="font: bold 15px Trebuchet MS">06-02-12</span> <span style="font-size: 17px;"><strong>-</strong></span> <strong>Id-el Maulud Celebrations....</strong> The school will be closed on Monday 6th February 2012 to observe the public holiday marking the Id-el Maulud celebration.</p><div class="read_more"></div><br />'

        pausecontent[1]='<p align="justify"></p><p style="text-align: justify; font: 13px candara; line-height: 19px; margin-top: -20px;"><span style="font: bold 15px Trebuchet MS">18-02-12</span> <span style="font-size: 17px;"><strong>-</strong></span> General PTA Meeting and Parents Day celebration will come up on Saturday 18-2-12 within the school premises. Time: 10a.m-12 noon (General PTA Meeting) and 12.15 - 3p.m (Parents Day). <br />Please plan to attend.</p><div class="read_more"></div><br />'

        pausecontent[2]='<p align="justify"></p><p style="text-align: justify; font: 13px candara; line-height: 19px; margin-top: -20px;"><span style="font: bold 15px Trebuchet MS">02-01-12</span> <span style="font-size: 17px;"><strong>-</strong></span> <strong>Book Care</strong>: We do prefer that all books be kept in the school during holidays to minimize loss and damage. Please  kindly return all books to school after examination at the end of each term and make specific request for books you wish to keep at home, especially BEC 4-6. Visit <strong><em>THE COMMUNITY LEISURE LIBRARY, <span style="font-size: 11px;">House 336, Phase 3 (Near One Nigeria) Gwagwalada, Abuja</span></em></strong>, with assorted books for all reading pleasure.  </p><div class="read_more"></div><br />'

        pausecontent[3]='<p align="justify"></p><p style="text-align: justify; font: 13px candara; line-height: 19px; margin-top: -20px;"><span style="font: bold 15px Trebuchet MS">02-01-12</span> <span style="font-size: 17px;"><strong>-</strong></span> <strong>Bulk S.M.S:</strong>Once again we request that parents who do not recieve text messages from the school should endeavour and please send the following information: <p align="justify" style="font: bold 13px candara; margin-top: -13px; line-height: 18px;">(Jewels Name - Class - Parents telephone number (active))&nbsp;&nbsp; to <strong style=" font-size: 14px;">&nbsp;&nbsp;07035646471</strong> </p><p align="justify" style="font: bold 12px candara; margin-top: -4px; line-height: 18px;">N/B: Please do not send VISAFONE numbers. !!!</p></p><div class="read_more"></div><br />'

    pausecontent[4]='<p align="justify"></p><p style="text-align: justify; font: 13px candara; line-height: 19px; margin-top: -20px;"><span style="font: bold 15px Trebuchet MS">18-01-12</span> <span style="font-size: 17px;"><strong>-</strong></span> <strong>"Resumption 2012":</strong> Our sincere apologies on the adjustment of our resumption date from Monday 16th January to Monday 23rd January 2012. This was due to the recent National Events. Eagerly waiting to see our Jewels.</p><div class="read_more"></div><br />'



//new pausescroller(name_of_message_array, CSS_ID, CSS_classname, pause_in_miliseconds)

new pausescroller(pausecontent, "pscroller1", "someclass", 11000)                                               
</script>

<?php

$query = "select * from table ORDER BY ID";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result_banner))
{
    $id = $row['ID'];                       
    $,,, = $row[',,,'];     

echo '<a href="#"><img src='.$,,,.' width="631" height="243" /></a>';


?>

Please help this code has been giving some headache, it might be am concatenating the script well.

Thanks and Best Regards

/***********************************************
* Pausing up-down scroller-  Dynamic Drive (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit http://www.dynamicdrive.com/ for this script and 100s more.
***********************************************/

function pausescroller(content, divId, divClass, delay){
this.content=content //message array content
this.tickerid=divId //ID of ticker div to display information
this.delay=delay //Delay between msg change, in miliseconds.
this.mouseoverBol=0 //Boolean to indicate whether mouse is currently over scroller (and pause it if it is)
this.hiddendivpointer=1 //index of message array for hidden div
document.write('<div id="'+divId+'" class="'+divClass+'" style="position: relative; overflow: hidden"><div class="innerDiv" style="position: absolute; width: 100%" id="'+divId+'1">'+content[0]+'</div><div class="innerDiv" style="position: absolute; width: 100%; visibility: hidden" id="'+divId+'2">'+content[1]+'</div></div>')
var scrollerinstance=this
if (window.addEventListener) //run onload in DOM2 browsers
window.addEventListener("load", function(){scrollerinstance.initialize()}, false)
else if (window.attachEvent) //run onload in IE5.5+
window.attachEvent("onload", function(){scrollerinstance.initialize()})
else if (document.getElementById) //if legacy DOM browsers, just start scroller after 0.5 sec
setTimeout(function(){scrollerinstance.initialize()}, 500)
}

// -------------------------------------------------------------------
// initialize()- Initialize scroller method.
// -Get div objects, set initial positions, start up down animation
// -------------------------------------------------------------------

pausescroller.prototype.initialize=function(){
this.tickerdiv=document.getElementById(this.tickerid)
this.visiblediv=document.getElementById(this.tickerid+"1")
this.hiddendiv=document.getElementById(this.tickerid+"2")
this.visibledivtop=parseInt(pausescroller.getCSSpadding(this.tickerdiv))
//set width of inner DIVs to outer DIV's width minus padding (padding assumed to be top padding x 2)
this.visiblediv.style.width=this.hiddendiv.style.width=this.tickerdiv.offsetWidth-(this.visibledivtop*2)+"px"
this.getinline(this.visiblediv, this.hiddendiv)
this.hiddendiv.style.visibility="visible"
var scrollerinstance=this
document.getElementById(this.tickerid).onmouseover=function(){scrollerinstance.mouseoverBol=1}
document.getElementById(this.tickerid).onmouseout=function(){scrollerinstance.mouseoverBol=0}
if (window.attachEvent) //Clean up loose references in IE
window.attachEvent("onunload", function(){scrollerinstance.tickerdiv.onmouseover=scrollerinstance.tickerdiv.onmouseout=null})
setTimeout(function(){scrollerinstance.animateup()}, this.delay)
}


// -------------------------------------------------------------------
// animateup()- Move the two inner divs of the scroller up and in sync
// -------------------------------------------------------------------

pausescroller.prototype.animateup=function(){
var scrollerinstance=this
if (parseInt(this.hiddendiv.style.top)>(this.visibledivtop+5)){
this.visiblediv.style.top=parseInt(this.visiblediv.style.top)-5+"px"
this.hiddendiv.style.top=parseInt(this.hiddendiv.style.top)-5+"px"
setTimeout(function(){scrollerinstance.animateup()}, 50)
}
else{
this.getinline(this.hiddendiv, this.visiblediv)
this.swapdivs()
setTimeout(function(){scrollerinstance.setmessage()}, this.delay)
}
}

// -------------------------------------------------------------------
// swapdivs()- Swap between which is the visible and which is the hidden div
// -------------------------------------------------------------------

pausescroller.prototype.swapdivs=function(){
var tempcontainer=this.visiblediv
this.visiblediv=this.hiddendiv
this.hiddendiv=tempcontainer
}

pausescroller.prototype.getinline=function(div1, div2){
div1.style.top=this.visibledivtop+"px"
div2.style.top=Math.max(div1.parentNode.offsetHeight, div1.offsetHeight)+"px"
}

// -------------------------------------------------------------------
// setmessage()- Populate the hidden div with the next message before it's visible
// -------------------------------------------------------------------

pausescroller.prototype.setmessage=function(){
var scrollerinstance=this
if (this.mouseoverBol==1) //if mouse is currently over scoller, do nothing (pause it)
setTimeout(function(){scrollerinstance.setmessage()}, 100)
else{
var i=this.hiddendivpointer
var ceiling=this.content.length
this.hiddendivpointer=(i+1>ceiling-1)? 0 : i+1
this.hiddendiv.innerHTML=this.content[this.hiddendivpointer]
this.animateup()
}
}

pausescroller.getCSSpadding=function(tickerobj){ //get CSS padding value, if any
if (tickerobj.currentStyle)
return tickerobj.currentStyle["paddingTop"]
else if (window.getComputedStyle) //if DOM2
return window.getComputedStyle(tickerobj, "").getPropertyValue("padding-top")
else
return 0
}
Edited by Dani because: Formatting fixed
  • 1 Contributor
  • 0 Replies
  • 65 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.