With PHP, you can connect to and manipulate databases.

MySQL is the most popular database system used with PHP.

MySQL Definition

  • MySQL is a database system used on the web
  • MySQL is a database system that runs on a server
  • MySQL is ideal for both small and large applications
  • MySQL is very fast, reliable, and easy to use
  • MySQL uses standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is free to download and use
  • MySQL is developed, distributed, and supported by Oracle Corporation
  • MySQL is named after co-founder Monty Widenius's daughter: My

 The data in a MySQL database are stored in tables. A table is a collection of its related data, and it consists of columns and rows. 


PHP + MySQL Database System

  • PHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform)

Database Queries

A query is a question or a request.

We can query a database for specific information and have a recordset returned.

Look at the following query (using standard SQL):

SELECT LastName FROM Employees

The query above selects all the data in the "LastName" column from the "Employees" table.

To learn more about SQL, please visit our SQL tutorial.

Download MySQL Database

If you don't have a PHP server with a MySQL Database, you can download it for free here: http://www.mysql.com

Facts About MySQL Database

MySQL is the de-facto standard database system for web sites with HUGE volumes of both data and end-users (like Facebook, Twitter, and Wikipedia).

Another great thing about MySQL is that it can be scaled down to support embedded database applications.

 

Comments

Post a Comment

Popular posts from this blog

What is Data Flow Diagram (DFD)

Image
Data Flow Diagram Symbols. DFD Library Data Flow Diagram Symbols. DFD Library Data Flow Diagrams graphically represent the information transfers and process steps of a system. They visually depict how data are processed by a system in terms of inputs and outputs, how occurs the input in a system, how the data flow through an information system and where they are stored, and how occurs output from the system. DFDs give the overview of the system and models the processes aspects, they are maintained with other methods of structured systems analysis. The main goal of DFDs is achievement of understanding between developers and users. For their construction are used two notations - Gane-Sarson and Yourdon, each of them uses its own set of symbols. Data Flow Diagrams solution from Software Development area extends the ConceptDraw PRO software with templates, samples, and predesigned libraries of data flow diagram symbols for both notations, allowing you
Read more
Image
New Technologies  VR, AR, MR  Virtual Reality Virtual reality is the use of computer technology to create simulated environments. Virtual reality places the user inside a three-dimensional experience. Instead of viewing a screen in front of them, users are immersed in and interact with 3D worlds. Simulation of human senses—all five of them—transforms a computer into a vehicle into new worlds. The only limitation to a superb VR experience is computing power and content availability. Three Categories Of VR Non-Immersive Virtual Reality : This category is often overlooked as VR simply because it’s so common. Non-immersive VR technology features a computer-generated virtual environment where the user simultaneously remains aware and controlled by their physical environment. Video games are a prime example of non-immersive VR. Semi-Immersive Virtual Reality :   This type of VR provides an experience partially based in a virtual environment. This type of VR makes sense for educational and tr
Read more