24 replies to this topic

[Unstoppable]

I know I might sound a bit novice, but I'd like to know how to make a register and login database. I'm making a serious website for the very first time and I can't find on internet how to make one (don't even know how it is named).
I would really appreciate me if someone could link me to a tutorial or give me the explanation, also the program to use (I think Microsoft Access is good?)

Edited by Unstoppable, 18 May 2007 - 09:02 AM.

[shadowx]

Do you mean you want this to be live on the internet as part of a website?

If so the prograsm to use isnt microsoft access, instead you will need to use, either php or ASP and MYSQL.

Dont worry its not as confusing as it sounds, though some coding knowledge or help would be usefull to you.

MYSQL is simply a database system and there is a tool called phpmyadmin which is basically the "program" you use to change these databases. It looks like a webpage and infactm it is a webpage, but its the best way to work with these databases.

What you will need to do is firstly find out what your webhost supports, this can usually be foud when you register under its features list, you need to look for two or three things, "PHP support" or "PHP version x.x" or "ASP support" and definately something similar to "XX MYSQL databases/tables" that means that you will be able to have a database and the code needed to work with it, on your website.

From there you might be able to find some code on the internet, i would look but im in college at the moment. If you can find something like a "PHP/MYSQL user login system" script then come back and someone can help you install and check it. If not then come back and ask for one to be made, if i had the time id do it myself but ive got another coding thing to do so i cant but someone else might be able to.

Its not mterribly complicated though if this the first experience with these database and PHP/ASP coding languages then it might be a little more dificult for you but we can all help hopefully!

Good luck! try searching for the code on the internet first and then come back here and let us know what you find, if anything.

[slushpuppy]

Microsoft access is just a database management software. If you know php, you can grab the username/password from a html form using the $_POST/$_GET super global variables and store it into the mysql database. Examples of using the $_POST/$_GET can be found here http://au3.php.net/manual/en/language.vari....predefined.php and for the mysql syntaxes, http://dev.mysql.com...sql-syntax.html. You can visit PHP help IRC chatrooms on the various networks should you encounter any problems.

[shadowx]

Thats true, though if there is a lot of work to do with sessions and the database queries and IF's and such.. and if you dont know php then that can be pretty hard even to find the right code let alone get it to work!

Though as i said if someone can find the code then im sure a few people from this site can help out in fixing it up to work with your settings.

[Unstoppable]

I got a Login System, but now I'm having trouble with linking it to the database. It would be highly appreciated if someone could make me a working login system with a database and send me the files. Otherwise I'll just look around some more and try to find the answer.

Edited by Unstoppable, 18 May 2007 - 05:06 PM.

[serverph]

here is a COMPLETE Login System using PHP and MYSQL:
http://www.trap17.com/forums/complete-logi...stem-t7247.html

still another SIMPLE User System (also PHP and MYSQL driven):
http://www.trap17.co...tem-t46278.html

if these two don't fit the bill for you, head on to our TUTORIALS section, and look around for what you require. it may already be somewhere in there; you just have to dig for it.
http://www.trap17.co...rials-f169.html

[Unstoppable]

ok really thx all, but now in this tut http://www.trap17.co...stem-t7247.html in the conn.php, there is a referral to a database. Can the database be empty or what does have to be in it? And can it be done in Access? thx for great help all, just beginner with programming. Next year i'm gonna study it tho (in university)

[Saint_Michael]

with the conn.php file oyu need to fill in the DB I give you an example:

DB name: forum_forum
User name: forum
password: 12345

Ok now with that MySQL info you just fill in the file as so.

$host = 'localhost';
$user = 'forum';
$pass = '12345';
$db = 'forum_forum';
mysql_connect($host,$user,$pass) or die ("Database is unavailable. Please try again later.");
mysql_select_db($db) or die ("Database is unavailable. Please try again later.");

Now what this file does is connect your MySQL database to your php scripts and thus be able to store information from a users registration such as name and password a person uses. Now with most log in scripts you have to keep them very secure especially your DB or a hacker could compromise the system and be able to steal or delete your files, if I remember correctly on log in scripts most of them will be 0666 or 0755 as for a somewhat more stable secured script.

Also I would recommend you check out pixel2life.com as they have several login system scripts that are well detailed such as the ones on here and some go into a lot of detail how to set up and secure them.

[Unstoppable]

so basically only a database with username, password and email with username as primary key?
[hr=noshade] [/hr]
Hmm, I completely installed the login system, but the submit buttons dont work. If i click them, nothing happens, help please?

[truefusion]

Unstoppable, on May 18 2007, 03:48 PM, said:

Hmm, I completely installed the login system, but the submit buttons dont work. If i click them, nothing happens, help please?

The only reason i can think of why it doesn't work is that it is not inside the FORM element. For example, it should look similar to this:

<form method="post" action="">
<input type="submit" value="Submit" />
</form>