|
|
Rank: Admin
Joined: 7/8/2003
Posts: 791
Location: United Kingdom
|
This is probably more geared towards BigB...
With the new tutorials section, would someone be able to give a database tutorial on:
- how you impliment database entries on webpages.
- how you make links between enteries in different tables in the database.
- how you make a table entry a html hyper-link.
If anyone can do this, it would be much appreciated, as I am wanting to make a lot of the info on my website into a database so that it is easier for me to add to, edit and maintain.
Thanks.
|
|
Rank: Larger than Life
Joined: 11/15/2003
Posts: 1,649
Location: United Kingdom
|
All I can tell you, is:
You need dynamic pages (php or asp). I do not (yet) know how to program in these but I know for sure that swoj does! As most of this site is now linked to a database. Maybe he can help you?
|
|
Rank: Admin
Joined: 7/8/2003
Posts: 791
Location: United Kingdom
|
He said he would at some point, but I realise he is very busy quite a lot, so doesn't have that much time! That's why I put this request up, just incase anyone else knows how to use databases in webpages.
I've been reading up on ASP, and I think I can get what I want my website to do just using that, but it won't be as tidy compared to using a database.
|
|
Rank: Larger than Life
Joined: 11/15/2003
Posts: 1,649
Location: United Kingdom
|
use the asp to get info from the database. Try downloading snitz forum, and have a look through their coding. It might give you some ideas on how to do it! I am currently learning how too, but have got 5 websites to make by Easter so I am busy! plus I have my final year of college to do!
|
|
Rank: Admin
Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
|
yeah, until I have time to put together tutorial, having a look through Snitx is probably the best idea just now. try the basic snitz forum, otherwise there is too much extra to get in the way. Start with index.asp (or default.asp) and track the page, I gather you are familiar with functions, so you should be able to get a rough idea of what the page is doing. somethings are obvious, such as the INCLUDE command, which just includes another file, so go look at that file and see why it is being included  Also, try these linkes http://www.asp101.com/http://www.asp101.com/samples/http://www.aspfree.com/http://www.programmersresource.com/specifically: http://www.asp101.com/samples/database.asp
|
|
Rank: Admin
Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
|
and while I remember
page1.asp -> lists all entries in a database table, each entry links to page2.asp?id=xxxx, where xxxx is the items database id
page2.asp -> takes the ID number and does a database query to pull out the table entry with that ID
hope that is clear
|
|
Rank: Larger than Life
Joined: 11/15/2003
Posts: 1,649
Location: United Kingdom
|
Quick question swoj! Swhy have you chosen to use asp not php? I haven't touched asp yet and find that php is good enough. I also know that most decent webhosts support php as standard but you would have to pay extra for asp.
|
|
Rank: Admin
Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
|
That would be because Degeneration hosts his site on my server! This server currently has Coldfusion and ASP, but not PHP.
Also, I've not used PHP either, I want to try it out, however I haven't had time but I do have some experience of ASP
|
|
Rank: Larger than Life
Joined: 11/15/2003
Posts: 1,649
Location: United Kingdom
|
AH so your using microsoft too host? or do you have some 3rd party software???
|
|
|
Guest |