Images in MySQL Table

[CrowleySA]

Hi, I'm pretty new to PHP but I've recently gotten some requests for web development, so I want to start using it more often. Still I'm new - so bear with me.

I want to store images in a MySQL database. I got some example code from tutorials on the web:
I made a mediumblob field in a table.
I take the pic, base64_encode it and then save it in the table.
To display the picture I base64_decode the field and then just echo it.

Now, this works fine on my Windows dev system, but it doesn't when I upload it to the Unix system hosting the site.

What can be the problem?

If I need to post the code I will...

[paulnaj]

Hi CrowleySA,

I'm not sure you're going to get much help on this one, I'm afraid. The standard way to store images 'in a database' would be just to store the filepath in the table, and the images in folders as usual.

I know you can do it your way as well, but I think it's fraught.

Having said that, have you got any part of the site (without images) working OK? Is it just the images that are the problem?

Paul.