PHP和MySQL存储过程的实例演示

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

					<ccid_code>$sql = "  create procedure myproce2(in score int)  
begin  if score >= 60 then  
select 'pass';  else  select 'no';  
end if;  end;   ";  
MySQL_query($sql);</ccid_code>

					<ccid_code>$sql = "  create procedure myproce3(out score int)  
begin  set score=100;  end;   "; 
 MySQL_query($sql);</ccid_code>

					<ccid_code>$result = MySQL_query('select @score;');  
$array = MySQL_fetch_array($result); 
 echo '<pre class="brush:php;toolbar:false;">';print_r($array); 
PHP与MySQL</ccid_code>

					<ccid_code>$sql = "  create procedure myproce4(inout sexflag int)  
begin  SELECT * FROM user 
WHERE sex = sexflag;  end;   ";  
MySQL_query($sql);</ccid_code>