#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    30
    Rep Power
    14
    I want to store pictures in a MySQL database, how would I go about inserting a picture into a MySQL database? Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    44
    Rep Power
    15
    I upload the pictures I want to store to a webserver, and input the url of the image into the mysql database. If there's a way to just upload the image to the database, I'd like to know how to do this too.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    30
    Rep Power
    14
    I know with access databases you can store pictures directly in the database as type BLOB....so I am guessing you should be able to do it with MySQL...I guess we will just wait for someone to help us.
  6. #4
  7. No Profile Picture
    Guest
    Devshed Newbie (0 - 499 posts)
    Well, PHP makes it very simple. The only problem is that the example I found only did one picture - a bit of a pain if you have several hundred to do :-) have a look at http://www.weberdev.com/get_example.php3?count=167

    I also found an example which used Perl and DBI, but I can't get it to work. I think there is a fundamental error in the script I found and I can't fix it :-( So, I will try and write a bulk loader in PHP and post it ..
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    32
    Rep Power
    14
    There's also an article in phpbuilder about this too..

    <A HREF="http://www.phpbuilder.com/columns/florian19991014.php3" TARGET=_blank>http://www.phpbuilder.com/columns/florian19991014.php3
    </A>

    scoobydoo

    [This message has been edited by scoobydoo (edited June 10, 2000).]

Similar Threads

  1. Display of pictures stored in mySQL blobs
    By justStarting in forum PHP Development
    Replies: 37
    Last Post: August 25th, 2004, 06:41 PM
  2. pictures in mysql & php
    By collegebloke in forum PHP Development
    Replies: 7
    Last Post: November 26th, 2003, 12:03 PM
  3. Error in PHP code concerning displaying pictures from mySQL
    By markb_1984 in forum PHP Development
    Replies: 30
    Last Post: February 21st, 2003, 03:02 PM
  4. storing pictures in MySQL
    By veedub in forum MySQL Help
    Replies: 6
    Last Post: November 3rd, 2000, 08:00 PM
  5. Best method to access pictures from mySQL.
    By SWiTCH2 in forum PHP Development
    Replies: 6
    Last Post: October 18th, 1999, 01:48 AM

IMN logo majestic logo threadwatch logo seochat tools logo