some type of member login/register system

im sure you probly get tons of questions like this and i dont really know anything about it. this might even be in the wrong section. sorry.

im making this website for one of my friends band and they like to edit whats on it with stuff like new gig dates and news. they dont know anything about websites and im afraid theyd mess up the site if i give them the password to write new stuff.

so i was wondering if there was like a log in system were they could make a new blog or section on the site when they wanted and they could edit it. i cant spend any money and if its to complicated then never mind they can just email it and ill change it but it would be cool i think. any help or suggestions. but if its not free then never mind. i found some sites from google and they deal with databases. i know nothing about them but i found a site that offers free ones or something. i even downloaded this hole login system thing but im clueless. any help.

What u need is PHP or ASP depending what you host accepts.

Hey, thanks umm my host is brinkster and i use the free educational package and it says it supports ASP 3.0 and ASP.NET. so what can i start to do. maybe there is another post on this forum with all the information. not sure. ill look around but any help would be great.

what your wanting to do is fairly simple...

do u have any knowledge of asp? if so we can skip a step..

A web "content management system" would make it easy for them to update the content in their site.

Alternately, if you have no money (and don't mind below average site design), you may consider one of the "website in 3 easy steps" solutions provided by NetSol.com, GoDaddy.com, etc.

sorry i dont know anything about asp

Then you can start learning At the top of this site is an Articles button. Read some of the ASP articles on there and www.tutorialized.com

maybe it would be an idea to make an article, build your own blogg....webforumz style...

If this is gona help people, ill do one. in both php and asp perhaps?

let me know some thoughts on this....i could have one up for monday morning if its going to be a big help...

yes that would be helpful. umm asp becuase thats what i can use for free but php would be helpful to others to.

ill throw somthing together...

Good

I think Fantistico has a script that may work for you, your web host may offer it.

so hows it coming along? or is it already done.

not even started it...not enuf hours in the day...

oh lol ok. ive been trying to use the b2evolution thing i found with google.. but its not working. so ill wait for you. but no hurry

just so you know, ive been making some nice progress...

I just sat down and wrote an article, then when I tried to add it to the article section kept getting a "Suspiscious Content" error.

So here it is, a php/mysql member system:


Creating a Simple Login System with PHP and MySQL

Most interactive websites nowadays would require a user to log in into the website’s member system in order to authenticate the user and display customised views for them.

A basic login system usually consists of 2 parts:

1. A module that allows a user to register their username and password.
2. A module that authenticates the user when they log in.

A simple system is easily created with PHP and MySQL.

Module 1 – Registration

Module 1 is typically implemented using a simple HTML form that contains 4 fields and 2 buttons:

1. A username field
2. A password field
3. A password reminder
4. An email address field
5. A Submit button
6. A Reset button

For this example, the form is included in a file named register.html.

HTML: Select all

<form name="register" method="post" action="register.php">
<input name="register_name" type="text" value="username" size="20"/><br>
<input name="register_password" type="text" value="password" size="20"/><br>
<input name="password_reminder" type="text" value="password reminder" size="20"/><br>
<input name="register_email" type="text" value="email" size="50"/><br>
<input type="submit" name="submit" value="submit"/>
<input type="reset" name="reset" value="reset"/>
</form>

When the user has filled in all the fields, the register.php page is called when the user clicks the Submit button.

The following code registers the user in the database. It connects to the MySQL database and inserts a record into the table used to store the registration info.

PHP: Select all

<?php
$register_name = $_POST['register_name'];
$register_password = $_POST['register_password'];
$register_email = $_POST['register_email'];
$password_reminder = $_POST['password_reminder'];

@mysql_connect("localhost", "database_username", "database_password") or die("Cannot connect to 

database.");
@mysql_select_db("db_name") or die("Cannot select database");
$insert = mysql_query("insert into users values ('NULL','".addslashes($register_name)."', 
'".sha1($register_password)."','".$password_reminder."','".$register_email."')")
or die("Could not insert data because ".mysql_error());
?>

This example assumes that the MySQL table that is used to store the registration record is named users and contains 5 fields – an id field(auto incremented), username, password, password reminder and email fields. The values of the $_POST['register_name'], $_POST['register_password'], $_POST['register_email'] and $_POST['password_reminder'] variables are passed in from the form in register.html via the post method. It also stores the password using secure hash algoryth (sha1), a very secure encryption method.

Module 2 – Authentication

FOr the user to then login to the website they will have to provide their username and password for the system to authenticate them.

This is done through a simple HTML form. This HTML form contains 2 fields and 2 buttons:

1. A username field
2. A password field
3. A Submit button
4. A Reset button

For this exmaple, the file will be called authenticate.html. When the user has filled in all the fields, the authenticate.php page is called when the user clicks on the Submit button.

HTML: Select all

<form name="authenticate" method="post" action="authenticate.php">
<input name="username" type="text" value="username" size="20"/><br>
<input name="password" type="text" value="password" size="20"/><br>
<input type="submit" name="submit" value="submit"/>
<input type="reset" name="reset" value="reset"/>
</form>

The following code sits in a file called authenticate.php (for this example) and processes the login. It connects to the MySQL database and queries the table used to store the registration details.

PHP: Select all

<?php
@mysql_connect("localhost", "database_username", "database_password") or die("Cannot connect to 

database.");
@mysql_select_db("db_name") or die("Cannot select database");

$match = "select id from users where username = '".$_POST['username']."' 
and password = '".sha1($_POST['password'])."';"; 

$qry = mysql_query($match) 
or die ("Could not match data because ".mysql_error()); 
$num_rows = mysql_num_rows($qry); 

if ($num_rows <= 0) { 
echo "Incorrect Username/Password"; 
} else { 
//Let user do what they want, or set cookie, session etc.
} 
?>

As in Module 1, this code assumes that the MySQL table that is used to store the registration data is named users and contains 5 fields – an id field (auto incrementing), username, password, password reminder and email fields. The values of the $_POST['username'] and $_POST['password'] variables are passed in from the form in authenticate.html using the post method.

And that's it, a simple user registration/login system that can be used for any site running PHP.

It can be further improved to include a profile editor for the user to change their details and can also be setup to use sessions to store details across pages.

You should also include some sort of validation for the html forms, to ensure users enter correct data and no security holes are opened up.