CREATE PROCEDURE login (IN uname VARCHAR(30),IN upwd VARCHAR(32), OUT re_uinfo VARCHAR(50))
BEGIN
SELECT @re_uinfo:=concat(user_id,'|',user_name) as uinfo FROM glcity_user WHERE user_name=uname AND user_pwd=upwd AND user_state=1 LIMIT 1;
END;请问各位朋友,PHP如何取到re_uinfo这个返回参数的值?
BEGIN
SELECT @re_uinfo:=concat(user_id,'|',user_name) as uinfo FROM glcity_user WHERE user_name=uname AND user_pwd=upwd AND user_state=1 LIMIT 1;
END;请问各位朋友,PHP如何取到re_uinfo这个返回参数的值?
程序中就这么写就OK了。
echo $result;
这样对不?
echo $ok_cg;
这样是没有值输出的。function hxQuery($sql,$type="ASSOC")
{
$this->rsType = $type != "ASSOC" ? ($type == "NUM" ? MYSQL_NUM : MYSQL_BOTH) : MYSQL_ASSOC;
$this->result = mysql_query($sql,$this->conn);
$this->queryCount++;
if($this->result)
{
return $this->result;
}
else
{
return false;
}
}