I have an urgent project that needs creating.
TIMING - THIS NEEDS TO BE WORKED ON IMMEDIATELY AND BE COMPLETE IN 1 WEEK FROM NOW. EVERY DAY THEIR WILL BE A DEADLINE THAT NEEDS TO BE MET.
I NEED SOMEONE WHO CAN WORK FULL TIME IMMEDIATELY FOR THE NEXT WEEK AT LEAST.
YOU WILL NEED TO BE CONTACTABLE BETWEEN THE HOURS OF 7AM GMT AND 8PM GMT
You will have extensive knowledge of PHP and mysql and be able to build secure scripts.
50% escrow to start project payment after 3 days subject to delivery within agreed time line and second 50% escrow.
payment of second 50% upon completion (1 week).
Additional $200 if completed early.
Registration system and user management built on tables within our MySql 5.0 database.
TABLE 1: engagingminds_schools
We have an excel file containing 32,000 schools. We need this uploaded to a table that you create on our database. Each school has been allocated a random 6 digit UNIQUE ID which is included on the spreadsheet. In addition, we have pre-defined a further 20,000 random 6 digit UNIQUE IDs which must follow on this table so we end up with 52,000 entries of which 32,000 are complete and as we add more schools through the project, they will be added to the table in order against one of the predefined UNIQUE IDs.
TABLE 2: engagingminds_teachers
This will contain the details of teachers who register. Each teacher will be associated to a specific school from table 1.
Page 1 is a login page where users enter a user ID and password to access their personal details and make changes. IF they are not yet registered, they will click a register now button here and be able to register.
Page 2 is the registration page. Here teachers can register their details. One of the entries is a radio button where a teacher must say if they are a permanent teacher or a supply teacher. If they are a permanent teacher then they must select a school that they belong to. To select this school, they will perform a search by entering the first part of their post code (eg. CB24). This will search against the schools table and bring up all of the schools that are located within that post code area. They must then select which one they belong to. The UNIQUE ID of the school will become their LOGIN ID for future logins. So many teacher may share the same user ID for login.
If they are a supply teacher, then they must enter their own address details, but they do not have to select a school. They will be allocated one of the unused UNIQUE IDs on the schools table and some of their details will be written to the school table against that UNIQUE ID row.
Within this registration, the user will choose their own 6 to 8 digit case sensitive password.
Users will select which programmes they wish to take part in. Some of these programmes can only have one teacher per school selecting them. Therefore with these programmes, if a teacher has already selected the programme, it will automatically appear checked when the school is selected by another teacher and they cannot uncheck the box. They can send an email to the teacher who orignially registered for this programme by clicking an email button.
Some of the information in this registration form will be written to the schools table and some will be written to the teachers table.
All registrations must be time and date stamped in format DD/MM/YYYY HH:MM
Page 3 is the profile management page where teachers can login (Page 1) and access their personal details on the teachers table. Here they can see all of their details and then click a button to make those details editable. A permanent teacher cannot change any of the details on the schools table but they can change the school they belong to by doing a post code search and selecting a different school. Or they can change from permanent to supply teacher and then must enter their own address which will be written to the schools table.
A supply teacher CAN edit their address details on the schools table.
If a teacher forgets their password, they can receive an automatic email by entering their UNIQUE ID and their email address. If they have forgotten their UNIQUE ID and their password then they can enter their first name, last name, school (via search) and email address and they will be emailed their username and password.