Images php and postgresql

angelorigo

I would like to know a code showing how to store images in a postgresql database shoing how to send the image how to retrieve from the database.

Thank´s in advance

chads2k2

Learn to read. That is the only way you will truly suceed in PHP/MySQL and others. You are looking at decomposing a .jpg or such and placing the BIGBLOB in the database and then from there you should learn how to do it on your own. GD becomes your friend. I will not release the code. Do NOT try to jump ahead without doing the work first. Make your mistakes and learn from them. That is the only way you can truly learn. I teach my class that everday and will continue to. Hate being this rude and blunt but it has been one of those days.

nnichols

chads2k2 is right. We are all here to help but you must also help yourself. If you have a go and don't succeed then there are loads of people here willing to look at your code and help you through.

But you won't learn by just being given the answers to the questions - I seem to remember teachers saying that of cheating at school.

Look through the posts on here. It is a common area and there are loads of threads. Most are written referring to MySQL but that can very easily be adapted for pgsql.

To get you started -

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10231230

ultraslacker

Are you sure you need to store a binary in the database? You will probably be fine storing the path to the image instead...

csn

Don't store images in databases!

angelorigo

Originally posted by ultraslacker
Are you sure you need to store a binary in the database? You will probably be fine storing the path to the image instead...

yes i think that´s a good way!, i am using postgresql, my intention here is to ask for tutorials about this topic

angelorigo

Originally posted by chads2k2
Learn to read. That is the only way you will truly suceed in PHP/MySQL and others. You are looking at decomposing a .jpg or such and placing the BIGBLOB in the database and then from there you should learn how to do it on your own. GD becomes your friend. I will not release the code. Do NOT try to jump ahead without doing the work first. Make your mistakes and learn from them. That is the only way you can truly learn. I teach my class that everday and will continue to. Hate being this rude and blunt but it has been one of those days.

Hi i do have tutorials about storing binary data with php mysql, but for postgresql i do not have found tutorials about, just the pg_escape_bytea in the php manual online, in help to searching tutorials about i try post this message here to verify if you can point me some documentation.

I like to read a lot!!!

nnichols

All the good tutorials that I know of relate to using php to store images in MySQL. If you download a copy of the php manual you will very quickly be able to turn the code for MySQL to code for PgSQL.

Examples -
mysql_query() => pg_query()
mysql_fetch_array() => pg_fetch_array()

But as both ultraslacker & csn said above - you shouldn't be storing the images in a db. It is inefficient and it is much better to store the image path/name in the db, and store the image in the filesystem.

angelorigo

Originally posted by nnichols
All the good tutorials that I know of relate to using php to store images in MySQL. If you download a copy of the php manual you will very quickly be able to turn the code for MySQL to code for PgSQL.

Examples -
mysql_query() => pg_query()
mysql_fetch_array() => pg_fetch_array()

But as both ultraslacker & csn said above - you shouldn't be storing the images in a db. It is inefficient and it is much better to store the image path/name in the db, and store the image in the filesystem.

Thank´s in advance, probably i will share my doubts here again!

nnichols

Have a go and then post the problems if you struggle with it.

Good luck!