Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 = "";              &


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle vs. SQL ͬÒå´Êsynonym ±ðÃû alias

oracle ͬÒå´Ê synonym ΪÊý¾Ý¿â¶ÔÏó½¨Á¢Í¬Òå´Êºó,µ±dba¶ÔÊý¾Ý¿â¶ÔÏó(table,view,ÐòÁÐ)×öÁËÒ»¸ö¼òµ¥¸Ä¶¯Ö®ºó,ÈçÃû×Ö»òÕ߽ṹ¸Ä±ä,Ôò²»ÐèÒªÖØÐ¸ü¸Ä²¢±àÒëÓ¦ÓÃ.ÔÚÊý¾Ý¿â×ÖµäÖÐÓж¨Òå,²»ÐèÒª½øÐÐÈκδ洢.
oracle±ðÃûalias,With as¡¡Éú³ÉÒ»¸öÁÙʱ±í£¬¶ÔÓÚ¸´ÔÓµÄÊý¾Ý²éѯ£¬¿ÉÒÔ¼õÉÙ×ÊÔ´ÏûºÄ¡¢Ìá¸ßÐÔÄÜ¡£9iÒýÈë¡£
with alias ......

php dateʱ¼ä±¾µØ»¯ÎÊÌ⣨ת£©


½ñÌìÔÚдһ¸ö¶«Î÷ʱ£¬·¢ÏÖʱ¼äÒ»Ö±¶Ô²»ÉÏ£¬date("Y-m-d h:i:s") ×ÜÊÇÓë·þÎñÆ÷ʱ¼ä²î¼¸¸öСʱ£®
Ô­À´´Óphp5.1.0¿ªÊ¼£¬php.iniÀï¼ÓÈëÁËdate.timezoneÕâ¸öÑ¡ÏĬÈÏÇé¿öÏÂÊǹرյÄ
Ò²¾ÍÊÇÏÔʾµÄʱ¼ä£¨ÎÞÂÛÓÃʲôphpÃüÁ¶¼ÊǸñÁÖÍþÖαê׼ʱ¼ä
ºÍÎÒÃǵÄʱ¼ä£¨±±¾©Ê±¼ä£©²îÁËÕýºÃ8¸öСʱ

½â¾ö·½Ê½:

Ò»¡ ......

ÐÂÀËPHP¹¤³Ìʦ±ÊÊÔÌâ

1. дһ¸öº¯Êý£¬¾¡¿ÉÄܸßЧµÄ£¬´ÓÒ»¸ö±ê×¼ url
ÀïÈ¡³öÎļþµÄÀ©Õ¹Ãû
   ÀýÈç: http://www.sina.com.cn/abc/de/fg.php
?id=1
ÐèҪȡ³ö php »ò .php
2. ÔÚ HTML ÓïÑÔÖУ¬Ò³ÃæÍ·²¿µÄ meta ±ê¼Ç¿ÉÒÔÓÃÀ´Êä³öÎļþµÄ±àÂë
¸ñʽ£¬ÒÔÏÂÊÇÒ»¸ö±ê×¼µÄ meta Óï¾ä
   <META http-equiv='Content-Type
' ......

mysql+php select ÏÂÀ­ÁбíÊ÷µÄ¼òµ¥ÊµÏÖ


Êý¾Ý¿âÉè¼Æ£º
--
-- Êý¾Ý¿â: `test`
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`ID` int(10) unsigned NOT NULL auto_increment,
`PID` int(11) NOT NULL,
`TITLE` varchar(200) NOT NULL,
`REMARK` varchar(200) NOT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ