Jump to content

Sql Query

How to insert an image into the table?  

1 member has voted

  1. 1. How to insert an image into the table?

    • Tell me how to insert teh images into the tables.
    • what is the data type and what is the query to do it?

Recommended Posts

vBulletin manages to store images and many other files via SQL. I think there are PHP functions which build and unbuild image files into their binary code for database storage. It gives faster access times compared to webspace-based images.

Link to post
Share on other sites

whoa, really? That's pretty cool... I woulda thought that browsers need an absolute path for all images that it displays.EDIT:indeed you can, but it would hurt the server processing time and is unnecessary. http://news.postnuke.com/index.php?name=Ne...3&theme=Printer

Link to post
Share on other sites

I mean, I want to maintain a database for my friends. I want to store their details along with their photos. How is it possible to do that? I want to store the photos and retrieve them through some fornt-end application like VB, VB.NET, JSP. Can anybody help me?

Link to post
Share on other sites

Of course you can store images (sounds, flash animation,...) into an Access or an SQL database, but it's really huge and it could be dangerous for the stability of your database. If you still want to do it, you have to options:- insert your images manually in a OLE OBJECT field of your database.- insert them dynamicly in your data base using some inserts or updates statments and an asp or a php function to first decode your image in their binary code.But, as it was mentionned before, the best way would be to store the path of your images in your database and to put your images on your server. That would be my choice.Happy programing :) Jerome

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...