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

PHPÓëMYSQLµÄ´æ´¢¹ý³Ì

ʵÀýÒ»£ºÎ޲εĴ洢¹ý³Ì
$conn = mysql_connect('localhost','root','root') or die ("Êý¾ÝÁ¬½Ó´íÎó!!!");
mysql_select_db('test',$conn);
$sql = "
create procedure myproce()
begin
INSERT INTO user (id, username, sex) VALUES (NULL, 's', '0');
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproceµÄ´æ´¢¹ý³Ì
$sql = "call test.myproce();";
mysql_query($sql);//µ÷ÓÃmyproceµÄ´æ´¢¹ý³Ì£¬ÔòÊý¾Ý¿âÖн«Ôö¼ÓÒ»ÌõмǼ¡£
ʵÀý¶þ£º´«Èë²ÎÊýµÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce2(in score int)
begin
if score >= 60 then
select 'pass';
else
select 'no';
end if;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce2µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce2(70);";
mysql_query($sql);//µ÷ÓÃmyproce2µÄ´æ´¢¹ý³Ì,¿´²»µ½Ð§¹û£¬¿ÉÒÔÔÚcmdÏ¿´µ½½á¹û¡£
ʵÀýÈý£º´«³ö²ÎÊýµÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce3(out score int)
begin
set score=100;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce3µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce3(@score);";
mysql_query($sql);//µ÷ÓÃmyproce3µÄ´æ´¢¹ý³Ì
$result = mysql_query('select @score;');
$array = mysql_fetch_array($result);
echo '<pre>';print_r($array);
ʵÀýËÄ£º´«³ö²ÎÊýµÄinout´æ´¢¹ý³Ì
$sql = "
create procedure myproce4(inout sexflag int)
begin
SELECT * from user WHERE sex = sexflag;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce4µÄ´æ´¢¹ý³Ì
$sql = "set @sexflag = 1";
mysql_query($sql);//ÉèÖÃÐÔ±ð²ÎÊýΪ1
$sql = "call test.myproce4(@sexflag);";
mysql_query($sql);//µ÷ÓÃmyproce4µÄ´æ´¢¹ý³Ì,ÔÚcmdÏÂÃæ¿´Ð§¹û
ʵÀýÎ壺ʹÓñäÁ¿µÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce5(in a int,in b int)
begin
declare s int default 0;
set s=a+b;
select s;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce5µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce5(4,6);";
mysql_query($sql);//µ÷ÓÃmyproce5µÄ´æ´¢¹ý³Ì,ÔÚcmdÏÂÃæ¿´Ð§¹û
ʵÀýÁù£ºcaseÓï·¨
$sql = "
create procedure myproce6(in score int)
begin
case score
when 60 then select '¼°¸ñ';
when 80 then select '¼°Á¼ºÃ';
when 100 then select 'ÓÅÐã';
else select 'δ֪·ÖÊý';
end case;
end;
";
mysql_query($sql);//´´½¨


Ïà¹ØÎĵµ£º

PHP·¢ËÍÓʼþ phpmailer

×î½üŪPHPÓʼþ·¢ËÍʱ£¬´ÓÍøÉÏÔØÁ˶δúÂ룬×ÜÊÇÓÐЩÎÊÌ⣬ËùÒÔ¶ÔÕâЩÎÊÌâµÄ½â¾ö×÷Ò»¸ö¼Ç¼£¬·½±ãÒÔºó²éÔÄ¡£
PHP·¢ËÍÓʼþ£º
1¡¢class.phpmailer.php Àà°üµÄ¹ÙÍøÏÂÔØ×îаæµÄphpmailerÀ࣬Ҫע²áµÄŶ¡£
2¡¢×¢Òâ¿´ÄãµÄ·¢ËÍÓÊÏäÊDz»ÊÇ¿ªÍ¨µÄSMTP·þÎñ¡£µÇ¼ÓÊÏä -> ÉèÖ㬠²é¿´ÊÇ·ñÖ§³ÖSMTP»òÊÇ·ñ¿ªÆô¡£
3¡¢ÎÊÌ⣺it is no ......

mysqlʵÓÃÃüÁî

Ò») Á¬½ÓMYSQL£º
   ¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL
   Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëmysql°²×°Ä¿Â¼ÏµÄbinĿ¼Ï£¬ÀýÈ磺 D:\mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë
£¬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³ ......

PHP SessionʹÓÃ

ÔÚPHP¿ª·¢ÖÐ¶Ô±ÈÆðCookie£¬session ÊÇ´æ´¢ÔÚ·þÎñÆ÷¶ËµÄ»á»°£¬Ïà¶Ô°²È«£¬²¢ÇÒ²»Ïñ Cookie ÄÇÑùÓд洢³¤¶ÈÏÞÖÆ.ÓÉÓÚ Session ÊÇÒÔÎı¾ÎļþÐÎʽ´æ´¢ÔÚ·þÎñÆ÷¶ËµÄ£¬ËùÒÔ²»Å¿ͻ§¶ËÐÞ¸Ä Session ÄÚÈÝ¡£Êµ¼ÊÉÏÔÚ·þÎñÆ÷¶ËµÄ Session Îļþ£¬PHP ×Ô¶¯ÐÞ¸Ä session ÎļþµÄȨÏÞ£¬Ö»±£ÁôÁËϵͳ¶ÁºÍдȨÏÞ£¬¶øÇÒ²»ÄÜͨ¹ý ftp Ð޸ģ¬ËùÒÔ° ......

»ùÓÚPHPµÄcURL¿ìËÙÈëÃÅ


Ô­ÎÄ£º»ùÓÚ
PHPµÄcURL¿ìËÙÈëÃÅ
Ó¢ÎÄÔ­ÎÄ£ºhttp://net.tutsplus.com/tutorial ... for-mastering-curl/
Ô­ÎÄ×÷ÕߣºBurak
Guzel
cURL
ÊÇÒ»¸öÀûÓÃURLÓï·¨¹æ¶¨À´´«ÊäÎļþºÍÊý¾ÝµÄ¹¤¾ß£¬Ö§³ÖºÜ¶àЭÒ飬ÈçHTTP¡¢FTP¡¢TELNETµÈ¡£×îˬµÄÊÇ£¬PHPÒ²Ö§³Ö cURL
¿â¡£±¾ÎĽ«½éÉÜ cURL µÄһЩ¸ß¼¶ÌØÐÔ£¬ÒÔ¼°ÔÚPHPÖÐÈçºÎÔËÓÃËü¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ