<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Predefined Constants</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="changelog.mysql.html">Changelog</a></div>
<div class="next" style="text-align: right; float: right;"><a href="mysql.examples.html">Examples</a></div>
<div class="up"><a href="book.mysql.html">Mysql</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="mysql.constants" class="appendix">
<h1>Predefined Constants</h1>
<p class="simpara">
The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.
</p>
<p class="para">
Since PHP 4.3.0 it is possible to specify additional client flags for the
<span class="function"><a href="function.mysql-connect.html" class="function">mysql_connect()</a></span> and <span class="function"><a href="function.mysql-pconnect.html" class="function">mysql_pconnect()</a></span>
functions. The following constants are defined:
<table id="mysql.client-flags" class="doctable table">
<caption><strong>MySQL client constants</strong></caption>
<thead>
<tr>
<th>Constant</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr id="constant.mysql-client-compress">
<td><strong><code>MYSQL_CLIENT_COMPRESS</code></strong></td>
<td>Use compression protocol</td>
</tr>
<tr id="constant.mysql-client-ignore-space">
<td><strong><code>MYSQL_CLIENT_IGNORE_SPACE</code></strong></td>
<td>Allow space after function names</td>
</tr>
<tr id="constant.mysql-client-interactive">
<td><strong><code>MYSQL_CLIENT_INTERACTIVE</code></strong></td>
<td>Allow interactive_timeout seconds (instead of <strong class="option unknown">wait_timeout</strong>
) of
inactivity before closing the connection.</td>
</tr>
<tr id="constant.mysql-client-ssl">
<td><strong><code>MYSQL_CLIENT_SSL</code></strong></td>
<td>Use SSL encryption. This flag is only available with version 4.x
of the MySQL client library or newer. Version 3.23.x is bundled both
with PHP 4 and Windows binaries of PHP 5.
</td>
</tr>
</tbody>
</table>
</p>
<p class="para">
The function <span class="function"><a href="function.mysql-fetch-array.html" class="function">mysql_fetch_array()</a></span> uses a constant for
the different types of result arrays. The following constants are
defined:
<table class="doctable table">
<caption><strong>MySQL fetch constants</strong></caption>
<thead>
<tr>
<th>Constant</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr id="constant.mysql-assoc">
<td><strong><code>MYSQL_ASSOC</code></strong></td>
<td>
Columns are returned into the array having the fieldname as the array
index.
</td>
</tr>
<tr id="constant.mysql-both">
<td><strong><code>MYSQL_BOTH</code></strong></td>
<td>
Columns are returned into the array having both a numerical index
and the fieldname as the array index.
</td>
</tr>
<tr id="constant.mysql-num">
<td><strong><code>MYSQL_NUM</code></strong></td>
<td>
Columns are returned into the array having a numerical index to the
fields. This index starts with 0, the first field in the result.
</td>
</tr>
</tbody>
</table>
</p>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="changelog.mysql.html">Changelog</a></div>
<div class="next" style="text-align: right; float: right;"><a href="mysql.examples.html">Examples</a></div>
<div class="up"><a href="book.mysql.html">Mysql</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
