Create an php page with the following functions. Please check the attachments for a view how it should look like.
Functions of PHP page
Opening page:
- show the following fields per row:
- event_id
- event_time
- event_durations
- event_location
- event_subject
- event_text
- event_date
- team_id
Check attachment for layoput.
- show 3 button (playing,maybe playing, not playing, empty field). Get the value from table event_available -> field: event_available_status
!! is field event_available_status="" then check no button.
Query:
SELECT*
FROM events
INNER JOIN event_available
ON events.event_id=event_available.event_id
where event_available.username="";
Function When page is open:
- When for example "Playing" button is pressed of event_id=1 by the user then do update query
UPDATE `event_available` SET `status`="not playing" WHERE event_available.event_id=1 AND event_available.username=""
!!This update is depending on the row offcource
You can see what I want: Go to [login to view URL] and login with
Username: florine
Password: florine
If you don't check this you don't need to respond.
Hello, how do you do? This project can be done by me with very less price and required time. and you can check out our portfolio than you will get know about my work and you will be glad to see my work . Must let me have chance to work with you. I will be waiting for your response.
Greetings. I see, you have small and easy task. I am ready to help you and solve your task like you discrabe it and show with example. Have a nice time and I wait for your answer.