Professional Web Applications Themes

PHP, MySQL, Blob data type - Macromedia Dreamweaver

I'm going to store image files in Blob data field. Does anyone know if there is an easy way to use Dreamweaver (or Dreamweaver Extension) to display the image data? Also, can I use Dreamweaver to insert image data? If you can point me to URLs, that will be great. Thanks, Alex...

  1. #1

    Default PHP, MySQL, Blob data type

    I'm going to store image files in Blob data field. Does anyone know if there is an easy way to use Dreamweaver (or Dreamweaver Extension) to display the image data? Also, can I use Dreamweaver to insert image data? If you can point me to URLs, that will be great.

    Thanks,
    Alex
    Alex Yu Guest

  2. #2

    Default Re: PHP, MySQL, Blob data type

    why blob type...

    its gonna kill your db performance....


    "Alex Yu" <ayu168msn.com> wrote in message
    news:bg4994$nae$1forums.macromedia.com...
    I'm going to store image files in Blob data field. Does anyone know if
    there is an easy way to use Dreamweaver (or Dreamweaver Extension) to
    display the image data? Also, can I use Dreamweaver to insert image data?
    If you can point me to URLs, that will be great.

    Thanks,
    Alex


    wibble Guest

  3. #3

    Default Re: PHP, MySQL, Blob data type

    Josh wrote:
    > I may be off base here, but wouldn't it be easier to store the images
    > in a server directory, and then just store the source link and size
    > information in the database? I'd think you'd increase performance and
    > decrease some of the implementation complexity.
    Not off base at all. Absolutely spot on.

    Databases are for storing searchable data. Use the DB to store details of
    the images and where they are stored, but store the images outside the DB.

    --
    David Powers
    *******************************************
    No-nonsense reviews of computer books
    [url]http://japan-interface.co.uk/webdesign/books.html[/url]
    Save 10% on TopStyle CSS Editor
    *******************************************


    David Powers Guest

  4. #4

    Default Re: PHP, MySQL, Blob data type

    Thanks for the comments... I will try this approach then. But does Dreamweaver have a built-in binary data php function or I will have to code in php?

    Thanks,
    Alex
    Alex Guest

Similar Threads

  1. #38921 [NEW]: pdo lost the first row data:with firebird blob data
    By achun dot shx at gmail dot com in forum PHP Bugs
    Replies: 2
    Last Post: January 27th, 12:54 PM
  2. CFMX blob insertion to MySQL
    By cam_pdx in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 16th, 06:49 PM
  3. Read blob from mysql
    By Thierry in forum PHP Development
    Replies: 3
    Last Post: November 18th, 06:39 AM
  4. [PHP] MySQL field data type for ISBN numbers
    By Michael Geier in forum PHP Development
    Replies: 0
    Last Post: August 11th, 12:53 AM
  5. Replies: 1
    Last Post: July 20th, 08:30 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139