PHP - What Am I Doing Wrong With Rand()?

Really need a hand from someone mysql query is pretty basic.

I have been ask to add a random order to this query.

 $query = "SELECT rd.user_id
            FROM {$regions_data_table} rd
            WHERE rd.field_id = {$regions_field_id} AND rd.value LIKE %s
                  AND rd.user_id NOT IN (SELECT um.user_id
                                         FROM {$wpdb->base_prefix}usermeta um
                                         WHERE ((um.meta_key='wp_ul_disabled' AND um.meta_value=1) OR (um.meta_key='wp_ul_inactive' AND um.meta_value=1))
                                         GROUP BY um.user_id)";

I have tried so many options but cannot seem to get it to work i am trying to insert order by rand().

Any help please?

Hi,   I'm having a bit of trouble. I want to order the same 9 results by RAND(). Currently I have them ordered by 'avg' (average views) and that's working fine, but when I add a sub query to make those 9 results scatter by random it's causing some trouble.   Code I currently have that works:

 
$sql = "SELECT *, views / HOUR(TIMEDIFF(NOW(), date)) as avg
    FROM content
    WHERE date BETWEEN CURDATE() - INTERVAL 30 DAY AND NOW() - INTERVAL 2 HOUR
    AND views > 600 
    AND live = '0'
    ORDER BY avg DESC
    LIMIT 9";
 

 

Hey guys,

I don't know what to do. I've got a script used for gamble:


$gamble_rand = rand($number_of_tickets,$gamble_chance);
if($gamble_chance == $gamble_rand){


If $number_of_tickets is set by 99 and $gamble_chance is set by 100 the chance is 1:100 that the If-Clause is not true. But it seems to me that PHP is making its on "random". Independent of the values PHP is interpreting that 20 times of 100 times the correct logic is false...

If $number_of_tickets is set by 1 there's no big different. Its just a little bit less, but not the chance that it has to be.

Thanks for helping and Merry Christmas :-)

I have 2 sites here that does what i need them to do but i dont know how to put the 2 codes together 

i got it to upload all files and used rand() to give the files a # but it ends up giving them all the same # lol so they overwrite them selfs lol


This site shows how to upload mltiple fiels with php.
http://www.ehow.com/how_6345068_upload-multiple-files-php.html


This site shows how to rename only 1 file uploaded with rand()
http://php.about.com/od/advancedphp/ss/rename_upload.htm


i pray this is not to hard to do and if any one gets bored after words can you show how to block a file type from being
uploaded ? like php/exe types

PS)i would call my self a php newbe lol and ty you for your time and help

Code from http://php.about.com/od/advancedphp/ss/rename_upload.htm

Code: [Select]
<form enctype="multipart/form-data" action="upload.php" method="POST">
Please choose a file: <input name="uploaded" type="file" /><br />
<input type="submit" value="Upload" />
</form>


//This function separates the extension from the rest of the file name and returns it 
function findexts ($filename)
{ $filename = strtolower($filename) ;
$exts = split("[/\\.]", $filename) ;
$n = count($exts)-1; $exts = $exts[$n];
return $exts;
}

//This applies the function to our file 
$ext = findexts ($_FILES['uploaded']['name']) ;

//This line assigns a random number to a variable. You could also use a timestamp here if you prefer. 
$ran = rand () ;
//This takes the random number (or timestamp) you generated and adds a . on the end, so it is ready of the file extension to be appended.
$ran2 = $ran.".";
//This assigns the subdirectory you want to save into... make sure it exists!
$target = "images/";
//This combines the directory, the random file name, and the extension
$target = $target . $ran2.$ext;
if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) {
echo "The file has been uploaded as ".$ran2.$ext; }
else {
echo "Sorry, there was a problem uploading your file.";
}
The code from http://www.ehow.com/how_6345068_upload-multiple-files-php.html

Code: [Select]
<form action="upload.php" method="post" enctype="multipart/form-data">
File: <input type="file" name="file[]"/><br/>
File: <input type="file" name="file[]"/><br/>
File: <input type="file" name="file[]"/><br/>
<input type="submit" name="submit" value="Upload"/>
</form>



$destpath = "upload/" ;


while(list($key,$value) = each($_FILES["file"]["name"])) {
if(!empty($value)){
f ($_FILES["file"]["error"][$key] > 0) {
echo "Error: " . $_FILES["file"]["error"][$key] . "<br/>" ;
}
else {
$source = $_FILES["file"]["tmp_name"][$key] ;
$filename = $_FILES["file"]["name"][$key] ;
move_uploaded_file($source, $destpath . $filename) ;
echo "Uploaded: " . $destpath . $filename . "<br/>" ;
}
}
}

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=326563.0

I want to use the following code to upload images to my server (below code works great)

Code: [Select]
<?php
$rand = rand(1,99999999999999);
$member_id = $_SESSION['SESS_MEMBER_ID'];

if(isset($_FILES['uploaded']['name']))
{
    $target = "gallery/";
$allowed_filetypes = array('.jpg','.gif','.bmp','.png');
$max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB) 
    $fileName = basename($_FILES['uploaded']['name']);
    $target = $target . $fileName;
$errors = array();

   // Get the extension from the filename.
   $ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); 
 
   // Check if the filetype is allowed.
   if(in_array($ext,$allowed_filetypes))
    {
         $errors[] = "The file you attempted to upload is not allowed.";
    }
    
// Now check the filesize.
   if(filesize($_FILES['uploaded']['tmp_name']) > $max_filesize)
    {
         $errors[] = "The file you attempted to upload is too large.";
    }
  
    // Check if we can upload to the specified path.
   if(is_writable($target))
    {
         $errors[] = "You cannot upload to the specified directory, please CHMOD it to 777.";
    }
 
    //Here we check that no validation errors have occured.
    if(count($errors)==0)
    {

//Try to upload it.
        if(!move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))
        {
            $errors[] = "Sorry, there was a problem uploading your file.";
        }
    }
    
    //If no errors show confirmation message
    if(count($errors)==0)
    {
         echo "<div class='notification success png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
The file {$fileName} has been uploaded<br>\n
</div>
</div>";

//echo "The file {$fileName} has been uploaded";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }
    else
    {
        //show error message
        echo "<div class='notification attention png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Sorry your file was not uploaded due to the following errors:<br>\n
</div>
</div>";
//echo "Sorry your file was not uploaded due to the following errors:<br>\n";
        echo "<ul>\n";
        foreach($errors as $error)
        {
            echo "<li>{$error}</li>\n";
        }
        echo "</ul>\n";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }
    
}
else
{
    //Show the form
echo "Use the following form below to add a new image to your gallery;<br />\n";
    echo "<form enctype='multipart/form-data' action='' method='POST'>\n";
    echo "Please choose a file: <input name='uploaded' type='file' /><br />\n";
    echo "<input type='submit' value='Upload' />\n";
    echo "</form>\n";

//Echo Tests!
    echo "<br /><br />Random FileName: "; 
echo $rand;
echo "<br />";
echo "member ID: #";
echo $member_id;
}
?>
i then want it to rename the files for example:

"test.png" is uploaded and name changed to "92997863_321.png" (where first number is using my $rand then the "_" then second number is my $member_id)

the script already got these pieces of information and also gets the file extension using the $ext code.

can this be done, and can i also upload the new filename to my sql table?

Okay, so I'm kind of a PHP noob.   But out of context, for this site that I'm designing, it's easiest if I make a directory in the temporary folder PHP uses. In my case, /tmp/ because I am on Linux.   I want to use rand() to generate a random name for the page. But I then realized something, rand() could produce duplicates. How do I prevent PHP from trying to make the same directory at the same time? I know there are functions that will check if a file exists but I'm assuming it'll fail if that directory is currently being created, right?   How do I assure thread safety?   I willing to change my idea and not use rand(). Is there a way to get a unique key for each anonymous user on my site?

I am querying...

$sql  = "SELECT `messages_inbox`.`message_id`, `users`.`firstname`, `users`.`lastname`, `users`.`username` AS `from`, '${user_info['username']}' AS `to`, `subject`, LENGTH(`files`) AS `len`, 'inbox' AS `box`, DATE_FORMAT(`messages_inbox`.`time` ,'%T %D-%M-%Y') AS `time` ";
   
$sql .= "FROM `messages_inbox` INNER JOIN `users` ON `messages_inbox`.`from_id` = `users`.`id` WHERE `to_id` = ${user_info['uid']} AND `messages_inbox`.`deleted` = 0 ORDER BY `messages_inbox`.`message_id` DESC";

and I am trying to output

$displayName = ucwords("${message['firstname']} ${message['lastname']}");

by using

$messages = pm_fetch_all($_GET['box']);

I know my fetch works but for some reason firstname and lastname are only returning the logged in users first name and last name, not the person who sent the message.

Hi all.
I always create my sql queries like below.

        $user = "user";
$pass = "123456";
$host = "localhost";
$base = "test";

$cn = mysql_connect($host, $user, $pass) or trigger_error("SQL", E_USER_ERROR);
mysql_select_db($base,$cn) or trigger_error("SQL", E_USER_ERROR);

       $QUERY = mysql_query("SELECT id FROM someTable", [size=14pt][color=red][b]$cn[/b][/color][/size]) or die(mysql_error());

while ($list = mysql_fetch_assoc($QUERY)){
              echo "Some Text over loop";
        }


Okay here is the question (or problem). What if i have 5000 records in my Table. Doesn't this code connect DB 5000 times?
If yes, then how can i optimize it?

When the webpage loads it inserts all its information via xml into the database.
This all works fine and perfect untill i reload the page again then it starts screwing up all the data im not sure what im doing wrong i know this isnt much info but is there a common mistake im making?

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Send Data Form</title>
</head>

<body>
<?php

if(!$_POST) exit;

$email = $_POST['Email'];
$name = $_POST['Name'];
$telephone = $_POST['Telephone'];
$comments = $_POST['Comments'];

//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
   $errors=1;
}
if($errors==1) echo $error;
else{
   $values = array ('Name','Email','Telephone','Comments');
   $required = array('Name','Email','Telephone','Comments');
   

   $your_email = "****************";
   $email_subject = "Comment posted from website:";
   
   
   foreach($values as $key => $value){
     if(in_array($value,$required)){
      if ($key != 'Name' && $key != 'Comments' && $key != 'Telephone') {
        if( empty($_POST[$value]) ) { echo 'Please go back and complete all fields, thank you.'; exit; }
      }
      $email_content .= $value.': '.$_POST[$value]."\n";
     }
   }
    
}
   
$headers = "From: $email\r\n"."Reply-To: $email\r\n".'X-Mailer: PHP/' . phpversion();
   

mail($your_email, $email_subject, $email_content, $headers);

if($send_contact){
echo "Thank you for your submission";
}
else {
echo "ERROR, your comment was not sent";

?>
</body>

</html>

MOD EDIT: [code] . . . [/code] tags added.

What an Earth is wrong with this code?

Code: [Select]
$query = "select sizes from products where id='$id'"; $result = mysql_query($query); $row = mysql_fetch_array($result); if ($row == 0) {echo "";} else {echo "Small - $row['sizes']";}
PHP Parse error:  syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

ok so before this.. if there isnt description for the company..the logo cant be click..only can be clicked if there is description added..im confused..


Code: [Select]


<?
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}

$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
//$companydescription = $row['company_description'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];

echo "<font color='#000000'  face='arial' ><b> $eventname </b> </font> <br>";
echo "<font color='#000000'  face='arial' ><i>Date</i> : $datefrom - $dateto <br>";
echo "<i>Venue</i> : $eventvenue <br>";

$querypstype = "SELECT DISTINCT master_pstype.pstype_id,  pstype_desc FROM master_pstype
INNER JOIN master_psevent ON master_psevent.pstype_id= master_pstype.pstype_id
where master_psevent.event_id = '$ttid'
ORDER BY pstype_order";

$resultpstype=mysql_query($querypstype);
while($rowpstype = mysql_fetch_array($resultpstype)){
$pstypeid = $rowpstype['pstype_id'];
$pstypedesc = $rowpstype['pstype_desc'];
echo "<br><font color='#8B3A3A' size='1' face='georgia' ><b><i>$pstypedesc</i></b></font> <br>";

$queryps = "SELECT master_psevent.*, pstype_desc, company_name, company_link, company_description, logo_filename FROM master_psevent
LEFT JOIN master_pstype ON master_psevent.pstype_id = master_pstype.pstype_id
LEFT JOIN master_ps ON master_ps.ps_id = master_psevent.ps_id
WHERE master_psevent.event_id = '$ttid' and master_pstype.pstype_id= '$pstypeid'
ORDER BY pstype_desc,company_name ";

$resultps=mysql_query($queryps);
while($rowps = mysql_fetch_array($resultps)){
$companyname = $rowps['company_name'];
$companyid = $rowps['ps_id'];
$companylinkori = $rowps['company_link'];
$companydescription = $rowps['company_description'];
$logopath = $rowps['logo_filename'];


$describelink = "index.php?ttid=$ttid&content=describe&pstypeid=$pstypeid&psid=$companyid";

echo "<a href=\"$describelink\" target=\"_blank\"><img src=".$logo_dir."/".$logopath." width=\"15%\"></a>";
?>

<br>
<?
}
echo "<br>";
}

}



?>



im new..so to make it simple..the problem is ..i want it to be (if there is description = logo can be click, if no = otherwise)

Hello all,
I'm having trouble with the following code, it's supposed to go like this, you search for a hotel, choose a room, then it takes you to confirmation page before the paypal, but the problem is, in the confirmation page, it shows everything right, the number of nights, the number of guests, all except the number of rooms, it always give me 0 rooms

It's seperated into 3 files, hotelsmanager.php, bookingmanager.php, and book.php

here are the codes

Code: [Select]
while($row = @mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class=\"text\" align=center>".$row['room_type']."</td>";
echo "<td class=\"text\" align=center>".$row['price_per_day']."</td>";
echo "<td class=\"text\" align=center>".$row['people']." People</td>";
echo "<td class=\"text\" align=center>";

?>

                        <select name="nrooms" id="nrooms" onchange="
                        //alert('<?php echo $row['id'] ; ?>');
                        //alert(this.value);
                        var exist = 0;
                        if(roomids.length > 0)
                        {
for(var hh = 0;hh < roomids.length; hh++)
{

if(roomids[hh] == <?php echo $row['id'] ; ?>)
{
exist = 1;
//alert(hh);
roomnumar[hh] = this.value;


}
}
if(exist == 0)
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}
                        }
                        else
                        {
                        roomids.push(<?php echo $row['id'] ; ?>);
                        roomnumar.push(this.value);
                        }
                       
                        document.bookingform.roomid.value = roomids;
                        document.bookingform.roomnum.value = roomnumar;
                       
                       
                       
                        ">
                        <option value=0>  0  </option>
                        <?php
                        for($i = 0; $i < $row['available_rooms']; $i++)
                         {
                         $nr = $i+1;
                         $pr=$nr * $row['price_per_day'];
                         echo "<option value=$nr>$nr ($pr\$)</option>";
                         }
                        echo "</select>
                        </td>";
                        echo "<td align=center>
                        &nbsp;
                        </td>";
echo "</tr>";
echo "<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>";

}
echo "<tr class=\"rooms\">
<td colspan=\"4\">&nbsp;</td>

<td align=center><input type=\"submit\" value=\"book\" id=\"bookroom\" name=\"bookroom\"/></td>
</tr>";
echo "</table>";
echo "</form>";
print_r($_SESSION['order']);

$_SESSION['order']=0;
unset($_SESSION['order']);

}

}


?>
then booking info

Code: [Select]
<?php include("hotelsManager.php"); ?>
<?php include("config.php"); ?>
<?php include("textManager.php"); ?>
<?php
 function echoPostedData()
 {
   
   $dbo = new DB();
   $hotelObj = new hotelManager();
   $hotelID = $_POST['hotelid'];
   $datein = $_POST['datein'];
   $dateout = $_POST['dateout'];
   $roomid = $_POST['roomid'];
   $pr = $_POST['tp'];
   
   $_SESSION['hotelID'] = isset($_POST['hotelid']) ? $_POST['hotelid'] : $_SESSION['hotelID'];
   $_SESSION['datein'] = isset($_POST['datein']) ? $_POST['datein'] : $_SESSION['datein'];
   $_SESSION['dateout'] = isset($_POST['dateout']) ? $_POST['dateout'] : $_SESSION['dateout'];
         $_SESSION['roomid'] = isset($_POST['roomid']) ? $_POST['roomid'] : $_SESSION['roomid'];   
   
   
   $roomsarray = explode(",",$_POST['roomid']);
   $_SESSION['roomsarray'] = isset($_POST['roomid']) ? explode(",",$_POST['roomid']) : $_SESSION['roomsarray'];
   $roonsNo = $_POST['nrooms'];
   $_SESSION['nrooms'] = isset($_POST['roomnum']) ? explode(",",$_POST['roomnum']) : $_SESSION['nrooms']; 
Then the confirmation page is

Code: [Select]
   <?php
   echoPostedData();
  ?>
                  </td>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
             
             
              </td>
            </tr>
            <tr>
              <td valign="top"><img src="images/spacer.gif" width="28" height="10" /></td>
            </tr>
            <tr>
              <td valign="top">
              <?php
if(isset($_POST['bookroom']))
  {?>

I am trying to create a very basic object but am having troubles.

Code: [Select]
<?php

class item{

public $name;
public $price;

function __construct($name,$price){
$this->name=$name;
$this->price=$price;}

function getName(){
return $this->name;
}

}


$object = new item("car",400);
echo $object->getName();


?>
The HTML output is:

name=$name; $this->price=$price;} function getName(){ return $this->name; } } $object = new item("car",400); echo $object->getName(); ?>


I'm sure that this code is clean but for some reason will not output the desired result! any help would be great. thanks.