- 论坛徽章:
- 0
|
- DELIMITER $$
- DROP PROCEDURE IF EXISTS `agent`.`addcom` $$
- CREATE PROCEDURE `addcom`(
- in name1 varchar(20),
- in username integer(20),
- in commission integer(20),
- in amount integer(20),
- out msg varchar(20)
- )
- begin
- declare co integer(20);
- select cno into co from client where cdname=name1;
- select co;
- insert into site_acc_order (cno,cdname,usr,commis,amt) values (co,name1,username,commission,amount);
- set msg=1;
- end $$
- DELIMITER ;
复制代码
========这是我 php 的 code !(我得不到 msql 的 set msg='Sucess'; 帮帮忙吧大家!!!)===========
- <? include("./spconn.php");
- $mysqli->real_query ("CALL addcom('".$_REQUEST['U']."','123456','".$_REQUEST['ccurid']."','".$_SESSION['uname']."','".$_REQUEST['name']."','".$_REQUEST['comm']."','".$_REQUEST['amt']."',@msg);select @msg;") or die(mysql_error());
- $objResult = $mysqli->store_result();
- $row = $objResult->fetch_assoc();
- if($row["msg"] == 1){
- print "Success";
- } else {
- print "error";
- }
- $row->free_result();?>
复制代码
[ 本帖最后由 dannylim86 于 2008-8-5 17:45 编辑 ] |
|