Submitting downloads 1

[Wired4Distortion]

Hey, i have recently started practicing making sites, and one of them is a torrent site (file sharing)and i would like to no an easy way to submit download links, using access prefrerably. im also attempting to use coldfusion but its goin right over my head, so i may need quite a bit of help. im using dreameaver for cold fusion, but i dont understand hardly any of it. I have made nearly all the pages, such as submit download, login and sign up . but i prob wont be able to put cfm in it without quite a bit of help. I will get quite alot of help from my bro but i would like to do this almost by myself. if any1 could help i wood be so hppy. ive posted some pics of th site here to show you what im getting at.

-on that picture you can see the bottom table, i would like more rows to appear everytime a download is added.

at the moment all of my pages are in html but i will change that when i understand more

- in that picture you will see that i have quite a few game download ections, and i was wondering if i should use all the game downloads under 1 access document or 1 docuemnt for each sub section.

i would also like to change the text on the side bar extremely easily and i hae no idia how to do that. I no im askin a bit 2 much but im realy hoping somone could halp with at least some of my problems...Thanks

 

[TruthInSatire]

sounds like you've got a nice sized beginning project.

We have no problem helping but we're not going to do the whole thing for you. lets start from the very beginning of the process and we'll help you through it that way. the more you learn on the way the less help you'll need in the end.

my guess is the first thing users do is register as a user by filling out a form? if so we'll start helping you with that first if that is the case. let us know.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[Wired4Distortion]

Yeah im not askin for you to everything for me. once i get the basics i will probably catch on quick. actualy all i would like to ask is that somone could walk me through the steps to make a sign up and login page. can you do this usng dreamweaver?

 

[TruthInSatire]

i'm not sure if dw has wizards for that, i never use canned code, i write it all so i know what's going on and [hopefully] less bloated.

ok basic setup with no "wiz bang" (username and password collection only)
you'd set up a db with a users table
include fields like userName nd password.

when a user signs up you'll have a form with 3 fields
username, password, and confirmPassword

when they submit check to make sure the two password fields are the same (i do this first to save a trip to the DB if it isn't).
<cfset errormsg = "">
<cfif form.password neq form.confirmPassword>
<cfset errorMsg = "Passwords Don't match">
</cfif>
then check to see if the username is available.
<cfif errormsg eq "">
<cfquery name = "qUserNameCheck" datasource = "foo">
select userName
from users
where userName = '#form.username#'
</cfquery>
<cfif qUserNameCheck.recordCount gt 0>
<cfset errorMsg = "Sorry this username is already in the system">
</cfif>
then if everything is ok register the user
<cfif errorMsg eq "">
<cfquery datasource = "foo">
insert into users (username, password) values ('#trim(form.username)#', '#trim(form.password)#'
</cfquery>
then send them to the confirmation page to show a thank success message.
<cflocation url = "confirmLogin.cfm">



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[Wired4Distortion]

thanks man, ill give it ago after im done revising for my tests tommorow, it sems like its a good time to leran how to revise...its weird how helpful people here are thanks

 

[ecobb]

Here's a good site to check out:

http://www.easycfm.com

They have tons of tutorials which are good starting points for some of the stuff you may be wanting to do.



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[TruthInSatire]

Good thinking ecobb.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[Wired4Distortion]

okay im busy doing my site in php and after im finished ill show you it and see if i can change that all into coldfusion, ive only just got into web design so i didnt know were to start and i chose php and its reely good.

for now i shall show u my new peice of art

http://www.freewebs.com/sadclimax/

which i only just made for practice but i may as well give it a use... it took me a few mins to make so dont whine about the messy text in the middle ill fix it with tables later i have a huge clump of sites around my pc ..ill prob end up dumping this on the pile of unused ones
along with

http://www.freewebs.com/sadevo

for school

hmmm

 

[TruthInSatire]

see if i can change that all into coldfusion,

yes it can, and in half the time minus learning curve

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)