logo-dw

Go Back   Dreamweaver Club Forums > Dreamweaver forums > Web Hosting and FTP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 09-25-2009, 02:43 PM   #1
Johnny Mac
Johnny Mac's Avatar
 
Join Date: Sep 2009
Posts: 9
Talking database hosting question/my life story

the more I learn the less I know.... umpfh!

Currently, a customer fills out a customized Excel spreadsheet then sends it back to me as an order. I print the invoice (a worksheet), the consumer signs for acceptance of goods and services, I scan it into a PDF then email it back to the person/account who requested the order (and also CC it to accounting for payment).

I also maintain a webpage for their account that allows everyone to view YTD, pending orders, invoices due, etc.

I want to move most of the ordering process and account management onto the web and develop a web application website.

My big aggravation is this... I customize each workbook for each customer, ie: company name, address, billing email, etc.... When I update a spreadsheet (raise prices, change the look of the invoice, etc) I then have to go back, re-create a new customized workbook for each account, name it V2x, email back to them and hope they actually use it, often the don't. Each account typically has several employees that orders from me. So I find myself cut and copying info from the older spreadsheet versions into the newer version.

I want to create one, master order solution where folks log into my company website, enter the consumer information, pick the goods and services, and save it to their account.

This way I can 1) make changes once and everyone is ordering in a standardized system... and more importantly... 2) I better protect my VBA programming/intellectual property by not sending everyone a complete workbook sitting on their local machines with years of my work only protected by passwords/hiding sheets, etc. (That part makes me a wee bit nervous I gotta tell ya.)

I've already lost years to Frontpage that I ultimately abandonded and I don't want to start on the wrong path with this endeavour.

IIS or Apache/linux? SQL/ASP or PHP/MySql? ...and why?

I'm less concerned about cost and more concerned about growth, flexibility, security.

Thanks in advance

JM
Johnny Mac is offline   Reply With Quote
Old 09-25-2009, 06:29 PM   #2
domedia
Administrator
domedia's Avatar
 
Join Date: Dec 2003
Posts: 9,730
Default

There has to be an existing online solution for this.
Quote:
IIS or Apache/linux? SQL/ASP or PHP/MySql? ...and why?
This really shouldn't matter much. You want the house built properly, you don't really care what kind of hammer the builder is using.
domedia is offline   Reply With Quote
Old 09-25-2009, 06:42 PM   #3
Johnny Mac
Johnny Mac's Avatar
 
Join Date: Sep 2009
Posts: 9
Default

thanks Dom... I currently have a Windows hosted domain and a Linux hosted domain too.. I am looking for input from someone with experience between the two database solutions before I devote my time to developing either
Johnny Mac is offline   Reply With Quote
Old 09-25-2009, 09:57 PM   #4
Johnny Mac
Johnny Mac's Avatar
 
Join Date: Sep 2009
Posts: 9
Default

looks like linux/php/mysql here I come...

http://www.web2coders.com/w2articles.php
Johnny Mac is offline   Reply With Quote
Old 09-26-2009, 05:18 PM   #5
domedia
Administrator
domedia's Avatar
 
Join Date: Dec 2003
Posts: 9,730
Default

Nothing wrong with choosing PHP/MySql as your platform, but be sure you chose it from the right reasons. Do you know the person that wrote this? Is he an authority on this subject. You could *easily* find articles claiming the opposite of this article. And you have to be critical to some of his views. Especially if this is the future of your business. I'd still look at finding a hosted web solution instead, problem solved and you don;t have to develop anything.
domedia is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:00 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com