MySQL Abilities

Codes here !

Moderators: macek, egami, gesf

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

MySQL Abilities

Postby bonkers » 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:

Postby wmdrumaizi » Thu Jun 05, 2003 7:10 pm

Yes it has,
format: BLOB

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

Postby bonkers » 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: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada
Contact:

Postby liquedus » 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: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol
Contact:

Re: MySQL Abilities

Postby WiZARD » 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.....

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

Postby Redcircle » Fri Jun 06, 2003 11:13 am

that's how I do it too.

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

Postby bonkers » Fri Jun 06, 2003 1:00 pm

What is the PK of a row?

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

Postby Redcircle » Sat Jun 07, 2003 5:18 am

PK?

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

Re: MySQL Abilities

Postby WiZARD » 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?


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 1 guest

cron