9.3 MySQL存储过程 实例262

delimiter //
create procedure pro_reg (in nc varchar(50), in pwd varchar(50), 
in email varchar(50),in address varchar(50))
begin
insert into tb_reg (name, pwd ,email ,address) values (nc, pwd, email, address);
end;
//    

$conn=new mysqli("localhost","root","root","db_database09");
$conn->query("set names gb2312");   

if($sql=$conn->query("call pro_reg('".$nc."','".$pwd."','".$email."','".$address."')"))
{
echo "<SCRIPT>alert('用户注册成功!');</SCRIPT>";
}
else
{
echo "<SCRIPT>alert('用户注册失败!');</SCRIPT>";
}