Quantcast

Maximum PC

It is currently Thu Jul 31, 2014 5:50 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Simple Database for Website
PostPosted: Sat Aug 22, 2009 2:53 pm 
Team Member Top 500
Team Member Top 500
User avatar

Joined: Sun Apr 02, 2006 7:32 pm
Posts: 1323
I have been doing some very basic web design and one of my friends has asked me to make a sort of database for her.

Basically she runs a healthy food order site for her local business. She wants to make it so on her website people sign up for a certain amount of "meals" and then every week she wants a total amount of each meals that everyone wants. So like basically she wants a table with each individual order then totals at the bottom.

Is there a simple way to do this?

Heres the order form she currently has in place C's Big Oven

I'm going to re do the form cause its not very user friendly, but how would I make that database of info for her?


Top
  Profile  
 
 Post subject:
PostPosted: Sun Aug 23, 2009 7:42 am 
Team Member Top 50
Team Member Top 50
User avatar

Joined: Sat May 30, 2009 12:53 pm
Posts: 409
So it sounds like she wants a simple spreadsheet that has orders on the y-axis and the different options along the x-axis and then have it self populated every time a customer makes an order.

I'd suggest storing the data in a mysql database then either creating a script to dump what you need into a comma separated value (csv) file. Then load that csv file in Excel or OpenOffice calc. Alternatively, you can try making a php generated html table that pulls it values straight from mysql.


Top
  Profile  
 
 Post subject:
PostPosted: Sun Aug 23, 2009 12:09 pm 
Team Member [Top 500]*
Team Member [Top 500]*
User avatar

Joined: Thu Jun 24, 2004 2:22 pm
Posts: 8720
Location: Cleveland, Ohio
Looks like the website is hosted by GoDaddy. The first thing you likely want to do is see what platform the site is hosted on as in Microsoft, Linux or whatever? Then see what the specific web hosting plan supports as to a database as in MSSQL or MYSQL. Knowing that information will help in deciding how you want to go about this.

Next, when I order my beanies and weenies and click submit where does my order go? Is the form data (order form) dumped into a database? Emailed to the big oven?

If the site plan allows and supports it (which it should) and this is not to be a gigantic database, I would likely create a MS Access database with several tables and link to the tables from the form(s) you use. I would first map out everything with a pencil and paper and work from there. I might think about populating combo boxes from a central set of tables with breakfast, lunch, and dinner plus whatever including the cost with the item. Your call on all of that... pencil and paper.

The language is also your call as long as the site supports it.

Ron


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group