php根据输入读取数据库,PHP根据输入回显数据库中的所有数据

我想了解如何根据单个键从数据库输出数据,例如我的数据库列是:

kodeDosen(PrimaryKey),namaDosen,电子邮件,电话,密码

和我的登录屏幕上,用户只能输入kodeDosen和密码,而我想显示其他数据,除了密码,这是我的注册php:

include 'connectdb.php';

$data = json_decode(file_get_contents('php://input'), true);

$kodeDosen =$data["kodeDosen"];

$namaDosen = $data["namaDosen"];

$email = $data["email"];

$telepon = $data["telepon"];

$password= $data["password"];

$message = array("message"=>"Success");

$failure = array("message"=>"Failure,kodeDosen already used");

$sql = "INSERT INTO tbl_dosen (kodeDosen, namaDosen, email, telepon, password) VALUES ('$kodeDosen', '$namaDosen', '$email', '$telepon','$password')";

if (mysqli_query($conn, $sql)) {

echo json_encode($message);

} else {

echo json_encode($failure) ;

}

?>

这是我的登录php:

include 'connectdb.php';

$data = json_decode(file_get_contents('php://input'), true);

$kodeDosen =$data["kodeDosen"];

$password = $data["password"];

$message = array("message"=>"Data found");

$failure = array("mesage"=>"Data not found");

if ($stmt = mysqli_prepare($conn, "SELECT kodeDosen, namaDosen, email, telepon FROM tbl_dosen WHERE kodeDosen =? and password = ?")) {

/* bind parameters for markers */

mysqli_stmt_bind_param($stmt, "ss", $kodeDosen,$password);

/* execute query */

mysqli_stmt_execute($stmt);

/* store result */

mysqli_stmt_store_result($stmt);

if(mysqli_stmt_num_rows($stmt) > 0) {

echo json_encode($row);

}else {

echo json_encode($failure);

}

}

?>

解决方法:

我想你想要echo json_encode($row);而不是echo json_encode($message);

尝试:

include 'connectdb.php';

$data = json_decode(file_get_contents('php://input'), true);

$kodeDosen =$data["kodeDosen"];

$password = $data["password"];

$message = array("message"=>"Data found");

$failure = array("mesage"=>"Data not found");

if ($stmt = mysqli_prepare($conn, "SELECT kodeDosen, namaDosen, email, telepon FROM tbl_dosen WHERE kodeDosen =? and password = ?")) {

/* bind parameters for markers */

mysqli_stmt_bind_param($stmt, "ss", $kodeDosen,$password);

/* execute query */

mysqli_stmt_execute($stmt);

/* store result */

$result = mysqli_stmt_get_result($stmt);

$row = mysqli_fetch_assoc( $result );

if(mysqli_num_rows($result) > 0) {

echo json_encode($row);

}else {

echo json_encode($failure);

}

}

?>

标签:arrays,php,database

来源: https://codeday.me/bug/20191109/2012035.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值