使用php insert.php在mysql中插入数据时出错

debugcn 发表于 Dev

文森特·奥蒙迪

我在插入数据时遇到了挑战。一切检查...即连接到数据库。数据不能只是插入。我正在使用本地主机 xampp。我的insert.php

<?php
$servername = "localhost";
$username = "root";
$password = "Maweutah2";
$dbname = "digital_content";
 $link = mysqli_connect($servername, $username, $password, $dbname );
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}

// Escape user inputs for security
$ref = mysqli_real_escape_string($link, $_REQUEST['ref']);
$date = mysqli_real_escape_string($link, $_REQUEST['date']);
$name = mysqli_real_escape_string($link, $_REQUEST['name']);
$class = mysqli_real_escape_string($link, $_REQUEST['class']);
$serial = mysqli_real_escape_string($link, $_REQUEST['serial']);
$details = mysqli_real_escape_string($link, $_REQUEST['details']);
$remarks = mysqli_real_escape_string($link, $_REQUEST['remarks']);

// attempt insert query execution
$sql = "INSERT INTO laptop_repair (ref, name, class, serial, details, remark) VALUES ('$ref', '$date', '$name', '$class', '$serial', '$details', '$remarks')";
if(mysqli_query($link, $sql)){
    echo "<h2>Records added successfully<a href='laptop_repairs.php'>ENTER AGAIN</h2></a>.";
} else{
    echo "<h2>ERROR: TRY AGAIN <a href='db.php'>ENTER AGAIN</h2></a>";
}

// close connection
mysqli_close($link);
?>

我的表格

<!DOCTYPE html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<div class="center">
<h1>ENTER DETAILS</h1>
<form action="insert.php" method="POST">
<h3>REF NUMBER</h3><input type="text" name="ref" /><br>
<h3>DATE</h3><input type="text" name="date" /><br>
<h3>NAME</h3><input type="text" name="name" /><br>
<h3>CLASS</h3><input type="text" name="class" /><br>
<h3>SERIAL</h3><input type="text" name="serial" /><br>
<h3>DETAILS</h3><input type="text" class="inputmingi" name="details" /><br>
<h3>REMARKS</h3><input type="text" class="inputmingi" name="remarks" /><br>
<input type="submit" />

</form>

</div>
<div class="center">
<h1>MENU</h1>
<form action="view.php" method="POST">
<button type="submit">View records</button>
</form>
</div>
</html>

当我提交时，连接成功但我的表中没有插入数据。

纳什·弗拉兹

更新这个

$sql = "INSERT INTO laptop_repair (ref, date, name, class, serial, details, remark) VALUES ('$ref', '$date', '$name', '$class', '$serial', '$details', '$remarks')";

您忘记插入日期值。你没有在查询中提到。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。