时间戳

首页 > 解决方案 > PHP，将表单数据插入 MYSQLi

php - PHP，将表单数据插入 MYSQLi

问题描述

我在创建此登录系统时遇到问题。当有人登录时，我希望它创建一个表，如果还没有的话。然后将它们带到表单页面，然后插入数据。在最后一页插入之前，我一切正常。

Steam API 登录后

<?php
    session_start();
    require ('../../../mysql_connect/mysqli_connect_accounts.php');
    require ('../steamauth/steamauth.php');
    require ('../steamauth/userInfo.php');
    $steamid=$_SESSION['steamid'];
    
    $query = "SELECT * FROM `".$steamid."`";
    
    $response = @mysqli_query($dbc, $query);
    
if($response){
        header("Location: http://theskindealer.com/index.php");
    } else {    
        $create = "CREATE TABLE `".$steamid."` (
        steam64 VARCHAR(30), 
        fullname VARCHAR(60),
        tradeurl VARCHAR(60),
        email VARCHAR(50),
        age INT(3),
        tos INT(1),
        access INT(1),
        freeze INT(1),
        balance DECIMAL(9,2),
        newsletter INT(1),
        emailVerified INT(1)
        )";
        if ($dbc->query($create) === TRUE) {
        
            header("Location: http://theskindealer.com/scripts/createAccount.php");

        } else {
            header("Location: http://theskindealer.com/pages/errorlogin.php");
        }
}
$stmt->close();
$dbc->close();
    
?>

然后它重定向到表单页面：

<!DOCTYPE HTML>

<?php
session_start();
require ('../../../mysql_connect/mysqli_connect_accounts.php');
require ('../steamauth/steamauth.php');
require ('../steamauth/userInfo.php');
$steamid=$_SESSION['steamid'];
?>

<html>
<head>
<title>TheSkinDealer | Setup</title>
<link rel="stylesheet" type="text/css" href="../css/accept.css"></head><body>
<div id="content">
<div id="acceptbox">
<img src="../images/logo.png">
<form action="setup.php" method="post">
        
<div id="name1">Full Name:</br> <input type="text" name="fullname"> </br></div>
<div id="name1">TradeURL: <a target="_blank" href="http://steamcommunity.com/id/me/tradeoffers/privacy#trade_offer_access_url">(?)</a></div> <input type="text" name="tradeurl"> </br>
<div id="name1">EMAIL:</div> <input type="text" name="email"> </br>
<div id="checkboxes">
<a href="http://theskindealer.com/tos/tos.php" target="_blank">Terms Of Serice</a>:  <input type="checkbox" name="tos" value="1"> </br>
18 Or Older:  <input type="checkbox" name="age" value="1"></br>
Newsletter:  <input type="checkbox" name="newsletter" value="1"></br>
</div>
<div id="returnhome">
<div id="accept"><input type="submit" value="Create Account"></a></div>
</div>
</form>
</div>
<center><div id="par">Purchases Or Sales Cannot Be Made Without Accepting TOS.</div></center>
</div>
</body>
</html>

最后插入页面：

<?php
    session_start();
    require ('../../../mysql_connect/mysqli_connect_accounts.php');
    require ('../steamauth/steamauth.php');
    require ('../steamauth/userInfo.php');
    $steamid=$_SESSION['steamid'];
        
            $insert = "INSERT INTO `".$steamid."` (steam64, freeze, access, 
tos, balance, age, email, tradeurl, fullname, newsletter, emailVerified) 
                       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            $stmt = $dbc->prepare($insert);
            $stmt->bind_param('sssssssssss', 
                $steam64, 
                $freeze, 
                $access, 
                $tos, 
                $balance, 
                $age, 
                $email, 
                $tradeurl, 
                $fullname,
                $newsletter,
                $emailVerified
            );
            
            $steam64 = $steamid;
            $freeze = 0;
            $access = 0;
            $tos = $_POST["tos"];
            $balance = 0.00;
            $age = $_POST["age"];
            $email = $_POST["email"];
            $tradeurl = $_POST["tradeurl"];
            $fullname = $_POST["fullname"];
            $newsletter = $_POST["newsletter"];
            $emailVerified = 0;
            $stmt->execute();
        
            header("Location: http://theskindealer.com/");
$stmt->close();
$dbc->close();
    
?>

标签： phphtmlmysqlformsmysqli

解决方案

执行此脚本时是否遇到任何错误？例如，您可以添加error_reporting(E_ALL);到脚本的顶部以更好地查看错误。

查看脚本，您似乎在变量存在之前就绑定了它们。您应该将变量分配放在执行之前bind_param：

    $steam64 = $steamid;
    $freeze = 0;
    $access = 0;
    $tos = $_POST["tos"];
    $balance = 0.00;
    $age = $_POST["age"];
    $email = $_POST["email"];
    $tradeurl = $_POST["tradeurl"];
    $fullname = $_POST["fullname"];
    $newsletter = $_POST["newsletter"];
    $emailVerified = 0;



   $stmt->bind_param('sssssssssss', 
        $steam64, 
        $freeze, 
        $access, 
        $tos, 
        $balance, 
        $age, 
        $email, 
        $tradeurl, 
        $fullname,
        $newsletter,
        $emailVerified
    );

    $stmt->execute();

还要记住，像 0 这样的数值必须与 'i' 而不是 's' 绑定，有关更多信息，请参见http://php.net/manual/de/mysqli-stmt.bind-param.php。

例如。

   $stmt->bind_param('iiisdissssi',

推荐阅读