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);
?>
Ïà¹ØÎĵµ£º
MySQL·þÎñÆ÷²ÉÓÃÁËÄ£¿é»¯·ç¸ñ£¬¸÷²¿·ÖÖ®¼ä±£³ÖÏà¶Ô¶ÀÁ¢£¬ÓÈÆäÌåÏÖÔÚ´æ´¢¼Ü¹¹ÉÏ¡£´æ´¢ÒýÇæ¸ºÔð
¹ÜÀíÊý¾Ý´æ´¢£¬ÒÔ¼°MySQLµÄË÷Òý¹ÜÀí¡£Í¨¹ý¶¨ÒåµÄAPI£¬MySQL·þÎñÆ÷Äܹ»Óë´æ´¢ÒýÇæ½øÐÐͨÐÅ¡£Ä¿Ç°Ê¹ÓÃ×î¶àµÄÊÇMyISAMºÍInnoDB¡£
InnoDB±»OracleÊÕ¹ººó£¬MySQL×ÔÐпª·¢µÄд洢ÒýÇæFalcon½«ÔÚMySQL6.0°æ±¾Òý½ø¡£
MyISAMÒýÇæÊÇÒ ......
ÒÔÏÂÄÚÈÝÔÚubuntu 9.04 serverϵͳÉϲâÊÔͨ¹ý
ÓÃapt-get install vsftp°²×°µÄʱºòÏà¹ØµÄÎļþλÖãº
Ö÷ÅäÖÃÎļþ£º/etc/vsftpd.conf
ÑéÖ¤ÅäÖÃÎļþ/etc/pam.d/vsftpd
ÖØÆô£º/etc/init.d/vsftpd restart
vsftp MysqlÑéÖ¤·½Ê½£º
MYSQLÒѾ°²×°ÔÚ/usr/local/mysql
Ö±½Ó°²×°vsftp
sudo apt-get install vsftp
°²×°pam_mys ......
GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......
-static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
Unix Socket 7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
ʹÓÃunixÌ×½Ó×ÖÁ´½ÓÌá¸ß7.5%ÐÔÄÜ£¬ËùÒÔÔÚwindowsÏÂmysqlÐÔÄܿ϶¨²»ÈçunixÏÂÃæ
--enab ......
¼ÇµÃǰÌìÓÐÈËÎÊÎÒ£¬ Memcache ºÍ MySQL ×Ô¼ºµÄ Query Cache ÓÐÉ¶Çø±ð? ÎÒÕâÑù»Ø´ðµÄ£¬Ç°ÕßÊÇɽկÖеÄÕ½¶·»ú£¬ºóÕßÊǹٷ½µÄÕ½¶·»ú¡£
ÐÂÊֻشðÎÊÌ⣬´íÁËι֡£¹þ¹þ¹þ¡£
ºÃÏñϸ½ÚÉϵIJî±ð»¹ÊÇÓеġ£
MemcacheÓŵãÈçÏ£º
1. ÀíÂÛÉÏ¿ÉÒÔÖ§³ÅÎÞÏÞ²¢·¢ÒµÎñ²Ù×÷¡£
2. ¿ÉÒÔÆôÓõ¥¶ÀµÄʵÀýÀ´»º´æ¾Þ¶àµÄÊý¾Ý¡££¨µ± ......