PHP - Php Random From Mysql

Hi,
I'm a researcher (and complete coding noob), and am planning a longitudinal study that requires e-mail follow-up with subjects taking an initial survey. For purposes of ethics/anonymity due to sensitive survey data, I'd like the acquired e-mails to be saved uncoupled from the survey responses; this is simple to deal with, and I use a basic PHP e-mail form, which injects the email address in a table in MySQL in a different server than the one used for the survey.

The issue is that the e-mails are saved in the MySQL database in order of injection, thus it is still theoretically possible for me to link the e-mails back to the survey responses (which have a time stamp that I cannot remove).  Ideally I would like not to be able (at all) to link the e-mails to the survey responses, and one way to do that (since I don't save the e-mail injection timestamps in MySQL) might be to have the e-mails saved in MySQL in a random order. Not sure if this is possible, and not even sure if this would be via PHP or MySQL side of things. The server is on godaddy and uses Starfield interface for MySQL but I cannot find an option for random insert/saving of table items (emails). They are saved in order of injection.
Any solution for this?
Thanks,

the title sounds quite ridiculous but i dont know how else to put it...

i want to return results, but my site has got quite popular, quicker than i would have thought. i want to paginate the results.

but i want the results to appear at random.

but the results should not appear twice...

can this even be done? any questions...?

thanks!

Hi All,   I'm looking to update a mysql column weekly, where by 5 randomly selected rows are given a new random number, from between 1 and the num_rows / 5. This cycle is looped again until all the entries have a new random group for the week. It is to help mix up the players for teams for 5 aside. It needs to be able to accomodate the posibillity of the num_rows not dividing exactly by 5, using ceil perhaps?   As an example   Name Group  a 1 b 2 c 1 d 1 e 1 f 3 g 2 h 1 i 2 j 2 k 2   Then Next week Name Group  a 2 b 1 c 2 d 2 e 1 f 2 g 3 h 1 i 2 j 1 k 1   I hope that makes sense. It'll be automated via cron job. I've been really struggling with it, this is as far as I have got.   $totalgroupsraw = $num_rows /5;

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

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.

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?

is there a way to make a random number input into mysql?

like if i add a new customer to a table, i want to assign a random number to that customer.

Hi Guys

I have a code what inserts very simple queries to database, im trying to add a random reference number for each enrty using
$reference = rand(111111111111,999999999999);

but each time I add an entry it gives me the same random number previously generated for previous entry

can you help pleasE?

Okay, minor issue, but not sure how to resolve.  I have a form that processes through PHP and has it's fields validated with JS and sends the data to an e-mail address and a database. It works fine, but there are random times where a submitted entry will show up blank in the e-mail and not be in the database at all, any ideas on what might be causing this? Thanks.

The purpose of this function is to go to the characters table and grab all of the characters that have a statusID of one however I want it to limit it to any ONE of those characters as this is a random image it's going to show and then I want it to have that charactes shortName and then use it to find their spotlight image from inside of the images/spotlight folder. All its showing right now in its spot is the the filename of the image when I call this function.

function spotlight(){

$query = "SELECT * FROM characters WHERE characters.statusID = 1 LIMIT 1";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

$labels = array('shortName');
    $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))];
} 

here is the database:

its a facebook app

i want that my sql will choose every time random but considerate in the sex parameter.
i mean that if the user is boy i will put it in parameter and boys is num-1 girls-0
and if the user is boy it will run random sql just on the boys
and if its girls so random on the girls


here what i did:
$sql = "SELECT * FROM  pcm ORDER BY RAND() LIMIT 1";

  $Recordset3 = mysql_query($sql) or die(mysql_error());

  $row2 = mysql_fetch_object($Recordset3);

  print_r($row2);


but for some reason i get an error that the database is not selected

maybe i didnt select my database right?

please help tnx....

Hi Guys,

I have a php script to upload a photo to a mysql table. This works great, until someone uploads a file with the same name, then it replaces the old one. Bad times!

So Ive researched it and I have put a timestamp on the filename and it uploads with the correct timestamp in the images folder.

However the data that it uploads to the table is just the original filename, ie it doesnt stamp the filename in the table therefore they dont match...

Any ideas...

<?php 

include('config.php'); 
if (isset($_GET['Ter']) ) { 
$ter = (int) $_GET['Ter']; 
if (isset($_POST['submitted'])) {

//Photo Upload

//This is the directory where images will be saved
$name=time();
$target = "images/"; 
$target = $target .$name. basename( $_FILES['photo']['name']);
//This gets all the other information from the form 
$photo = ($_FILES['photo']['name']);
//Pause Photo Upload


foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); } 
$sql= "UPDATE `ter` SET `Ter` =  '{$_POST['Ter']}' , `BranchName` = '{$_POST['BranchName']}' ,  `BranchAddress` =  '{$_POST['BranchAddress']}' ,  `BranchTel` =  '{$_POST['BranchTel']}' , `BranchEmail` =  '{$_POST['BranchEmail']}' , `BranchLink` =  '{$_POST['BranchLink']}' , `Theme` =  '{$_POST['Theme']}' , `LocalInfo` =  '{$_POST['LocalInfo']}' , `BranchInfo` =  '{$_POST['BranchInfo']}' , `photo` =  '{$_FILES['photo']['name']}' WHERE `Ter` = '$ter' "; 

mysql_query($sql) or die(mysql_error()); 


//Unpause Photo Upload
//Writes the photo to the server 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{
//Tells you if its all ok
echo "<br />The file ". basename( $_FILES['photo']['name']). " has been uploaded. <br />";
}
else {
//Gives and error if its not
echo "";
} //End of Photo Upload

echo (mysql_affected_rows()) ? "<br />Edited Branch.<br />" : "<br />Nothing changed. <br />";  
} 
$row = mysql_fetch_array ( mysql_query("SELECT * FROM `ter` WHERE `Ter` = '$ter' "));
?>

Hi Everyone,

I was wondering if anyone could help me make this code I wrote better and a bit more readable and shorter.

I have 8 images on the home page so the php code is like this:

Code: [Select]
<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
$selectedImage1 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
$selectedImage2 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
        $selectedImage3 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
$selectedImage4 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
        $selectedImage5 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
$selectedImage6 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
$i = rand(0, count($images)-1);
        $selectedImage7 = "_images/showreel/{$images[$i]}.jpg";
?>

<?php
$images = array('image1', '8', 'image2', 'image7', 'image5', 'image4', '9', 'image6');
        $i = rand(0, count($images)-1);
$selectedImage8 = "_images/showreel/{$images[$i]}.jpg";
?>

And the HTML is like this:

Code: [Select]
<div id="slider1" class="nivoSlider">
<img src="<?php echo $selectedImage1; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage2; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage3; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage4; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage5; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage6; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage7; ?>" alt="John Richard Cleckheaton West Yorkshire" />
<img src="<?php echo $selectedImage8; ?>" alt="John Richard Cleckheaton West Yorkshire" />
</div>

I no this code is terrible but I am still learning. Just a few months ago I had never touched PHP. Any help would be greatly appreciated.

Regards

Barry

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:

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 = "";
}
?>