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

PHPÓëMYSQLµÄ´æ´¢¹ý³Ì

ʵÀýÒ»£ºÎ޲εĴ洢¹ý³Ì
$conn = mysql_connect('localhost','root','root') or die ("Êý¾ÝÁ¬½Ó´íÎó!!!");
mysql_select_db('test',$conn);
$sql = "
create procedure myproce()
begin
INSERT INTO user (id, username, sex) VALUES (NULL, 's', '0');
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproceµÄ´æ´¢¹ý³Ì
$sql = "call test.myproce();";
mysql_query($sql);//µ÷ÓÃmyproceµÄ´æ´¢¹ý³Ì£¬ÔòÊý¾Ý¿âÖн«Ôö¼ÓÒ»ÌõмǼ¡£
ʵÀý¶þ£º´«Èë²ÎÊýµÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce2(in score int)
begin
if score >= 60 then
select 'pass';
else
select 'no';
end if;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce2µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce2(70);";
mysql_query($sql);//µ÷ÓÃmyproce2µÄ´æ´¢¹ý³Ì,¿´²»µ½Ð§¹û£¬¿ÉÒÔÔÚcmdÏ¿´µ½½á¹û¡£
ʵÀýÈý£º´«³ö²ÎÊýµÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce3(out score int)
begin
set score=100;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce3µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce3(@score);";
mysql_query($sql);//µ÷ÓÃmyproce3µÄ´æ´¢¹ý³Ì
$result = mysql_query('select @score;');
$array = mysql_fetch_array($result);
echo '<pre>';print_r($array);
ʵÀýËÄ£º´«³ö²ÎÊýµÄinout´æ´¢¹ý³Ì
$sql = "
create procedure myproce4(inout sexflag int)
begin
SELECT * from user WHERE sex = sexflag;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce4µÄ´æ´¢¹ý³Ì
$sql = "set @sexflag = 1";
mysql_query($sql);//ÉèÖÃÐÔ±ð²ÎÊýΪ1
$sql = "call test.myproce4(@sexflag);";
mysql_query($sql);//µ÷ÓÃmyproce4µÄ´æ´¢¹ý³Ì,ÔÚcmdÏÂÃæ¿´Ð§¹û
ʵÀýÎ壺ʹÓñäÁ¿µÄ´æ´¢¹ý³Ì
$sql = "
create procedure myproce5(in a int,in b int)
begin
declare s int default 0;
set s=a+b;
select s;
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproce5µÄ´æ´¢¹ý³Ì
$sql = "call test.myproce5(4,6);";
mysql_query($sql);//µ÷ÓÃmyproce5µÄ´æ´¢¹ý³Ì,ÔÚcmdÏÂÃæ¿´Ð§¹û
ʵÀýÁù£ºcaseÓï·¨
$sql = "
create procedure myproce6(in score int)
begin
case score
when 60 then select '¼°¸ñ';
when 80 then select '¼°Á¼ºÃ';
when 100 then select 'ÓÅÐã';
else select 'δ֪·ÖÊý';
end case;
end;
";
mysql_query($sql);//´´½¨


Ïà¹ØÎĵµ£º

MySQLÖÐÎÄÂÒÂë½â¾ö·½°¸

˵Ã÷: ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬
ΪISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
¡¾½â¾ö·½°¸¡¿
1. ´ò¿ªÎļþ: C:\Program Files\MySQL\MySQL Server 5.0\my.ini;
2. ½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312, ......

Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃÓë²âÊÔ


»·¾³:
Tomcat6.0.18
Mysql: 5.1.36
Windwos XP sp2
×î½üÐèÒªÓõ½Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ,½ñÌìÔÚÍøÉϲéÁ˺öà×ÊÁÏ,ÀÏ×ÊÁÏÌ«¶à,¶ÔÓÚÒÔÉϵÄÀϰ汾tomcat¿ÉÄÜÓÐÓÃ,±¾ÈËûÓвâÊÔ¹ý,Õýȷд³ötomcat6.0ÅäÖõÄÎļäºÜÉÙ!ºÃ¶à×ÊÁÏÉÏÃæµÄÅäÖöÔÓÚÏÖÔÚаæµÄ¼¸ºõ¶¼ÊÇÓÐÎÊÌâµÄ,Ê®´íÆß°Ë!½ñÌì°ÑÎÒÅäÖõÄÕýÈ··½·¨Ð´ÏÂÀ´,¹©´ó¼Ò²Î¿¼ ......

php³ÌÐò²åÊý¾ÝÈëmysql, ²åÈëʧ°ÜÎÊÌâ

×¢Òâ:ÒýÓÃ"·ÊÕ¼µÄ²©¿Í http://fatjames.extjs.org.cn/archives/40"
mysql5.x sql-mode ÒýÆðµÄ´íÎó
½ñÌì°²×°Á˸ömysql5.0,ÄÃÁËÒ»¸öºÜ¾ÃÖ®Ç°ÍøÉÏϵijÌÐò¼ì²éÒ»ÏÂÊÇ·ñ¹¤×÷Õý³£.
·¢ÏÖÒÔǰµÄ³ÌÐò¾ÓÈ»²»ÄÜÕý³£ÔËÐÐ,ÌáʾÐÅÏ¢ÈçÏÂ:
Database error: Invalid SQL: INSERT INTO
Survey_UserHistory(userId,jobId,type ......

»ùÓÚPHPµÄcURL¿ìËÙÈëÃÅ


Ô­ÎÄ£º»ùÓÚ
PHPµÄcURL¿ìËÙÈëÃÅ
Ó¢ÎÄÔ­ÎÄ£ºhttp://net.tutsplus.com/tutorial ... for-mastering-curl/
Ô­ÎÄ×÷ÕߣºBurak
Guzel
cURL
ÊÇÒ»¸öÀûÓÃURLÓï·¨¹æ¶¨À´´«ÊäÎļþºÍÊý¾ÝµÄ¹¤¾ß£¬Ö§³ÖºÜ¶àЭÒ飬ÈçHTTP¡¢FTP¡¢TELNETµÈ¡£×îˬµÄÊÇ£¬PHPÒ²Ö§³Ö cURL
¿â¡£±¾ÎĽ«½éÉÜ cURL µÄһЩ¸ß¼¶ÌØÐÔ£¬ÒÔ¼°ÔÚPHPÖÐÈçºÎÔËÓÃËü¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ