Programming Help

Web Development



What's Here?

  • Members: 137,420
  • Replies: 481,949
  • Topics: 75,147
  • Snippets: 2,568
  • Tutorials: 676
  • Total Online: 1,988
  • Members: 67
  • Guests: 1,921

Welcome to Dream.In.Code
Become a PHP Expert!

Join 137,420 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,988 people online right now. Registration is fast and FREE... Join Now!




How to save picture in mysql

 
 Reply to this topicStart new topic

How to save picture in mysql, How to save picture in mysql
mouse_catz00
23 Jan, 2008 - 12:52 AM
Post #1

New D.I.C Head
*

Joined: 23 Jan, 2008
Posts: 1
i need help in my project. i must save picture in mysql database. tongue.gif
User is offlineProfile CardPM
+Quote Post

didgy58
RE: How To Save Picture In Mysql
23 Jan, 2008 - 08:35 AM
Post #2

D.I.C Head
**

Joined: 23 Oct, 2007
Posts: 171



Thanked: 1 times
My Contributions
do you have to save pictures or couldnt you just save the image name into mysql and then when u pull the record from the database and would like to view the picture u basically put it in a image tage

CODE


<img src="direct to the image folder/ $variable user to hold the sql return['imagename']" />


i think its something along that lines i have the code and ill grab it for u shortly and repost but its something like that off the top of my head

dan
User is online!Profile CardPM
+Quote Post

didgy58
RE: How To Save Picture In Mysql
23 Jan, 2008 - 08:41 AM
Post #3

D.I.C Head
**

Joined: 23 Oct, 2007
Posts: 171



Thanked: 1 times
My Contributions
CODE


$pic=$row['Picture'];

><img src='../images/$pic' border=0 alt=''></



thats how i have gone about using images with my database

hope that helps.
User is online!Profile CardPM
+Quote Post

MitkOK
RE: How To Save Picture In Mysql
23 Jan, 2008 - 10:04 PM
Post #4

D.I.C Regular
Group Icon

Joined: 9 Aug, 2007
Posts: 314



Thanked: 12 times
Dream Kudos: 250
My Contributions
Alternative way, which I do not prefer :
- http://dev.mysql.com/doc/refman/5.0/en/blob.html
- http://www.weberdev.com/get_example-3688.html

It's better to upload image in directory and put image path in MySQL field.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/5/08 04:25AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month