MySQL Abilities

Codes here !

Moderators: egami, macek, gesf

Post Reply
bonkers
New php-forum User
New php-forum User
Posts: 45
Joined: Wed Mar 12, 2003 7:17 pm

Thu Jun 05, 2003 5:31 pm

Does MySQL have the ability to hold images in it?

User avatar
wmdrumaizi
New php-forum User
New php-forum User
Posts: 40
Joined: Thu Jan 23, 2003 5:15 pm
Location: Malaysia
Contact:

Thu Jun 05, 2003 7:10 pm

Yes it has,
format: BLOB
Thanks and regards;
wmdrumaizi

bonkers
New php-forum User
New php-forum User
Posts: 45
Joined: Wed Mar 12, 2003 7:17 pm

Thu Jun 05, 2003 7:30 pm

Alright, I'm going to search for "blob" tutorials and see what I can find on google, but if anyone has any favorites I'd appreciate it.

liquedus
php-forum Active User
php-forum Active User
Posts: 264
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada
Contact:

Fri Jun 06, 2003 4:10 am

http://www.phpbuilder.com/columns/william19990908.php3

however i wouldnt bother holding images in MySQL, can you imagine why?, rather I would rename the uploaded file to perhaps the PK of the row!?

User avatar
WiZARD
Moderator
Moderator
Posts: 1240
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol
Contact:

Fri Jun 06, 2003 7:08 am

bonkers wrote:Does MySQL have the ability to hold images in it?

but i'm not reccomend do this cause if more images you storing in DB reindexing or other process with DB too hard for DB
IMHO i use just string there placed string at directory where placed images.....
"Sex,Drugs and Rock&Roll " replaced at "Sucks,Bugs and Plug&Play";
Image

User avatar
Redcircle
Moderator
Moderator
Posts: 826
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Fri Jun 06, 2003 11:13 am

that's how I do it too.

bonkers
New php-forum User
New php-forum User
Posts: 45
Joined: Wed Mar 12, 2003 7:17 pm

Fri Jun 06, 2003 1:00 pm

What is the PK of a row?

User avatar
Redcircle
Moderator
Moderator
Posts: 826
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Sat Jun 07, 2003 5:18 am

PK?

User avatar
WiZARD
Moderator
Moderator
Posts: 1240
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol
Contact:

Sun Jun 08, 2003 3:52 am

structure in DB:
images_id init autoincrement,
images_descrition varchar(250),
images_date datetime,
images_img_small varchar(200),
images_img_big varchar(200),
etc


in images_img_small varchar(200) and
images_img_big varchar(200)
you hold path to images.....
it's difficult?
"Sex,Drugs and Rock&Roll " replaced at "Sucks,Bugs and Plug&Play";
Image

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 6 guests