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);//´´½¨