Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

PHP ×Ö·û´®½ØÈ¡

<?php
//$str = "abcdef¡ôÖлªÈËÃñ¹²ºÍ¹ú";
//$str = "1234567890";
$str = "ÖлªÈËÃñ¹²ºÍ¹úabcÖлªÈËÃñ¹²ºÍ¹úÖлªÈËÃñ¹²ºÍ¹ú";
$str = cut_str($str, 18);
echo $str;
function cut_str($str, $len){
 if(strlen($str) <= $len) return $str;
 $n = 0;
 $tempstr = '';
 for($i = 0; ......

PHPÃæÊÔÌâ»ã×Ü

»ù´¡Ìâ
¡¡¡¡1.±íµ¥ÖÐ getÓëpostÌá½»·½·¨µÄÇø±ð?
¡¡¡¡´ð£ºgetÓû§¶Ë½«Êý¾Ý¼Óµ½URLºó£¬¸ñʽΪ”?×Ö¶Î1=ÊäÈëÊý¾Ý1&×Ö¶Î2=ÊäÈëÊý¾Ý2&..."¡£
¡¡¡¡ÓÉÓÚgetÌá½»²ÎÊýºó»áÔÚµØÖ·À¸ÖÐÏÔʾ³öÀ´£¬ËùÒÔ»á²úÉúÑÏÖØµÄ°²È«ÎÊÌâ¡£
¡¡¡¡get´«ÊäµÄÊý¾ÝÁ¿Ð¡£¬get´«ÊäµÄÊý¾ÝÁ¿Ð¡£¬ÕâÖ÷ÒªÊÇÒòΪÊÜurl³¤¶ÈÏÞÖÆ;¶øpost¿ÉÒÔ´«Ê ......

phpÃæÊÔÌâÄ¿(ÒÑ×¢´ð°¸)


¼òÊöÌâ(50·Ö)()
1¡¢ÓÃPHP´òÓ¡³öǰһÌìµÄʱ¼ä¸ñʽÊÇ2006-5-10 22:21:21(2·Ö)
echo date('Y-m-d H:i:s', strtotime('-1 day'));
»òÕß
$yesterday = time() - (24 * 60 * 60);
echo 'today:'.date('Y-m-d H:i:s')."\n";
echo 'yesterday:'. date('Y-m-d H:i:s', $yesterday)."\n";
2¡¢echo(),pr ......

phpÈí¼þ°æ °²×° ÎÊÌâ

ÕâÁ½ÌìÒ»Ö±ÔÚ°ïÈË×ö¸öÈí¼þ¿ÉÊǰ³Ö»»áÓÃphp£¬php³ÌÐòµÄÔËÐÐÊÇ»ùÓÚApache·þÎñÆ÷µÄ£¬Ã»°ì·¨ ÒªÔËÐгÌÐò¾Í±ØÐëÔËÐзþÎñÆ÷Apache·þÎñÆ÷¿ÉÒÔÑ¡ÓÃ×é×°°æµÄ£¬ÏÂÃæ·ÖÏíÏÂÎÒµÄÅäÖ÷½·¨£¬ÓÃÒ»¸öСµÄÅú´¦Àí³ÌÐò¾Í¿ÉÒÔÍê³É¡£
ÏÂÃæ¾ÍÊÇÎÒµÄÅú´¦Àí³ÌÐò£º
@ ECHO OFF
copy d:\road\httpd-vhosts.conf c:\xampp\apache\conf\extra  / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ