Rotating php insert text

[michaelsacca]

Hello, I'm new to this board but I had a question about inserting a rotating php insert script where the script could post text information (say a name) that would change each time the page is refreshed. 

[pocobueno1388]

You could do this

 

<?php

$query = mysql_query("SELECT name FROM users ORDER BY RAND() LIMIT 1")or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo $row['user'];

?>

[Fadion]

If you aren't aiming for a database approach (which in that case the above will work just great), u can use:

 

Array Approach

<?php
$names = array('php', 'mysql', 'html', 'xml', 'javascript'); //the array that stores all the names
$rand = rand(0, count($names) - 1); //generate a random index from 0 to the number of array items - 1
echo $names[$rand];
?>

 

or a file approach, supposing u have your text names comma separated in names.txt. The text file should look like: "php,mysql,html,xml,javascript"

<?php
$names = explode(',', file_get_contents('names.txt')); //get file content of 'names.txt' and explode the comma to pass all the names in an array
$rand = rand(0, count($names) - 1); //generate a random index, same concept as the above snippet
echo $names[$rand];
?>