registration confirmation error, php with sql registration confirmation error Options

[adnan shahid]

Dear Sir,
My files are hosted at http://myproject.6te.net/.
After account creation it sends the activation link on the email. But the link that is sent to email will not be able to activate the account.
There is need to activate the account from the database server etc. or what other problem.
I am following the tutorial at http://youhack.me/2010/04/01/building-a-re...ication-in-php/
Thanks
Best regards
Adnan shahid

[CharlesEF]

Where is your code? No one can help without seeing what you have done.

[adnan shahid]

Where is your code? No one can help without seeing what you have done.

please find code here.
http://we.tl/lRFgf9SCgF

[adnan shahid]

please confirm me that you find the code.

[adnan shahid]

please check it urgently?
i need it urgent.
thanks
adnan

[adnan shahid]

I am waiting it on urgent basis?

[CharlesEF]

please confirm me that you find the code.

Yes, I got it. Give me some time to go over it. I'll post back later.

[adnan shahid]

thanks

[CharlesEF]

The 1st question I have is what is the user name needed to access the database? You have conflicting code in your 'database_connection.php' file.

You have constants defined for 'DATABASE_USER', 'DATABASE_PASSWORD', 'DATABASE_HOST' and DATABASE_NAME but in the mysqli_connect statement you are not using any of them. The constant for user is defined as DEFINE('DATABASE_USER', '819903@localhost') but in the connection string you are using '819903' as the user. There is no problem using constants, just make sure the values are correct and then use them in your connection string, like this: $dbc = @mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME);

If you can't connect to the database then there can be no activation. Fix this first and then report back what happens. Also, I need as much detail as you can provide.

[adnan shahid]

thanks for reply.
as the matter of username i did not know what to write.
however as the username of shown in the hosting server.
I am using as it is showing in the server host.
actually the username is 819903,
i am trying it alternatively sometime 819903 or sometime 819903@localhost.
as the matter of connection string .I am already using.
$dbc = @mysqli_connect('localhost', '819903', 'adnanno1','819903');

[CharlesEF]

thanks for reply.
as the matter of username i did not know what to write.
however as the username of shown in the hosting server.
I am using as it is showing in the server host.
actually the username is 819903,
i am trying it alternatively sometime 819903 or sometime 819903@localhost.
as the matter of connection string .I am already using.
$dbc = @mysqli_connect('localhost', '819903', 'adnanno1','819903');

I see how you are using the connection string. My question was why define constants if you are not going to use them? So, I guess your username and database name are the same? They both show '819903', is this correct? Is the activation code being stored in the database correctly? You will have to check the sql server data to check for sure. Also, while in the sql server manager you should be able to log in with the username and password you posted. Can you actually do this?

[adnan shahid]

please find the attachment

[adnan shahid]

please find the attachment

[adnan shahid]

please let me know that you have downloaded the screen shots and gain confidence .
now i am using the 819903 for both of the fields.
further i will share the database information shortly .
in the meanwhile you can create an account and i will show you the database.
All information is saving in the database correctly .
But the account activating problem.
thanks

[CharlesEF]

Okay, according to the photos you posted your SQL files are located at: 'http://orgfree.freewebhostingarea.com/pma/' then how can you use 'localhost' as the database host? localhost is only used when you have a web server and mySQL installed on your local computer. You should contact orgfree support and double check with them what host name you should be using.

[adnan shahid]

dear sir,
please find server information and tell me what to use for the username?
819903@localhost or just 819903?
thanks
best regards
adnan shahid

[adnan shahid]

dear sir,
please find server information and tell me what to use for the username?
819903@localhost or just 819903?
thanks
best regards
adnan shahid

[adnan shahid]

My Dear respectful sir,
please find the complete server information and suggest me the correct option.
what to use for usename?
what to do next?
thanks
best regards
adnan shahid

[CharlesEF]

Okay, you have provided everything I needed to log in to your SQL account. I found the problem. The Email length was set to 20 and that is not big enough (any email address 20 character or less would be fine). This caused the email address to never verify.

I changed the length to 50 and tested again and was successful in activation. Now I saw that the web server was using a localhost using UNIX socket but if has been over 15 years since I used UNIX so I can't say how that works now. Anyway, since you have posted all the information anyone needs to log in to your SQL account you should change the password and don't forget to change the password in your code also.

[adnan shahid]

Dear Sir,
Kindly tell that what the error is now as the two new fields are now added.?
Please tell that what type of error is this?
Thanks
Best regards
adnan shahid