⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 php_db_odbc.asp

📁 W3Schools tutorial..web designing
💻 ASP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<!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 Database ODBC</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">
<iframe style="background-color:#808080" src="../banners/bannerframe.asp@adpartner=xmlmaster" height="90" width="728"
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>

<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" style='font-weight:bold;'>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" >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 Database ODBC</h1>
<a href="php_mysql_delete.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" width="100" height="20" /></a>
<a href="php_xml_parser_expat.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>
<hr />
<p class="intro">ODBC is an Application Programming Interface 
(API) that allows you to connect to a data source (e.g. an MS 
Access database).</p>
<hr />
<h2>Create an ODBC Connection</h2>

<p>With an ODBC connection, you can connect to any database, on any computer in 
your network, as long as an ODBC connection is available.</p>
<p>Here is how to create an ODBC connection to a MS Access Database:&nbsp;</p>
<ol>
  <li>Open the <b>Administrative Tools</b> icon in your Control Panel.</li>
  <li>Double-click on the <b>Data Sources (ODBC)</b> icon inside. </li>
  <li>Choose the <b>System DSN</b> tab. </li>
  <li>Click on <b>Add </b>in the System DSN tab. </li>
  <li>Select the <b>Microsoft Access Driver</b>. Click <b>Finish.</b> </li>
  <li>In the next screen, click <b>Select</b> to locate the database. </li>
  <li>Give the database a <b>Data Source Name (DSN)</b>. </li>
  <li>Click <b>OK</b>.</li>
</ol>
<p>Note that this configuration has to be done on the computer where your web 
site is located. If you are running Internet 
Information Server (IIS) on your own computer, the instructions above will work, 
but if your web site is located on a remote server, you have to have physical 
access to that server, or ask your web host to to set up a DSN for 
you to use.</p>
<hr />

<h2>Connecting to an ODBC</h2>
<p>The odbc_connect() function is used to connect to an ODBC data source. The function takes 
four parameters: the data source name, username, 
password, and an optional cursor type.</p>
<p>The odbc_exec() function is used to execute an SQL statement.</p>
<h3>Example</h3>
<p>The following example creates a connection to a DSN 
called northwind, with no username and no password. It then creates an SQL and 
executes it:</p>
<table width="100%" border="1" class="ex" cellspacing="0">
<tr><td>
<pre>$conn=odbc_connect('northwind','','');
$sql=&quot;SELECT * FROM customers&quot;; 
$rs=odbc_exec($conn,$sql);</pre>
</td></tr></table>
<br />
<hr />

<h2>Retrieving Records</h2>
<p>The odbc_fetch_row() function is used to return records from the result-set. This function returns true if it is able to return rows, otherwise 
false.</p>
<p>The function takes two parameters: the ODBC result identifier and an optional 
row number:</p>
<table width="100%" border="1" class="ex" cellspacing="0">
<tr><td>
<pre>odbc_fetch_row($rs)</pre>
</td></tr></table>
<br />
<hr />

<h2>Retrieving Fields from a Record</h2>
<p>The odbc_result() function is used to read fields from a record. This function
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -