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 = ""; &
Ïà¹ØÎĵµ£º
<?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µÄ¿ª·¢ÈËÔ±ÔÚ¿ªÊ¼¿ª·¢webÓ¦ÓóÌÐò֮ǰ£¬¶¼Ó¦¸ÃÊìϤÏÂÃæµÄÎå¼þÊ£º www.phperz.com
1. ¿ò¼Ü
php³ÌÐòÔ±Ö®¼Ò
¿ò¼Ü¿ÉÒÔ˵ÊÇphp¿ª·¢ÖеÄÒ»¸ö×îÖØÒªµÄÎÊÌâ¡£ÓÃphp¿ª·¢webÓ¦ÓóÌÐòʱÓкܶ෽·¨£¬Óкܶ࿪ԴµÄ¿ò¼Ü¿ÉÒÔʹÓã¬¿É ......
PHPÊÇһßßЧµÄÍøÂç±à³ÌÓïÑÔ£¬ÓÉÓÚËü¾ßÓбàдÁé»î¡¢ÔËÐпìËÙµÈÓŵ㣬ѸËÙ³ÉΪWeb³ÌÐòÔ±µÄÊ×Ñ¡ÓïÑÔ¡£Ç°²»¾ÃµÄÒ»·ÝȨÍþµ÷²é±íÃ÷£¬ÏÖÔÚÒѾÓÐ31.6£¥µÄÍøÕ¾Ê¹ÓÃPHP×÷ΪÖ÷ÒªµÄ·þÎñÆ÷¶Ë±à³ÌÓïÑÔ¡£
¡¡¡¡µ«ÊÇ£¬Òª³ÉΪһÃûPHP±à³Ì¸ßÊÖÈ´²¢²»ÈÝÒס£²¢²»ÏñºÜ¶àÈËÏëÏóµÄÄÇÑù£¬Ö»ÒªÄܹ»·É¿ìµØ±àд ......
PHPÊÇÈõÀàÐÍÓïÑÔ¡£
»ù±¾Êý¾ÝÀàÐÍ£ºinteger¡¢string¡¢boolean¡¢float
¸´ºÏÊý¾ÝÀàÐÍ£ºarray¡¢object
»ù±¾Êý¾ÝÀàÐ;Ͳ»ËµÁË£¬ÏÂÃæ¿´Ò»¸öÊý×éÏà¹ØµÄһЩÀý×Ó¡£
$test1=array(1,2,3,4);//¶¨ÒåÁËÒ»¸ö°üº¬4¸öÊýµÄÊý×é
$test1=array("new1"=>1,"new2"=>2);//Á½¸ö±äÁ¿µÄÊý×é,array['new1']=1,array['new2']=2
¶àÎ ......