dousidan1279 2018-08-04 03:01
浏览 48
已采纳

$ _POST不工作PHP(没有错误)[重复]

I need some help with PHP. $_POST is not working in PHP. I'm using MAMP on Mac.

I have no errors returned, no data stored in my DB.

My DB username and password are not switched because I set the password as 'root'.

<?php
$conn = mysqli_connect('localhost', 'juicysoft', 'root', 'PublicFiles');
$uname = $_POST['uname'];
$pword = $_POST['pword'];
$email = $_POST['email'];
$sql = 'INSERT INTO users (uname, pword, email) VALUES ($uname, $pword, 
$email)';
mysqli_query($conn, $sql);
if (mysqli_connect_errno()) {
    echo mysqli_connect_error();
} else {
echo "Success!";
}

?>

<!-- The form that I need to post -->

<!DOCTYPE html>
<html>
<head>
    <title>PublicFiles - Register</title>
</head>
<body>
<h1>Register</h1>
<form action="process.php" method="post">
    <input type="text" name="uname" placeholder="Screen Name..."><br>
    <input type="password" name="pword" placeholder="Password..."><br>
    <input type="email" name="email" placeholder="Email..."><br>
    <input type="submit" value="Sign Up">
</form>
</body>
</html>

</div>
  • 写回答

1条回答 默认 最新

  • dongshiru5913 2018-08-04 03:06
    关注

    Your $sql is written incorrect,

    Change

    $sql = 'INSERT INTO users (uname, pword, email) VALUES ($uname, $pword, 
    $email)';
    

    to

    $sql = "INSERT INTO users (uname, pword, email) VALUES ('".$uname."','".$pword."','".$email."')";
    

    NOTE: Set parameter directly into sql may cause SQL Injection,you had better use prepared statement to do it

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥35 MIMO天线稀疏阵列排布问题
  • ¥60 用visual studio编写程序,利用间接平差求解水准网
  • ¥15 Llama如何调用shell或者Python
  • ¥20 谁能帮我挨个解读这个php语言编的代码什么意思?
  • ¥15 win10权限管理,限制普通用户使用删除功能
  • ¥15 minnio内存占用过大,内存没被回收(Windows环境)
  • ¥65 抖音咸鱼付款链接转码支付宝
  • ¥15 ubuntu22.04上安装ursim-3.15.8.106339遇到的问题
  • ¥15 blast算法(相关搜索:数据库)
  • ¥15 请问有人会紧聚焦相关的matlab知识嘛?