Help me adding and fetching images from mysql database

[Lucifer]

I am so not able to know how am i supposed to fetch or insert images into database so if anyone could help would be great

 

[Ciccioo]

you don't

storing the path is often a better idea

 

if you MUST store them in the database, i presume you would have to save them in a blob field, but again, it wouldn't be optimal

[alpenwasser]

What language are you using?

There are upsides and downsides to this approach, you'll find

plenty of pro and con arguments when you google around. As @Ciccioo

says, often you can just store the image path, and if you really

do wish to store the images directly in the database, you'd use

a blob field. I have done this for a website I did, it's not really

that difficult (although I'd need to look it up again as I haven't

looked at it in a while ).

[MG2R]

Basically: all of the above...

 

Storing images in the database is usually slower and more

resource consuming than only storing the image path.

 

Since you didn't specify what language you're working with,

I can't really help with any specific code. Maybe elaborate

a bit more on what it is you're trying to accomplish?

[rockking1379]

Blob data type. Some say to just store a file path. The issue there is synchronization between disc and database.

[MrSuperb]

I am so not able to know how am i supposed to fetch or insert images into database so if anyone could help would be great

 

...

 

....

 

and again the OP is not subscribed to his own thread ...

[MG2R]

and again the OP is not subscribed to his own thread ...

he hasn't been online since making this thread, give him some time...

[Lucifer]

i use php basically but i have only learnt php for content management system not more

[MG2R]

i use php basically but i have only learnt php for content management system not more

I take it you're used to writing Drupal or Joomla modules and now want to build a website from scratch?

 

It'll seem a bit basic, but it's never a bad idea to start at w3schools.

[Lucifer]

yeah ok i'll try thank you

[ultimatemythbuster]

I would not store them in the database.  Only store the path to the image in the database.  You can then use that path to get the image where you need it.