Çë½ÌÒ»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!
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊһϸ÷λ´óϺ£¬ÎÒÓÃphp×ö¸öÍøÒ³ÓÎÏ·£¬µ±È»ÊÇ×îÀ¬»øµÄÄÇÖÖhtmlµÄ£¬
ÏÖÔÚÎÒÏë°ÑËùÓÐÍæ¼ÒºÍ¹ÖÎnpcµÄÊý¾Ý´¢´æ£¬
µ±È»£¬Êý¾Ý¿âÖе±È»ÓУ¬µ«ÊÇÎÒÓÖ²»Ïë¹ý¶àµÄÈ¥²éѯÊý¾Ý¿â£¬
±ÈÈçÕ½¶·ÏµÍ³£¬¿Ï¶¨ÒªÏȳõʼ»¯Ë«·½Êý ......
¿ª·¢PHPÓÃÓÃʲôÈí¼þ£¿
¶à½éÉܼ¸ÖÖ¡£
ÎÒ¶¼²»ÏþµÃ¡£¹þ¹þ¡£ºÃ¾ÍûÓÐÉÏcsdn£¬¿´¼ûÄã·¢ÁËÌù¡£×î½üÔõôÑù£¿£¿£¿
Îı¾±à¼Æ÷¶¼¿ÉÒÔµÄ
±±¾©Î弫ÐÇÐÅϢϵͳ¼¼ÊõÓÐÏÞ¹«Ë¾ÏÖÕÐÆ¸5ÃûPHP³ÌÐòÔ±¡£
ְλҪÇó£º ......
¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
public function Logout()
{
//header('Co ......