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.06/09/2022:
* Work1: HTML ; the associated files TP1_Basic.html and TP1_Errors.html.
13/09/2022:
* Work2: Tables, CSS ; the associated files TP2_2019_BTest.html and TP2_images.zip (source: December 2019 B Test, Mr. Santos Pereira).
20/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.
27/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).
04/10/2022:
* Work5: PHP.
11/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.
18/10/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).
25/10/2022:
* Test n°1 (2 x 45 minutes).
* Part without computer: The test.
* Part 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).
* 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).
08/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).
15/11/2022-Up to prebac:
* Semester 1 Project: Build your website from scratch.
* During each course: bring your laptops, use WAMP / MAMP for your project.
09/01/2023:
* No ICT course: orientation session.
16/01/2023:
* Oral presentation of your projects.
23/01/2023 and 30/01/2023:
* Two weeks of prebac.
07/02/2023:
* How to hack a website? SQL injection.
* Graphs: a slideshow introduction.
14/02/2023:
* Work9: Graphs (1/5); the associated Python code.
28/02/2023:
* End of Work9.
* Work10: Graphs (2/5); the associated Python code.
07/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).
14/03/2023:
* Work11: Graphs (3/5); the associated Python code.
21/03/2023:
* Rehearsal with the B Test from previous year: the subject; the associated Python code.
28/03/2023:
* Teacher absent: project week.
18/04/2023:
* B Test.
25/04/2023:
* Work12: Graphs (4/5); the associated Python code.
02/05/2023:
* Prebac history 2 periods: no course.
09/05/2023:
* Work13: Graphs (5/5): a simplified model of artificial intelligence; the associated Python code.
23/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.
30/05/2023:
* ???