...

View Full Version : PHP TEXT Rotate



infinity0
07-13-2012, 06:58 PM
Hi, I'm making a text rotator that rotates text.
The original script is here:http://www.javascriptbank.com/random-text-rotator-script.html/en/

My php for selecting from the database is here:

<?php
date_default_timezone_set('America/Denver');
include("config.php");
// Assuming `when` is a real DATE or DATETIME data type in MySQL...
// compare to CURDATE() to get today's
$result = mysql_query("SELECT * FROM events WHERE `when` = CURDATE() ORDER BY RAND() LIMIT 6");
if($result === FALSE) {
die(mysql_error()); // TODO: better error handling
}

if ($result) {
// array to hold all the output
$events = array();
while ($row = mysql_fetch_assoc($result)) {
// Add the event to your array
$events[] = $row['tag'];
}
// After building the array, encode it as JSON
// Later you'll echo this into your JavaScript in place of the array...
$events = json_encode($events);
}
?>

which when $events is printed out, for example would give ["Halloween","Christmas"]

My javascript is:


<script>
function rotateEvery(sec)
{
// The JSON from PHP output here
// Would look something like
// ["Event 1","Event 2","Event 3"]
var Quotations = <?php echo $events; ?>;

var which = Math.round(Math.random()*(Quotation.length - 1));
document.getElementById('textrotator').innerHTML = Quotation[which];

setTimeout('rotateEvery('+sec+')', sec*1000);
}
</script>
but its not working. What's happening?

Fou-Lu
07-13-2012, 09:12 PM
Is this condition true?


// The JSON from PHP output here
// Would look something like
// ["Event 1","Event 2","Event 3"]
var Quotations = <?php echo $events; ?>;


If Quotations appears correctly in the generated source, this is not a PHP issue.

firepages
07-14-2012, 01:10 AM
var Quotations = <?php echo $events; ?>;
document.getElementById('textrotator').innerHTML = Quotation[which];

are those the same variable ?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum