This folder contains three projects: * the first *case* shows how the div tag can be used to position the text boxes in a page * the second project *website* sets up a website for some academic conference * the third project *sqlback* sets up a mySQL backed website for online queries CSS allows to specify both static (color, font and so on and dynamic, or event dependent html features. Two methods are available for sending values obtained in an input form to a remote server. The difference is that *get* shows the values being sent in the client browser's address bar while *post* doesn't. PHP reads in parameters sent by *get* or *post* and results in a HTML. To run a local PHP web server, install the package *libapache2-mod-php5* and files can be put in */var/www*. In the browser, to retrieve home.php for instance, type *http://localhost/home.php*. The Apache web server is written in C. To serve web applications in Python, Cherrypy may be better suited. However, one might be advised to run Cherrypy on top of Apache for a better task sharing. *python -m SimpleHTTPServer 8000* also starts a web server which makes browsing local files just like webpages. However, it doesn't support PHP. Javascript is order-sensitive: the next two HTML snippets
JavaScript can change the content of an HTML element.
andJavaScript can change the content of an HTML element.
don't have the same output when converted using > markdown readme.md > readme.html In SQL, select * from table_1, table_2 forms a cartesian product from the entries of the two tables. And where allows to eliminate rows that do not satisfy certain conditions. Performance wise, where and join are the the same but the former offers a clearer vision of what is done. PHP can send queries to a SQL database and iterate through the returned table, hence making it easy for dynamic webpage generation. SQL can enforce input content integrity through table constraints. For example, the foreign key checks whether certain attributes of a new row are defined in an existing table, which makes subsequent table join more robust. phpmyadmin is a frontend for mySQL which helps visualize tables in the database