Downloaded file automatically saved and overwrite previous

[Tinus]

Hi

I have a php code that uploads a file to mysql db then I detrmine the id of the last inserted file and download the file .e user is asked if he wants to save the file and then asked for te file name.
I want te php to automatically save the file and overrides the previous downloaded file.
Any advise will be apprecited.

If 1stfile upload = name.txt and 2ndfile upload=surname.txt.Surname.txt must overwrite name.txt.

?php
    // Check if a file has been uploaded
     if(isset($_FILES['uploaded_file'])) {
     // Make sure the file was sent without errors
     if($_FILES['uploaded_file']['error'] == 0) {
         // Connect to the database
         $dbLink = new mysqli("127.0.0.1","root","blabla",'blabla');//143.160.11.51
         if(mysqli_connect_errno()) {
         die("MySQL connection failed: ". mysqli_connect_error());
         }
         // Gather all required data
 
         $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
         $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
         $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
         $size = intval($_FILES['uploaded_file']['size']);
         // Create the SQL query
         $query = "INSERT INTO file (`name`,`mime`,`size`,`data`,`created`)
                   VALUES ('{$name}', '{$mime}', '{$size}', '{$data}', NOW())";
// Execute the query
$resulta = $dbLink->query($query);
$getid="SELECT id FROM file ORDER BY created DESC LIMIT 1 ";
$result2 = $dbLink->query($getid);
$mysqli->error;
$row1=$result2->fetch_assoc();
 
 
// Close the mysql connection
$dbLink->close();
}}
else
{echo 'Error! A file was not sent!';}
 /////////////////////////Download///////////////////////////////////////////
 
// Make sure an ID was passed 
 
// Get the ID 
$id= $row1['id']; 
 
// Make sure the ID is in fact a valid ID 
if($id <= 0) { 
die('The ID is invalid!'); 
} 
else { 
  // Connect to the database 
 $dbLink = new mysqli("127.0.0.1","root","blabla",'blabla'); 
 if(mysqli_connect_errno()) { 
 die("MySQL connection failed: ". mysqli_connect_error()); 
                            } 
// Fetch the file information 
$query = "SELECT `mime`, `name`, `size`, `data` 
FROM `file` 
WHERE `id` = {$id}"; 
$resultb=$dbLink->query($query); 
 
if($resultb) {
// Make sure the result is valid 
if($resultb->num_rows == 1) {
$rowb =mysqli_fetch_assoc($resultb); 
// Print headers
header("Content-Type: ".$rowb['mime']);
header("Content-Length: ".$rowb['size']);
header("Content-Disposition: attachment; filename=".$rowb['name']);
// Print data
echo $rowb['data'];
 } 
else { 
echo 'Error! No image exists with that ID.'; 
} 
// Free the mysqli resources 
@mysqli_free_result($resultb); 
} 
else { echo "Error! Query failed: <pre>{$dbLink->error}</pre>"; } 
@mysqli_close($dbLink); 
}
echo 'end';
echo $rowb['data'];
?>
 

[TheServant]

How about instead of:

$query = "INSERT INTO file (`name`,`mime`,`size`,`data`,`created`)
                   VALUES ('{$name}', '{$mime}', '{$size}', '{$data}', NOW())";

You use:

$prev_id = "ID you want to replace";
$query = "UPDATE file SET `name`='{$name}', `mime`='{$mime}', `size`='{$size}', `data`='{$data}', `created`=NOW() WHERE id='{$prev_id}' LIMIT 1";

With a little if clause, that only UPDATE if $prev_id is set, otherwise use INSERT as you have before.

[Tinus]

Hi
Thanks for the reply.
I dont want the file in the database to be overwritten.
I want the file that is stored in the specific directory on the server.

1.File upload to database.
2.Store file in directory on pc
3.Do things with the file in /weqw/wer/..

Nxt time a file is uploaded
1.strore in db
2.overwrite file thatwas previously downloaded to directory.
3. do some stuff with the file.

Sorry for not stating the issue more clearly.

[code green]

I dont want the file in the database to be overwritten.
I want the file that is stored in the specific directory on the server.

TheServant misunderstood because the code supplied is for database interaction.
There is no code for saving the file anywhere on the server.

[Tinus]

The download section does provide the user with question on if he would like to open or save the file.(which is downloaded from the DB)

Thanks for the help.

I have changed the code to upload the file to database and store the file in a directory(not download from DB) and it's doing what I wanted.