时间戳

首页 > 解决方案 > 隐藏字段属性未从 PHP 文件添加到 mysqli 表

php - 隐藏字段属性未从 PHP 文件添加到 mysqli 表

问题描述

我需要将 HTML 文件中隐藏字段属性的数据发送到 mysqli mariadb SQL 表。由于某种原因，数据没有被发送到表中。这是应该将数据发送到表的 PHP 文件的代码：

require_once ("settings.php");
    $conn = @mysqli_connect($host,
    $user,
    $pwd,
    $sql_db
);

if (!$conn){
    echo $errMsg = $errMsg. "<p>Database connection failure</p>";
} 
    $sql_table="orders";
    $fname = trim($_POST["fname"]);
    $lname = trim($_POST["lname"]);
    $email = trim($_POST["email"]);
    $address = trim($_POST["address"]);
    $suburb = trim($_POST["suburb"]);
    $state = trim($_POST["state"]);
    $postcode = trim($_POST["postcode"]);
    $mobile = trim($_POST["mobile"]);
    $prefContact = trim($_POST["contact"]);
    $plan = trim($_POST["plan"]);
    $option = trim($_POST["option"]);
    $months = trim($_POST["months"]);
    $install = trim($_POST["install"]);
    $creditName = trim($_POST["creditName"]);
    $creditNumber = trim($_POST["creditNumber"]);
    $creditExpiry = trim($_POST["creditExpiry"]);
    $CVV = trim($_POST["CVV"]);

    $query = "INSERT INTO `orders`(`first_name`, `last_name`) VALUES ('testName2', $lname)";
    $result = mysqli_query($conn, $query);
    if(!'result'){
        echo "<p class=\"wrong\">Something is wrong with ", $query, "</p>";
    } else {
        echo "<p class=\"ok\">Succesfully added a new order to records</p>";
        //header('Location: receipt.php');
    }
mysqli_close($conn);

我输入的值是 1）一个测试字符串，看看是否仅仅是我没有正确获取变量和 2）我尝试插入另一个变量。

标签： phphtmlmysqli

解决方案

像这样使用...

$query = "INSERT INTO订单SET名姓='".$testName2."',姓='".$lname."'"; $result = mysqli_query($conn, $query);

推荐阅读