Official syllabus:
It is the 2019 syllabus which is available at the following link.How to program in PHP + MySQL:
1) Install the following softwares:* A PHP editor, e.g. https://netbeans.apache.org/ (or Visual Studio as on the school computers)
* A PHP + SQL server, e.g. https://www.wampserver.com/ for Windows or https://www.mamp.info/en/downloads/ (select ``MAMP & MAMP PRO 6.6'', you probably have an Intel processor so select the Intel one).
a) Using WAMP (Windows Apache MySQL PHP):
* Put any PHP file you want to test into C:/wamp64/www/.
* Make sure wampserver is running and has opened a local PHP server.
* Open your browser and type http://localhost/TP6_Exo1.php (or the name of your script).
b) Using MAMP (Mac Apache MySQL PHP):
* Put any PHP file you want to test into /Applications/MAMP/htdocs/.
* Make sure MAMP is running and has opened a local PHP server.
* Open your browser and type http://localhost/TP6_Exo1.php (or the name of your script).
2) If you only test really simple PHP scripts (no SQL, no GET / POST), you can go online:
* https://phpsandbox.io/
* https://www.w3schools.com/php/phptryit.asp?filename=tryphp_compiler
* https://sandbox.onlinephpfunctions.com/
Documents:
Some of the documents shared in this section have been reproduced thanks to documents shared by other colleagues. Let them be thanked for eternity (and beyond). It is not easy to always create works ex nihilo, and their help was more than valuable.02/09/2021:
* Work1: HTML ; the associated files TP1_Basic.html and TP1_Errors.html.
09/09/2021:
* Work2: Tables, CSS ; the associated files TP2_2019_BTest.html and TP2_images.zip (source: December 2019 B Test, Mr. Santos Pereira).
16/09/2021:
* Work3: HTML Forms ; the associated image TP3_select_all_white.png.
23/09/2021:
* Work4: PHP ; the associated files TP4_Welcome.txt and TP4_Form.txt (open them to see the code, download and rename them to .php to use them).
30/09/2021:
* Work5: PHP.
07/10/2021:
* Work6: PHP: rehearsal for B Test ; the associated files: TP6_Exo1.txt and TP6_Exo2.txt (open them to see the code, download and rename them to .php to use them).
* Elements of correction for exercise 4: Work6_Form.html.
14/10/2021:
* Work7: PHP: GET and POST; the associated files: TP7_Form.html (click to test the POST method), TP7_Post.txt (open it to see the code) and TP7_Get.php (click and modify the url to test the GET method), TP7_Get.txt (open it to see the code, download and rename it to .php to use it).
* Elements of correction for exercise 3: Work7_Form.html (click to test the code), Work7_Parity.txt (open it to see the code, download and rename it to .php to use it).
21/10/2021:
* Test n°1 (2 x 45 minutes): Without computer; With computer; the associated file: Test1_ExoB1.txt (open it to see the code, download and rename it to .php to use it).
* Elements of correction: With and without computer; the associated file: Test1_ExoB5.txt (open it to see the code, download and rename it to .php to use it).
28/10/2021:
* Work8: phpMyAdmin; the associated files: TP8_Library_database.sql and TP8_Php_sql_first.txt (open it to see the code, download and rename it to .php to use it).
11/11/2021--23/12/2021:
* Semester 1 Project: Build your website from scratch.
* During each course: bring your laptops, use WAMP / MAMP for your project.
[UPDATED] 13/01/2022:
* Last project week.
[UPDATED] 17/01/2022:
* Deadline for sending your code + explanation. Send me your project by e-mail, including PHP (and maybe HTML) files, a SQL export of your database(s), a short explanation of your project and of the choices you made (4 pages), some screenshots of your website.
[UPDATED] 20/01/2022:
* B Test: maximum 20 minutes per group (minimum 5 minutes per student).
The grading grid, one per student (as opposed to the team grading for the code) is the following: oral presentation grading (it's the same as last year).
27/01/2022 and 03/02/2022:
* Two weeks of prebac.
10/02/2022:
* Last B Test presentations.
17/02/2022:
* Work on your own: teacher on school trip.
17/03/2022:
* Yves Roggeman is presenting: What does mean "cryptographically safe"?.
10/02/2022, [17/02/2022: teacher on school trip], 03/03/2022, 10/03/2022, 17/03/2022, 24/03/2022, 31/03/2022:
* Inside the Metaverse: slideshow; some links.
31/03/2022:
* Inside the Metaverse: presentations of your work.
* Graphs: a slideshow introduction.
07/04/2022:
* Inside the Metaverse: last presentations of your work.
* Graphs: a slideshow introduction.
* Work9: Graphs (1/3); the associated Python code.
28/04/2022:
* Work10: Graphs (2/3); the associated Python code; elements of correction.
05/05/2022:
* (8h30-10h00: short pre-baccalaureate in Advanced mathematics).
* Work11: Graphs (3/3); the associated Python code.
12/05/2022:
* B Test: the subject; the associated Python code.
19/05/2022:
* (No course, baccalaureate revisions).