Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

MySQL Abilities

Codes here !

Moderators: macek, egami, gesf

MySQL Abilities

Postby bonkers » Thu Jun 05, 2003 5:31 pm

Does MySQL have the ability to hold images in it?
bonkers
New php-forum User
New php-forum User
 
Posts: 46
Joined: Wed Mar 12, 2003 7:17 pm

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

Yes it has,
format: BLOB
User avatar
wmdrumaizi
New php-forum User
New php-forum User
 
Posts: 40
Joined: Thu Jan 23, 2003 5:15 pm
Location: Malaysia

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.
bonkers
New php-forum User
New php-forum User
 
Posts: 46
Joined: Wed Mar 12, 2003 7:17 pm

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!?
liquedus
php-forum Active User
php-forum Active User
 
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada

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
WiZARD
Moderator
Moderator
 
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol

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

that's how I do it too.
User avatar
Redcircle
Moderator
Moderator
 
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA

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

What is the PK of a row?
bonkers
New php-forum User
New php-forum User
 
Posts: 46
Joined: Wed Mar 12, 2003 7:17 pm

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

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

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?
User avatar
WiZARD
Moderator
Moderator
 
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.