<?php
$con = mysql_connect("localhost","root","root");
if (false == $con)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
}
$ret = mysql_select_db("algoplat",$con);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
}
$sql_procedure = "
create procedure insert_db(in in_aid int,in in_did int)
begin
insert into taskstatus (aid,did) values (in_aid,in_did);
end;
";
// create procedure,有同名procedure时会报错
$ret = mysql_query($sql_procedure,$con);
if (false == $ret)
{
printf("%s,%s,%s:error=%s\n",__FILE__,__FUNCTION__,__LINE__,mysql_error($con));
exit(1);
}
$sql = "call algoplat.insert_db(1000,1000)";
$ret = mysql_query($sql,$con);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
exit(1);
}
$sql = "select * from taskstatus;";
$ret = mysql_query($sql);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
exit(1);
}
$row = true;
while(true)
{
$row = mysql_fetch_row($ret);
if (false == $row)
{
break;
}
var_dump($row);
}
?>
$con = mysql_connect("localhost","root","root");
if (false == $con)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
}
$ret = mysql_select_db("algoplat",$con);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
}
$sql_procedure = "
create procedure insert_db(in in_aid int,in in_did int)
begin
insert into taskstatus (aid,did) values (in_aid,in_did);
end;
";
// create procedure,有同名procedure时会报错
$ret = mysql_query($sql_procedure,$con);
if (false == $ret)
{
printf("%s,%s,%s:error=%s\n",__FILE__,__FUNCTION__,__LINE__,mysql_error($con));
exit(1);
}
$sql = "call algoplat.insert_db(1000,1000)";
$ret = mysql_query($sql,$con);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
exit(1);
}
$sql = "select * from taskstatus;";
$ret = mysql_query($sql);
if (false == $ret)
{
printf("%s,%s,%s\n",__FILE__,__FUNCTION__,__LINE__);
exit(1);
}
$row = true;
while(true)
{
$row = mysql_fetch_row($ret);
if (false == $row)
{
break;
}
var_dump($row);
}
?>