使用id_user和密码登录到mysql数据库上的表用户 [英] Php login with id_user and password to table users on mysql database

问题描述

我正在用PHP（Web服务）编写一个CRUD函数来将我的android应用程序连接到Mysql数据库，我收到一条错误消息意味着当我尝试执行我的php登录功能的代码时用户名和密码不正确。



DbOperation.php

I'm coding a CRUD functions with php (Web Service) to connect my android application to Mysql database , i getting an error message mean that username and password are incorrect when i try executing the code of my php login function .

DbOperation.php

function createUser($id_user, $nom, $prenom, $email, $password){
	//	$password = md5($password);
		$stmt = $this->con->prepare("INSERT INTO users (id_user, nom, prenom, email, password) VALUES (?, ?, ?, ?, ?)");
		$stmt->bind_param("issss", $id_user, $nom, $prenom, $email, $password);
		if($stmt->execute())
			return true; 
		return false; 
	}
			public function userLogin($id_user, $password){
			$password = md5($password);
			$stmt = $this->con->prepare("SELECT id_user FROM users WHERE id_user = ? AND password = ?");
			$stmt->bind_param("is",$id_user,$password);
			$stmt->execute();
			$stmt->store_result(); 
			return $stmt->num_rows > 0; 
		}
	public function getUserById($id_user){
			$stmt = $this->con->prepare("SELECT * FROM users WHERE id_user = ?");
			$stmt->bind_param("i",$id_user);
			$stmt->execute();
			return $stmt->get_result()->fetch_assoc();
		}

UserLogin.php

UserLogin.php

 <?php 

require_once '../includes/DbOperation.php';

$response = array(); 

if($_SERVER['REQUEST_METHOD']=='POST'){
	if(isset($_POST['id_user']) and isset($_POST['password'])){
		$db = new DbOperation(); 

		if($db->userLogin($_POST['id_user'], $_POST['password'])){
			$user = $db->getUserById($_POST['id_user']);
			$response['error'] = false; 
			$response['id_user'] = $user['id_user'];
			$response['password'] = $user['password'];
		}else{
			$response['error'] = true; 
			$response['message'] = "Invalid Id or Password";			
		}

	}else{
		$response['error'] = true; 
		$response['message'] = "Required fields are missing";
	}
}

echo json_encode($response);

Api.php

Api.php

case 'getuserbyid':
				isTheseParametersAvailable(array('id_user'));
				$db = new DbOperation();
				$response['error'] = false; 
				$response['message'] = 'Request successfully completed';
				$response['users'] = $db->getUserById($_POST['id_user']);
			break;

我尝试过什么：



我尝试在邮递员上执行UserLogin.php的代码，我输入值但我收到此消息：



无效的身份证或密码



但我的id_user和密码是正确的

What I have tried:

I try to execute the code of UserLogin.php on postman , i enter values but i get this message :

Invalid Id or Password

But my id_user and password are correct

推荐答案

id_user，

nom，

prenom，

这篇关于使用id_user和密码登录到mysql数据库上的表用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！