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

Çë½ÌÒ»PHP¶ÔMySQLµÄ²Ù×÷

ÏÖÓÐÈçÏÂÒ»´æ´¢¹ý³Ì£º

SQL code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_Test`(

in $W_id int

)
BEGIN

DECLARE $type int DEFAULT 0;
DECLARE $preID int;
DECLARE $nextID int;
DECLARE $preName varchar(50);
DECLARE $nextName varchar(50);

SELECT `W_Type` INTO $type from `tb_Writings`

WHERE `W_ID`=$W_id;

SELECT `W_ID`,`W_Name` INTO $nextID,$nextName from `tb_Writings`

WHERE `W_ID`>$W_id AND `W_Type`=$type

ORDER BY `W_ID` ASC LIMIT 1;

SELECT `W_ID`,`W_Name` INTO $preID,$prename from `tb_Writings`

WHERE `W_ID`<$W_id AND `W_Type`=$type

ORDER BY `W_ID` DESC LIMIT 1;
SELECT $preID AS `PreID`,$nextID AS `NextID`,$preName AS `PreName`,$nextName AS `NextName`;

END



ÏÖÔÚÒªÇó¸ÄÔÚPHPÀïÖ±½ÓÔËÐжø²»µ÷Óô洢¹ý³Ì£¬Èç¹ûʵÏÖ£¿

¿ÉÒÔ²»¸ø³ö´úÂ룬µ«Ò²Òª°Ñ˼·˵Ã÷°×¡£
²»¾ÍÊǼ¸¾äSELECTÂð...Ҫʲô˼·?

¸ã²»¶®Â¥Ö÷Ïë¸ÉÂð

ÎÊÌâÊÇ Õâ½ö½öÊÇÒ»¸ö½Ï¼òµ¥µÄ´æ´¢¹ý³Ì£¬¶øÇÒ»¹Ö»ÊÇÒ»¸ö¹¦ÄܵÄʵÏÖ£¬¾ÍÒªÁ¬½ÓÖ´ÐÐÄÇô¶à´Î²éѯ¡£

Èç¹ûÊÇ»»³ÉÒ»¸ö¸´ÔÓµãµÄ£¬Èç´´½¨ÁÙʱ±í£¬Âß¼­ÅÐ¶Ï µÈ£¬PHP¸ÃÈçºÎµ÷Óã¿

±§Ç¸£¬¸Õѧ PHP £¬»¹²»Ê죬ֻÏëÁ˽âһϠPHP ¶ÔÕâÖÖÇé¿öÈçºÎ½â¾ö¡£


ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

PHPÀ©Õ¹CʱµÄÎÊÌâ

ÎÒÓÃPHPÀ©Õ¹Cʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ

²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿

ÔËÐÐÁË/ext_skel --extname=Ä ......

ÇóÖú°ïÎÒ°ÑÒ»¶Î¼òµ¥µÄPHP´úÂëת»»³ÉASPµÄ

<?php
if($_SERVER['HTTP_REFERER']!=''){
  @header("Content-type:image/jpeg");
  echo file_get_contents("xlight.jpg");
}
else{
  @header("location:ht ......

±±¾©¼±ÕÐlinux¡¢PHPÍøÂçÓ¦Óÿª·¢

ÎÒÃÇÁ¥ÊôÖпÆÔº¼ÆËãËùÍøÂçÖØµãʵÑéÊÒ(http://www.ict.ac.cn/survey/channel/detail443.asp)»ù´¡ÉèÊ©¿ÎÌâ×é.
ÏÖÒòÏîÄ¿ºÍÒµÎñÍØÕ¹µÄÐèÒª,ÌØÐèÒªÕÐÆ¸ÓëÏîÄ¿Ïà¹ØµÄÍøÂçÓ¦Óù¤³Ìʦ1-2Ãû¡£

¾ßÌåÒªÇóÈçÏ¡£ÓÐÒâÕß ......

¹ØÓÚphpα¾²Ì¬µÄÎÊÌâ

<?php
/*
¹¦ÄÜ£ºPHPα¾²Ì¬»¯Ò³ÃæµÄʵÏÖ
¾ßÌåÓ÷¨:
ÀýÈçÁ´½ÓΪ:test.php/year/2006/action/_add.html
mod_rewrite();
 $yearn= $_GET["year"];//½á¹ûΪ'2006' ......

php webservice±¨´íObject id #2À²£¡

webclient.phpÎļþ£º
<?php
$arrOptions = array( 'uri'=>'http://10.10.19.111/','location'=>'http://10.10.19.111/webservice/webservice.php','trace' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ