Ò»¸ömysqlµÄ´æ´¢¹ý³Ì£¬ÄÄÀïÓÐÎÊÌ⣿

SQL code:

create procedure(in w varchar(20),out c int)
begin
set @sqlcount=concat('select count(*) into @c from scms_product where ',w);
prepare stm1 from @sqlcount;
execute stm1;
set c=@c;
set @sql=concat('select * from scms_product where ',w);
prepare stm2 from @sql;
execute stm2;
end


ÉÏÃæµÄ´æ´¢¹ý³ÌÔÚmysqlÀïÔËÐÐÕý³££¬ÒªÇóÔÚphpÀïµÃµ½out±äÁ¿cµÄÖµ£¬php´úÂëÊÇÕâÑùµÄ
PHP code:

$rs=$mysqli->query("call p5('cateid=5',@c)");
$res=$mysqli->query("select @c");
$row=$res->fetch_row();
echo $row[0];


ÔËÐеÄʱºò¾Í»á³öÏÖ´íÎóÌáʾ£¬Call to a member function fetch_row() on a non-object  Èç¹ûÎÒÈ¥µô´æ´¢¹ý³ÌÖеÄ
set @sql=concat('select * from scms_product where ',w);
prepare stm2 from @sql;
execute stm2;
Õ⼸ÐоÍÕý³£ÁË£¬ÇëÎÊÎÒµÄphp³ÌÐò¸ÃÔõôд£¿

---

create procedure(in w varchar(20),out c int)
begin
..


Õâ¸ö±¾ÉíÓï·¨ÉϾ͹ý²»È¥¡£

½¨ÒéÄãÄÜÌù³öÄãʵ¼ÊÎÊÌâµÄ´úÂëÒÔ±ã·ÖÎö¡£

---

create procedure SPÃû×Ö(in w varchar(20),out c int)
begin
set @sqlcount=concat('select count(*) into @c from scms_product where  ',w);
prepare stm1 from @sqlcount;
execute stm1;
set