473,486 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Store Multiple Images in Mysql

250 Contributor
I'm using mysql and php. In my application I want to store multiple images in a database.
ex: I want to store a vehicle details. vehicle id, type,make and vehicle images. there can be 1 or more images for 1 vehicle. Should I need to create column for vehicle table or should I create separate table for images. Please help me..
Jul 14 '11 #1
3 3886
code green
1,726 Recognized Expert Top Contributor
Unlees you really need to, images are better stored directly on the server.
Then in your table have an extra column that stores the filename.
The database can quickly grow storing blob data.
Jul 14 '11 #2
ghjk
250 Contributor
How can I store more images in one column.
This is my table
Expand|Select|Wrap|Line Numbers
  1. vehicleId  vehicleMake     vehicleModel  imagePath
  2.  
  3.  
Jul 14 '11 #3
mwasif
802 Recognized Expert Contributor
You should create a separate table to store images/images path containing the following 2 fields (you can add more fields if required e.g. image type) e.g.
vehicleId
imagePath
Jul 17 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2188
by: Patrick Blackman | last post by:
How do you create a TIFF to store multiple images?
2
4483
by: Netian | last post by:
Hello , Please teach me how to create an Icon object with multiple images by GDI++ . I can create an Icon with a image as following , but can't do an Icon with multiple images. private Icon...
9
2247
by: Ben | last post by:
Hi Please Help?! I have created a file which contains some app settings, plus two images. I used the code below to read the contents of the image, then save it with my app settings: ...
7
17869
by: mukeshpatil | last post by:
How to get data from .CSV file using php & store it into Mysql database I want to read data from two different .CSV files using php & How to store it into Mysql Database tables Please help me...
1
2039
by: thulaseeram | last post by:
I am using iframe to store uploaded images, it is uploading fine in IE but it is not happening in firefox means first time it is uploading image if i try to upload second image it is not calling even...
11
4139
by: Jankie | last post by:
I need to dispaly a user's multiple images in one entry.Right now,say if a user uploads 3 images,three entries for the same id display to match 3 images. I only want 1 entry to display all of a...
1
2719
by: =?Utf-8?B?UmFqYWdvcGFs?= | last post by:
Question How to Upload multiple images in asp.net? (ex.Like a gmail file field)
2
3240
by: sarayu | last post by:
Hi All, How can i select multiple images by using shift or control key from my hard disk and upload it by using a submit button.For this what we use for selecting different images and...
3
2785
KeredDrahcir
by: KeredDrahcir | last post by:
I want to be able the upload multiple images at once. I can do a normal upload where the user browses for each image individually and I can also do where you have several browse images on the screen....
2
2337
by: deepucando | last post by:
Hi i need help that how to store the images in the mysql table and retrieval of stored image using php code... sample code that helps me a lot.. regards ~Deepu~
0
7094
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7173
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7305
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5427
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4863
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3066
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1378
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
598
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.