PHP - How Are The Temporary File Names Generated ?

I've got a script where the client can upload pictures. The pictures are then resized, thumbnailed, and added to the database. In the process I'm trying to search the database for a duplicate file name and create a new name if necessary:

Code: [Select]
$userfile = 'userfile' . $i;
$tmpLoc = $_FILES[$userfile]['tmp_name'];
$name = $_FILES[$userfile]['name'];
$error = $_FILES[$userfile]['error'];
$type = $_FILES[$userfile]['type'];
$temp = 'album' . $i;
$album = $_POST[$temp];

if($error > 0) {
echo "Error on $name: ";
switch ($error) {
case 1: echo "File exceeded upload_max_filesize"; break;
case 2: echo "File exceeded max_file_size"; break;
case 3: echo 'File only partially uploaded'; break;
case 4: echo 'No file uploaded'; break;
}
echo "</div>";
exit;
}       

// Check for name duplicates and deal with
$query = "SELECT * FROM pictures WHERE src = $name";
$result = mysql_query($query);
if($result)
$dup = true;
while($dup) {
                                                echo "Duplicate file name $name <br />";
$ext;
if($type == 'image/gif')
$ext = '.gif';
else if($type == 'image/jpeg')
$ext = '.jpg';
else if($type == 'image/png')
$ext = '.png';
else
die("Error: Unsupported file type");

$x = 0;
$name = $x . $ext;
                                                echo "Checking $name <br />";
$query = "SELECT * FROM pictures WHERE src = $name";
$result = mysql_query($query);
if(!$result) {
$dup = false;
echo "File successfully renamed to $name to avoid duplicate <br />";
}

$x++;
}


I don't get any errors of any sort, it just never enters the loop

I can get files to  upload to folder and add a new row for each in to a mysql db using the code below, how do I get all the filles in one row with multiple uploads

Code: [Select]
//Check if the form was submitted.
if(isset($_POST['uploadButton'])) {
  //Specify folder path where the file is going.
  $path = 'uploads/';

  //Upload file one by one.
  foreach($_FILES['file']['name'] as $key => $val) {
    if($val != '') {
      $file_name = $_FILES['file']['name'][$key]; //Get file name.
      $file_tmp  = $_FILES['file']['tmp_name'][$key]; //Get temporary file name.
      $file = $path . $file_name;
      mysql_query("INSERT INTO images (img1) VALUES('$file');") or trigger_error('Unable to INsert: ' . mysql_error());
   




 
      //Move uploaded file
      if(move_uploaded_file($file_tmp, $file)) {
        echo 'File was succesfully uploaded to: ' . $file . '<br />';
      } else {
        //Display error message if there was a problem uploading file.
        echo 'Error uploading file "' . $key . '."<br />';
      }
echo $target_path;


        }
     }
  }

?>

Hi all,

This is my very first post here, so I will try and make it count 

Very recently I have been working with php and I found this simple little script that allows users to upload files. I tweaked some things to only make it upload .doc files but now I have a slight problem.
Every time someone uploads a word file with the same name, it gets replaced.

I tried looking for other examples here on the forum, but was unable to apply it to my own script.

It would be a big help if someone could provide a simple add-on to this existing script.

Thanks in advance.

Script:

<?

$locatie="upload/";
$toegestaan = "doc";
$max_size = 1000000;


set_time_limit(0);

if(isset($_POST['upload']))
{
    if(is_uploaded_file($_FILES['bestand']['tmp_name']))
    {
        $extensie_bestand = pathinfo($_FILES['bestand']['name']);
        $extensie_bestand = $extensie_bestand[extension];

        $extensies_toegestaan = explode(", ", $toegestaan);

        for($i = 0; $i < count($extensies_toegestaan); $i++)
        {
            if($extensies_toegestaan[$i] == "$extensie_bestand")
            {
                $ok = 1;
            }
        }

        if($ok == 1)
        {
            if($_FILES['bestand']['size']>$max_size)
            {
                echo "Het bestand is te groot, de maximale grootte is: <b>$max_size</b>";
                exit;
            }

            if(!move_uploaded_file($_FILES['bestand']['tmp_name'],
            $locatie.$_FILES['bestand']['name']))
            {
                echo "het bestand kan niet worden verplaatst";
                exit;
            }

            echo "Het bestand ".$_FILES['bestand']['name']." is geupload<br>
            <a href='".$locatie."".$_FILES['bestand']['name']."' </a>";
        }
        else
        {
            echo "Verkeerde extentie, de toegestane extensies zijn: <b>$toegestaan</b>";
        }
    }
    else
    {
        echo "Het uploaden is mislukt, probeer het opnieuw";
    }

}

?>
<title>test tittle</title>
<style type="text/css">
<!--
body {
   margin-top: 0px;
}
-->
</style></head>

<body>
<table width="1216" height="1191" border="0" cellpadding="0" cellspacing="0" background="back">
  <tr>
    <td height="317" colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td height="381">&nbsp;</td>
    <td><p>&nbsp;</p>
      <form method="post" action="<?=$_SERVER['PHP_SELF']?>" enctype="multipart/form-data">
        <table width="398" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="180">&nbsp;</td>
            <td width="218"><input type="file" name="bestand" />
                <input type="submit" name="upload" value="uploaden" /></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
        </table>
      </form></td>
  </tr>
  <tr>
    <td width="420">&nbsp;</td>
    <td width="796">&nbsp;</td>
  </tr>
</table>

Hello I have a problem.

I have been trying to copy my music folders structure but not copying the mp3s; instead using the file names as a file name for a .txt file and inserting the URL to the file in the .txt file.

Eg.

E:\My Music
       folder 1
           folder 1.1
               file.mp3
       folder 2
       folder 3

to

G:\My Music
       folder 1
           folder 1.1
               file.txt
       folder 2
       folder 3

and inside "file.txt" would be one line saying "http://www.xxx.com/my_music/file.mp3

I want to remove the file extension - I have done that. I want to remove the trailing slash. - I have done that   But I cannot for the life of me get the  the regular page to display instead of the folder which show a tree of files within it.     site.com/website-tips.php

site.com/website-tips/increase speed.php   The extension drops off and the trailing slash too but when I navgate back through the vreadcrumb to website-tips (without php in html code) it gives me the folder and shows the file tree (files within website tips folder)

How would I solve this?

right now if I access the website-tips.php file, it shows the directory and its interior pages   Pls hlp out.    

Hi,
I want to store files to variable array using glob()

like
$files[0] = xyz.txt
$files[1] = pqr.txt
.
.
.
$files[n] = nfile.txt

I know how to list files from directory using glob()

Code: [Select]
<?php
foreach (glob("*.txt") as $filename) {
    echo "$filename size " . filesize($filename) . "\n";
}
?>



How can I do that ?

In querying my database, I'm Selecting nameFirst and nameLast, and it produces a name like Joe Smith.  I'm trying to match a photo with the name.  Right now I'm uploading photos into a folder naming the file (e.g. SmithJoe.jpg). 

For reasons that involve writers being able to upload and access photos, I'm trying to use an image plugin.  When uploading photos, it strips capital letters, so SmithJoe,jpg goes in as smithjoe.jpg, and it's not matching my database query. 

Here is the code I'm working with that works quite well with this one exception:


$query = 'SELECT * FROM wp_playerRank';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

if ($line['wpID'] == $wp_tagID)  {

echo '<div class="player">';


// Here is the code that produces the image.  I need to get rid of capital letters for ease of use

echo '<div><img src="/wp-content/uploads/' . $line['nameLast'] . $line['nameFirst'] . '.jpg"></div>';



echo '<div class="playerData">' . $line['height'] . ' ';
if ($line['position'] == 'PG')  {echo 'Point Guard';}
elseif ($line['position'] == 'SG')  {echo 'Shooting Guard';}
elseif ($line['position'] == 'SF')  {echo 'Small Forward';}
elseif ($line['position'] == 'PF')  {echo 'Power Forward';}
elseif ($line['position'] == 'C')  {echo 'Center';}
echo '</div>';
echo '<div class="playerData">' . $line['hschool'] . '</div>';
echo '<div class="playerData">' . $line['summer'] . '</div>';
echo '<div class="playerData">Class of ' .$line['year'] . '</div>';

if ($line['committed'] == 'y') {
echo '<div>
<br>Committed to <strong>'. $line['college'] . '</strong></div>
';}

}
}

My Php Buddies,

I have mysql tbl columns these:

id: 
date_&_time: 
account_activation_code: 
account_activation_status: 
id_video_verification_status: 
id_verification_video_file_url: 
username: 
password: 
primary_domain: 
primary_website_email: 
sponsor_username: 
 

Now, I want to display their row data by excluded a few columns.

Want to exclude these columns:

date_&_time

account_activation_code

account_activation_status

id_verification_video_file_url

password

 

So, the User's (eg. your's) homepage inside his account should display labels like these where labels match the column names but the underscores are removed and each words' first chars CAPITALISED:

Id: 1
Id Video Verification Status: 1
Username: requinix
Primary_domain: requinix.majesty
Primary Website Email: requeen@requinix.majesty
Sponsor Username: phpsane
Recruits Number: 2

 

For your convenience only PART 1 works. Need help on Part 2

My attempted code:

 

	PART 1
	<?php 
	// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
	// Query to get columns from table
$query = $conn->query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'members' AND TABLE_NAME = 'users'");
	while($row = $query->fetch_assoc()){
    $result[] = $row;
}
	// Array of all column names
$columnArr = array_column($result, 'COLUMN_NAME');
	foreach ($columnArr as $value) { 
echo "<b>$value</b>: ";?><br><?php 
} 
	?>
	 
	PART 2
	<?php 
	//Display User Account Details 
echo "<h3>User: <a href=\"user.php?user=$user\">$user</a> Details</h3>";?><br> 
<?php 
$excluded_columns = array("date_&_time","account_activation_code","account_activation_status","id_verification_video_file_url","password"); 
foreach ($excluded_columns as $value2) 
{    
    echo "Excluded Column: <b>$value2</b><br>";
}
foreach ($columnArr as $value) 
{ 
    
    if($value != "$value2")
    { 
        $label = str_replace("_"," ","$value"); 
        $label = ucwords("$label"); 
        //echo "<b>$label</b>: "; echo "$_SESSION[$value]";?><br><?php 
        echo "<b>$label</b>: "; echo "${$value}";?><br><?php 
    }
} 
?>
	

PROBLEM: Columns from the excluded list still get displayed.

Edited November 19, 2018 by phpsane

This topic has been moved to MySQL Help.

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

My users table on my forum is what gets checked everytime a user refreshes to authentic them.    When killing a monster, I want users to be able to grab items and it will insert them into their inventory. I have this part done already. But I want them to have a plethora of loot available that drops from a mob, and once they click the specific item it will then be inserted into their inventory (server database).   I'm storing the Temporary Item Data in a PHP session variable. Once they kill a monster, the Tempory Item Data variable get's filled with the specific loot and then the user will have the option to choose what items they want to go into their inventory.   My problem is, if they open the game in a new browser they will get a new session id. Since I'm authenticating them through my users table, can I just make a new column called session_id and just use php's session_id() before every session start so no matter which browser they're on they will have the same session right?    You might think, well why dont you just store the temporary item data in a mysql field or rows instead? I want to try to minimize mysql usage as much as possible, as players will be CLICKING a lot to kill mobs, it is most likely very mysql demanding as well and I want to be intuitive about it. I just want to use temporary session data for the loot. Then once the user clicks an item they want, it is EXTRACTED from their tempory item data variable, then I will use MYSQL to insert those items into their inventory.    Is this a fair and intuitive way to do temporary data for item loot? For example, in action RPG's like Path of Exile you kill a group of mobs and you see a shit ton of loot on the floor. (I imagine that loot is just temporary waiting for someone to pick it up right?) Once you do pick it up, mysql is then called to save it right? That's the same logic I have with my web based game. Is using a session variable to store that temporay loot.   Is this an intuitive way to do this, or are there other ways?
Edited by Monkuar, 24 November 2014 - 01:24 AM.

Hi Guys I trying to download files and I have this error message, hopelly you guys can help me please Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 17

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 18     This is the code I use to force the download

<?php
include('core/inc/init.inc.php');
   if(isset($_GET['file_id'])) {  
     $file_id=(int)$_GET['file_id'];    
     $file=mysql_query("SELECT file_name, file_expiry FROM files WHERE file_id=$file_id");    
     if(mysql_num_rows($file)!=1){   
       echo'Invalid file Id';
     }else{
       $row=mysql_fetch_assoc($file);
       if ($row['file_expiry']<time()){
          echo'This file has expired'; 
       }else{
              $path="core/files/{$row['$file_name']}";
              header('Content-Type:application/octet-stream');
              header('Content-Description:File Transfer');
              header('Content-Transfer-Encoding:binary');
              header("Content-Disposition:attachment;filename=\"{$row['file_name']}\"");
              header('Content-Length:'.filesize($path));
              readfile($path);
       }
     }
}
?>

Thank you for your help.....

I'm using a popular PHP script for my web site, which uses main_1.htm for the header and footer, and inner_index.htm for the main part of the home page. Also, of course it has index.php.

How can I set up a duplicates of these files to work on and test changes to the home page, before I actually deploy the changes on to my live site's home page?

Thanks

I'm modifying a script I built a few months ago to allow someone to upload an attachment via a form and then email it off. It is expected that this form will receive a lot of hits and so it won't be possible to store the attachment in a folder before emailing it out (right away).

Problem: If I skip the move_uploaded_file part, and just attach the tmp_name the tmp_name is how I receive it rather than the PDF that it actually is.

How can i change the documents name before sending it off, without saving it to a general location. My worry with saving it is, someone uploads their copy and at the exact moment it's supposed to email off, someone somewhere else uploads theirs and it overwrites the first persons and then the email gets sent with the newest persons data.

index.php
Code: [Select]
<form action="process.php" method="post" enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>

process.php
Code: [Select]
<?php
print_r($_FILES);
if ($_FILES["file"]["type"] == "text/plain") {
if ($_FILES["file"]["error"] > 0) {
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
} else {
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

if (file_exists("upload/" . $_FILES["file"]["name"])) {
echo $_FILES["file"]["name"] . " already exists. ";
} else {
move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
}
}
} else {
echo "Invalid file";
}
?>

Ok here is what i got so far and now I am stuck.  The user enters a number of how many squares (rectangles is note accurate) they wish to calculate.  If its between 1 and 100 it continues, if its any other number it tells you to put in a number between 1 and 100.  That was easy for me to do.

If the number is between 1 and 100 it creates and input for length, width and height of each rectangle. creating the variables as it goes, i.e. "length$i" when $i is the while counter and increases to the ammount of rectangles you wished to view.  Again, not that hard for me.

 So I am at the point where is I put in 50 I get length1 - through length30, width1 - width50, and height1 - height50.  THis works great.  However I now what to store those variables and calculate the area of each one via a while look which again creates an area$i variable which can be added (it would create area1 - area50 which I then wish to add together)

Here is what I have so far.

<?php
session_start();  


if (isset($_REQUEST['numpack'])) {
    if ($_REQUEST['numpack'] <= 0 || $_REQUEST['numpack'] > 100 ) {
    $error = "Please enter a number between 1 and 100";    
    echo $error;

?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>
<?php
} else {
?>
<form name="form2" method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
<?php   
   
   
   
   $i=1;
   while($i<=ceil($_REQUEST['numpack']))
  {
  ?>
  <table width="325" border="0" cellspacing="5" cellpadding="5" style="float: left;" class="aluminium">
  <tr>
    <td align="center" rowspan="2"><span class="transparent" style="color: #FFF; font-weight: bold;"><?=$i; ?>.</span></td>
    <td align="center">L</td>
    <td align="center">x</td>
    <td align="center">W</td>
    <td align="center">x</td>
    <td align="center">H</td>
  </tr>
  <tr>
    <td align="center"><input name="length<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="width<?=$i; ?>" type="text" size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="height<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
  </tr>
</table>
    <?php
  $i++;
  }
?>


</form>
<?php   
   
}
}
If (!isset($_REQUEST['numpack'])) {
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>    
<?php    
}
?>

Now I was reading up on session data and think this might be the best way to go, but again how do I do this? and two I want to make sure that if there are 2 people accessing it at the same time, it does not change the variables on them... (i.e. user one puts in 50 values, and user two puts in 50 different values I do not want cross contamination)

Any ideas on how to proceed?

I have this interesting problem, I think I know how to do it.   In a java class I took there was a lab on swapping the values of variables and if there were two variables, you needed a third temporary value holder.   So this project I'm working on has a row output, currently the individual values are outputted as a concatenated string but ideally they would be independent rows with accompanying buttons.   One of those buttons is a ^ symbol, when you press this, ideally the row is moved up in ID putting the previous ID in front or ahead.   The problem is that the ID's / rows are not necessarily in sequential order.   So, when I recall a set of rows that have random sequential values for example, 2, 5, 27, 41, 43   and those are outputted by themselves, now becoming 0,1,2,3,4 respectively or 1,2,3,4,5   So when I try to move 43 to position 2, that's 4 positions away or 4 clicks of the ^ button.   Now how do you deal with that 4 difference and the difference of 41... ? thereby, when the initial set of rows are recalled again, the order is now, 43, 5, 27, 41, 2 Of course the ID I think remains the same but the data is switched... ? yeah I have to draw some pictures, but this isn't a current problem to fix, later on down the road after I update the interface.   here is a drawing to explain, I'm more of a visual person    wp_20150112_05_27_16_pro.jpg   59.67KB   0 downloads   Any ideas would be appreciated, otherwise I will post my solution when I come to it. Or I don't figure it out and find one. thanks