Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: mack
I have a e-comm site with static pages, I am looking at building something new that pulls from a Database to make updating easier.
Does anyone know of a good online resource to get me started, I was hoping to use my newly acquired Ultradev to build it with, any ideas?
What type of database, MsSQL, MySQl, Access etc.
What does your webhosting company support?
What resources do you have, do you have a IIS server you can play with, do you have an Apache server which you can play with.
Do you want a free database or are you willing to pay for it?
(MySql is free, MsSql, and Access are not)
How many users will access it at the same time? (access have a restriction of 255)
Web database? [webmasterworld.com]
I was hoping to use my newly acquired Ultradev to build it with, any ideas
No worries re ultra dev. There are lots of tutorials out there and quite a few ready made free cart softwares.
Should do all you need. Access based as well so quite easy to do as opposed to messing around with schemas when wishing to use mysql etc.
do a google for "charon cart"
and also look at this
"What type of database, MsSQL, MySQl, Access etc."
I was hoping to use Access
"do you have a IIS server you can play with"
Yes sir, I have PWS on a Win98 machine I can play with
"How many users will access it at the same time? (access have a restriction of 255)"
Only getting around 100 uniques per day at the moment
"What does your webhosting company support?"
"Do you want a free database or are you willing to pay for it?"
We are willing to pay, but free would be better
Thanks, I will have a look
Take a look at:
There is a lot of help and tutorials available.
The next problem is that if you're host only uses Apache you will not be able to use Access on it (not from what i know anyway)
But you can use ChiliAsp (it costs, it's used for running ASP on Apache servers.), and you can convert your database to MySQL (Free), then, even though that might take a little bit more knowledge.
I have managed to find out a little bit more info on my hosting :
"Our servers are a minimum of dual Pentium III 800 systems with at least 1024MB of ECC RAM running Linux as operating system and Apache as web server. The machines are protected by RAID5-systems"
What set up would you recommend? Would Chilli ASP be the way forward or go with mySQL
If I am going to take the time to learn it, I want to make sure it is commercially viable, I may take the skills with me to a new job....I hope.
There is also very many tutorials out ther on how to use MySql, and then you would probably use Php or something like it to present the results.
You can also use ChiliAsp to connect to a MySql database if i'm not wrong, but as stated before it's not free.
Also a tip to make it easier to administrate MySql, and have a "microsoft" experience i would suggest downloading MySql-Front.
Also on a note, Access was never intended in the first time to be used for the web, and therefore it doesn't support all the functions that MySql and MsSql does.
However, if your host is using Apache, you might want to use PhP as your scripting language from the get-go, rather than using ASP. You can still install PhP for W98.
That way, when it's time to upload your pages to the server, you won't have to worry about chiliASP.
Dreamweaver MX does write in PhP, but I believe UltraDev only writes in JSP and ASP.
I have just installed MySQL, it looks very confusing but after spending about the last 2 hours looking at it, I am starting to make sense of it.
I will let you guys know how I get on.
other thing you might want to look at, if you haven't already
links of note
The above product has now been discontinued, I managed to download a copy, it took me ages to find it but I cant make it work :-( and there is no online support anymore.
Is anyone aware of a similar product I could try, free would be nice ;-)
I have given up with phpmyadmin at the miniute, it looks easy but I have been trying to connect all morning with no success
And if you don't use the latest version, almost all problems have been found and there is earlier threads for them.