I have an urgent project that needs creating.
TIMING - THIS NEEDS TO BE WORKED ON IMMEDIATELY - I NEED TO SEE PART 1 COMPLETE IN 12 HOURS.
I NEED SOMEONE WHO CAN START NOW!
You will have extensive knowledge of PHP and mysql and be able to build secure scripts.
PROJECT PART 1
1. Create a table on our database - engagingminds_schools
2. Insert a large excel file to that table. This is a table of all schools. Each school has been given a unique 6 digit ID. In addition there are about 10,000 further records with only a unique ID but no further information as this will be added for new schools.
3. Create a table on our database - engagingminds_teachers
4. FRONT END
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 select supply teacher, then they must enter their own address details, but they do not have to select a school so that part should not appear. In this case, their own address details will be written to engagingminds_schools against the next unused UNIQUE ID on the table.
Within this registration, the user will choose their own 6 to 8 digit case sensitive password.
Their future login will be USERNAME: the school unique ID / PASSWORD: their own selected password. So there may be many teachers with the same USERNAME, but a teacher cannot have the same USERNAM AND PASSWORD.
PROJECT PART 2
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.