MySQL Improved Extension (
Mysqli
)
2307
Documentation for MySQL can be found at
http://dev.mysql.com/doc/
.
Parts of this documentation included from MySQL manual with permissions of Oracle Corporation.
20.7.3.1. Examples
Copyright 1997-2012 the PHP Documentation Group. [2230]
All examples in the
mysqli
documentation use the world database. The world database can be found
at
http://downloads.mysql.com/docs/world.sql.gz
20.7.3.2. Overview
Copyright 1997-2012 the PHP Documentation Group. [2230]
This section provides an introduction to the options available to you when developing a PHP
application that needs to interact with a MySQL database.
What is an API?
An Application Programming Interface, or API, defines the classes, methods, functions and variables
that your application will need to call in order to carry out its desired task. In the case of PHP
applications that need to communicate with databases the necessary APIs are usually exposed via
PHP extensions.
APIs can be procedural or object-oriented. With a procedural API you call functions to carry out tasks,
with the object-oriented API you instantiate classes and then call methods on the resulting objects. Of
the two the latter is usually the preferred interface, as it is more modern and leads to better organized
code.
When writing PHP applications that need to connect to the MySQL server there are several API options
available. This document discusses what is available and how to select the best solution for your
application.
What is a Connector?
In the MySQL documentation, the term connector refers to a piece of software that allows your
application to connect to the MySQL database server. MySQL provides connectors for a variety of
languages, including PHP.
If your PHP application needs to communicate with a database server you will need to write PHP
code to perform such activities as connecting to the database server, querying the database and other
database-related functions. Software is required to provide the API that your PHP application will use,
and also handle the communication between your application and the database server, possibly using
other intermediate libraries where necessary. This software is known generically as a connector, as it
allows your application to connect to a database server.
What is a Driver?
A driver is a piece of software designed to communicate with a specific type of database server. The
driver may also call a library, such as the MySQL Client Library or the MySQL Native Driver. These
libraries implement the low-level protocol used to communicate with the MySQL database server.
By way of an example, the
PHP Data Objects (PDO) [2309]
database abstraction layer may use one of
several database-specific drivers. One of the drivers it has available is the PDO MYSQL driver, which
allows it to interface with the MySQL server.
Sometimes people use the terms connector and driver interchangeably, this can be confusing. In the
MySQL-related documentation the term “driver” is reserved for software that provides the database-
specific part of a connector package.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...