PHP Introduction Flashcards
A recursive acronym for “PHP: Hypertext Preprocessor” – It is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.
PHP: Hypertext Preprocessor
What is PHP: Hypertext Preprocessor?
PHP is a server-side scripting language
PHP scripts are executed on the server
PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP is open-source software
PHP runs on different platforms (Windows, Linux, Unix, etc.)
PHP is compatible with almost all servers used today (Apache, IIS, etc.)
PHP is FREE to download from the official PHP resource: ww.php.net
PHP is easy to learn and runs efficiently on the server side
A structured collection of data that is often stored electronically in a
computer system.
database
In charge of controlling a database
Database Management System (DBMS)
Abbreviated to just database, is the collective term for the data the DBMS, and the applications that are connected to it.
Database System
- Are raw facts
- Raw data must be formatted for storage, processing, and presentation
- Are the foundation of information, which is the bedrock of knowledge
- Building blocks of information
Data
- The result of processing raw data to reveal meaning.
- Requires context to reveal meaning
- produced by processing data
- used to reveal meaning in data
Information
- Accurate, relevant, timely information is the key to good decision making
- Good decision making is the key to organizational survival
- Data management: focuses on proper generation, storage, and retrieval of data
Analysis
Practical tools for storing data
Databases and Spreadsheets
Acts as a conduit between the database and the applications that will use it, enabling users to access, modify, and control how the
data is arranged and optimized. Also makes it easier to monitor and manage databases, enabling a number of administrative tasks like performance tweaking, backup, and recovery.
DBMS
What are the roles of DBMS?
- DBMS is the intermediary between the user and the database
- DBMS enables data to be shared
- DBMS integrates many users’ views of the data
Advantages of DBMS
- Improved data sharing
- Improved data security
- Improved data access
- Improved decision making
- Increased end-user productivity
- Minimized data inconsistency
- Better data integration
An open source relational database management system. It can
operate on any platform and was created and optimized for online applications.
MySQL
SQL
Structured Query Language, or SQL, is a query language.