Don
Publicado por Juba_PornBorn (1 intervención) el 07/05/2008 04:52:58
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]
Now please How do I do this?
Remember I need a "For dummies tutorial".
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]
Now please How do I do this?
Remember I need a "For dummies tutorial".
Valora esta pregunta
0