473,655 Members | 3,114 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

lots of data with pictures, how to put it in website database?

Hi guys,
i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?
Jul 19 '05 #1
3 2009
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #2
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #3
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
2778
by: google_nospam | last post by:
Thanks in advance for any help. I'm looking for a way to pass data from php to perl. Basically, I want to take some dynamic data from a database, mixed with user input, then reformat it to make a new set of variables and pass those variables to a perl script to do all the hard work. Anyway, I can handle the database connectivity, and putting variables together, but how do I pass the variables to perl? I have seen other comments on...
10
1739
by: Dave Moore | last post by:
Hi All, I want to be able to store data as part of my website. I'm assuming that I''ll need to use PHP scripts to provide this functionality, but what would the best aproach be to storing data?. I could use a database of some sort (maybe MySQL?), but I'm wondering whether there are any other aproaches to data storage that would be less elaborate than a full database. Any ideas?. Dave
0
2020
by: JakeC | last post by:
Hey all, I'm currently redesigning a website that a friend and I started about a year ago. It is a daily surf report so when choosing the best script/language to use for the new design, I found that a mixture of PHP and MySQL would be a good idea. I have currently set up OmniHTTPd and installed MySQL and PHP onto my homeserver. I want the site to be set up as follows: 1- I add the report, date and pictures (and amount of pictures...
5
1415
by: Simon | last post by:
Hi all, I'm hoping that someone could help with the following general question: I'm making a website that manages beta releases of software. It does various things like store bugs, comments, work arounds and feature requests. Users can subscribe to be notified if a feature or bug is detected in their area of interest. The software developer can publish new and polls and all sorts of crap like
2
1267
by: Sune | last post by:
Hi, I'm in the situation that i need to print (to paper) some documents from a database using a website, and i need to manipulate the data on the fly, but my problem is that i don't know how to do this or if it's even possible. I need to split the content in to individual pages, so that when it gets printed via the browser it will be possible for me to print it in a custom table that provides a design (header/footer) with the company...
3
2006
by: John | last post by:
Hi We have a staff database app that also stores staff pictures with each staff record. I have been asked to design something so we can send pictures of staff to people's mobiles when they need it for ID purposes. I have no idea where to start on this. Has anyone had any experience with sending pictures to mobiles from a .net app? Any pointers would be appreciated. I would not know the phone service providers of the recipients...
3
1443
by: ulrichwilliam | last post by:
Hello Everybody, I have written a function for new user to register online it collect information about them. It is working fine and the user data are stored on phpmyadmin on a long row. Now i want to publish all the entered user data on the website. Actually this is done automatically but when i try to add pictures to their profile i do not see them on the website i only see their data(i.e. height, size,...) but no pictures. i used ...
1
1484
by: FeelLikeANut | last post by:
My question is partly a language issue (memory) and partly a Web issue (where the program runs), so I hope everyone will be open to helping. Users may submit and store pictures with my program. I have the choice of storing these pictures either as files on the server or as a blob in the database. The pictures are just user data, and it seems logical to keep them in the database with all the other data. But I'm concerned about how to...
5
7608
by: countnazgul | last post by:
Hello, I've got very odd problem. I use windows application to store files in data base (MySql) and then to extract this files from data base and save it on hdd. But when i save them back to hdd tihs files are 1Kb less from original file. When i insert pictures this 1kb obviously is not imported and the pictures is shown. But other files when try to be opened is corrupted or if they open some error message is shown. So the code that i use to...
0
8380
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8816
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8710
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8497
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8598
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7310
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4150
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4299
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1928
muto222
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.