Some documents for the S7 level in ICT.

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/, e.g. TP6_Exo1.php (or any other script).
  * 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/, e.g. TP6_Exo1.php (or any other script).
  * 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.php and TP4_Form.php.

30/09/2021:
  * Work5: PHP.

07/10/2021:
  * Work6: PHP: rehearsal for B Test ; the associated files: (a) download and rename .txt to .php or open and copy/paste TP6_Exo1.txt and TP6_Exo2.txt and (b) test directly the php files (or right click and save if you want to modify them) TP6_Exo1.php and TP6_Exo2.php.
  * Elements of correction for exercise 4: TP6_Form.html.

14/10/2021:
  * Work7: PHP: GET and POST; the associated files: TP7_Form.html, TP7_Post.php and TP7_Get.php (test directly or right click and save if you want to modify them).
  * Elements of correction for exercise 3: Work7_Form.html, Work7_Parity.php.

21/10/2021:
  * Test n°1 (2 x 45 minutes): Without computer; With computer; the associated file: Test1_ExoB1.php (right click and save if you want to modify it).
  * Elements of correction: With and without computer; the associated file: Test1_ExoB5.php (right click and save if you want to modify it).

28/10/2021:
  * Work8: phpMyAdmin; the associated files: TP8_Library_database.sql and TP8_Php_sql_first.txt (right click and save then rename it as .php).

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.
  * Wednesday, December the 22nd (just before the holidays): 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.
  * Thursday, January the 13th: oral presentation of your project with the oral presentation grading from last year.