I need a quote for a very easy PHP website.
The site is based on PHP and HTML, simple box on front page asking for First Name, Surname, email address, desired Username and desired Password.
Back end php scrtipt to collect the First Name, Surname, email address, desired username and desired password along with collecting the IP address that the user is connected from. The username has to be UNIQUE, ie we can only have 1 user called �bigdaddy� (as in the example) so if that username has gone, then it states it has gone and requests a new one from the client.
We need an admin interface that allows us to look at the registrations, turn �on or off� IP blocking per country. (so that we can stop people even seeing the website before it starts loading). It should also allow us to update the current IP information from a downloadable csv file (at maxmind(See below))
These credentials to be stored to a database and flatfile. The IP address is to be looked up (from the maxmind csv file/geo database) and in the newly created user database it is stored what country the user is from. If the user is from the UNITED KINGDOM then it is to be stored in the database along with the ROUTE (from whois lookup).
Once we have the username and password, these need to be stored in a flat text file, username is the filename and the password is placed within the file with extra information.
The GEO IP lookup I have enclosed some links for the free database, I have also enclosed other links for information purposes.
FILE FORMATS:
User file :
Username of bigdaddy with password of billbob would mean the following file being created with the extra information of ;*;1 being placed after the password
File Username : bigdaddy
Contents of file : billbob;*;1
Database fields:
Unique ID, First Name, Surname, email address, desired username and desired password, IP Address, Country, IP route if GB (UNITED KINGDOM)
Database collection sample:
1, bill, gates,bill(at)microsoft.net, bigdaddy, billbob, [login to view URL], UK or GB, [login to view URL]
2, Ben, Shirman,ben(at)microsoft.net, bumble, bull, [login to view URL], FR,
Links:
[login to view URL]
IP to Country (this is PHP code for reading the csv/dv)
[login to view URL]
Database of the country IP addresses (these are the actual
IP's store in GEO-DB)
[login to view URL]
IP Blocking for PHP and HTML for shared server (this is the page for blocking traffic determined from the GEO-DB database)