Chapter 1 - Dynamic Web Content Flashcards
What is Apache?
The web server we use.
What does Apache web server do?
It responds to web requests and triggers other software to run on the server, such as:
PHP, operating as a module embedded into Apache.
MySQL, which acts as the database.
What does Apache web server do?
It responds to web requests and triggers other software to run on the server, such as:
PHP, operating as a module embedded into Apache.
MySQL, which acts as the database.
What is a request response process?
It consists of a web browser asking the web server to send it a web page, and the server sending it back to the page. the browser then takes care of displaying the page.
What does DNS stand for?
Domain Name Service
Give an example of an INSERT statement
INSERT INTO users VALUES(‘Smith’, ‘John’, ‘jsmith@mysite.com’);
Give an example of a SELECT statement
SELECT surname,firstname FROM users WHERE email=’jsmith@mysite.com’;
What does SQL stand for?
Structured Query Language
What is an RSS?
Really Simple Syndication
What does the Rewrite module do?
Enables the web server to handle a varying range of URL types and rewrite them to its own internal requirements.
What does the proxy module do?
You can use this to serve up often-requested pages from a cache to ease the load on the server.
What does PHP handle?
All the main work on the web server
What does mySQL handle?
Manages all the data
What do CSS and Javascript handle?
How the web page is presented
What are the four components at minimum, needed to create a fully dynamic web page?
A web server (such as Apache)
a server-side scripting language (PHP)
a database (MySQL)
a client-side scripting language (JavaScript).
What does HTML stand for?
HyperText Markup Language: the web page itself, including text and markup tags.
Why does the name MYSQL contain the letters SQL?
Like nearly all database engines, MySQL accepts commands in Structured Query Language (SQL). SQL is the way that every user (including a PHP program) communicates with MySQL.
PHP and JAvaScript are both programming languages that generate dynamic results for web pages. What is their main difference, and why would you use both of them?
PHP runs on the server, whereas JavaScript runs on the client. PHP can communicate with the database to store and retrieve data, but it can’t alter the user’s web page quickly and dynamically. JavaScript has the opposite benefits and drawbacks.
What does CSS stand for?
Cascading Style Sheets: styling and layout rules applied to the elements in an HTML document.
List three major new elements introduced in HTML5.
Probably the most interesting new elements in HTML5 are , , and , although there are many others such as , , , and more.
If you encounter a bug in one of the open source tools, how do you think you could get it fixed?
Some of these technologies are controlled by companies that accept bug reports and fix the errors like any software company. But open source software also depends on a community, so your bug report may be handled by any user who understands the code well enough. You may someday fix bugs in an open source tool yourself.
