时间戳

首页 > 解决方案 > 无法将 php 密码字段上传到 phpmyAdmin

javascript - 无法将 php 密码字段上传到 phpmyAdmin

问题描述

我有一个 HTML 表单，它接受用户的名字、姓氏、用户名和密码，我正在将这些值上传到我的本地phpMyAdmin，但我无法将密码字段上传到数据库中。

这是我的 HTML 代码

<input type="text" name="first" required placeholder="John*">
<input type="text" name="last" required placeholder="Doe*">
<input type="text" name="username" id="vname" placeholder="jondoe11*" />
<input type="password" name="pass" id="vpassword" placeholder="*****" />

和我的 php 文件

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "credentials";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {      
    die("Connection failed: ");  
}  else
{    echo "connnected";  }

$first = $_POST['first'];
$last = $_POST['last'];
$user = $_POST['username'];
$password = $_POST['pass'];


$sql =$conn->prepare('INSERT INTO users (username, password, first, last) values(?,?,?,?)');
$sql->bind_param('ssss', $user,$password,$first,$last);
$val = $sql->execute();
?>

我可以成功输入除密码字段之外的所有值。请帮忙

标签： javascriptphpcsshtmlphpmyadmin

解决方案

您有$password用于数据库连接的变量，并且还为数据传递访问相同的变量。我将数据变量更改为$user_password. 希望这对你有用。

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "credentials";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {      
    die("Connection failed: ");  
}  else
{    echo "connnected";  }

$first = $_POST['first'];
$last = $_POST['last'];
$user = $_POST['username'];
$user_password = $_POST['pass'];


$sql =$conn->prepare('INSERT INTO users (username, password, first, last) values(?,?,?,?)');
$sql->bind_param('ssss', $user,$user_password,$first,$last);
$val = $sql->execute();
?>

推荐阅读