PHP - Random File Name

My images generator comprises an array of image names extracted form an images table from a database using a select statement a random number generator, and a string that builds the correct pathname for the selected file. To select one of the images for display, i generate a random number between 1 and the length of the array. Though the generator is working, I noticed one of the random numbers is throwing up this error: Warning: getimagesize(images/): failed to open stream: No such file or directory in An inspection of the array reveals 2 array elements (representing my number of images) but one array element is NULL ( the first entry in the banner table   image_generator.php

require_once('connection.inc.php');
    $sql = 'SELECT `filename` FROM  banner';
    $result = $mysqli->query($sql, MYSQLI_STORE_RESULT) or die(mysqli_error());
    $row = $result->fetch_array(MYSQLI_ASSOC);//an array of image names
    $count = $result->num_rows;
    for ($i = 1; $i <= $count; ++$i) 
    {
       $row[$i] = $result->fetch_array(MYSQLI_ASSOC);
    }
    $i = rand(1, $count); //a random number generator,
       //The random number is used in the final line to build the correct pathname for the selected file.
       $selectedImage = "images/{$row[$i]['filename']}"; 
      if (file_exists($selectedImage) && is_readable($selectedImage)) 
      {
        $imageSize = getimagesize($selectedImage);
      }

var_dump($row)

array (size=1)
    'filename' => string 'ginsomin2.jpg' (length=13)
    null

RANDON IMAGE DISPLAY

require_once 'image_generator.php';
<div id="banner" class="wrapper clearfix">
      <img src="<?php echo $selectedImage; ?>" alt="banner">
   </div>

Kindly advice how i may proceed from here? Thanks.

As above,

I have a lottery style site that picks a random number between 1-8 but my users complain for some reason that this is not enough.

So i was told to look into using fopen and random.org to generate a random number.

Anyone have experience of this and perhaps a code snippet for me to look at and possibly use?

help will be appreciated.

how to get the name of the file including a file from the included file,

This one has me mixed up a bit.. I am trying to record site activity information from a common.php file using a user object. But since the file is included into different php files based on different situations I need a dynamic way of finding the file name that is including it. I could be over complicating things but right now this seems like the best solution other wise I'll have to rewrite the code on every page i write. Is there a function for doing this? Or if someone gets what I'm trying to do if they could point me to the direction of some more information on it.

Thanks.

I know this is not coding.. However...
How tolerant is PHP from generating a random output from 1000s of entry columns in a mysql database.
I would like to make a script that would potentially pick one of a 1000 results at random.
is this a problem with being ran multiple times?

how do I pull out two random integers at the same time without ever possibly choosing the same integer twice?

Im trying to figure out the best way to random a line from a text file and after the random delete that line from the file. This way the same username cannot be picked twice thanks for any input

Im Am Trying To Display A Random Image Every Time The Page Refreshs
i dont know if this will help???
<?php

/*

User Pets (user_pets.php)

*/

$rank_check = 1;
$page_title = "User Pets";
include "header.inc.php";

print $openHTML;

$array = fetch("SELECT * FROM user_pets2 WHERE id = '$id' AND game = '$game'");

if (!$array[id])
{
    die("<p align=center class=error>That is not a real pet</p>$closeHTML");
}

if ($array[pet_desc])
{
    $petNote = "<tr><td colspan=2><p align=center><font size=-1><i>$array[pet_desc]</i></font></p></td></tr>";
}

print "<center><table>$petNote<tr>
<td width=200>
";

$id = $array[id];
$getPet = fetch("SELECT * FROM pets2 WHERE id = '$array[species]' AND game = '$game'");
$getOwner = fetch("SELECT display_name,username FROM members2 WHERE id = '$array[owner]' AND game = '$game'");

$image = "pet_$getPet[id]";

if ($array[wearing] != 0)
{
    $findLook = fetch("SELECT * FROM pet_looks WHERE change_from = '$array[species]' AND item_name = '$array[wearing]'");

    if ($findLook[id])
    {
        $image = "pet2_$findLook[id]";
    }
}

$hunger = $array[$hunger];

$hungerLevel = $hungerArray[$hunger];

if (($array[hunger] > 10) OR ($array[hunger] < 0)) { $hungerLevel = "Unknown ($array[hunger])"; }

$percentHealth = ($array[current_hp] / $array[max_hp]) * 100;
if ($percentHealth > 0)
{
    $healthLine = "<font color=red>$array[current_hp]/$array[max_hp]</font>";
}
if ($percentHealth > 35)
{
    $healthLine = "<font color=orange>$array[current_hp]/$array[max_hp]</font>";
}
if ($percentHealth > 75)
{
    $healthLine = "<font color=green>$array[current_hp]/$array[max_hp]</font>";
}

ECHO <<<END

<br>
<CENTER><TABLE BGCOLOR="#$tableOutline" CELLSPACING=1 CELLPADDING=0 WIDTH=400>
   <tr>
   <td colspan=2 bgcolor=#$topAndBottomBG><font color=#$topAndBottomText><b>View Pet:</b></font></td></tr>
   <TR>
      <TD BGCOLOR=#$middleBG>
         <p>
    <font size=-1>
    Name: $array[name]<br>
    Level: $array[level]<br>
    Experience: $array[experience]<br>
    Next Level: $nextLevel[$id]<br>
    Health: <b>$healthLine</b><br>
    Strength: $array[strength]<br>
    Intelligence: $array[intelligence]<br>
    Speed: $array[speed]<br>
    Defense: $array[defense]<br>
    Hunger: $hungerLevel<Br>
    </font>
    </p>

    <p>
    <font size=-1>
    1-Player Wins: $array[one_p_wins]<br>
    1-Player Loses: $array[one_p_loses]
    </font>
    </p>

      </TD>
      <TD WIDTH=175 BGCOLOR=#FFFFFF>
         <p align=center>
    <img src=$base_url/images/user_images/opg_$game/pets/$image.gif border=1>
    <br><a href=view_pet.php?id=$array[id]&game=$game><b>$array[name]</b> the $getPet[name]!$petNote[$id]</a></P>    <p align=center>$attitude[$id]</p>
      </TD>
   </TR>
</TABLE>
</CENTER>

<p align=center><a href=user_profile.php?game=$game&user=$getOwner[username]>Back to $getOwner[display_name]'s Profile!</a></p>

END;

print "$closeHTML";

?>
Please Help Me
Jackthumper

Is there anyway in MySQL you can select a random record in a table?  I normally do this by generating a random number first and then using that number to find a record but was wondering if there is an easier way.  Thanks for any help. 

i wanted to choose 5 random numbers from 0-20. each number represents an index in an array. is there a way to pick out 5 random items from the array. say if random number generator piked a number 22, the last item in the array is at index 20, it wud then have to go to index 0.

thanks!

I need some help working out this MySQL query:   I need it to pull a random quote, that hasn't been used before (that's the 'checked' part of the query), and it needs to find it based on a specific category. I am using this alongside PHP with MySQLI Prepared method.  

SELECT `id`, `word`, `def` FROM `dictionary` AS `r1` JOIN (SELECT (RAND() * (SELECT MAX(`id`) FROM `dictionary`)) AS `id`) AS `r2` WHERE `r1`.`id` >= `r2`.`id` AND `category`=? AND `checked`=0 ORDER BY `r1`.`id` ASC LIMIT 1

  This query yields an error stating that the id column is ambiguous. 

This is going to be tricky for everyone but here is goes. I have a random image function however I want the image attatched to a link that will go to the person's bio page. Even if I query anything how can I make sure that it matches up with what the right link person.

<a href="bio/".$shortname.""><img src="images/spotlight/<?php randlogo(); ?>" alt=".::Spotlight A KOW Superstar::." /></a>

<?php
function randlogo(){
$img = array();
if($handle = opendir('images/spotlight/')) {
$count = 0;
while (false !== ($file = readdir($handle))) {
if(strlen($file) > 2){
$img[$count] = $file;
$count++;
}
}
}
echo $img[rand(0, (count($img)-1))];
} 
?>

It's working great, but at some points after one of the random events goes through, I reload the page and it either gives me or takes away some starpoints without showing the message.. but it shows the message all the other times.
Could someone help me debug this and see why it's doing that?

Code: [Select]
<?php
include("config.php");

//To change the odds, change the second number in the rand() function.
$rand = rand(1,3);
if($rand == 1)
{
$sql = "SELECT * FROM randomevents WHERE rarity <= '10'";
$result = mysqli_query($cxn, $sql);
//Write the events in here with the opener: $event[] = "#your event#";
while ($row = mysqli_fetch_assoc($result))
{
$event[] = $row['phrase'];
}

//This will pick a random event and show it
$renum = rand(0,count($event));
$display = $event[$renum];

if ($display == "")
{
$eventdisplay = "";
}
else
{
$eventdisplay = "<table cellspacing=\"0\" class=\"events\" align=\"center\"><br>
<tr><br>
<td><center><b><h1>Random Event</h1></b></center></td><br>
</tr><br>
<tr><br>
<td><img src=\"".$_SERVER['SCRIPT_NAME']."\">
<p><center>".$display."</center></p><br>
</td><br>
</table><br>";

$sql = "SELECT type FROM randomevents WHERE phrase='".$display."'";
$result = mysqli_query($cxn, $sql);
$row = mysqli_fetch_assoc($result);
if ($row['type'] == "gainsp")
{
$rand = rand(200,500);
$sql = "UPDATE members SET starpoints = starpoints+$rand WHERE userid='".$_SESSION['userid']."'";
mysqli_query($cxn, $sql) or die("Query died: updating starpoints");
}
elseif ($row['type'] == "losesp")
{
$rand = rand(50,100);
$sql = "UPDATE members SET starpoints = starpoints-$rand WHERE userid='".$_SESSION['userid']."'";
mysqli_query($cxn, $sql) or die("Query died: updating starpoints");
}
else
{}
}
}
else
{
$eventdisplay = "";
}
?>

Alright, I have a random thing going on. Works perfectly fine. This is the code:

Code: [Select]
<?php
include("config.php");

//To change the odds, change the second number in the rand() function.
$rand = floor(rand(0,1));
if($rand == 1)
{
$sql = "SELECT * FROM randomevents WHERE rarity <= '10'";
$result = mysqli_query($cxn, $sql);
while ($row = mysqli_fetch_assoc($result))
{
$event[] = $row['phrase'];
if ($row['type'] == 'gainsp')
{
$rand = rand(200,500);
$sql = "UPDATE members SET starpoints = starpoints+$rand WHERE userid='".$_SESSION['userid']."'";
mysqli_query($cxn, $sql) or die("Query died: updating starpoints");
}
}

//This will pick a random event and show it
$renum = floor(rand(0,count($event)));

$eventdisplay = $event[$renum];
}
?>
In the database, I have the phrases set as:
"You have gained {$rand} starpoints!".
How do you make that variable echo out as the $rand I'm generating on this page?
It just keeps posting as is. When I went the {$rand} to display as the number I'm generating to set their starpoints to.
So I guess how do you hold a variable in the database?

Does anyone understand what I'm asking?
Here as an image to help understand:

Wow, I have no clue what I'm doing.. I'm trying to make a random game and if you roll a 6, you will win 500 rp and I'm trying to insert the 500 rp into the user who is logged in ($_SESSION['username'). But I... just don't know where to begin.

Here is my crappy coding that I just.. am stumped on:

<p><?php
$dice = rand(1,6);
if($dice == 1){
echo "You rolled a 
<br><b>1</b>";
}if($dice == 2){
echo "You rolled a
<br><b>2</b>";
}if($dice == 3){
echo "You rolled a
<br><b>3</b>";
}if($dice == 4){
echo "You rolled a
<br><b>4</b>";
}if($dice == 5){
echo "You rolled a
<br><b>5</b>";
}if($dice == 6){
echo "You rolled a
<br><b>6</b>";
}

$winner = "500";
if($dice == 6);
{
include("haha.php");
$cxn = mysqli_connect($dbhost,$dbuser,$dbpassword,$dbdatabase);
$sql = "INSERT INTO Member (rp) VALUES ('$winner')";
mysqli_query($cxn,$sql);
}
?>

Hi,

I'm having trouble generating random string with 8 characters, when I refresh I sometimes get
6 characters and sometimes 8. "-" not included as character.

Wrong:
6JW-F7W

Correct: (should always generate random like this)
DVMF-F36V

I know I'm trying to achieve this in wrong methods but it's the only way I know.
Hope someone can help.


function getReference() {
    $length = 8;
    $characters = "0123456789abcdefghijklmnopqrstuvwxyz"; 

    for ($p = 0; $p < $length; $p++) {
        $string .= $characters[mt_rand(0, strlen($characters))];
    }
    
    return strtoupper(substr($string, 0, -$length/2)."-".substr($string, $length/2-1, -1));
}