/    Sign up×
Community /Pin to ProfileBookmark

where is the picture Stored to do quiery

Copy linkTweet thisAlerts:
Jun 20.2006

Ok, I was thinking when i upload a picture where is it going to be store so i can call it later for displaying along some info.

I was thinking it needs to go to the database, so i can call it later, because it it goes into a directory i will have problems calling it, later,

help please

to post a comment
PHP

6 Comments(s) ↴

Copy linkTweet thisAlerts:
@scottyrobJun 20.2006 — I dont think you can store images in a database... You can however store a link to the image though... i.e in the database have <img src="xxx.jpg">
Copy linkTweet thisAlerts:
@franknuauthorJun 20.2006 — so how so i display the image. let's say i have a bunch of info that goes with the image after i submit that info how do i call it then
Copy linkTweet thisAlerts:
@jonraJun 20.2006 — You can store the image in the DB as a BLOB, however for the most part you don't want to do this. Simply store the image file name in the DB, store the actual image on the web server, and use a call to the DB to populate your image source.

&lt;img src="imageDirectory/&lt;?=$row['fileName']?&gt;"&gt;
Copy linkTweet thisAlerts:
@franknuauthorJun 20.2006 — i think i got it now. So the only think that will be store in the dabase is the Name of the file which will be call by an query later when i need it..
Copy linkTweet thisAlerts:
@bokehJun 20.2006 — So the only think that will be store in the dabase is the Name[/QUOTE]You can store whatever you like in your database, width, height, mime type, format, etc. but storing images as binary data is not such a good idea.
Copy linkTweet thisAlerts:
@franknuauthorJun 20.2006 — What link do i have to create to store in my database. and to create just the name on the database does it have to have an extension.
×

Success!

Help @franknu spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...