Advanced
Web Applications


Foundational Preparatory Session

Webhosting

You should have an account at webik.ms.mff.cuni.cz (webik). You can connect to webik using following command.


ssh -p 42222 {username}@webik.ms.mff.cuni.cz
  

Content of the ~/public_html/ directory is available at https://webik.ms.mff.cuni.cz/~{username}.

PHP

There is PHP available at webik.

There is PHP installed on lab computers. You can start development PHP web-server with following command.


php -S 127.0.0.1:8070
      

SQL

There is a phpMyAdmin and Adminer available.

  • login and password are the same as for your first SSH login
  • your database name is stud_{yourlogin}

Checklist

You should be able to execute and explain all following steps.

  • Connect to webik and deploy simple HTML-site file.
  • Create another site using PHP.
  • Create a simple dialog using PHP. The dialog should utilize a POST request to same URL the dialog is at. In response to the POST the request PHP script should return a dialog summary. THe dialog must contain at least one field.
  • Create a table in the SQL database and populate it with data.
  • Connect to database using PHP and list all the records in the table.
Questions, ideas, or any other feedback?

Please feel free to use the anonymous feedback form.