我正在制作一个应用程序,与我的网站共享相同的数据库。我在整个活动期间维护登录会话,并且可以获得用户名,但是如何从正在登录的用户那里获得用户ID(PK)呢?我得到了所有的表很好地创建,我可以与应用程序和网站的数据库进行通信。请帮帮我
//PHP文件
if($_SERVER['REQUEST_METHOD']=='POST'){
//Getting values
$email = $_POST['email'];
$password = $_POST['password'];
//Creating sql query
$sql = "SELECT * FROM Utilizadores WHERE email='$email' AND password='$password'";
//importing dbConnect.php script
require_once('connection.php');
//executing query
$result = mysqli_query($con,$sql);
//fetching result
$check = mysqli_fetch_array($result);
//if we got some result
if(isset($check)){
//displaying success
echo "success";
}else{
//displaying failure
echo "failure";
}
mysqli_close($con);
}
//安卓文件
public class Config {
//URL to our login.php file
public static final String LOGIN_URL = "http://192.168.1.43/Teste/login.php";
//Keys for email and password as defined in our $_POST['key'] in login.php
public static final String KEY_EMAIL = "email";
public static final String KEY_PASSWORD = "password";
public static final String KEY_ID = "id_utilizador";
//If server response is equal to this that means login is successful
public static final String LOGIN_SUCCESS = "success";
//Keys for Sharedpreferences
//This would be the name of our shared preferences
public static final String SHARED_PREF_NAME = "myloginapp";
//This would be used to store the email of current logged in user
public static final String EMAIL_SHARED_PREF = "email";
//This would be used to store the id of current logged in user
public static final String ID_SHARED_PREF = "id_utilizador";
//We will use this to store the boolean in sharedpreference to track user is loggedin or not
public static final String LOGGEDIN_SHARED_PREF = "loggedin";
}
据我所知,您希望检索服务器端变量(userID)。如果登录成功,你可以让你的服务器输出这个变量,然后解析来自Android应用的服务器响应。