With PHP, you can connect to databases and change the way they work.
PHP is most often used with MySQL, which is a database system.
What does MySQL mean?
- MySQL is an online database system.
- MySQL is a server-based database system.
- MySQL is great for both small and big projects.
- MySQL is quick, reliable, and simple to use.
- SQL is used by MySQL.
- MySQL can be built on several platforms.
- MySQL is free to use and to get.
Oracle Corporation is in charge of making, distributing, and supporting MySQL.
MySQL is named after My, the daughter of co-founder Monty Widenius.
Tables hold the information in a MySQL database. A table is a group of related information that is made up of columns and rows.
Databases are good for storing information in a way that makes sense. A company’s database could have the following tables:
- School
- Teachers
- Student
- Class
System for PHP and MySQL Database
PHP and MySQL together 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 ask a database for information and get back a set of records.
Look at this query, which is written in standard SQL:
SELECT Name FROM Students
Choose the last name from the list of Students.
The query above gets all the information from the “Students” table’s “Name” column.
Visit our SQL tutorial to learn more about SQL.
Get the MySQL Database file.
If you don’t have a PHP server with a MySQL database, you can get one for free at http://www.mysql.com.
About the MySQL Database:
MySQL is the standard database system for websites with a lot of users and a lot of data.
Another great thing about MySQL is that it can be shrunk down to work with database applications that are built into other programs.
You can see a list of companies that use MySQL at http://www.mysql.com/customers/.