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 (the ``W'' icon on the bottom right of your screen should be green).
* Open your browser and type http://localhost/TP6_Exo1.php (or the name of your script) to test your php programs.
* Open phpMyAdmin to update your database (click on the green ``W'' icon and then phpMyAdmin, 5.1.1).
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) to test your php programs.
* Open phpMyAdmin to update your database (inside MAMP, click on ``WebStart'' and then MySQL, phpMyAdmin).
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.08-09/09/2022:
* Work1: HTML ; the associated files TP1_Basic.html and TP1_Errors.html.
15-16/09/2022:
* Work2: Tables, CSS ; the associated files TP2_2019_BTest.html and TP2_images.zip (source: December 2019 B Test, Mr. Santos Pereira).
22-23/09/2022:
* Work3: HTML Forms ; the associated image TP3_select_all_white.png.
* Associated websites: https://www.mtgpics.com/search ; http://www.barsamian.am/mathsexams/ ; http://www.euroschool.lu/luxschool/maths/admin/form.php.
29-30/09/2022:
* 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).
06-07/10/2022:
* Work5: PHP.
12-13/10/2022:
* Work6: PHP: rehearsal for 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.
19-20-26/10/2022 (depending on when you're on trip...):
* Test n°1 (2 x 45 minutes).
19/10/2022:
* Test n°1 without computer: The test.
* Presents: 8/9 (everyone except Diego).
20/10/2022:
* Test n°1 with computer: The test; the associated file: Test1_ExoB1.txt (open it to see the code, download and rename it to .php to use it).
* Presents: 2/9 (Paolo, Ruan).
* 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).
26/10/2022:
* Extra activity for the three of you who are there: register machines, algorithms with an ice cube tray (adapted from the Post machine ; thanks to an original idea from Alain Busser, see this article, in French).
27/10/2022:
* Teacher on school trip.
09/11/2022:
* 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).
10/11/2022:
* 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).
16/11/2022-Up to prebac:
* Semester 1 Project: Build your website from scratch.
* Vehicles database: CO2_emissions_by_cars.sql.
* Music database: musicBrainz.sql ; explanations.
* During each course: bring your laptops, use WAMP / MAMP for your project.
11-12/01/2023:
* Oral presentation of your projects.
18/01/2023:
* How to hack a website? SQL injection.
19/01/2023:
* Graphs: a slideshow introduction.
25-26/01/2023 and 01-02/02/2023:
* Two weeks of prebac.
08-09/02/2023:
* Last oral presentation.
* Work9: Graphs (1/5); the associated Python code.
15-16/02/2023:
* End of Work9 (question 5).
* Work10: Graphs (2/5); the associated Python code.
08/03/2023:
* End of Work10.
* The following Python code uses no external libraries and computes the derivative of a function that uses the variable "x", if we give its expression as a string. It is the compilation of our works 9 and 10, together with a parser (that converts the expression string to a Tree): derive.py. The fact that is uses no external library makes this program usable on your calculator (Numworks, TI 83 Premium CE Python).
09/03/2023:
* Work11: Graphs (3/5); the associated Python code.
15-16/03/2023:
* End of Work11.
22-23/03/2023:
* Rehearsal with the B Test from previous year: the subject; the associated Python code.
29/03/2023:
* Work11bonus: Graphs (3bonus/5); the associated Python code.
30/03/2023:
* Teacher absent: project week.
19-20/04/2023:
* B Test
26/04/2023:
* Teacher absent: training.
27/04/2023:
* Work12: Graphs (4/5); the associated Python code.
03-04/05/2023:
* End of work 12.
* Work13: Graphs (5/5); the associated Python code.
10/05/2023:
* Prebac philosophy 2 periods: no course.
11/05/2023:
* Work13 bonus: random walks on infinite graphs.
24-25/05/2023:
* Work14: Artificial intelligence: a translated excerpt from the book ``L'intelligence artificielle n'est pas une question technologique'' by Laurent Bibard and Nicolas Sabouret (pages 15 to 27). And the French version: intelligence artificielle.
31/05/2023:
* Bac day: no course.