PHP+MYSQL ²éѯÊý¾ÝµÄ´æ´¢¹ý³Ì£¬ÔõôµÃµ½½á¹û¼¯£¿
BEGIN
select * from operator;
END
Õâ¾ÍÊÇÎÒ´æ´¢¹ý³ÌµÄÄÚÈÝ£¬ÔÚPHPÀïÔõô¿ÉÒԵõ½·µ»ØµÄ½á¹û¼¯£¿
¼ÙÉèÉÏÃæÊ¾ÀýµÄMySQL´æ´¢¹ý³ÌΪ:
SQL code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`proc_test` $$
CREATE PROCEDURE `test`.`proc_test` ()
BEGIN
select * from tbl_name;
END $$
DELIMITER ;
ûÓп´¶®
µ±È»ÒªÓÐÒ»¸öÁ´½ÓÊý¾Ý¿âÀà Èçclass sjk (Êý¾Ý¿âÀàËæ±ã°Ù¶ÈÒ»ÏÂ)
$db= new sjk();
$res=$db->query("CALL test.proc_test()");
while ($arr=$res->fetch_array())
{
echo $arr["Field"] ." <br/>";
}
ºÍÆÕͨµÄselect ²éѯ ÏàͬµÄ·½·¨¡£Ö±½ÓÓà mysql_query ¾ÍÐÐÁË¡£s
Â¥ÉÏ ¸÷λ½âÊ͵ĺÜÇå³þÁË
Ïà¹ØÎÊ´ð£º
¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
public function Logout()
{
//header('Co ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid']
ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid']
ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ
function showdiv()
{
var kk=<?= $fID ? ......