Çë½ÌÒ»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ʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ
²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿
ÔËÐÐÁË/ext_skel --extname=Ä ......
<?php
if($_SERVER['HTTP_REFERER']!=''){
@header("Content-type:image/jpeg");
echo file_get_contents("xlight.jpg");
}
else{
@header("location:ht ......
ÎÒÃÇÁ¥ÊôÖпÆÔº¼ÆËãËùÍøÂçÖØµãʵÑéÊÒ(http://www.ict.ac.cn/survey/channel/detail443.asp)»ù´¡ÉèÊ©¿ÎÌâ×é.
ÏÖÒòÏîÄ¿ºÍÒµÎñÍØÕ¹µÄÐèÒª,ÌØÐèÒªÕÐÆ¸ÓëÏîÄ¿Ïà¹ØµÄÍøÂçÓ¦Óù¤³Ìʦ1-2Ãû¡£
¾ßÌåÒªÇóÈçÏ¡£ÓÐÒâÕß ......
<?php
/*
¹¦ÄÜ£ºPHPα¾²Ì¬»¯Ò³ÃæµÄʵÏÖ
¾ßÌåÓ÷¨:
ÀýÈçÁ´½ÓΪ:test.php/year/2006/action/_add.html
mod_rewrite();
$yearn= $_GET["year"];//½á¹ûΪ'2006'
......
webclient.phpÎļþ£º
<?php
$arrOptions = array( 'uri'=>'http://10.10.19.111/','location'=>'http://10.10.19.111/webservice/webservice.php','trace' ......