📄 php_ref_mysql.asp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>PHP MySQL Functions</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<link rel="stylesheet" type="text/css" href="../stdtheme.css" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txtimg*/
google_ad_slot = "5330033957";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript" src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<noscript>
<a href="../default.asp" target="_blank"><img src="../banners/w6.gif" border="0" alt="W3Schools" /></a>
</noscript>
<br /></th>
</tr>
</table>
<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>PHP Basic</b><br />
<a class="left" target="_top" href="default.asp" >PHP HOME</a><br />
<a class="left" target="_top" href="php_intro.asp" >PHP Intro</a><br />
<a class="left" target="_top" href="php_install.asp" >PHP Install</a><br />
<a class="left" target="_top" href="php_syntax.asp" >PHP Syntax</a><br />
<a class="left" target="_top" href="php_variables.asp" >PHP Variables</a><br />
<a class="left" target="_top" href="php_string.asp" >PHP String</a><br />
<a class="left" target="_top" href="php_operators.asp" >PHP Operators</a><br />
<a class="left" target="_top" href="php_if_else.asp" >PHP If...Else</a><br />
<a class="left" target="_top" href="php_switch.asp" >PHP Switch</a><br />
<a class="left" target="_top" href="php_arrays.asp" >PHP Arrays</a><br />
<a class="left" target="_top" href="php_looping.asp" >PHP Looping</a><br />
<a class="left" target="_top" href="php_functions.asp" >PHP Functions</a><br />
<a class="left" target="_top" href="php_forms.asp" >PHP Forms</a><br />
<a class="left" target="_top" href="php_get.asp" >PHP $_GET</a><br />
<a class="left" target="_top" href="php_post.asp" >PHP $_POST</a><br />
<br />
<b>PHP Advanced</b><br />
<a class="left" target="_top" href="php_date.asp" >PHP Date</a><br />
<a class="left" target="_top" href="php_includes.asp" >PHP Include</a><br />
<a class="left" target="_top" href="php_file.asp" >PHP File</a><br />
<a class="left" target="_top" href="php_file_upload.asp" >PHP File Upload</a><br />
<a class="left" target="_top" href="php_cookies.asp" >PHP Cookies</a><br />
<a class="left" target="_top" href="php_sessions.asp" >PHP Sessions</a><br />
<a class="left" target="_top" href="php_mail.asp" >PHP E-mail</a><br />
<a class="left" target="_top" href="php_secure_mail.asp" >PHP Secure E-mail</a><br />
<a class="left" target="_top" href="php_error.asp" >PHP Error</a><br />
<a class="left" target="_top" href="php_exception.asp" >PHP Exception</a><br />
<a class="left" target="_top" href="php_filter.asp" >PHP Filter</a><br />
<br />
<b>PHP Database</b><br />
<a class="left" target="_top" href="php_mysql_intro.asp" >MySQL Introduction</a><br />
<a class="left" target="_top" href="php_mysql_connect.asp" >MySQL Connect</a><br />
<a class="left" target="_top" href="php_mysql_create.asp" >MySQL Create</a><br />
<a class="left" target="_top" href="php_mysql_insert.asp" >MySQL Insert</a><br />
<a class="left" target="_top" href="php_mysql_select.asp" >MySQL Select</a><br />
<a class="left" target="_top" href="php_mysql_where.asp" >MySQL Where</a><br />
<a class="left" target="_top" href="php_mysql_order_by.asp" >MySQL Order By</a><br />
<a class="left" target="_top" href="php_mysql_update.asp" >MySQL Update</a><br />
<a class="left" target="_top" href="php_mysql_delete.asp" >MySQL Delete</a><br />
<a class="left" target="_top" href="php_db_odbc.asp" >PHP ODBC</a><br />
<br />
<b>PHP XML</b><br />
<a class="left" target="_top" href="php_xml_parser_expat.asp" >XML Expat Parser</a><br />
<a class="left" target="_top" href="php_xml_dom.asp" >XML DOM</a><br />
<a class="left" target="_top" href="php_xml_simplexml.asp" >XML SimpleXML</a><br />
<br />
<b>PHP and AJAX</b><br />
<a class="left" target="_top" href="php_ajax_intro.asp" >AJAX Introduction</a><br />
<a class="left" target="_top" href="php_ajax_xmlhttprequest.asp" >XMLHttpRequest</a><br />
<a class="left" target="_top" href="php_ajax_suggest.asp" >AJAX Suggest</a><br />
<a class="left" target="_top" href="php_ajax_xml.asp" >AJAX XML</a><br />
<a class="left" target="_top" href="php_ajax_database.asp" >AJAX Database</a><br />
<a class="left" target="_top" href="php_ajax_responsexml.asp" >AJAX responseXML</a><br />
<a class="left" target="_top" href="php_ajax_livesearch.asp" >AJAX Live Search</a><br />
<a class="left" target="_top" href="php_ajax_rss_reader.asp" >AJAX RSS Reader</a><br />
<a class="left" target="_top" href="php_ajax_poll.asp" >AJAX Poll</a><br />
<br />
<b>PHP Reference</b><br />
<a class="left" target="_top" href="php_ref_array.asp" >PHP Array</a><br />
<a class="left" target="_top" href="php_ref_calendar.asp" >PHP Calendar</a><br />
<a class="left" target="_top" href="php_ref_date.asp" >PHP Date</a><br />
<a class="left" target="_top" href="php_ref_directory.asp" >PHP Directory</a><br />
<a class="left" target="_top" href="php_ref_error.asp" >PHP Error</a><br />
<a class="left" target="_top" href="php_ref_filesystem.asp" >PHP Filesystem</a><br />
<a class="left" target="_top" href="php_ref_filter.asp" >PHP Filter</a><br />
<a class="left" target="_top" href="php_ref_ftp.asp" >PHP FTP</a><br />
<a class="left" target="_top" href="php_ref_http.asp" >PHP HTTP</a><br />
<a class="left" target="_top" href="php_ref_libxml.asp" >PHP Libxml</a><br />
<a class="left" target="_top" href="php_ref_mail.asp" >PHP Mail</a><br />
<a class="left" target="_top" href="php_ref_math.asp" >PHP Math</a><br />
<a class="left" target="_top" href="php_ref_misc.asp" >PHP Misc</a><br />
<a class="left" target="_top" href="php_ref_mysql.asp" style='font-weight:bold;'>PHP MySQL</a><br />
<a class="left" target="_top" href="php_ref_simplexml.asp" >PHP SimpleXML</a><br />
<a class="left" target="_top" href="php_ref_string.asp" >PHP String</a><br />
<a class="left" target="_top" href="php_ref_xml.asp" >PHP XML</a><br />
<a class="left" target="_top" href="php_ref_zip.asp" >PHP Zip</a><br />
<br />
<b>PHP Quiz</b><br />
<a class="left" target="_top" href="php_quiz.asp" >PHP Quiz</a><br />
<!--<b>PHP XML</b><br />
<a class="left" target="_top" href="php_xml_parser.asp" >PHP Expat</a><br />
<a class="left" target="_top" href="php_xml.asp" >PHP XML</a><br />
<br />
<b>PHP Software</b><br />
<a class="left" target="_top" href="php_zend.asp" >Zend Studio</a><br />
--><br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>
<h1>PHP MySQL Functions</h1>
<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>
<hr />
<h2>PHP MySQL Introduction</h2>
<p>The MySQL functions allows you to access MySQL database servers.</p>
<hr />
<h2>Installation</h2>
<p>For the MySQL functions to be available, you must compile PHP with MySQL
support.</p>
<p>For compiling, use <i>--with-mysql=DIR </i>(the optional DIR points to the MySQL directory).</p>
<p><b>Note:</b> For full functionality of MySQL
versions greater than 4.1., use the MySQLi extension instead. If you would like to install
both the mysql extension and the mysqli extension you should use the same client
library to avoid any conflicts.</p>
<p><b>Installation on Linux Systems</b></p>
<p><b>PHP 5+:</b> MySQL and the MySQL library is not enabled by default. Use the
<i>--with-mysql=DIR</i> configure option to include MySQL
support and download headers and libraries from
<a target="_blank" href="../../www.mysql.com/default.htm">www.mysql.com</a>.</p>
<p><b>Installation on Windows Systems</b></p>
<p><b>PHP 5+:</b> MySQL is not enabled by default, so the php_mysql.dll must be enabled inside of php.ini. Also, PHP needs access to the MySQL
client library. A file named libmysql.dll is included in the Windows PHP
distribution, and in order for PHP to talk to MySQL this file needs to be
available to the Windows systems PATH.</p>
<p>To enable any PHP extension, the PHP extension_dir setting (in the php.ini
file) should be set to the directory where the PHP extensions are
located. An example extension_dir value is c:\php\ext.</p>
<p><b>Note:</b> If you get the following error when starting the web server: "Unable to load dynamic library './php_mysql.dll'", this is because
php_mysql.dll or libmysql.dll cannot be found by the system.</p>
<hr />
<h2>Runtime Configuration</h2>
<p>The behavior of the MySQL functions is affected by settings in the php.ini
file.</p>
<p>MySQL configuration options:</p>
<table class="ex" cellspacing="0" border="1" width="100%" id="table9">
<tr>
<th width="20%" align="left" valign="top">Name</th>
<th width="15%" align="left" valign="top">Default</th>
<th width="42%" align="left" valign="top">Description</th>
<th width="23%" align="left" valign="top">Changeable</th>
</tr>
<tr>
<td valign="top">mysql.allow_persistent</td>
<td valign="top">"1"</td>
<td valign="top">Whether or not to allow persistent connections</td>
<td valign="top">PHP_INI_SYSTEM</td>
</tr>
<tr>
<td valign="top">mysql.max_persistent</td>
<td valign="top">"-1"</td>
<td valign="top">The maximum number of persistent connections per
process</td>
<td valign="top">PHP_INI_SYSTEM</td>
</tr>
<tr>
<td valign="top">mysql.max_links</td>
<td valign="top">"-1"</td>
<td valign="top">The maximum number of connections per process
(persistent connections included)</td>
<td valign="top">PHP_INI_SYSTEM</td>
</tr>
<tr>
<td valign="top">mysql.trace_mode</td>
<td valign="top">"0"</td>
<td valign="top">Trace mode. When set to "1", warnings and SQL-errors will be displayed.
Available since PHP 4.3</td>
<td valign="top">PHP_INI_ALL</td>
</tr>
<tr>
<td valign="top">mysql.default_port</td>
<td valign="top">NULL</td>
<td valign="top">The default TCP port number to use</td>
<td valign="top">PHP_INI_ALL</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -