php Á´½Óoracle phpµ÷ÓÃoracle´æ´¢¹ý³Ì
phpµ÷ÓÃoracleÐд洢¹ý³Ì############################################################
PHP³ÌÐò·ÃÎÊÊý¾Ý¿â£¬ÍêÈ«¿ÉÒÔʹÓô洢¹ý³Ì£¬ÓÐÈËÈÏΪʹÓô洢¹ý³Ì±ãÓÚά»¤
²»¹ýÈÊÕß¼ûÈÊ£¬ÖÇÕß¼ûÖÇ¡£
ÔÚÕâ¸öÎÊÌâÉÏ£¬Å¼ÈÏΪʹÓô洢¹ý³ÌÒâζ×űØÐëÒªDBAºÍ¿ª·¢ÈËÔ±¸ü½ôÃÜÅäºÏ,Èç¹ûÆäÖÐÒ»·½¸ü±ä£¬ÔòÏÔÈ»ÄÑÒÔά»¤¡£
µ«ÊÇʹÓô洢¹ý³ÌÖÁÉÙÓÐÁ½¸ö×îÃ÷ÏÔµÄÓŵ㣺ËٶȺÍЧÂÊ¡£
ʹÓô洢¹ý³ÌµÄËÙ¶ÈÏÔÈ»¸ü¿ì¡£
ÔÚЧÂÊÉÏ£¬Èç¹ûÓ¦ÓÃÒ»´ÎÐèÒª×öһϵÁÐSQL²Ù×÷£¬ÔòÐèÒªÍù·µÓÚPHPÓëORACLE£¬²»Èç°Ñ¸ÃÓ¦ÓÃÖ±½Ó·Åµ½Êý¾Ý¿â·½ÒÔ¼õÉÙÍù·µ´ÎÊý£¬Ôö¼ÓЧÂÊ¡£
µ«ÊÇÔÚINTERNETÓ¦ÓÃÉÏ£¬ËÙ¶ÈÊǼ«¶ÈÖØÒªµÄ£¬ËùÒÔºÜÓбØÒªÊ¹Óô洢¹ý³Ì¡£
żҲÊÇʹÓÃPHPµ÷Óô洢¹ý³Ì²»¾Ã£¬×öÁËÏÂÃæÕâ¸öÁÐ×Ó¡£
SQL´úÂë:-----------------------------------------
//½¨Á¢Ò»¸öTEST±í
CREATE TABLE TEST (
ID NUMBER(16) NOT NULL,
NAME VARCHAR2(30) NOT NULL,
PRIMARY KEY (ID)
);
//²åÈëÒ»ÌõÊý¾Ý
INSERT INTO TEST VALUES (5, 'PHP_BOOK');
//½¨Á¢Ò»¸ö´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE PROC_TEST (p_id IN OUT NUMBER,p_name OUT VARCHAR2) AS
BEGIN
SELECT NAME INTO p_name from TEST WHERE ID = 5;
END PROC_TEST;
/
PHP´úÂë:-----------------------------------------
<?php
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
$user = "scott"; //Êý¾Ý¿âÓû§Ãû
$password = "tiger"; //ÃÜÂë
$conn_str = "tnsname"; //Á¬½Ó´®(cstr : Connection_STRing)
$remote = true //ÊÇ·ñÔ¶³ÌÁ¬½Ó
if ($remote) {
$conn = OCILogon($user, $password, $conn_str);
}
else {
$conn = OCILogon($user, $password);
}
//É趨°ó¶¨
$id = 5; //×¼±¸ÓÃÒ԰󶨵Äphp±äÁ¿ id
$name = ""; &
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
(IT°ØÀͼ Ô´´ÎÄÕÂ)Èç¹ûÖ»ÊÇunicodeתutf-8±àÂëµÄËã·¨£¬ÍøÉϵ½´¦¶¼ÊÇÁË£¬²»¹ýºÜ¶àÈËÒ²ÊÇÄã³ÎÒ£¬ÎÒ³Ä㣬¸ù±¾¾Í²»Àí½âwhyºÍdo£¬±¾ÎijýÁ˸ø³ö×î¼òµ¥µÄphp¶Ôunicodeתutf-8±àÂ뺯ÊýÖ®Í⣬ҲÉîÈëÌÖÂÛÁËÕâÁ½ÖÖ±àÂëµÄ¹ØÏµ£¬Àí½âºÃÁ˻ᷢÏÖÍøÉÏһЩ¾ÉµÄ¶«Î÷£¬ÊÇÑÏÖØ¶àÓà¼æ¹ýÆÚµÄ£¬ÒòΪ´Óutf-8Á÷ÐпªÊ¼µ½ÏÖÔÚ£¬ÔçÒѾÓÉÔÀ´Áù×Ö½Ú ......
¡öPDOΪºÎÎ
POD£¨PHP Data Object£©À©Õ¹ÔÚPHP5ÖмÓÈ룬PHP6Öн«Ä¬ÈÏʶÓÃPDOÁ¬½ÓÊý¾Ý¿â£¬ËùÓзÇPDOÀ©Õ¹½«»áÔÚPHP6±»´ÓÀ©Õ¹ÖÐÒÆ³ý¡£¸ÃÀ©Õ¹ÌṩPHPÄÚÖÃÀà PDOÀ´¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬²»Í¬Êý¾Ý¿âʹÓÃÏàͬµÄ·½·¨Ãû£¬½â¾öÊý¾Ý¿âÁ¬½Ó²»Í³Ò»µÄÎÊÌâ¡£
ÎÒÊÇÅäÖÃÔÚwindowsÏÂ×ö¿ª·¢Óõġ£
¡öPDOµÄÄ¿±ê
ÌṩһÖÖÇáÐÍ¡¢ÇåÎú¡¢·½±ãµÄ A ......
PHPÊÇһßßЧµÄÍøÂç±à³ÌÓïÑÔ£¬ÓÉÓÚËü¾ßÓбàдÁé»î¡¢ÔËÐпìËÙµÈÓŵ㣬ѸËÙ³ÉΪWeb³ÌÐòÔ±µÄÊ×Ñ¡ÓïÑÔ¡£Ç°²»¾ÃµÄÒ»·ÝȨÍþµ÷²é±íÃ÷£¬ÏÖÔÚÒѾÓÐ31.6£¥µÄÍøÕ¾Ê¹ÓÃPHP×÷ΪÖ÷ÒªµÄ·þÎñÆ÷¶Ë±à³ÌÓïÑÔ¡£
¡¡¡¡µ«ÊÇ£¬Òª³ÉΪһÃûPHP±à³Ì¸ßÊÖÈ´²¢²»ÈÝÒס£²¢²»ÏñºÜ¶àÈËÏëÏóµÄÄÇÑù£¬Ö»ÒªÄܹ»·É¿ìµØ±àд ......