This site is mobile accessible. Press the "Tap Here" button to use a different font-size.


Smartphone icons created by Freepik - Flaticon

  • 8.1 MySQL Database
  • 8.2 MySQL Connect
  • 8.3 MySQL Create DB
  • 8.4 MySQL Create Table
  • 8.5 MySQL Insert Data
  • 8.6 MySQL Get Last ID
  • 8.7 MySQL Insert Multiple
  • 8.8 MySQL Prepared
  • 8.9 MySQL Select Data
  • 8.10 MySQL Where
  • 8.11 MySQL Order By
  • 8.12 MySQL Delete Data
  • 8.13 MySQL Update Data
  • 8.14 MySQL Limit Data
    •
  • 1.1 PHP Intro
  • 1.2 PHP Install
  • 1.3 PHP Syntax
  • 1.4 PHP Comments
  • 1.5 PHP Variables
  • 1.5.1 Variables Scope
  • 1.6 PHP Echo / Print
    •
  • 2.1 PHP Data Types
  • 2.2 PHP Strings
  • 2.3 PHP Numbers
  • 2.4 PHP Math
  • 2.5 PHP Constants
  • 2.6 PHP Casting
  • 2.7 PHP Magic Constants
    •
  • 3.1 PHP Operators
  • 3.2 PHP If Else Elseif
  • 3.3 PHP Switch
  • 3.4 PHP Loops
  • 3.4.1 While Loop
  • 3.4.2 Do While Loop
  • 3.4.3 For Loop
  • 3.4.4 Foreach Loop
  • 3.4.5 Break/Continue
  • 3.5 PHP Functions
    •
  • 4.1 PHP Arrays
  • 4.1.1 Indexed Arrays
  • 4.1.2 Associative Arrays
  • 4.1.3 Multidimensional Arrays
  • 4.1.4 Sorting Arrays
  • 4.2 PHP Superglobals
  • 4.2.1 $GLOBALS
  • 4.2.2 $_SERVER
  • 4.2.3 $_REQUEST
  • 4.2.4 $_POST
  • 4.2.5 $_GET
  • 4.3 PHP RegEx
    •
  • 5.1 PHP Form Handling
  • 5.2 PHP Form Validation
  • 5.3 PHP Form Required
  • 5.4 PHP Form URL / E-mail
  • 5.5 PHP Form Complete
    •
  • 6.1 PHP Date and Time
  • 6.2 PHP Include Files
  • 6.3 PHP File Handling
  • 6.4 PHP File Open/Read
  • 6.5 PHP File Create/Write
  • 6.6 PHP File Upload
  • 6.7 PHP Cookies
  • 6.8 PHP Sessions
  • 6.9 PHP Filters
  • 6.10 PHP Filters Advanced
  • 6.11 PHP Callback Functions
  • 6.12 PHP JSON
  • 6.13 PHP Exceptions
    •
  • 7.1 PHP What is OOP
  • 7.2 PHP Classes / Objects
  • 7.3 PHP Constructor
  • 7.4 PHP Destructor
  • 7.5 PHP Access Modifiers
  • 7.6 PHP Inheritance
  • 7.7 PHP Class Constants
  • 7.8 PHP Abstract Classes
  • 7.9 PHP Interfaces
  • 7.10 PHP Traits
  • 7.11 PHP Static Methods
  • 7.12 PHP Static Properties
  • 7.13 PHP Namespaces
  • 7.14 PHP Iterables
    •
  • 8.1 MySQL Database
  • 8.2 MySQL Connect
  • 8.3 MySQL Create DB
  • 8.4 MySQL Create Table
  • 8.5 MySQL Insert Data
  • 8.6 MySQL Get Last ID
  • 8.7 MySQL Insert Multiple
  • 8.8 MySQL Prepared
  • 8.9 MySQL Select Data
  • 8.10 MySQL Where
  • 8.11 MySQL Order By
  • 8.12 MySQL Delete Data
  • 8.13 MySQL Update Data
  • 8.14 MySQL Limit Data
    •
  • 9.1 PHP XML Parsers
  • 9.2 PHP SimpleXML Parser
  • 9.3 PHP SimpleXML - Get
  • 9.4 PHP XML Expat
  • 9.5 PHP XML DOM
    •
  • 10.1 AJAX Intro
  • 10.2 AJAX PHP
  • 10.3 AJAX Database
  • 10.4 AJAX XML
  • 10.5 AJAX Live Search
  • 10.6 AJAX Poll
  • My Poll
    •

    • 8.1 MySQL Database

    • 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 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.

    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.
    • Look at http://www.mysql.com/customers/ for an overview of companies using MySQL.

    PHP Fundamentals course home
    Module 8. MySQL Database

    Navigate this module
  • 8.1 MySQL Database
  • 8.2 MySQL Connect
  • 8.3 MySQL Create DB
  • 8.4 MySQL Create Table
  • 8.5 MySQL Insert Data
  • 8.6 MySQL Get Last ID
  • 8.7 MySQL Insert Multiple
  • 8.8 MySQL Prepared
  • 8.9 MySQL Select Data
  • 8.10 MySQL Where
  • 8.11 MySQL Order By
  • 8.12 MySQL Delete Data
  • 8.13 MySQL Update Data
  • 8.14 MySQL Limit Data
    •

    Eventually the navigation links, above, will be replaced by these << (previous) and >> (next) buttons below.



    Animated PHP icons used in the buttons provided by ICONS8.COM. Smartphone icons created by Freepik - Flaticon

    Example files created in this module:
    MySQLi Object-Oriented connection MySQLi Procedural connection MySQL PDO connection Create database using MySQLi Object-oriented Create database using MySQLi Procedural Create database using PDO Create database table using MySQLi Object-oriented Create database table using MySQLi Procedural Create database table using PDO Insert data using mySQLi OO Insert data using mySQLi Procedural Insert data using PDO Get Last Guests ID OO Get Last Guests ID Procedural Get Last Guests ID PDO Insert Multiple Records OO Insert Multiple records Procedural Insert Multiple records PDO Prepared Statements OO Prepared Statements PDO My Guests mySQLi OO Selecting guests (mySQLi Procedural) My Guests (PDO) Where Filter mySQLi OO Where Filter mySQLi Procedural Where Filter PDO Order By mySQLi OO Order By mySQLi Procedural Order-by PDO Delete Guests mySQLi OO Delete Guests mySQLi Procedural Delete Guests PDO Update Guests mySQLi OO Update Guests mySQLi Procedural Update Guests PDO My Customers