THE WORLD'S LARGEST WEB DEVELOPER SITE

PHP 教程

PHP主页 PHP简介 PHP安装 PHP语法 PHP评论 PHP变量 PHP回声/打印 PHP数据类型 PHP字符串 PHP编号 PHP数学 PHP常量 PHP运算符 PHP If...Else...Elseif PHP开关 PHP循环 PHP函数 PHP数组 PHP超全局变量 PHP正则表达式

PHP 形式

PHP表单处理 PHP表单验证 需要PHP表格 PHP表单URL /电子邮件 PHP表格完成

PHP 高级

PHP日期和时间 PHP包含 PHP文件处理 PHP文件打开/读取 PHP文件创建/写入 PHP文件上传 PHP Cookies PHP会话 PHP过滤器 PHP过滤器 高级 PHP Callback Functions PHP JSON PHP异常

PHP OOP

PHP什么是OOP PHP类/对象 PHP构造函数 PHP析构函数 PHP访问修饰符 PHP继承 PHP常量 PHP抽象类 PHP特质 PHP静态方法 PHP静态属性 PHP Namespaces PHP Iterables

MySQL 数据库

MySQL数据库 MySQL连接 MySQL创建数据库 MySQL创建表 MySQL输入sert Data MySQL获取最后一个ID MySQL输入sert Multiple MySQL准备 MySQL选择 Data MySQL位置 MySQL排序依据 MySQL删除 Data MySQL更新 Data MySQL限制数据

PHP XML

PHP XML解析器 PHP SimpleXML解析器 PHP SimpleXML-获取 PHP XML扩展 PHP XML DOM

PHP - AJAX

AJAX简介 AJAX PHP AJAX数据库 AJAX XML AJAX实时搜索 AJAX投票

PHP 示例

PHP 示例 PHP编译器 PHP 测试 PHP 练习 PHP 证书

PHP 参考

PHP概述 PHP数组 PHP 日历 PHP日期 PHP目录 PHP错误 PHP文件系统 PHP过滤器 PHP FTP PHP JSON PHP Libxml PHP邮件 PHP数学 PHP杂项 PHP MySQLi PHP网络 PHP正则表达式 PHP SimpleXML PHP Stream PHP字符串 PHP变量处理 PHP XML解析器 PHP邮编 PHP时区

PHP MySQL数据库


With PHP, you can connect to and manipulate databases.

MySQL is the most popular database system used with PHP.


What is MySQL?

  • 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 related data, and it consists of columns and rows.

Databases are useful for storing information categorically. A company may have a database with the following tables:

  • Employees
  • Products
  • Customers
  • Orders

PHP + MySQL数据库 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数据库

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


Facts About MySQL数据库

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.

Look at http://www.mysql.com/customers/ for an overview of companies using MySQL.




W3Schools is optimized for learning, testing, and training. 示例 might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 1999-2020 by Refsnes Data. All Rights Reserved.
Powered by W3.CSS.

W3Schools.com