mysql Á¬½Óorcal Êý¾Ý¿â OCIDefineByName
Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
內ÈÝ說Ã÷
±¾º¯Ê½ÓÃ來¶¨義Ö¸¶¨µÄ PHP 變數£¬Ê¹ÆäÄܹ© SQL Ö¸ÁîÖÐµÄ SELECT Ö¸ÁîʹÓá£ÔÚ´óС寫µÄ問題ÉÏҪעÒâһϣ¬Òò為 Oracle 資ÁÏ庫ÖеÄ欄λÃû稱Æä實¶¼ÊÇ´ó寫µÄÃû×Ö¡£參數 stmt ÊÇ經過 Oracle ½âÎö (OCIParse) ááµÄ×Ö´®Ö¸標¡£參數 ColumnName ÊÇ Oracle 資ÁϱíÉϵÄ欄λÃû稱¡£參數 variable Ç°ÃæÒ»¶¨Òª¼Ó & ·û號£¬±í PHP 變數λַ¡£參數 type ͨ³£Ê¡ÂÔ¡£ÖµµÃ×¢ÒâµÄÊÇÓûʹÓà Oracle 8 ÖÐÌØÓеÄÐÂ資ÁÏÐÍ態 LOB/ROWID/BFILE µÈ時£¬ÐèÒªÏÈ執ÐÐ OCINewDescriptor() º¯Ê½¡£執Ðб¾º¯Ê½³É¹¦則傳»Ø true Öµ¡£
ʹÓÃ範Àý
這個範ÀýÊÇ thies@digicol.de ËùÌá³öµÄ
<?php
$conn = OCILogon("scott","tiger");
$stmt = OCIParse($conn,"select empno, ename from emp");
/* ʹÓà OCIDefineByName ÒªÔÚ執ÐÐ OCIExecute ǰ */
OCIDefineByName($stmt,"EMPNO",&$empno);
OCIDefineByName($stmt,"ENAME",&$ename);
OCIExecute($stmt);
while (OCIFetch($stmt)) {
echo "empno:".$empno."\n";
echo "ename:".$ename."\n";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
Ïà¹ØÎĵµ£º
Each MySQL Cluster host computer running an SQL node must have
installed on it a MySQL binary. For management nodes and data
nodes, it is not necessary to install the MySQL server binary, but
management nodes require the management server daemon
......
For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.
Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.
mysql>show variables like’max_allowed_packet’;
......
1,ÔÚwindow×Ô´øµÄ·À»ðǽÀïµÄÀýÍâÌí¼Ó3306¶Ë¿Ú£¬ÎªTCP
2£¬½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ ......