Database may frying my brain

[JayDrake]

Windows XP Home... that will cause you problems. I don't think it can run IIS or PWS... and it has lots of other limitations on it, so even though you downloaded mySQL, PHP and Apache which "should" install properly... it will be hard to learn it when they aren't supported on XP Home. You may find problems that would work on XP Pro... if you can, I'd upgrade.

Any program which runs on XP Pro should run on XP Home. IIS and PWS are irrelevant as you are, in this case, using Apache as the web server.

[simplygraphix]

I wrote a very long SQL tutorial (targetted at MySQL) and you can find it on http://www.webdevelopersnotes.com/tu...sql/index.php3
I wrote it some time back get great feedback from my visitors. Hope it is useful to the newbie.

[netman4ttm]

You have picked a great system. MySQL and PHP are really great for web sites.
Now that you have seen the manual are you ready to admit that this is not a 2 month project?

Learn the database first. Understanding the database makes learning any language that interacts with it easier. School is good, but working with someone who has worked with the database is often quicker. How much history do you need and understanding why some db's have a null and some don't isn't all that important.

Good luck and give it a year.

[Greymalkin]

>> What my plan is is to build databases to hold and contain information to populate the interior pages of the site which will not only include images, price, description but also title, description and keywords and also html to generate related products links that will be dynamically inserted at the bottom of the page could be anyshere from 7 or 8 items to 25 or 30 related items.


Sounds nice... and a lot of work ;-) I am doing something along similar lines (OK, already did it and now I am refactoring...). For the second version I chose Plone (see http://plone.org). It is nice, it is opensource and available on a bunch of platforms. Still, to 'get in' it is quite a bit of work, too. A number of issues I had to worry about with a relational database are not a problem any more. You can have Apache or IIS in front, if you'd like. You can have PostgreSQL/MySQL...Oracle in the back, if you wish. You pay with your time for the open source philosophy of the development environment and for the flexibility. I think it is worthwile and have decided to give it a try. I still have quite a way to go, but my mouth is watering:)

I think that in the US there are already some service providers offering Plone housing, but you may need to look around to find on.

Well, these were my 2 cents.

[netman4ttm]

Also, check out PHPnuke. Tear it apart to see how it was put together.

[tenaki]

Hi you can install everything on xp home but you have to make a few modifications and it is really time consuming, there is a really good tutorial here http://www.sitepoint.com/article/228but the whole thing including apache takes a load of memory and I really don't think it's worth it as there are some great free databases available.

You can find some at hotscripts and devscripts and many other places

Just re-read this thread and found this http://www.webdevelopersnotes.com/tutorials/sql/8.php3Excellent

[Peter Spear]

Hi,
it seems you are reinventing the wheel. If you want data bases for a shop..e.g. pictures of product, prices, lists etc you can do no better than use the FREE shop at oscommerce.com. It is an open source project and well proven. It also has paths to several credit card and payment methods, products due to come and specials it does it all.
regards,
Peter

[snovak]

check out 3d buzz (3dbuzz.com). They have a couple of very helpful video tutorials.. Quick to the point. You get a lot in a little amount of time. You need to become a member (free). I only suggest this because getting to know PHP and MySQL will be most usefull if you're going to continue with web tech.

I suggest also that you use OSCommerce (oscommerce.com) . I've used it for 2 sites so far and I have had few problems (only because I'm a dork and like to switch things around) :) .
have a look:
http://www.petspreferus.com
http://www.ultrasoneusa.com
I've also used Miva Merchant,
http://www.performancedir.com

hope this helps.

[mad-prices4u]

I just got some shopping cart software,it's top man.
It has wizzards and sorts of tricks its called shopping cart system, its allot easier as it practacally does it for you or use it as a temporary thing wile you learn databases.
the url is http://www.scsystem.com
and below is the version you want.
Shopping Cart System v3.2.0

Also you might want to consider open university short courses, the following link has short database course or you can do the whole web application development certificate. its an online courseand is available in most countries.
http://www3.open.ac.uk/courses/bin/p12.dll?Q02C39
As i am currenly doing one at the open university.
Rob

[mushroom]

The MySql PHP Apache combination is widely supported and my selection. I have working on a very large website for 1 1/2 years now, and its very intimidating.

But I would not work on a windows platform!

I purchased the latest verson of SuSe Pro ($ 89 US) which includes the above plus phpMyAdin and Quanta (a very good php editor). Set up my own in house server and write and test on the same machine.

Suse Linux is easy to inslall and lends itself easyly to dual booting.