如何从程序中获取用户ID? [英] How can I get userid from procedure?
本文介绍了如何从程序中获取用户ID?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我写了一个mysql查询(程序)插入用户(userID,角色),userID是自动增量。它的确有效。我想得到带有参数的userID,但我不知道怎么办?!
我的程序查询:
CREATE DEFINER =`root` @`localhost` PROCEDURE `Insert_User`( IN `Role` INT ( 1 ))
BEGIN
INSERT INTO < span class =code-keyword> user (UserID,角色) VALUES (< span class =code-keyword> null ,角色);
END
i通过php代码调用它:
if(isset( $ _POST ['sbm']))
{
$ pass ='1050585712';
$ role = $ _POST ['user'];
开关($ role)
{
case 0:$ role = 0; break;
案例1:$ role = 1; break;
案例2:$ role = 2; break;
案例3:$ role = 3; break;
案例4:$ role = 4; break;
默认值:$ role = 3; break;
}
if($ con = mysqli_connect(localhost,root,$ pass))
{
mysqli_select_db($ con,toggery);
mysqli_set_charset($ con,utf8);
$ p = $ con - >准备(CALL Insert_User(?));
$ p - > bind_param('i',$ role);
$ p - >执行();
}
else
{
echo'db connection error!';
}
}
我的尝试:
如何通过php获取UserID?
我应该如何更改程序查询?
解决方案
_POST ['sbm']))
{
pass ='1050585712';
role =
hi,
i wrote a mysql query(procedure) for insert to user(userID,Role) and userID is auto increament. it works true. i want to get the userID with out parameters but i dont know how?!
my procedure query :
CREATE DEFINER=`root`@`localhost` PROCEDURE `Insert_User`(IN `Role` INT(1))
BEGIN
INSERT INTO user(UserID, Role)VALUES(null, Role);
END
i called it by php code:
if(isset($_POST['sbm'])) { $pass = '1050585712'; $role = $_POST['user']; switch($role) { case 0 :$role = 0;break; case 1 :$role = 1;break; case 2 :$role = 2;break; case 3 :$role = 3;break; case 4 :$role = 4;break; default:$role = 3;break; } if($con = mysqli_connect("localhost", "root", $pass)) { mysqli_select_db($con, "toggery"); mysqli_set_charset($con, "utf8"); $p = $con -> prepare("CALL Insert_User(?)"); $p -> bind_param('i', $role); $p -> execute(); } else { echo 'db connection error!'; } }
What I have tried:
how can i get UserID by php?
and how should i change the procedure query for do this?
解决方案
_POST['sbm'])) {
pass = '1050585712';
role =
这篇关于如何从程序中获取用户ID?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文