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.
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
Interface with Operating System
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
Managing File Upload
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
Parsing and Managing HTML Documents
Configuring and Sending out Emails
Image and Picture Processing
Managing ZIP Archive Files
Managing PHP Engine and Modules on macOS
Managing PHP Engine and Modules on CentOS
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