<div>
I found the problem I needed to target the array [$i] as it was in the loop. However I can display each image as a list with the ability to delete however I need a link to view it.
</div>


<div>
I found the problem I needed to target the array [$i] as it was in the loop. HowI can display each image as a list with the ability to delete however I need a link to view it?
</div>


<div>
OK, couple of things. &nbsp;You might want to consider storing your images in the file system of the server, and only storing a pointer in the data base. &nbsp;Too many reasons WHY, but trust me -- that is the &quot;best practice&quot; approach to storing images.<br />
<br />
If you have the images in the file system, you can just produce a link from the associated row of the data base, and your clients can get the image directly. &nbsp;If you're concerned about controlling access to the images you can use .htaccess or similar means to restrict who can go to the directory. &nbsp;There are lots of ways of controlling access to files, but all of them come with the same caveat: Once it's on somebody's screen you've lost control of that copy of the file, period.<br />
<br />
If you have the images in the data base, you have to write code that makes your data base act a little like the file system. &nbsp;You will need a script that enables a client to see the image, download the image, delete the image, etc.<br />
<br />
To offer any more specific help, I would need to have a better understanding of what you're trying to achieve and what code you're using now. &nbsp;If you want to post that info, I'll be glad to try to help.<br />
<br />
Best, ~Ray
</div>


<div>
Just trying to save files and images to a mysql database, found various scripts, but tryng to get the storage working properly. Images is fine. I just need a good script on saving files and downloading them from the MySQL database, im not worrying too much about the filesystem vs database storage problem at the moment.
</div>


<div>
I can give you a download example, but you REALLY NEED TO UNDERSTAND WHAT YOU ARE DOING if you put an image into a data base. &nbsp;The database will become very slow. &nbsp;You will have difficulty with backups. &nbsp;There are a host of problems with doing it this way. &nbsp;It's sort of like putting a flushing toilet into a car. &nbsp;You have seen them in boats, and it makes sense there, so you try to put one into a car. &nbsp;You could do it, but it might be more of a mess than you want to deal with. &nbsp;<br />
<br />
So you are warned now, and I sincerely hope you will change strategy and NOT DO THIS.<br />
<br />
Here is a d/l script, so the question is answered. &nbsp;In case you decide you would like to ask this question a different way, you might want to post something about how to choose the best practices for uploading, downloading and saving images.<br />
<br />
What are you looking for when you way this: &quot;I would like the file name as well as the extension.&quot; &nbsp;You cannot get the file name from a client machine, only the basename.<br />
<br />
Best of luck, and I hope you reconsider! ~Ray<br />

<pre><code class="code-10 nolinks" id="code-265930"><span>&lt;?php // RAY_force_download.php</span>
<span> </span>
<span>// FUNCTION TO FORCE A FILE DOWNLOAD FROM A MySQL DATABASE BLOB</span>
<span>function force_download($table, $key, $type=&quot;jpg&quot;)</span>
<span>// ASSUME CONNECTION TO DATA BASE SERVER AND SELECTION OF DATA BASE</span>
<span>{</span>
<span> </span>
<span>// SYNTHESIZE THE FILE NAME</span>
<span>    $file = 'blob.' . $type; </span>
<span>    </span>
<span>// CONSTRUCT A QUERY, LOCATE THE INFORMATION TO BE DOWNLOADED    </span>
<span>    $sql  = &quot;SELECT blob FROM $table WHERE key=$key LIMIT 1&quot;;</span>
<span>    $res  = mysql_query($sql) or die( mysql_error() );</span>
<span>    if (!mysql_num_rows()) return FALSE;</span>
<span>    $row  = mysql_fetch_assoc($res);</span>
<span>    </span>
<span>// DETERMINE THE SIZE OF THE DOWNLOAD    </span>
<span>    $size = strlen($row[&quot;blob&quot;]);</span>
<span>    </span>
<span>// ISSUE THE HEADERS TO CAUSE A DOWNLOAD    </span>
<span>    header(&quot;Content-Type: application/force-download&quot;);</span>
<span>    header(&quot;Content-Disposition: attachment; filename=\&quot;$file\&quot;&quot;);</span>
<span>    header(&quot;Content-length: &quot;.(string)($size));</span>
<span>    header(&quot;Expires: &quot;.gmdate(&quot;D, d M Y H:i:s&quot;, mktime(date(&quot;H&quot;)+2, date(&quot;i&quot;), date(&quot;s&quot;), date(&quot;m&quot;), date(&quot;d&quot;), date(&quot;Y&quot;))).&quot; GMT&quot;);</span>
<span>    header(&quot;Last-Modified: &quot;.gmdate(&quot;D, d M Y H:i:s&quot;).&quot; GMT&quot;);</span>
<span>    header(&quot;Cache-Control: no-cache, must-revalidate&quot;);</span>
<span>    header(&quot;Pragma: no-cache&quot;);</span>
<span>    flush();</span>
<span> </span>
<span>// DOWNLOAD THE BLOB</span>
<span>    echo $row[&quot;blob&quot;];</span>
<span>    return TRUE;</span>
<span>}</span>
<span> </span>
<span>?&gt;</span>
</code></pre>
</div>


<div>
Have you got an upload script to the mysql database, bearing in mind I have global variables off. Thanks for the help.
</div>


<div>
Thank you for your help very useful tips.
</div>


<div>
Thanks for the points! &nbsp;Best of luck with it, ~Ray
</div>


<div>
<div class="content wysiwyg-content">
I am storing images into MySQL as type BLOB. I want to know how do I get the filename of the file (a.jpg) and make the link available for download rather than show.<br />
<br />
Currently:<br />
I can only get the jpg as I found this on the internet: but I would like the file name as well as the extension.<br />
$ext = explode('.', $_FILES['userFile']['name'<wbr />]);<br />
$filename = $_POST['userName'] . '.' . $ext[count($ext)-1];
</div>
</div>


I am storing images into MySQL as type BLOB. I want to know how do I get the filename of the file (a.jpg) and make the link available for download rather than show.

Currently:
I can only get the jpg as I found this on the internet: but I would like the file name as well as the extension.
$ext = explode('.', $_FILES['userFile']['name']);
$filename = $_POST['userName'] . '.' . $ext[count($ext)-1];

Storing Image in MYSQL Blob and Retrieving as a Downloadable Link

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.