End of semester evaluation 2 ILJune 2020PresentationThis evaluation will be carried out in the form of a mini project that you will have one week to complete.It is a question of developing a website in PHP which will be based on a database in order to be able to manageorganizing parties with friends. The principle is as follows:• An organizer is defined by a nickname, a password and an email address. It can create an evening atfrom the moment all of its information is entered.• The characteristics of an evening are as follows:◦ it takes place on a specific date and time.◦ it takes place at a place defined by a name and an address (ex: "chez Marcel", "12 rue de la soif, 35000Rennes "or" Salle des fête communale "," place de la mairie, 46800 Moncuq ").• The creator of the evening adds guests to his evening. A guest is known to the system only by name,a first name and an email address.• Once the evening has been created with its guests, an email is sent to them inviting them to visit the siteto confirm or not their presence. This email contains a link configured with the identifier of the evening and theguest email (ex: "http: // localhost / soiree?
[email protected]").• Thanks to the two parameters contained in the link received by email, the site can directly present to the guestthe page where he can accept or decline the invitation.• The organizer who organized the evening can, at any time, have access to a "dashboard" of theevening indicating the status of the various guests (invitation accepted / invitation declined / no response)as well as the details of the evening (place and date).Organizers interfaceHere is a proposal for organizer interfaces. These interfaces are given for information only,• the style sheets will be personalized according to your tastes• the compulsory elements are in bold and underlined.Page 1 of 4List of an organizer's eveningsIt will be a table listing the past and future evenings of a given organizer. Only the organizerconnected can see his evenings.Dashboard / Evening creationThe dashboard or a page similar to it will be used in different cases with a few nuances:• Creation or modification of an evening (not yet passed) by the organizer:◦ the fields in the "Information" tab can be entered,◦ You can add, modify or delete one of the guests from the list (see how).• Visualization of an evening spent by the organizer: all the fields are read-only, nomodification of the list of possible guests.• Visualization of a future evening by a guest (via the link received by email): all fields are readonly, no modification of the guest list possible. An "Accept" button and a "Refuse" buttonare present under the dashboard for the guest to define whether or not to attend the partyPage 2 of 4Click on a row in the tablereplace the current page with theevening dashboardclicked whether it passed orto come up.The active tab is displayed usingspecific formatting.A click on the inactive tab makes itactive:- replacement of content byguest list without reminder toserver (javascript only).- the clicked tab becomes visuallyactive (here, for example, it would switch toyellow background, bold and borderlesslower)Find a system to display theresponse from participants: accepted,refused or not yet answered.The use of tabs managed byjavascript is required.Technical considerationsAs you will be in a development context (local server), the functioning ofmail sending functions are not guaranteed as they would be once the project is deployed ona hosting server, in production context.As this skill is secondary, you can content yourself with:• to prove the correct use of the functions implemented to send emails,based on your Intech account identifiers, with:• smtp server: smtp.office365.com• security: STARTTLS• port: 587• and to provide a means of recovering the information sent in your emails,including invitation links, for example, using the php function"Error_log ($ message); To display the links on the server console.Renderings• You will return by email, no later than Sunday 6/21/2020 at 11.59pm, your project in the form◦ a zip of your entire php project. This one MUST have the following name:"EVALS2_202006_ _ _ .zip" (by changing, of course,the , and values by the elements in question.Zip another zip containing the SQL scripts for creating your tables and an image of your MCD atjpg format. This zip MUST have the following name:«EVALS2_BDD_202006_ _ _ .zip "(changing, fineheard, the values , and by the elements in question.• Depending on your campus, these zip files will be sent to the following supervisor:◦ Agen →
[email protected]◦ Béziers, Montauban →
[email protected]◦ Dax →
[email protected]◦ Nîmes →
[email protected]◦ Pamiers →
[email protected] assessed PHP:◦ Know how to use imports (require / include)◦ Know how to create and use an associative array or an object◦ Know how to manage session data ($ _SESSION)◦ Know how to recover data from a form posted via GET and POST methods◦ Know how to create a Statement via PDO and use it (execution, recovery, etc.)Page 3 of 4◦ Know how to test a variable via isset () and empty ()◦ Know how to redirect via PHP◦ Know how to send an email Web programming◦ Know how to write style sheets to adapt the layout◦ Know how to respect the standards defined by the W3C organization (respect the semantics, use a sheetrobust style, test and correct pages, etc.)◦ Know how to manipulate the DOM tree via JavaScript (with or without a framework like JQuery) Merise modeling◦ Know how to create a conceptual data model (MCD) and master the concepts: cardinalities, entities,associations, properties, identifiers◦ Know how to create a Logical Data Model (MLD) Database management◦ Know how to create and handle a database▪ Know how to write Select type queries with at least one inner join and one condition(where clause)▪ Know how to write requests of type Insert, Delete, Update Security◦ know how to protect your site with .htaccess Good practices◦ Know how to comment, correctly indent your code◦ Know how to respect the rules for naming variables, functions, files, etc.Page 4 of 4