Member Registration And Login System

[uncled1023]

Um, works fine on my browser.

[Kznz93k]

Thanks, this helped!

[Croix]

I'm a newb, and have no clue how to start this. I'm in the database, but I don't know what things I should fill out for the table.

[Ekutah]

index.php?id=register

doesn't work any suggestions :l

[IamShipon1988]

Croix - You will need to read a little on PHP and database management. I recommend you read the guide at http://php.net or at http://tizag.com

Ekutah - You can always use register.php

[mar]

i like this turial just 1 problem the php files assume the files are on localhost. in my case they are not.
All files are in same folder but not local host, how do i fix that?

[Hillyer]

Hello,

Thanks for a comprehensive tutorial. I feel I have learnt a lot just by reading through it. I understand what I read, and I understand what the code does (except a lot of the punctuation!!) but that doesn't seem to help me much when it comes down to publishing and trying to work!

I have filled out everything, and edited the config.php page accordingly. I think I have typed in the $db_user and password / database correctly - yet whenever using a new host, you can never be sure that they're right or not.

"Warning: mysql_connect(): Access denied for user 'db_username'@'192.168.1.1' (using password: YES) in /www/zxq.net/m/a/j/majortrouble/htdocs/config.php on line 6 Couldn't connect to server."

That is the code I get. Noone seems to be talking on IRC (of the 20 ppl in there....) so if anyone else can help, I am grateful ;]
Hillyer

[Jacob]

You need to update the database credentials to your correct ones for it to work.

[Hillyer]

A typo in my credentials was sorting the problem. Thanks to Dave in #zymic (irc) it is sorted :]

[Jacce]

Well, I'm very new with PHP and MySQL.
First of all. I made all those files and then i uploaded them to my website, won't work.
Second, my website (http://mc-rp.zxq.net/) is coded in HTML and CSS. Is it possible to have this login working and that even though the site is coded in HTML?

[IamShipon1988]

I made all those files and then i uploaded them to my website, won't work.

Jacce what problems are you encountering. Make sure you upload the files and change the permissions of those files as requested.

Is it possible to have this login working and that even though the site is coded in HTML?

In order for any php functions to work, the file must have a .php extension. However, if you want the login form in your HTML page, you can try using iFrames. It is a bad practice to do that. It is best just to convert your pages to PHP as you can incorporate your HTML code in php as well.

[Jacce]

Jacce what problems are you encountering. Make sure you upload the files and change the permissions of those files as requested.

In order for any php functions to work, the file must have a .php extension. However, if you want the login form in your HTML page, you can try using iFrames. It is a bad practice to do that. It is best just to convert your pages to PHP as you can incorporate your HTML code in php as well.

What do you mean change permissions? Well, anyway, here you can see my problem: http://mc-rp.zxq.net/index.php

And how do I use HTML code in a PHP file?

EDIT: Excuse me for these noob questions. I coded my first webpage just a half year ago and this is the very first time I work with PHP and MySQL.

[uncled1023]

your error is because you didnt change the username and password and such in the config file... it thinks ****** is your username for the mysql database. also, you use html in a php page just normally. all you do is change .html to a .php, and then you can use php in your html file.

[Jacce]

What do you mean change permissions? Well, anyway, here you can see my problem: http://mc-rp.zxq.net/index.php

And how do I use HTML code in a PHP file?

EDIT: Excuse me for these noob questions. I coded my first webpage just a half year ago and this is the very first time I work with PHP and MySQL.

Well, I don't really know what to write there. Is it the name of my Zymic database or what?

EDIT: I think I've finally fixed it ...
But, the links wont work when I click on them. I have to manually write in the adress to go to another side.
EDIT2: If you like to see how it looks like, go to http://mc-rp.zxq.net/ and at the right you will see links to register and login, none of them will work.
EDIT3: That's fixable, but registration wont work. When I press "Submit", it just sends you back to index.php. Or accely, it send you to index.php?id=register

[uncled1023]

well, the links seem to work. teh registration, its supposed to send you to id=register. and all your links, are supposed to use index.php?id=(page you want minus .php)

and in index, you had to put the include thing to include the id of the page.

[Jacce]

Umm, I don't really understand, but I'll give it a shot.

EDIT: Fixed it, thanks
EDIT2: GOSH!!! The errors still keep coming. When I log in it sends me to profile.php, but the sub category wont show up and to the right it say "fatal error" and suchs. But when i write http://mc-rp.zxq.net/profile.php it works fine.
EDIT3: Also, this code won't work:

CODE

<?php include 'login_check.php'; ?>

I tried both in the very top of the page, inside the <head>-tags and under the <body>-tag.
It just ends up showing <script type="text/javascript"> over the menu.
EDIT4: The login bug is fixed, I figured out that I can't use /index.php?id=*page* links to my original pages, it just won't work.
EDIT5: Fixed the other thing, though it redirects me to index EVEN when I'm logged in.
EDIT6: Edit5 is no longer necessary. Though I would like to know how to make so a user can change his password, e-mail and maybe even upload an avatar?

[IamShipon1988]

You mean something like a profile editor? You can do that by creating a document that will basically replace the current database entry with new ones.

[Jacce]

Yea, but how to do that?
EDIT: Someone crashed my forum by writing something with JavaScript in a new topic. I fixed this by removing the topic. But I saw a big security breach. Is there any way to prevent users using programming language in my forum?
EDIT2: I'm trying to use reCAPTCHA in my login to increase security. But what's the name of the verify file?
EDIT3: I can't get reCAPTCHA to work... And how to make an e-mail verification thing?
EDIT4: How to send the users IP to the database when he registrates? I know how to get the visitors IP, but not how to add it to the database when he registrates.

[Jacce]

It's been two weeks now, still no help -.-
EDIT: I think I've fixed the thing mentioned in EDIT4 in the last reply.

[Faithkarm4]

Alright, I am having massive problems with this set up. I can't get anything to access the database and register.php is showing up on my site but not actually doing anything. I click it, it pulls up the table then you type the information in and it sends you back to the main page but nothing goes to the database. Any suggestions? I really need help. I tried going to the support chat here and they really aren't helpful, they keep telling me I should know this and that. I finally just decided to come here and post. Someone please help me out, it would be greatly appreciated.