php 执行mysql存储过程

创建一个存储过程

create procedure route_stop(IN 'stop_id' int,IN 's_id' int )

 

BEGIN

select

rs1.stop_id as 起点站,

rs2.stop_id as 终点站,

rs1.bus_id as 乘坐路线,

rs2.order-rs1.order as 经过的站点数

from 

t_route_stop rs1,

t_route_stop rs2

where

rs1.bus_id=rs2.bus_id

 

and rs1.stop_id=start_stop_id

and rs2.stop_id=end_stop_id

and rs1.up_down= rs2.up_down;

END

 

在php中执行：

注意：

要用mysqli_connect()函数来连数据库

 

$db = mysqli_connect(Server,UserName,Password,DBName); if (!$db) { printf("连接出错：%s",mysqli_connect_error()); } $id = 444; $query = "call inquiryt0(1303,910)"; //$result = $db->getResult($query); //$result = mysql_query($query); $result = mysqli_query($db,"call inquiryt0(1303,910)") ; if (!$result) echo "没有返回结果集<br />"; while( $row = mysqli_fetch_array($result) ) echo $row[0]. "--------- SR.<br /> ";