请问关于mysql存储过程如何在php代码里实现？

是不是也是先
mysql_connect("localhost","root","");
mysql_select_db("dbname");
$sql = "create procedure stu_sp1(IN seat int,OUT uname char(20))";
$sql .= "begin";
$sql .= "select stuName from stuinfo where stuSeat=seat into uname";
$sql .= "end";

mysql_query($sql);

mysql_query("call stu_sp1(1,@name)");

我看网上说如果在php页面使用存储过程关键还要注意两点：（不知道这两点是不是必须写才能使用存储过程）

关键就是两点

1）define('CLIENT_MULTI_RESULTS', 131072);

2）$link = mysql_connect("127.0.0.1", "root", "",1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());

---

自己顶一下，希望大家能帮助我

---

恩，不过你创建procedure的格式要注意.而且既然是php处理，应该在create procedure之前执行一次drop

PHP code:
mysql_query("drop procedure if exists stu_sp1");
$sql = "create procedure stu_sp1(IN seat int,OUT uname char(20))";
$sql .= "\nbegin";//\n
$sql .= "\nselect stuName from stuinfo where stuSeat=seat into uname;";//语句加;号
$sql .= "\nend";

mysql_query($sql);

mysql_query("call stu_sp1(1,@name)");