List any two web development technologies that are used for creating dynamic web pages. List five important features of these technologies.
Answers
Ans.
###1. PHP-:( Hypertext Preprocessor )
PHP is a general-purpose scripting language that is especially suited to server-side web development, in which case PHP generally runs on a web server. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content or dynamic images used on websites or elsewhere.
it’s a simple matter to embed dynamic activity in web pages. When you give pages the .php extension, they have instant access to the scripting language.
****Features of php*****
1. Simple
It is very simple and easy to use, compare to other scripting language it is very simple and easy, this is widely used all over the world.
2. Interpreted
It is an interpreted language, i.e. there is no need for compilation.
3. Faster
It is faster than other scripting language e.g. asp and jsp.
4. Open Source
Open source means you no need to pay for use php, you can free download and use.
5. Platform Independent
PHP code will be run on every platform, Linux, Unix, Mac OS X, Windows.
6. Case Sensitive
PHP is case sensitive scripting language at time of variable declaration. In PHP, all keywords (e.g. if, else, while, echo, etc.), classes, functions, and user-defined functions are NOT case-sensitive.
7. Error Reporting
PHP have some predefined error reporting constants to generate a warning or error notice.
8. Real-Time Access Monitoring
PHP provides access logging by creating the summary of recent accesses for the user.
9. Loosely Typed Language
PHP supports variable usage without declaring its data type. It will be taken at the time of the execution based on the type of data it has on its value.
####2. MySQL :- (My Structured Query Language )
MySQL is an open source relational database management system based on SQL. we also used MySQL for making dynamic web pages. Which are helpful in accessing information from database.
MySQL is the standard query language for interacting with databases. MySQL is an open source, SQL database server that is more or less free and extremely fast. MySQL is also cross platform
****Fetuses of MySQL****
features as available in MySQL 5.6:
1. A broad subset of ANSI SQL 99, as well as extensions
2. Cross-platform support
3. Stored procedures, using a procedural language that closely adheres to SQL/PSM[77]
4. Triggers
5. Cursors
6. Updatable views
7. Online Data Definition Language (DDL) when using the InnoDB
8. Storage Engine.
9. Information schema
10. SSL support
11. Query caching
12. Unicode support
Two web development technologies that are used for creating dynamic web pages are:
i) PHP-:( Hypertext Preprocessor )
PHP is one of the most used scripting language that is especially suitable for server-side web development, in which case PHP generally runs on a web server.
The PHP runtime executes a PHP code in a requested file, usually to create dynamic web page content or dynamic images used on websites or elsewhere.
Features of php:
1. Faster
It is faster than other scripting language e.g. asp and jsp.
2. Open Source
Open source means you no need to pay for use php, you can free download and use.
3. Platform Independent
PHP code will be run on every platform, Linux, Unix, Mac OS X, Windows.
4. Case Sensitive
PHP is case sensitive scripting language at time of variable declaration. In PHP, all keywords (e.g. if, else, while, echo, etc.), classes, functions, and user-defined functions are NOT case-sensitive.
5. Simple
It is very simple and easy to use, compare to other scripting language it is very simple and easy, this is widely used all over the world.
6. Interpreted
It is an interpreted language, i.e. there is no need for compilation.
ii) MySQL :- (My Structured Query Language )
MySQL is an open source relational database management system which is based on SQL. MySQL is also used for making dynamic web pages that are helpful in accessing information from database.
For interacting with databases MySQL is a great query language. SQL database serve is more or less free and extremely fast.
Features of MySQL:
1. Cross-platform support
2. Stored procedures, using a procedural language that closely adheres to SQL/PSM
3. A broad subset of ANSI SQL 99, as well as extensions
4. Cursors
5. Triggers
6. Updatable views