$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);

					$sql = "create procedure myproce2(in score int)
beginif score >= 60 then
select 'pass';elseselect 'no';
end if;end; ";
MySQL_query($sql);

					$sql = "create procedure myproce3(out score int)
beginset score=100;end; "; 
 MySQL_query($sql);

					$result = MySQL_query('select @score;');
$array = MySQL_fetch_array($result); 
 echo '<pre>';print_r($array); 
PHP與MySQL

					$sql = "create procedure myproce4(inout sexflag int)
beginSELECT * FROM user 
WHERE sex = sexflag;end; ";
MySQL_query($sql);