Results 1 to 3 of 3

Thread: Blob type : How to ...

  1. #1
    Registered
    Join Date
    Jan 2006
    Location
    Italy/Thailand
    Posts
    27

    Blob type : How to ...

    This is my problem:
    I have several GIFs stored in a mysql table as Longblob type.

    I'd like to "convert" this binary content to "regular" GIF files on my Hard Drive

    What's the esiest way to do it?

    ps. I have the script to display the images with PHP, that doesn't solve my prob.
    I need to store the imgs and upload them to a separate folder on my server.

    Thanks for helping the n00b

  2. #2
    Going strong! Kings's Avatar
    Join Date
    Aug 2003
    Posts
    61
    Write a PHP script that will retrieve all the GIF images from the database (using the standard DB functions, like mysql_connect and mysql_query), then write each GIF to the HD (using the standard file functions, like fopen and fwrite).

    Let me know if you need a simple example
    Dennis Pallett

  3. #3
    Registered
    Join Date
    Jan 2006
    Location
    Italy/Thailand
    Posts
    27
    Thanks Dennis, mission accomplished

Similar Threads

  1. Where to find this type of content?
    By deronsizemore in forum General Chat
    Replies: 3
    Last Post: 11-14-2005, 06:59 AM
  2. Personality Type
    By incka in forum General Chat
    Replies: 8
    Last Post: 06-08-2004, 12:45 PM
  3. dating type of sites ?
    By s2kinteg916 in forum Advertising & Affiliate Programs
    Replies: 8
    Last Post: 04-28-2004, 09:04 AM
  4. changing a field type in mysql
    By eMEraLdwPn in forum Website Programming & Databases
    Replies: 2
    Last Post: 02-06-2004, 10:13 PM
  5. friendster type sites ?
    By s2kinteg916 in forum Advertising & Affiliate Programs
    Replies: 1
    Last Post: 10-28-2003, 12:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •