echo insert mysql_mysql第一次insert成功,第二次!$result,echo "数据写入失败";同样的代码...

require'fns/select_fns.php';if(!isset($_SESSION['username'])){echo"用户没有登录";exit();}$menuid=$_REQUEST['menu_id'];$applicationid=$_REQUEST['application_id'];$userid=g...

require 'fns/select_fns.php';

if (!isset($_SESSION['username'])){

echo "用户没有登录";

exit();

}

$menuid=$_REQUEST['menu_id'];

$applicationid=$_REQUEST['application_id'];

$userid=get_userid($db);

$query="select application_id from user_application_list where user_id='$userid' and application_id='$applicationid'";

$result=$db->query($query);

if ($result->num_rows>0){

echo "ok";

exit();

}

$query="insert into user_application_list(user_id,menu_id,application_id) values('$userid','$menuid','$applicationid')";

//$query="insert into user_application_list(user_id,menu_id,application_id) values('$userid','$menuid','$applicationid')";

$result=$db->query($query);

if (!$result){

echo "数据写入失败";

exit();

}

echo "成功添加";

更改userid 的话，第一次成功，第二次又不成功

展开