Crear un scrolling text apartir de una bd mysql
  
(Nivel 1 - 3 posts) |
pero ahora quiero integrar las 2 cosas con un scrolling text tipo estes:
http://www.tutorialized.com/view/tut...scroller/12759 Ya consegui un effecto arrechisimo con texto simples pero no tengo idea de como integrar php en javascrip (AJAX). Se alguien puede echar una mano. Recuperar el texto de una db mysql y ponerlo en un scrolling text en un css background [img]http://img146.imageshack.us/img146/4879/dibujoxb0.png[/img] [img]http://img146.imageshack.us/img146/1787/statsfullwarwu1.png[/img] O sea juntar estos scripts: [CODE]<html> <head> <style type="text/css"> td{font-size: 9pt; color:maroon; } center{display: none;} .style1 { border-style: solid; border-width: 1px; background-color: #C0C0C0; } </style> </head> <body topmargin="0" leftmargin="-2" bgcolor="#000000"> <basefont size="-1" face="MS GOTHIC" color="maroon"> <table width="700" cellpadding="1" cellspacing="1"> <tr><td colspan="13"><b>Player Ranking TOP15</b> </td> </tr> <tr bordercolor="#C0C0C0" bgcolor="#C0C0C0"> <td align="center">rank</td> <!--<td class="row1" align="center"> authid</td>--> <td align="center">name</td> <td align="center">kills</td> <td align="center">deaths</td> <td align="center">score</td> <td align="center">hits</td> <td align="center">shots</td> <td align="center">hs</td> <td align="center">eff.</td> <td align="center">acc.</td> <td align="center">acc. hs</td> </tr> <?php // connect to the database server $hostname="localhost"; $mysqli_login="root"; $mysqli_password=""; $database="amx"; $link = mysql_connect($hostname, $mysqli_login, $mysqli_password); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Stats from server FULLWAR'; mysql_select_db("amx",$link);//database name. //ranking view. $i = 0; $result = mysql_query("SELECT * FROM statustable ORDER BY score DESC, kills DESC, accuracy DESC"); if ($myrow = mysql_fetch_array($result)) { do{ if($i > 14){ break;} $i++; printf("<tr><td><h4> %s</h4></td><td>%s</td><td align='right'>%s</td><td align='right'>%s</td><td align='right'>%s</td><td align='right'>%s</td><td align='right'>%s</td><td align='right'>%s</td><td align='right'>%1.2f%%</td><td align='right'>%1.2f%%</td><td align='right'>%1.2f%%</td></tr> ",$i,$myrow["name"],$myrow["kills"],$myrow["deaths"],$myrow["score"],$myrow["hits"],$myrow["shots"],$myrow["headshots"],$myrow["efficiency"],$myrow["accuracy"],$myrow["accuracyHS"]); } while ($myrow = mysql_fetch_array($result)); } ?></table> </body></html>[/CODE] [CODE]<style type="text/css"> /*Example CSS for the two demo scrollers*/ #pscroller1{ width: 700px; height: 300px; //border: 1px solid black; //padding: 0 px; background-image: url(http://img146.imageshack.us/img146/1787/statsfullwarwu1.png); } #pscroller2{ width: 350px; height: 20px; border: 1px solid black; padding: 3px; } #pscroller2 a{ text-decoration: none; } .someclass{ //class to apply to your scroller(s) if desired } </style> <script type="text/javascript"> /*Example message arrays for the two demo scrollers*/ var pausecontent=new Array() pausecontent[0]='<a href="http://www.javascriptkit.com">JavaScript Kit</a><br />Comprehensive JavaScript tutorials and over 400+ free scripts!' pausecontent[1]='<a href="http://www.codingforums.com">Coding Forums</a><br />Web coding and development forums.' pausecontent[2]='<a href="http://www.cssdrive.com" target="_new">CSS Drive</a><br />Categorized CSS gallery and examples.' var pausecontent2=new Array() pausecontent2[0]='<a href="http://www.news.com">News.com: Technology and business reports</a>' pausecontent2[1]='<a href="http://www.cnn.com">CNN: Headline and breaking news 24/7</a>' pausecontent2[2]='<a href="http://news.bbc.co.uk">BBC News: UK and international news</a>' /*********************************************** * 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.offsetWidt h-(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.onmouseou t=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 } </script> <script type="text/javascript"> //new pausescroller(name_of_message_array, CSS_ID, CSS_classname, pause_in_miliseconds) new pausescroller(pausecontent, "pscroller1", "someclass", 3000) document.write("<br />") </script>[/CODE] |
