Image as an argument to the stored procedure

Reply

Join Date: May 2009
Posts: 10
Reputation: mohan7690 is an unknown quantity at this point 
Solved Threads: 0
mohan7690 mohan7690 is offline Offline
Newbie Poster

Image as an argument to the stored procedure

 
0
  #1
Sep 1st, 2009
hi all i want to insert an image into mysql database
using stored procedure, i need to pass the image from c# plz help me
Mohan Kumar
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 79
Reputation: varmadba is an unknown quantity at this point 
Solved Threads: 8
varmadba varmadba is offline Offline
Junior Poster in Training

Re: Image as an argument to the stored procedure

 
0
  #2
Sep 2nd, 2009
Save the image in the database as type BLOB
and Load the image file and read the file into a variable using file_get_contents() or similar

but best way is not to save image directly in Database rather save location or assign UUID to a image and save it to disk
so when u recall you can go and pick the image instead of regenerating image from pixels
:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/
Reply With Quote Quick reply to this message  
Reply

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC