Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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!




Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

phpÓÎÏ·¿ª·¢

ÇëÎÊһϸ÷λ´óϺ£¬ÎÒÓÃphp×ö¸öÍøÒ³ÓÎÏ·£¬µ±È»ÊÇ×îÀ¬»øµÄÄÇÖÖhtmlµÄ£¬
ÏÖÔÚÎÒÏë°ÑËùÓÐÍæ¼ÒºÍ¹ÖÎnpcµÄÊý¾Ý´¢´æ£¬
µ±È»£¬Êý¾Ý¿âÖе±È»ÓУ¬µ«ÊÇÎÒÓÖ²»Ïë¹ý¶àµÄÈ¥²éѯÊý¾Ý¿â£¬
±ÈÈçÕ½¶·ÏµÍ³£¬¿Ï¶¨ÒªÏȳõʼ»¯Ë«·½Êý ......

¿ª·¢PHPÓÃÓÃʲôÈí¼þ

¿ª·¢PHPÓÃÓÃʲôÈí¼þ£¿

¶à½éÉܼ¸ÖÖ¡£

ÎÒ¶¼²»ÏþµÃ¡£¹þ¹þ¡£ºÃ¾ÍûÓÐÉÏcsdn£¬¿´¼ûÄã·¢ÁËÌù¡£×î½üÔõôÑù£¿£¿£¿

Îı¾±à¼­Æ÷¶¼¿ÉÒÔµÄ

±±¾©Î弫ÐÇÐÅϢϵͳ¼¼ÊõÓÐÏÞ¹«Ë¾ÏÖÕÐÆ¸5ÃûPHP³ÌÐòÔ±¡£
ְλҪÇó£º ......

¹ØÓÚ¡¡php webservice¡¡µÄÎÊÌâ - PHP / »ù´¡±à³Ì

¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
  public function Logout()
  {
//header('Co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ