Oracle is the world's most popular relational database. It is a powerful engine of industrialization promoted by large companies. Let’s take a look at its related functions first:
(1) integer ora_logon (string user, string password)
Start a connection to an Oracle database server.
(2)integer ora_open(integer connection)
Open the cursor of the given connection.
(3)integer ora_do(integer connection, string query)
Execute the query on the given connection. PHP generates an indicator, parses the query, and executes it.
(4)integer ora_parse(integer cursor, string query)
Parse a query and prepare it for execution.
(5) boolean ora_exec(integer cursor)
Execute a query previously parsed by the ora_parse function.
(6) boolean ora_fetch(integer cursor)
This function will cause the rows in an executed query to be fetched into the indicator. This allows you to call the ora_getcolumn function.
(7) string ora_getcolumn(integer cursor, integer column)
Return the current value. Column zero-based numeric index.
(8) boolean ora_logoff(integer connection)
Disconnect the link to the database server.
The following is a sample program to insert data into the ORACLE database:
Insert data into the ORACLE database</ title></head><br><br><body><br><br><form action="<?echo $PHP_SELF;?>" method="post"><br> <br><table border="1" cellspacing="0" cellpadding="0"><br><br><tr><br><br><th>ID</th><br><br><th>name</th><br><br><th>Description</th><br><br></tr><br><br><tr><br><br><td><input type="text" name="name" maxlength="50" size="10"></td><br><br><td>< ;input type="text" name="email" maxlength="255" size="30"></td><br><br><td><input type="text" name=" Description" maxlength="255" size="50"></td><br><br></tr><br><br><tr align="center"><br><br><td colspan="3"><input type="submit" value="Submit"> <input type="reset" value="Rewrite"></td><br><br></tr><br><br></table><br><br></form><br><br><?<br><br>//Set first Two environment variables ORACLE_HOME, ORACLE_SID<br><br>putenv("ORACLE_HOME=/oracle/app/oracle/product/8.0.4");<br><br>putenv("ORACLE_SID=ora8");<br><br>//Set the web page to display Chinese<br><br>putenv("NLS_LANG=Simplified_Chinese.zhs16cgb231280");<br><br>if($connection=ora_logon("scott","tiger")) { <br><br>//Library table test has three items: ID, name, and Description <br><br>$sql = 'insert into test(ID, name, Description) values '; <br><br>$sql .= '('' . $ID . '','' . $name . '',''. $Description . '')';<br><br>if($cursor=ora_do($connect,$ sql)) {<br><br>print("insert finished!");<br><br>}<br><br>$query = 'select * from test';<br><br>if( $cursor=ora_do($connect,$query)) {<br><br>ora_fetch($cursor);<br><br>$content0=ora_getcolumn($cursor,0);<br><br>$content1 =ora_getcolumn($cursor,1);<br><br>$content2=ora_getcolumn($cursor,2);<br><br>print("$content0");<br><br>print("$ content1");<br><br>print("$content2");<br><br>ora_close($cursor);<br><br>}<br><br>ora_logoff($connection);<br><br>}<br><br>?><br><br></body><br><br></html><br><br>
</p>
<p align="left"></p>
<div style="display:none;">
<span id="url" itemprop="url">http://www.bkjia.com/PHPjc/315531.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http: //www.bkjia.com/PHPjc/315531.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">Oracle (Oracle) is the most popular relational database in the world. It is a powerful engine of industrialization promoted by large companies. Let’s take a look at its related functions first: (1) integer ora_lo...</span>
</div>
<div class="art_confoot"></div></div><div class="nphpQianMsg"><div class="clear"></div></div><div class="nphpQianSheng"><span>Statement：</span><div>The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn</div></div></div><div class="nphpSytBox"><span>Previous article：<a class="dBlack" title="Community (php&&mysql) three_PHP tutorial" href="https://m.php.cn/faq/312052.html">Community (php&&mysql) three_PHP tutorial</a></span><span>Next article：<a class="dBlack" title="Community (php&&mysql) three_PHP tutorial" href="https://m.php.cn/faq/312054.html">Community (php&&mysql) three_PHP tutorial</a></span></div><div class="nphpSytBox2"><div class="nphpZbktTitle"><h2>Related articles</h2><em><a href="https://m.php.cn/article.html" class="bBlack"><i>See more</i><b></b></a></em><div class="clear"></div></div><ins class="adsbygoogle"
style="display:block"
data-ad-format="fluid"
data-ad-layout-key="-6t+ed+2i-1n-4w"
data-ad-client="ca-pub-5902227090019525"
data-ad-slot="8966999616"></ins><script> (adsbygoogle = window.adsbygoogle || []).push({});
</script><ul class="nphpXgwzList"><li><b></b><a href="https://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="https://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="https://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="https://m.php.cn/faq/1.html" title="How to use cURL to implement Get and Post requests in PHP" class="aBlack">How to use cURL to implement Get and Post requests in PHP</a><div class="clear"></div></li><li><b></b><a href="https://m.php.cn/faq/2.html" title="All expression symbols in regular expressions (summary)" class="aBlack">All expression symbols in regular expressions (summary)</a><div class="clear"></div></li></ul></div></div><ins class="adsbygoogle"
style="display:block"
data-ad-format="autorelaxed"
data-ad-client="ca-pub-5902227090019525"
data-ad-slot="5027754603"></ins><script> (adsbygoogle = window.adsbygoogle || []).push({});
</script><footer><div class="footer"><div class="footertop"><img src="/static/imghwm/logo.png" alt=""><p>Public welfare online PHP training，Help PHP learners grow quickly！</p></div><div class="footermid"><a href="https://m.php.cn/about/us.html">About us</a><a href="https://m.php.cn/about/disclaimer.html">Disclaimer</a><a href="https://m.php.cn/update/article_0_1.html">Sitemap</a></div><div class="footerbottom"><p> © php.cn All rights reserved
</p></div></div></footer><script>isLogin = 0;</script><script type="text/javascript" src="/static/layui/layui.js"></script><script type="text/javascript" src="/static/js/global.js?4.9.47"></script></div><script src="https://vdse.bdstatic.com//search-video.v1.min.js"></script><link rel='stylesheet' id='_main-css' href='/static/css/viewer.min.css' type='text/css' media='all'/><script type='text/javascript' src='/static/js/viewer.min.js?1'></script><script type='text/javascript' src='/static/js/jquery-viewer.min.js'></script><script>jQuery.fn.wait = function (func, times, interval) {
var _times = times || -1, //100次
_interval = interval || 20, //20毫秒每次
_self = this,
_selector = this.selector, //选择器
_iIntervalID; //定时器id
if( this.length ){ //如果已经获取到了，就直接执行函数
func && func.call(this);
} else {
_iIntervalID = setInterval(function() {
if(!_times) { //是0就退出
clearInterval(_iIntervalID);
}
_times <= 0 || _times--; //如果是正数就 --
_self = $(_selector); //再次选择
if( _self.length ) { //判断是否取到
func && func.call(_self);
clearInterval(_iIntervalID);
}
}, _interval);
}
return this;
}
$("table.syntaxhighlighter").wait(function() {
$('table.syntaxhighlighter').append("<p class='cnblogs_code_footer'><span class='cnblogs_code_footer_icon'></span></p>");
});
$(document).on("click", ".cnblogs_code_footer",function(){
$(this).parents('table.syntaxhighlighter').css('display','inline-table');$(this).hide();
});
$('.nphpQianCont').viewer({navbar:true,title:false,toolbar:false,movable:false,viewed:function(){$('img').click(function(){$('.viewer-close').trigger('click');});}});
</script></body><!-- Matomo --><script> var _paq = window._paq = window._paq || [];
/* tracker methods like "setCustomDimension" should be called before "trackPageView" */
_paq.push(['trackPageView']);
_paq.push(['enableLinkTracking']);
(function() {
var u="https://tongji.php.cn/";
_paq.push(['setTrackerUrl', u+'matomo.php']);
_paq.push(['setSiteId', '9']);
var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s);
})();
</script><!-- End Matomo Code --></html>
