| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 29441 | 2003-01-20 07:34:00 | Help Help, Database Design - Web Site | Annanz (3044) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 115450 | 2003-01-20 07:34:00 | We own small toy store, which has been run my parents for over 20 years. We like to put it online, but need some advice. I understand how to design web page, like layout, frames & drop down menu etc using Microsoft Frontpage. But instead of having to create a page for every product, would like to use database to retrieve the product information from, like pictures & text. Looked at using Microsoft Access but been pulling my hair out trying to figure it out, even though spent a lot of time reading help files online. Is there any database program all products that can make this job a lot simpler??????? | Annanz (3044) | ||
| 115451 | 2003-01-20 08:20:00 | My preferred way of doing this is using a web based language called PHP, and a database program called MySQL. Once the information is in the MySQL database, it's simply a matter of PHP retrieving the information using basic statements, however this may be a bit difficult for a beginning website designer. You may need to design your site how you like it, make the templates, and then get a database designer and website programmer (such as myself) to do the harder parts. Good luck, Jonathan |
JoGiles (1898) | ||
| 115452 | 2003-01-20 09:45:00 | To create web pages you need to either know HTML or use a program to create the HTML for you. To create a web site with database access you again use HTML to create the layout, but use a different language - PHP, ASP or ColdFusion - to access the database. The database itself could be created in MSAcess or MySQL or similar. My suggestion would be to design the layout for your site on paper then find someone else to do the database side of it. If you're planning on on-line sales you will also need a shopping cart attached to the site. If you need a hand you could contact me - heather details co nz (add the appropriate symbols in the address) |
Heather P (163) | ||
| 115453 | 2003-01-20 10:09:00 | haha - It sounds like the other 'helpers" are out to make bucks from our free help forum! LOL I'll happily set it up for you, no cost, no obligation, whatsoever. Just drop me your contact email addy. Rgdz Greg |
Greg S (201) | ||
| 115454 | 2003-01-20 13:25:00 | I'm not out to make any bucks, and made no mention of that! :) I said exactly what Heather said - the advanced stuff will probably need someone else, and Heather, you and myself have all offered to give a hand. I hope my attempt at helping is not interpretted as me trying to make bucks, as it makes me feel extremely shallow. Hope one of us can help, however I'm in Singapore for the next week... Ciao, Jo |
JoGiles (1898) | ||
| 115455 | 2003-01-20 20:52:00 | My apologies to you and Heather. | Greg S (201) | ||
| 115456 | 2003-01-20 21:55:00 | Of course, the other side of the coin, get a free web site by asking on a free website forum (no offence Anna) . Some of us have to make a living (well try anyway) I'd love to write open source software all day but it seems that money is way that we trade these days . |
Dolby Digital (160) | ||
| 115457 | 2003-01-21 02:29:00 | Appreciate the replies, but if I need to learn Database programming where do I start??? Got another month to fill in, before going back to Uni . Do understand it's going to take a lot longer than a month to learn, just don't want to be dependent on someone else . Just hoping there could have been simpler way of doing it, without learning database programming . This is probably stupid question because; there is probably no way of telling what database programming language was use to design database for http://www . iqtoys . co . nz |
Annanz (3044) | ||
| 115458 | 2003-01-21 12:42:00 | There are some hosting services which provide a shopping cart as part of their services e.g. hostme.co.nz (uses php/mySQL - note that I haven't used their service!) so presumably you can design a site around it and their software will handle all that "dirty" database work. | Dolby Digital (160) | ||
| 115459 | 2003-01-21 13:45:00 | if you want to learn a sever side program (e.g. ASP, PHP or Cold Fusion) i did a 9 month course @ the National Collage Of Design and Technology (based in Ack, Well and ChCh) the Dip IT teach you how to make a online Shopping cart using ASP they also do a bit of PHP (enough to make basic things) here is what i made (it is NO WHERE NEAR finished and i haven't uploaded all the pics) but you can see it is data base driven by all the quarry-strings www24.brinkster.com if you want to learn a bit go to www.w3schools.com (not w3schools.com "s" it is some religious cult) here you can learn ASP, PHP, SQL, XML....... personally i prefer ASP cos i find it easyer, its really easy to make member only sites in it i'm raveling oh and it looks like ASP on iqToys cos of"?page=4" but most sever side programs use similar quarry-strings |
sc0ut (2899) | ||
| 1 2 | |||||