Help With Database

[Unstoppable 0]

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 May 18, 2007 by Unstoppable (see edit history)

[shadowx 0]

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 0]

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://forums.xisto.com/no_longer_exists/ and for the mysql syntaxes, http://dev.mysql.com/doc/refman/5.7/en/sql-syntax.html. You can visit PHP help IRC chatrooms on the various networks should you encounter any problems.

[shadowx 0]

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 0]

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 May 18, 2007 by Unstoppable (see edit history)

[serverph 0]

here is a COMPLETE Login System using PHP and MYSQL:
http://forums.xisto.com/topic/7247-complete-login-system-with-php-mysql/

still another SIMPLE User System (also PHP and MYSQL driven):
http://forums.xisto.com/topic/46278-simple-user-system-php-mysql-driven/

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://forums.xisto.com/topic/169-tutorials/

[Unstoppable 0]

ok really thx all, but now in this tut http://forums.xisto.com/topic/7247-complete-login-system-with-php-mysql/ 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 3]

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 0]

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 3]

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>

[ghostrider 0]

The username is a field with a letters, the primary key has to be a number. I generally use a field that i call id for all my primary keys.

[Unstoppable 0]

Hmm, no thats not the problem. Can someone search the problem in my documents? I'll send them.

[jlhaslip 4]

Can you post the code or supply a link to a zipped file, please.Someone will look at the whole thing and advise what they find, but until we see the code, we will only be guessing at the potential fixes...

[Unstoppable 0]

thx jlhaslip and others: http://forums.xisto.com/no_longer_exists/ i think it would be great if anyone of you could make a database in mysql, cuz i made it in access so itll prolly suck

[jlhaslip 4]

First thing to change is to add the php start and stop tags to the conn.php.When a file is "included", it is parsed as html unless you identify it as a php file by inserting the "<?php" and "?>" tags before and after. It might be that the con.php is not firing up the connection? because it isn't being id'd as a php file...