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

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 ;


ÒýÓÃ
ʾÀý£º
PHP code$res=$db->query("CALL test.proc_test()");while ($arr=$res->fetch_array())
{echo$arr["Field"]." <br/>";
}


ûÓп´¶®

µ±È»ÒªÓÐÒ»¸öÁ´½ÓÊý¾Ý¿âÀà Èç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 webservice¡¡µÄÎÊÌâ - PHP / »ù´¡±à³Ì

¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó
ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8
webserviceÈçÏÂ
<?php
class WebService
{
  public function Logout()
  {
//header('Co ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......

¸¶·ÑÇóÒ»¶Îphp´úÂ룬֧³ÖÌÔ±¦½»Ò×

¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ

¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ

¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

jsÈçºÎ»ñÈ¡µ½PHPÀïµÄ±äÁ¿»òsession

±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid']
ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid']
ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ
function showdiv()
{
var kk=<?= $fID ? ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ