b1naryc0de 1 Report post Posted June 25, 2005 Tumpang lalu.. Mintak tolong boleh?? Camner nak simpan gambar dalam mysql?? Aku nak pakai php dengan mysql untuk simpan gambar dalam database..*maaf kalo soalan ni dah selalu ditanya Quote Share this post Link to post Share on other sites
sharuzzaman 1 Report post Posted June 26, 2005 simpan gambar atau sebarang bentuk binary dengan menggunakan type blob... tapi sebaiknya jangan simpan gambar dalam database, tapi simpan nama fail gambar tu dalam databaselepas tu gunakan nama fail tu untuk point pegi folder kat mana gambar tu disimpan. Quote Share this post Link to post Share on other sites
b1naryc0de 1 Report post Posted June 26, 2005 (edited) Maksud ko simpan link untuk gambar tue dalam database tapi gambar tu simpan dalam folder gambar.. gitu??Tapi kenapa ko kata sebaiknya jangan simpan gambar dalam database sebaliknya hanya simpan reference fail tersebut?? Adakah sebab untuk mengelakkan slow pada database?? Atau ada lagi sebab2 lain?? Edited June 26, 2005 by b1naryc0de Quote Share this post Link to post Share on other sites
sharuzzaman 1 Report post Posted June 26, 2005 kalau simpan binary, nanti saiz database tu jadi besar giler.. access akan jadi slow, nak buat backup dan restore pun susah.. tapi kalau simpan reference, reference tu hanyalah teks ASCII jer, kecik... Quote Share this post Link to post Share on other sites
b1naryc0de 1 Report post Posted June 26, 2005 ok.. mekasih Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 27, 2005 Actually.... Size sesuatu database tu tak der jadi masalah kalau kiter index betul betul table yang dah sedia ader. Simpan gambar dalam database ni actually not a very common practive. people tend to save FILES instead pictures sebab converion back of the binary kepada imag file on application akan effect System performance..(but we are talking just MILI SECONDS) Image file and text file is about the same thing. Optimzation is all depends on the index of the record. Yang akan slow nanti for sure is back up and restore due to the nature of the data size.Tapi I agree with mr sharuzzaman bab simpan Link/Path for the images somewhere else.StepOrlando, FL 32807 Quote Share this post Link to post Share on other sites
dekzorro 0 Report post Posted June 30, 2005 [sharuzzaman,Jun 26 2005, 07:37 PM]tapi sebaiknya jangan simpan gambar dalam database, tapi simpan nama fail gambar tu dalam databaselepas tu gunakan nama fail tu untuk point pegi folder kat mana gambar tu disimpan.←bole korang terangkan kat aku pasal benda ni. lebih² lagi ayat nih:gunakan nama fail tu untuk point pegi folder kat mana gambar tu disimpan.camne lak kalu guna VB? Quote Share this post Link to post Share on other sites
sharuzzaman 1 Report post Posted June 30, 2005 camne lak kalu guna VB?←kalau guna VB, agak sukar sikit, sebab lain komputer, lain path dia.. kalau specifically guna untuk VB, mungkin kena simpan jugak la dalam database.alternatif lain, fetch gambar untuk papar dalam VB tu guna HTTP. maknanya dalam server database tu, ada gak web server.. so, boleh guna konsep simpan path dalam database, simpan fail dalam folder.. Quote Share this post Link to post Share on other sites
step 0 Report post Posted June 30, 2005 Just sugesttion.. gambar tu simpan dalam same network.. Share la mana mana folder yang boleh accessible for anybody within the network... Another method simpan kat WEB directory and you can retrive the image via HTTP and IP link.Step Quote Share this post Link to post Share on other sites
manequeen 0 Report post Posted October 16, 2008 saya pun nak simpan gambau dlm database tp sy guna ms sql server + visual studio 2005 + asp.net + vb...dalam form yg ada personal detail tp nak save gmbar skali...simpan dlm db coz in future when they wat search..kuar detail with the gmbar skali..tolong la ajau sya step by step..dah buntu nie,dateline pun dh lepas...if nak save link in db..pls tell me how...pls..pls...thx anyway... Quote Share this post Link to post Share on other sites