php_ref_mysql.asp

W3Schools tutorial..web designing

  <tr>
    <td valign="top"><a href="func_mysql_num_fields.asp">mysql_num_fields()</a></td>
    <td valign="top">Returns the number of fields in a recordset</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_num_rows.asp">mysql_num_rows()</a></td>
    <td valign="top">Returns the number of rows in a recordset</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_pconnect.asp">mysql_pconnect()</a></td>
    <td valign="top">Opens a persistent MySQL connection</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_ping.asp">mysql_ping()</a></td>
    <td valign="top">Pings a server connection or reconnects if there is no 
	connection</td>
    <td valign="top">4</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_query.asp">mysql_query()</a></td>
    <td valign="top">Executes a query on a MySQL database</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_real_escape_string.asp">
	mysql_real_escape_string()</a></td>
    <td valign="top">Escapes a string for use in SQL 
	statements</td>
    <td valign="top">4</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_result.asp">mysql_result()</a></td>
    <td valign="top">Returns the value of a field in a recordset</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_select_db.asp">mysql_select_db()</a></td>
    <td valign="top">Sets the active MySQL database</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_stat.asp">mysql_stat()</a></td>
    <td valign="top">Returns the current system status of the MySQL server</td>
    <td valign="top">4</td>
  </tr>
  <tr>
    <td valign="top">mysql_tablename()</td>
    <td valign="top"><span class="red">Deprecated.</span> Returns the table name of field. Use 
	mysql_query() instead</td>
    <td valign="top">3</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_thread_id.asp">mysql_thread_id()</a></td>
    <td valign="top">Returns the current thread ID</td>
    <td valign="top">4</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mysql_unbuffered_query.asp">
	mysql_unbuffered_query()</a></td>
    <td valign="top">Executes a query on a MySQL database (without fetching / buffering 
	the result)</td>
    <td valign="top">4</td>
  </tr>
  </table>
<br />
<hr />

<h2>PHP MySQL Constants</h2>
<p>Since PHP 4.3 it has been possible to specify additional flags for the mysql_connect() and mysql_pconnect() functions:</p>
<p><b>PHP</b>: indicates the earliest version of PHP that supports the 
  constant.</p>
<table class="ex" cellspacing="0" border="1" width="100%" id="table7">
  <tr>
    <th width="45%" align="left">Constant</th>
    <th width="50%" align="left">Description</th>
    <th width="5%" align="left">PHP</th>
  </tr>
  <tr>
    <td valign="top">MYSQL_CLIENT_COMPRESS</td>
    <td valign="top">Use compression protocol</td>
    <td valign="top">4.3</td>
  </tr>
  <tr>
    <td valign="top" height="25">MYSQL_CLIENT_IGNORE_SPACE</td>
    <td valign="top" height="25">Allow space after function names</td>
    <td valign="top" height="25">4.3</td>
  </tr>
	<tr>
    <td valign="top">MYSQL_CLIENT_INTERACTIVE</td>
    <td valign="top">Allow interactive timeout seconds  
	of inactivity before closing the connection</td>
    <td valign="top">4.3</td>
  </tr>
  <tr>
    <td valign="top">MYSQL_CLIENT_SSL</td>
    <td valign="top">Use SSL encryption (only available with 
	version 4+ of the MySQL client library)</td>
    <td valign="top">4.3</td>
  </tr>
  </table>
<p>The mysql_fetch_array() function uses a constant for the different types of 
result arrays. The following constants are defined:</p>
<table class="ex" cellspacing="0" border="1" width="100%" id="table8">
  <tr>
    <th width="25%" align="left">Constant</th>
    <th width="70%" align="left">Description</th>
    <th width="5%" align="left">PHP</th>
  </tr>
  <tr>
    <td valign="top">MYSQL_ASSOC</td>
    <td valign="top">Columns are returned into the array with the fieldname as 
	the array index</td>
    <td valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td valign="top">MYSQL_BOTH</td>
    <td valign="top">Columns are returned into the array having both a numerical 
	index and the fieldname as the array index</td>
    <td valign="top">&nbsp;</td>
  </tr>
	<tr>
    <td valign="top">MYSQL_NUM</td>
    <td valign="top">Columns are returned into the array having a numerical 
	index (index starts at 0)</td>
    <td valign="top">&nbsp;</td>
  </tr>
  </table>
<br />
<hr />

<a href="php_ref_misc.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" width="100" height="20" /></a>
<a href="php_ref_simplexml.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->

<h2>Learn XML with &lt;oXygen/> XML Editor - Free Trial!</h2>
<table cellpadding="0"><tr>
<td valign="top"><a target="_blank" href="../../www.oxygenxml.com/default.htm">
<img src="../images/oxygenxml.png" border="0" alt="oXygen - Probably The World's Best XML Editor" /></a></td>
<td>&nbsp;&nbsp;</td>
<td valign="top">
<p><a href="../../www.oxygenxml.com/default.htm" target="_blank">oXygen</a> helps you learn to define,
edit, validate and transform XML documents. Supported technologies include XML Schema,
DTD, Relax NG, XSLT, XPath, XQuery, CSS.</p>
<p>Understand in no time how XSLT and XQuery work by using the intuitive oXygen debugger!</p>
<p>Do you have any XML related questions? Get free answers from the oXygen
<a href="../../www.oxygenxml.com/forum/default.htm" target="_blank">XML forum</a>
and from the <a href="../../www.oxygenxml.com/documentation.html" target="_blank">video</a>
demonstrations.</p>
<p><b><a href="../../www.oxygenxml.com/download.html" target="_blank">
Download a FREE 30-day trial today!</a></b></p>
</td></tr></table>
<hr />


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

</center>
<hr />


<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='php_ref_mysql.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=php" height="1500" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>