Php code for downloading a file from database

You can check your uploads folder and database table to confirm that it was successful. Let's display it so that the user can view it and click on it to download it.

First, we need to fetch the file info from the database. Open filesLogic. Now create a file called downloads. Now on this page, the files information from the database are listed each along with its size in KB and number of downloads. There is also a download button against each file.

What remains now is the code that actually downloads the file from our uploads folder. Let's write the code right away. So when you click on the download link of a file, that file's id is sent to the filesLogic. Then we proceed to set some headers and finally respond with the file to the user using the readFile function in PHP. After the file is downloaded, we update the downloads count for that particular file in the database. That's about it with file upload and download.

You can further customize it to build cool PHP applications. Schreier 1, 1 1 gold badge 20 20 silver badges 30 30 bronze badges. Add a comment. Active Oldest Votes. I have changed to your code with little modification will works well. Here is the code: butangDonload. AdRock 2, 9 9 gold badges 58 58 silver badges bronze badges.

You can also check the working demo in the link : websamplenow. Not really answer to initial question, but this answers MY question : — Anton Kolenkov. Dhaval Rathod Dhaval Rathod 31 7 7 bronze badges. Ondrej Janacek Try to avoid answers that are just code. It is more helpful to explain what is going on and how it works. Thanks for posting and keep working at it. Switching to sessions instead of query strings isn't going to help and could break by causing data to be overwritten if the site is being browsed in multiple tabs.

This gives access to every file on the server! It's a massive security hole. Use for our example the following download URL:.

With the following example, I will use a string to receive the name of a file which is stored inside a secure MySQL database. Let say, we have a simple database table with only two columns for the ID and the filename. The code for the file download. In the first example I used the file name inside the download URL. If you really need to protect your downloads , you need to deny the direct access of the file location using Apache directives or.

Use more secure slugs to receive a file name from your database. For example you can encrypt the database row key as well. Published in: PHP Scripts. Most JavaScript examples…. I ditched Apache so many years ago… I thought it was practically shipped with nowadays. Just another reason to switch to an nginx-based solution. I think lighty has supported it for a long time too.

Then they should move away from shared hosts. Sure they should move away, but many of them stick with shared hosting because of the higher costs for managed server hosting. Hi, i used your code to create a download. I would like to protect also my folder from url access, if i use as chmod value, the page will not return the download file, but it will stay blank the fopen fail.. Which value should i use for access files from the code? Or protect your directory via.