PHP - Upload Filename Using Rand() & Insert Filname To Sql

Hi all, I have an issue with an image upload script. So far the script will upload the image to the server and rename it with a random 5 digit number on the end. I then INSERT this data into a table for sourcing the image later on. the only problem is that the data in the table is the image's original name not the new one. how do I get it to change that name too? Thanks.

Code: [Select]
<?php

 $idir = "uploads/";   // Path To Images Directory


if (isset ($_FILES['fupload'])){

//upload the image to tmp directory
$url = $_FILES['fupload']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload']['type'] == "image/jpg" || $_FILES['fupload']['type'] == "image/jpeg" || $_FILES['fupload']['type'] == "image/pjpeg") { 
$file_ext = strrchr($_FILES['fupload']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload']['tmp_name'], $idir. basename($_FILES['fupload']['name'], $file_ext).rand(10000 , 99999).$file_ext);   // Move Image From Temporary Location To Perm 
}
}
error_reporting (E_ALL ^ E_NOTICE);
    $usr = "user";
    $pwd = "pword";
    $db = "db";
    $host = "host";

    # connect to database
    $cid = mysql_connect($host,$usr,$pwd);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }

    if ($_POST['submit']) {
   $logo = mysql_real_escape_string("$idir" . $_FILES['fupload']['name']);

        $SQL = " INSERT INTO mhhire ";
        $SQL .= " (logo) VALUES ";
        $SQL .= " ('$logo') ";

        
        $result = mysql_db_query($db,$SQL,$cid);
      $last=mysql_insert_id();


        
        if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    }

header("location:thanks.php");
exit();

    }
?>

Code I'm using


if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Successfully uploaded image!";
    if (file_exists("img/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "img/" . $_FILES["file"]["name"]);
      
      echo "<a href='img/$filename'>Your File</a>;
      }
    }
  }
else
  {
  echo "Invalid file";
  }
mysql_query("INSERT INTO $tbl (body, name, subject, ip, timestamp, img) VALUES ('$body', '$name', '$subject', '$ip', '$timestamp', '$imglink')");
mysql_query("INSERT INTO total (ip, subject, name, board) VALUES ('$ip','$subject','$name','$dfg')");
echo "<font color='red'><font size='15'><strong><center>Successfully posted to /$tbl/";
//print("<meta http-equiv='REFRESH' content='0;url=index.php?board=$tbl'>");

If I have the query on the top it runs, and the upload img doesn't
&& vice versa

Okay, so I found this code on-line that uploads images via a form, inserts them in to MySQL and displays the images on the page.  It works great!  Problem is, I spent a long time hacking this script to make it work with my site just to realize it did not re-size the image after it uploaded (dumb me).  I have found other code that do this but I really do not want to start over at this point and my level of expertise with PHP are a step below what I need to figure this out.  I am attaching the "original" code.  If anyone knows how to add the necessary lines of code to make every image re-size (reduce) itself.  I would very much appreciate it.  Thanks

       <?php
    $con=mysql_connect("localhost", "root", "rootwdp")or die("cannot connect");
    mysql_select_db("student",$con)or die("cannot select DB");
     
    if(isset($_POST['upload']))
    {
    $img=$_FILES["image"]["name"];
    foreach($img as $key => $value)
    {
    $name=$_FILES["image"]["name"][$key] ;
    $tname=$_FILES["image"]["tmp_name"][$key];
    $size=$_FILES["image"]["size"][$key];
    $oext=getExtention($name);
    $ext=strtolower($oext);
    $base_name=getBaseName($name);
    if($ext=="jpg" || $ext=="jpeg" || $ext=="bmp" || $ext=="gif"){
    if($size< 1024*1024){
    if(file_exists("upload/".$name)){
    move_uploaded_file($tname,"upload/".$name);
    $result = 1;
    list($width,$height)=getimagesize("upload/".$name);
    $qry="select id from img where `img_base_name`='$base_name' and `img_ext`='$ext'";
    $res=mysql_fetch_array(mysql_query($qry));
    $id=$res['id'];
    $qry="UPDATE img SET `img_base_name`='$base_name' ,`img_ext`='$ext' ,`img_height`='$height' ,`img_width`='$width' ,`size`='$size' ,`img_status`='Y' where id=$id";
    mysql_query($qry);
    echo "Image '$name' updated<br />";
    }
    else{
    move_uploaded_file($tname,"upload/".$name);
    $result = 1;
    list($width,$height)=getimagesize("upload/".$name);
    $qry="INSERT INTO `img`(`id` ,`img_base_name` ,`img_ext` ,`img_height` ,`img_width`, `size` ,`img_status`)VALUES (NULL , '$base_name', '$ext', '$height', '$width', '$size', 'Y');";
    mysql_query($qry);
    echo "Image '$name' uploaded<br />";
    }
    }
    else{
    echo "Image size excedded.<br />File size should be less than 1Mb<br />";
    }
    }
    else{
    echo "Invalid file extention '.$oext'<br />";
    }
    }
    }
     
    function getExtention($image_name){
    return substr($image_name,strrpos($image_name,'.')+1);
    }
    function getBaseName($image_name){
    return substr($image_name,0,strrpos($image_name,'.'));
    }
    ?>
     
    <!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 http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled Document</title>
    <script type="text/javascript">
    function addItems()
    {
    var table1 = document.getElementById('tab1');
    var newrow = document.createElement("tr");
    var newcol = document.createElement("td");
    var input = document.createElement("input");
    input.type="file";
    input.name="image[]";
    newcol.appendChild(input);
    newrow.appendChild(newcol);
    table1.appendChild(newrow);
    }
    function remItems()
    {
    var table1 = document.getElementById('tab1');
    var lastRow = table1.rows.length;
    if(lastRow>=2)
    table1.deleteRow(lastRow-1);
    }
    </script>
     
    <style type="text/css">
     
    <a class="tooltip" and them url href="/http.www.anyurl.com" </a>
     
    a.tooltip:hover span{display:inline; position:absolute; border:2px solid #cccccc; background:#efefef; color:#333399;}
    a.tooltip span
    {display:none; padding:2px 3px; margin-left:8px; width:150px;}
     
    </style>
     
    </head>
     
    <body>
     
    <form method="post" action="" enctype="multipart/form-data">
    <table align="center" border="0" id="tab1">
    <tr>
    <td width="218" align="center"><input type="file" name="image[]" /></td>
    <td width="54" align="center"><img src="Button-Add-icon.png" alt="Add" style="cursor:pointer" onclick="addItems()" /></td>
    <td><img src="Button-Delete-icon.png" alt="Remove" style="cursor:pointer" onclick="remItems()" /></td>
    </tr>
    </table>
     
    <table align="center" border="0" id="tab2">
    <tr><td align="center"><input type="submit" value="Upload" name="upload" /></td></tr>
    </table>
    </form>
    <table border="0" style="border:solid 1px #333; width:800px" align="center"><tr><td align="center">
     
    <iframe style="display:none" name="if1" id="if1"></iframe>
     
    <?
    $qry="select * from img where img_status='Y' order by id";
    $res=mysql_query($qry);
    $i=0;
    if(mysql_num_rows($res)){ ?>
    <div align="center"><ul style="width:650px; border: 0px">
    <?
    while($fetch=mysql_fetch_array($res)){
    $hratio=120/$fetch['img_height'];
    $wratio=120/$fetch['img_width'];
    $ratio=($hratio < $wratio) ? $hratio : $wratio;
    $hth=$fetch['img_height']*$ratio;
    $wth=$fetch['img_width']*$ratio;
    ?>
    <li style="width:120px; height:180px; border:0px solid #333;float:left;list-style:none outside none; padding-right:5px;"><img src="upload/<? echo $fetch['img_base_name'].'.'.$fetch['img_ext']; ?>" width="<? echo $wth; ?>" height="<? echo $hth; ?>" title="<? echo "image : ".$fetch['img_base_name'].".".$fetch['img_ext']; ?>" /><br />
    <?
    if($i==0)
    $fp=fopen("fileInfo.txt",'w');
    else
    $fp=fopen("fileInfo.txt",'a');
    fwrite($fp,"Image : ".++$i ."\r\n");
    fwrite($fp,"Name : ".$fetch['img_base_name'].".".$fetch['img_ext']."\r\n");
    fwrite($fp,"width X height :
    ".$fetch['img_width']." X ".$fetch['img_height']."\r\n");
    fwrite($fp,"Size : ".round($fetch['size']/1024,1)."Kb\r\n");
    fwrite($fp,"____________________________________\r\n");
    fclose($fp);
     
    echo $fetch['img_base_name'].".".$fetch['img_ext'].'<br />';
    echo $fetch['img_width'].' X ';
    echo $fetch['img_height'].'<br />';
    echo round($fetch['size']/1024,1) .'Kb';
    ?>
    </li>
    <?
    }?>
    </ul>
    </div><? }?>
     
    </td></tr></table>
    </body>
    </html>

i need to upload files to a different folder dependint on option in form, make thumbnails, and store title and src for image and thumb in database table dependant on category. i think i'm pretty close, but there's still something wrong.

Here is my upload form :

Code: [Select]
<form enctype="multipart/form-data" action="upload.php" method="POST">
 Photo: <input type="file" name="photo"><br>
 Category: <select name="cat">
<option value="weddings">Weddings</option>
<option value="music">Music</option>
<option value="portraits">Portraits</option></select>
Title: <input type="text" name="title"><br>
 <input type="submit" value="Upload photo">
 </form>
form processed by upload.php :
Code: [Select]
<?php 
 
 require "db.php";
 
 //Get form info 
 $name=$_POST['name']; 
 $title=$_POST['title']; 
 $category=$_POST['cat']; 
 $pic=($_FILES['photo']['name']); 
 //set target dir source file width height
 $target = $cat."/"; 
 $src = $target . basename( $_FILES['photo']['name']); 
 $destination = $cat."/thumbs";
 $thumbsrc = $destination . basename( $_FILES['photo']['name']); 
 $width = 200;
 $height = 200;
    header("content-type: image/jpeg");
    $src_img = imagecreatefromjpeg("$src");
    $srcsize = getimagesize("$dest");
    $dst_img = imagecreatetruecolor($width, $height);

    imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $width, $height, $srcsize[0], $srcsize[1]);
    imagejpeg($dst_img);
    
 //Unstert into db
 mysql_query("INSERT INTO `$category` VALUES ('$name', 'Stitle', '$src, $thumbsrc')") ; 
 
 //move photo 
 if(move_uploaded_file($_FILES['photo']['tmp_name'], $fulltarget)) 
 { 
 //Ok 
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 //not ok 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

call a script from main page
Code: [Select]
<div class="gallery">
 <?php include "weddings/get.php" ?>
 </div>
 <div class="gallery">
 <?php include "music/get.php" ?>
 </div>

get.php displays links

Code: [Select]
<?php
include "db.php"; 
$cat = weddings;
$q = "SELECT id, title, src, thumbsrc FROM $cat";

$result = $mysqli->query($q) or die(mysqli_error($mysqli));

if ($result) {
    
    echo "<ul id='photos'> \n";
    
    while ($row = $result->fetch_object()) {
   
        $title = $row->title;
        $src = $row->src;
        $thsrc = $row->thumbsrc;
        $id = $row->id;
        
        echo "<a href='$src' class="lightbox" rel="$cat" title="$name - $title"><img src='$thsrc' id='$id'      alt='$name' /></a>":
        }    
        
        echo "</ul>";
    

    
}



?>   
I think i'm going along the right sort of path, but i'm not sure.

Hello everybody,

I just have a quick question.

I am trying to develop a webpage for dice rolling (to use for myself when i play dnd)

Now, I know a lot of the random functions is computer languages are not truly random, and thus have some areas that the value will be the result more than others.

What would be a good way to try to make it as "random" as possible, or am I just over-thinking it?

what am i doing wrong? I can't see it... I want to catch the rand variable but it doesn't. So I print an extra print at the bottom. So there should be two rand prints. Here's the code.

<html>
<head><title></title>
</head>
<body>

<form action='random.php' method='post'>

<?php
if(isset($_REQUEST['rand'])){
$rand = $_REQUEST['rand'];
print $rand . "<br /><br />";
} else {
print "rand: empty<br /><br />";
}

$rand = rand(1,1000);
print $rand."<br /><br />";
print "<input type='hidden' value='$rand' />";
?>
<input type='submit' value='scramble' />

</form>
</body>
</html>

I forgot to tell ya that the if statement returns rand: empty. Help...

I have this in my code:

$dr =rand(0, 100);
echo $dr;

Here are the last 5 refreshes:

997
6336
6144
1110
2914

similar results when I use mt_rand()...

Hi,   I basically want a function that takes a parameter which is a percentage chance of the functioning returning true. A user can move from tier 1->10 and at tier 1 there's a 70% chance to move to tier 2, from tier 2 there's a slightly less chance to move up, and so on.   I tried with the following piece of code:  

public function rollTheDice($winnerPercentage)
{
$number = rand(1, 100);
if ($number <= $winnerPercentage)
return true;
return false;
}

  The above code makes logical sense to me: 1. Pick a random number between 1 and 100. 2. If that number is less than or equal to the percentage, then we passed (example, if the random number is less than or equal to 70.. there must be a 70% chance of this?)   This however does not seem to work, in fact it appears that when simulating a roll, 70% fails at the very first step (where there is a 70% chance of winning..) To actually make it to tier 10, has yet to be accomplished, so by simulating this with unlimited attempts for 120 seconds straight doesn't seem to "win".   I tried (just for fun) and change the if-statement so: if ($number >= $winnerPercentage)   This seems to be working quite well, as the simulator quickly reaches tier 10 this way. Any suggestions to code changes, or can someone explain why it is working way better when exchanging less than with greater than?

Hey,

This is my [faulty] PHP

$input3 = array("BB, BB, BB, BB, BB, BB, BB, BB, BB, bb");
$rand_keys3 = array_rand($input3, 2);
$BB1 = $input3[$rand_keys3[0]] . "\n";
$BB2 = $input3[$rand_keys3[1]] . "\n";

$input4 = array("HD, HD, HD, HD, HD, hd");
$rand_keys4 = array_rand($input4, 2);
$HD1 = $input4[$rand_keys4[0]] . "\n";
$HD2 = $input4[$rand_keys4[1]] . "\n";

$input5 = array("DD, DD, DD, DD, DD, DD, DD, dd");
$rand_keys5 = array_rand($input5, 2);
$D1 = $input5[$rand_keys5[0]] . "\n";
$D2 = $input5[$rand_keys5[1]] . "\n";

$input6 = array("CC, CC, CC, CC, CC, cc");
$rand_keys6 = array_rand($input6, 2);
$C1 = $input6[$rand_keys6[0]] . "\n";
$C2 = $input6[$rand_keys6[1]] . "\n";

$input7 = array("HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, HG, hg");
$rand_keys7 = array_rand($input7, 2);
$HG1 = $input7[$rand_keys7[0]] . "\n";
$HG2 = $input7[$rand_keys7[1]] . "\n";

And this is the error I'm getting:

Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/content/91/6351791/html/dogtrader.php on line 48

Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/content/91/6351791/html/dogtrader.php on line 54

Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/content/91/6351791/html/dogtrader.php on line 60

Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/content/91/6351791/html/dogtrader.php on line 66

Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/content/91/6351791/html/dogtrader.php on line 72

I've checked back over it all and looked up the function in various places to check what they say about it, but can't see which bit I'm going wrong wit! :[

If anybody has any advice as to what to do to fix it, it would be much appreciated.


Cheers.

Hi there,

I have one question about the function rand(),

What if i want to have an number between 0 and 360

Without 90 to 180

so 91,92,93,94.....180 can't be the number

how can i do that?

btw, I know its possible through if,while,for and so on. But is there an other way to do this?

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?

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 :-)

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";
 

 

This topic has been moved to MySQL Help.

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

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?