Need Help in MySQL

mr_fazz

hey to every computer experts here
just nak tanye, macam mane nak INSERT picture to the database using MySQL statement?
tgh stuck kat situ la

im developing a system using ASP and MySQL

thanks guyz

zenslack

guna blob

http://dev.mysql.com/doc/refman/5.0/en/blob.html

baca dulu

shahnazz

tak pun save the name of the file to the database, the file itself simpan as a file outside of the database. lagi database efficient. file tu pun kena somehow diupload or FTPed to the server.

mr_fazz

Originally posted by zenslack at 10-11-2006 11:40 PM
guna blob

http://dev.mysql.com/doc/refman/5.0/en/blob.html

baca dulu

thanks for the link
saya dah baca but still tak faham macam mane nak apply BLOB
leh tolong explain sikit
really appreciate it

mr_fazz

Originally posted by shahnazz at 13-11-2006 12:29 AM
tak pun save the name of the file to the database, the file itself simpan as a file outside of the database. lagi database efficient. file tu pun kena somehow diupload or FTPed to the server.

ermm.. macam mane nak upload to the server??

shahnazz

try gedek this web site

http://www.hotscripts.com

ada sample PHP code, gedek2 la kat situ
kalau ada masa i pinpoint kat mana utk file upload

kat sana berlambak code bukan saja utk PHP, macam-macam ada...

selamat mencuba :bgrin:

azharfcsit

macam ni la yg aku suka lepak kt forum macam ni..
takde le macam setengah forumer klu org mintak tolong tanye camne nk wat itu wat ini diorang asyik2 jawab RTFM...klu teringin nk jawab sgt camtu jawab dalam hati dah le..tak pyh tulis kt sini RTFM

mr_fazz

Originally posted by shahnazz at 14-11-2006 09:26 AM
try gedek this web site

http://www.hotscripts.com

ada sample PHP code, gedek2 la kat situ
kalau ada masa i pinpoint kat mana utk file upload

kat sana berlambak code bukan saja utk PHP, ma ...

thanks shahnaz
i'll try to look through and apply to my project
anything i will ask again
really appreciate it

erkk.. tenkiu bagi info...

Application Developer
ITBaseLogger
0123959774

neotoxin

err.. utk ASP sama konsep ngan PHP ke? i.e. kena open (read mode), read as a variable, close, kemudian insert dlm db as blob...

drasmadi

ASP tu Microsoft punya, Php tu Opensource ... kalau silap maaf.

jimbait

what is " rtfm "??

nuwa

rtfm = "Read The F**k Manual" :D

payungterjun

takyah guna blob tuuu beb, buat semak ko punya DB jek, baik ko simpan jea filename & location file tu dalam DB, dan gambar tuuu upload ke server...