View Full Version : Building an admin section

10-24-2005, 01:27 PM

I've built a website for my local golf club www.whittingtonheathgc.co.uk
One of the things they requested was a login page for the members, so they could check out competition times and results. This was all done in asp quite simple really, however now they want a facility to change and upload the members page themselves. I guess like an admin section.

This is were I'm stuck. :confused:

Can anybody point me in the right direction in building an admin section were my client can change and upload the members page as many times as they like.

Is there any tutorials out there I could try?

Hope some one can help.

Many Thanks


10-25-2005, 01:55 AM
i need first to understand you webpage content and what admins needs to add to the website.

10-25-2005, 05:21 PM

Thanks for getting back to me.

The type of thing their after is a HTML editor like the one I'm using now to post this link. They will only be able to change the members page which will only consist of text no images. I want them to be able to change the text colours, fonts and sizes the way we can with this posting tool.

This is the way I envisage this working, please tell me if I'm well of the mark.

My client would log into an admin section say www.whittingtonheathgc.co.uk/adminsection The admin section is then a html editor like this one, they type all the results tarting it up as they go along with the various features. Once finished they click submit, and the page is uploaded.

I know I will need a database to check the username & password is correct.
Is this possible or am I just being very fick with my approach?

Would it be possible for them to just upload a page created in word?

I hope this hasn't confused you any more.

Many Thanks

10-26-2005, 01:28 AM
Look man, i guess all your work will be on DataBase, when i create admin pages for any web project, all i do enabling the admin to change anything in the DB from the form, and also like the profile page, you read the data from the DB and add it to the forms controls, then use the update statemnt to change the new data, and all other things like this, and for modifieng text, we can see about that later after you finish the basics first

10-26-2005, 11:07 AM

Thanks I'll get back to you once all the basics are done.


11-04-2005, 02:36 PM

OK all the basics are done!

1 .My client logs on
2. The HTML editor opens with the text which is stored in the database. (the page their editing)
3. They make the changes to the page and click submit.
4. The HTML editor previews how the new page will look.

This is were I'm lost, when they click submit I want the new information they created to be sent to the database using the UPDATE statement.

Thanks QBALL

11-04-2005, 10:13 PM
Thats great, can you show me a picture for you DataBase diagram?!

11-07-2005, 11:39 AM
I'm not sure about the database diagram! Is this any use?

Database MEMBERS.mdb


The ADMIN_TABLE is sorted, everything works fine.

The MEMBERS table has just 2 columns ID and Description, I want to save the new data in the Description column.

If you would preffer I could forward the url password and username of the admin side so you could get ab etter idea of what I need to do.


11-07-2005, 10:38 PM
well i think i must see the admin page, plus i really need to know your database, maybe you just try to do like the photo i sent in this post

11-08-2005, 10:04 AM

I've sent you a private email with the Admin details.

11-08-2005, 01:07 PM
Thats really a pretty work, if you have time, and wont that mind you, may you tell me how you did that :), its really cool. And i still dont know where's you problem, i mean, is the database only contains 1 field for that text box, or is there more details you'll enter, like (Title, UserName, ......).

11-08-2005, 01:09 PM
ahhhh i c, this's already made text editor :) thats cool, i got it for my self :thumbsup:

11-09-2005, 12:05 AM
Its just 1 field, but I do not know the code to update it to the database

The form (texteditor) is called:
<form name="myForm" method="post" action="display_form_submission.asp">

And the text is placed in:
<textarea name="textarea" cols="80" rows="15" id="myTextarea">

I can get the info from the database using the Response.write statement but I do not know the code and how to apply it to update the database.

11-09-2005, 03:51 AM
look man you should be using ASP.NET coz if you noticed this's .NET, so in .NET you should use the a different form tag
<form method="post" runat="server">

if you question was in asp, then i'm sorry, cant help.