[RELEASE] Secure PHP Web Registration Script (MSSQL ODBC)

This is a modernized version of [Only registered and activated users can see links. Click Here To Register...].

It uses a safer method of querying the database that does not rely on escaping input to prevent SQL injection.

The only files that are different from my old registration script are:
db.config.php
register.php
changepass.php

That means if you made changes to the views for the old registration page, you can reuse those same style changes with this registration page just by replacing the view files :)
You will need to put your database credentials into this db.config.php.

You will need to set the RowID column on the Users_Master table to be an auto-increment column.

When using this script treat register.php as the index page. Or rename register.php to index.php if you wish.

#Added to the Index

Quote:

Originally Posted by JohnHeatz #Added to the Index

Thanks, you could probably replace the link to my old registration page in the index with this one. The only reason to use the old one is if you want to use the php_mssql driver instead of the odbc driver. The php_mssql driver is horribly out of date, so it may be better to steer people to use odbc.

Hello , I got this error
"Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'RowID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecute in C:\xampp\htdocs\Registration\register.php on line 60"
when i press "Create Account"
can someone help me please ? =)

Quote:

Originally Posted by EpicG4m3r "Cannot insert the value NULL into column 'RowID', table 'PS_UserData.dbo.Users_Master'; column does not allow nulls. INSERT fails." B]

I Think your problem is here o,o make it allow nulls :)

Quote:

Originally Posted by JuuF I Think your problem is here o,o make it allow nulls :)

Actually no, you want to set the RowID column to be auto-increment. This way each row has a unique identifier.

thanks friend thank you very much hopefully everyone were like you who share
1000 tnk

Quote:

Originally Posted by abrasive You will need to set the RowID column on the Users_Master table to be an auto-increment column.

Hello all! After 1 year, I'm back ;-)
Help, plz. I can not change the autoincrement in RowlD.
There is any sql for this? Manually doesn't work.
I get this message: "Saving change is not permited ......... tables to be dropped and re-created."
But I'm have content in the table.

Thank you all.

Try logging into your SQL with the sa user and password and doing the change, normally that happens due to permissions

Quote:

Originally Posted by patoringa Hello all! After 1 year, I'm back ;-) Help, plz. I can not change the autoincrement in RowlD. There is any sql for this? Manually doesn't work. I get this message: "Saving change is not permited ......... tables to be dropped and re-created." But I'm have content in the table. Thank you all.

Fala aew meu querido *-* resolveo volta ao ramo de shaiya rs.
Se quiser akida, estamos aew. um abraço

Quote:

Originally Posted by venon321 Fala aew meu querido *-* resolveo volta ao ramo de shaiya rs. Se quiser akida, estamos aew. um abraço

Obrigado. Retornando com força total! ;)

How do i set Auto incement ?

Its a noob question i know, but i dont know how to set it in RowID.

Greetings.

[Only registered and activated users can see links. Click Here To Register...]

Do that, I don't think much explanation besides it will be needed

Dont work, i dont know why, i cant get it to work...

Quote:

Originally Posted by JohnHeatz [Only registered and activated users can see links. Click Here To Register...] Do that, I don't think much explanation besides it will be needed

:confused: I try it with sa user, but don't work for me too.