Page 1 of 1

how do i make a member site with statistics, register, login

Posted: Mon Dec 15, 2003 3:50 pm
by PHP-Fusion
how do i make a member site with statistics, register, login etc.

like in the site http://www.dbznetwork.net (many sites use this, a gave this site becuse i just like the members thing in there...)

Thanks 8)

Posted: Mon Dec 15, 2003 4:11 pm
by dull1554
if you don't know php which i'm assuming you don't you should use a portal, perhaps the one this site uses phpbb2, just a thought, good luck

Posted: Mon Dec 15, 2003 5:16 pm
by PHP-Fusion
i know php, i have a forum of my own http://www.yoyo.2ya.co.il with a portal...

i want to know how to make a members site without a forum...(alone - like the site i gave...)

Posted: Mon Dec 15, 2003 5:18 pm
by uberpolak
Do some reading:

viewtopic.php?t=6521

EXAMPLE!

Posted: Mon Dec 15, 2003 5:34 pm
by PHP-Fusion
here is an example of table in MySql DATABASE that i use for this members site:

Code: Select all

CREATE TABLE marketing ( 
  heading varchar(255) NOT NULL default '', 
  body_text text NOT NULL, 
  news_id int(25) NOT NULL auto_increment, 
  PRIMARY KEY  (news_id), 
  UNIQUE KEY news_id (news_id), 
  UNIQUE KEY heading (heading) 
) TYPE=MyISAM COMMENT='My Company's Marketing Newsletter';

Posted: Mon Dec 15, 2003 5:43 pm
by qads
you cant use that talbe for any membership site...well you can but only for newsletters and stuff..as it says in the comments.

you would need a beter table.

somethinglike:

ID INT
username CHAR 32
password CHAR 32
email CHAR 200(should be enough?)

to start with.

once you have the table set up you need to use php sesions to allows users to login. there are tons of tutorials for this. try google for [google]php login tutorials[/google].

btw, when you say "i know php" do you mean you can make scripts etc or do you know as in "yes i know it exists" :?.

good luck.

Posted: Mon Dec 15, 2003 5:55 pm
by dull1554
that was my thought exactly
when you say "i know php" do you mean you can make scripts etc or do you know as in "yes i know it exists"
i looked at fusion's site, it allready uses phpbb, i dont understand why he does not just use the portal buitl into phpbb like this site does, im sure you can find modules to do what ever you want.

i know to make scripts...

Posted: Tue Dec 16, 2003 6:29 am
by PHP-Fusion
i know to make scripts...

and...

Posted: Tue Dec 16, 2003 6:35 am
by PHP-Fusion
you know google search realy helped me...

Thanks... :lol:

Posted: Tue Dec 16, 2003 12:37 pm
by m3mn0n
What resource did you find in Google that was helpful?

i found a member ship (log-in, register etc.) Tutorial!

Posted: Tue Dec 16, 2003 1:23 pm
by PHP-Fusion
i found a member ship (log-in, register etc.) Tutorial! 8) :!:

Posted: Tue Dec 16, 2003 2:56 pm
by basdog22
8O

Posted: Tue Dec 16, 2003 3:26 pm
by dull1554
well if you know php my suggestion is to make a registration script that automaticly posts the user info to a mysql database, the for login it would be rather standard, user enters username and p-word and compare it to the database(i'd suggest using md5 to hash the passwords in the database, then to compare what the user entered to whats in the database all you would have to do is md5(); what the user entered for a p-word and compare it to the database, but if you know php you should have no problem with this much, then i'm sure you could figure out what to do for statistics