What if several users try to access a different picture at the same
time? Won't that render the wrong image for some?
Gerry
On 2/16/06, tedd <tedd@xxxxxxxxxxxx> wrote:
> Hi gang:
>
> In a previous post (i.e., Strange response to MySQL query) I
> was trying to save a BLOB as a file, namely using an "INTO DUMPFILE"
> query.
>
> If you are the system admin, and have all the system permissions,
> then this is not a big problem. However, if you aren't, then getting
> MySQL to dump a file becomes very problematic with respect to getting
> the right permissions to accomplish the task.
>
> So, I found a way around it. I am sure that others have thought of
> this before me, so I'm not claiming credit and I am sure that this
> solution is obvious to some -- but, it's just that I searched
> literally hundreds of posts and spent considerable time without
> finding an answer. The following is the result of my tinkering. So
> here goes:
>
> First, on your site create a file called "my_image.png"
>
> Second, give it 777 permissions.
>
> Third, in your code after opening the dB, grab the image from MySQL:
>
> $dbQuery = "SELECT image";
> $dbQuery .= "FROM $your_table ";
> $dbQuery .= "WHERE image_Id = $pageNum";
>
> $result = mysql_query($dbQuery) or die("Error: ".mysql_error());
>
> Forth, drop the image into a variable:
>
> $fileContent = @mysql_result($result, 0, "image");
>
> Fifth, create an image from a string (a great function here):
>
> $original=imagecreatefromstring($fileContent);
>
> Sixth, save the image.
>
> imagepng($original, "my_image.png");
>
> And Bingo, the image is now the "my_image.png" file.
>
> Any comments or suggestions are welcomed.
>
> tedd
>
> --
> --------------------------------------------------------------------------------
> http://sperling.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Gerry
http://portal.danen.org/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
