我的MYSQL数据库中有一个分页程序,调用时返回一个分页的记录集,并返回一个总记录数.///////////////////////MYSQL 过程的原型//////////////////////////
qs_common_search(@m_pageNo,@m_perPageCnt,@m_column,@m_table,@m_condition,@m_orderBy,@countpage)
说明:本段过程在MYSQL中测试通过.
/////////////////////////////PHP调用///////////////////////////$db_cnd->select_db($mysql_db); //$mysql_db为数据库名
//以下为给过程参数变量赋值
$db_cnd->query("set @m_pageNo=$pageNo"); //页码
$db_cnd->query("set @m_perPageCnt=$perPageCnt"); //页面大小
$db_cnd->query("set @m_column=$column");
$db_cnd->query("set @m_table=$table");
$db_cnd->query("set @m_condition=$condition");
$db_cnd->query("set @m_orderBy=$orderBy");
$result=$db_cnd->query("call qs_common_search(@m_pageNo,@m_perPageCnt,@m_column,@m_table,@m_condition,@m_orderBy,@countpage)");$category="";
while($recordset = $result->fetch_array())
{
$category[] = array(
"corporation_id"=>"$recordset[corporation_id]",
"corporation_name"=>"$recordset[corporation_name]",
"corporation_address"=>"$recordset[corporation_address]",
"corporation_legal_person"=>"$recordset[corporation_legal_person]",
"corporation_legal_person_tel"=>"$recordset[corporation_legal_person_tel]",
"corporation_legal_person_moble"=>"$recordset[corporation_legal_person_moble]",
"corporation_invalid_date"=>"$recordset[corporation_invalid_date]",
"corporation_certificate_exe"=>"$recordset[corporation_certificate_exe]",
"corporation_main_product"=>"$recordset[corporation_main_product]"
);}$smarty->assign("corpration",$category);
//以上调取记录部分己完成.只是在此以下调用过程返回值时,无法通过
//调取记录数
$result=$db_cnd->query("select @countpage");
printf("ERROR:%s",$db_cnd->error);
if($recordset = $result->fetch_array())
{
$smarty->assign("pagecount",$recordset[0]);
}
//////////错误提示
Commands out of sync; you can't run this command now
qs_common_search(@m_pageNo,@m_perPageCnt,@m_column,@m_table,@m_condition,@m_orderBy,@countpage)
说明:本段过程在MYSQL中测试通过.
/////////////////////////////PHP调用///////////////////////////$db_cnd->select_db($mysql_db); //$mysql_db为数据库名
//以下为给过程参数变量赋值
$db_cnd->query("set @m_pageNo=$pageNo"); //页码
$db_cnd->query("set @m_perPageCnt=$perPageCnt"); //页面大小
$db_cnd->query("set @m_column=$column");
$db_cnd->query("set @m_table=$table");
$db_cnd->query("set @m_condition=$condition");
$db_cnd->query("set @m_orderBy=$orderBy");
$result=$db_cnd->query("call qs_common_search(@m_pageNo,@m_perPageCnt,@m_column,@m_table,@m_condition,@m_orderBy,@countpage)");$category="";
while($recordset = $result->fetch_array())
{
$category[] = array(
"corporation_id"=>"$recordset[corporation_id]",
"corporation_name"=>"$recordset[corporation_name]",
"corporation_address"=>"$recordset[corporation_address]",
"corporation_legal_person"=>"$recordset[corporation_legal_person]",
"corporation_legal_person_tel"=>"$recordset[corporation_legal_person_tel]",
"corporation_legal_person_moble"=>"$recordset[corporation_legal_person_moble]",
"corporation_invalid_date"=>"$recordset[corporation_invalid_date]",
"corporation_certificate_exe"=>"$recordset[corporation_certificate_exe]",
"corporation_main_product"=>"$recordset[corporation_main_product]"
);}$smarty->assign("corpration",$category);
//以上调取记录部分己完成.只是在此以下调用过程返回值时,无法通过
//调取记录数
$result=$db_cnd->query("select @countpage");
printf("ERROR:%s",$db_cnd->error);
if($recordset = $result->fetch_array())
{
$smarty->assign("pagecount",$recordset[0]);
}
//////////错误提示
Commands out of sync; you can't run this command now
存储过程pr_web_page需要两个参数$cur_page,$per_page。
$sql = "EXEC pr_web_page $cur_page,$per_page from news ORDER BY form_id DESC";