members only area...

[Muk108]

can someone help me make a members only area in any laguage i dont care wich one it is. XML HTML Java CGI whatever i would just like some help.

[cpradio]

what languages are supported on your server?
PHP with Mysql? Perl? CGI? Java? are you able to password protect certain directories using .htaccess?

-Matt

[Muk108]

can you help me with the last one? the .htaccess one. or i do have php and mysql access on my web host

[cpradio]

if using .htaccess you will either have to manually update it for new members to login or write a php script to do that for you. If you want to use a php script I suggest just using php and mysql to handle your member area.

If you decide to go with mysql and php, then the following is what you will need for your database, you can make your database via phpMyAdmin or using the sql statement provided:

phpMyAdmin Database Setup:

• field = id
  type = int
  length/values = 11
  null = not null
  extra = auto increment
  check primary and unique
• field = username
  type = varchar
  length/values = 250
  null = not null
• field = password
  type = varchar
  length/values = 250
  null = not null

php sql Code:

<?
  $sql = "create table members(id int(11) not null auto increment primary unique, username varchar(250) not null, password varchar(250) not null)";
  $query = mysql_query($sql);
?>

The above php code has not been tested

-Matt

[Muk108]

how easy would it be to make that script to write to the .htaccess file?

[cpradio]

harder than it would be to use cookies and a mysql database.

[Muk108]

ooo well i have something that is for the .htaccess file

is this what it sould look like?

AuthUserFile \passwordfile.pwd
AuthName "Secure Area"
AuthType Basic
require valid-user

and the passwordfile should look like this...

muks:password (?password?)
muk:pass (?username?)

[cpradio]

yes

[Muk108]

ok well i tryed that and it doesnt accept my username and password? or do i have to set where it goes?