Jump to content

Sql Query


Prakash
 Share

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.
      0
    • what is the data type and what is the query to do it?
      1


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 comment
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 comment
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 comment
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 comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...