Outdated: mysql_connect() using php_mysql.dll Library
This section describes functions supported by the MySQL extension library, php_mysql.dll. mysql_connect() creates a connection to the specified MySQL server.
PHP's MySQL support comes from an extension library, php_mysql.dll, which
offers a number of functions:
- mysql_connect() - Connects to a MySQL server, and returns a connection resource.
In most cases, you need to call it with 3 arguments like mysql_connect($server, $username, $password).
$server specifies the network address of machine where the MySQL server is running.
$username specifies the user login name on the MySQL server.
$password specifies the password for the login name.
- mysql_close() - Closes a MySQL connection resource. Usually, you call it with 1 parameter
like mysql_close($connection), where $connection represents the connection resource to be closed.
- mysql_get_server_info() - Returns a string of server information.
- mysql_status() - Returns a string of server status.
- mysql_query() - Sends a query to the server, and returns a result set resource.
For example, mysql_query('SELECT * FROM MyTable WHERE ID = 10').
- mysql_affected_rows() - Returns the number of effected rows of the given result set,
if the executed query is an INSERT or UPDATE statement.
- mysql_num_rows() - Returns the number of rows of the given result set, if the
executed query is a SELECT statement.
- mysql_fetch_array() - Fetches a row from a given result set, and returns the row
as an array with both numeric index, and column name map. It will return boolean false,
if there is no row left in the result set.
- mysql_free_result() - Frees the given result set.
Last update: 2015.
Table of Contents
About This Book
Introduction and Installation of PHP 7.3
PHP Script File Syntax
PHP Data Types and Data Literals
Variables, References, and Constants
Expressions, Operations and Type Conversions
Conditional Statements - "if" and "switch"
Loop Statements - "while", "for", and "do ... while"
Function Declaration, Arguments, and Return Values
Arrays - Ordered Maps
Introduction of Class and Object
Integrating PHP with Apache Web Server
Retrieving Information from HTTP Requests
Creating and Managing Sessions in PHP Scripts
Sending and Receiving Cookies in PHP Scripts
Controlling HTTP Response Header Lines in PHP Scripts
MySQL Server Connection and Access Functions
Functions to Manage Directories, Files and Images
SOAP Extension Function and Calling Web Services
SOAP Server Functions and Examples
Localization Overview of Web Applications
Using Non-ASCII Characters in HTML Documents
Using Non-ASCII Characters as PHP Script String Literals
Receiving Non-ASCII Characters from Input Forms
"mbstring" Extension and Non-ASCII Encoding Management
Managing Non-ASCII Character Strings with MySQL Servers
Configuring and Sending out Emails
Outdated: Downloading and Installing PHP 7.0 for Windows
Outdated: Downloading and Installing PHP 5.6.6 for Windows
Outdated: Downloading and Installing PHP 5.4.3 for Windows
Outdated: Downloading and Installing PHP 5.2.2 for Windows
Outdated: Downloading and Installing PHP 5.0.4 for Windows
Outdated: Adding PHP to IIS as CGI
Outdated: Downloading Apache HTTP Server 2.4.12 for Windows
Outdated: Installing Apache HTTP Server 2.4.12 on Windows
Outdated: Publishing PHP Scripts as Web Pages
Outdated: Configuration for php_mysql.dll Library
►Outdated: mysql_connect() using php_mysql.dll Library
Outdated: MySqlLoop.php using php_mysql.dll Library
Outdated: Get_Temperature.php - First Example of SOAP
Outdated: Get_Temperature_Dump.php - Dumping Debugging Information
Outdated: MySqlUnicode.php using php_mysql.dll Library
Full Version in PDF/EPUB