带 while 循环的 PHP 表单
我在生成可以打印基于 SQL 查询的表单的页面时遇到了一些麻烦。在这种情况下，我需要执行一个查询来列出表中名称为 Porcac1x 的所有行。内容需要是显示当前变量值并且可以更新的输入字段。这正是我陷入困境的地方。如何创建一个基于 php while 循环的可变表单？使用附加的代码，我可以列出内容并显示所有变量，但我在创建表单操作来更新值时遇到麻烦。我想澄清的是，我并不关心安全性，因为代码将在本地环境中运行，我是唯一有权访问的人。
这是当前输出
但是保存按钮当然不起作用
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="description" content="$1">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" type="text/css" href="style.css">
<title>test page</title>
</head>
<body><form action="" method="post">
<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "root";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `id`, `title`, `amount` FROM `expenses` WHERE name='Porcac1x';";
$result = $conn->query($sql);
森栏1回答
-
慕码人8056858
要使其发挥作用，您将需要数组符号。（或每行 1 个表格）这是每行 1 个表单元素的解决方案：<html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="description" content="$1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" type="text/css" href="style.css"> <title>test page</title></head> <body> <?php $servername = "localhost"; $username = "root"; $password = "root"; $dbname = "root"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT `id`, `title`, `amount` FROM `expenses` WHERE name='Porcac1x';"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo '<form method="post">'; echo "ID: <input type='text' name='id' value='".$row["id"]."'> Title: <input type='text' name='title' value='".$row["title"]."'> Amount: <input type='text' name='amount' value='".$row["amount"]."'> <button type='submit' name='save'>Save</button><br>"; echo '</form>'; } } else { echo "0 results"; } if(isset($_POST['save'])){ $myID = $_POST["id"];//??? < Issue $myTitle = $_POST["title"];//??? < Issue $myAmount = $_POST["amount"]; //??? < Issue echo $myID; echo $myTitle; echo $myAmount; $sqlUpdate = "UPDATE expenses SET title='$myTitle', amount ='$myAmount' WHERE id='$myID';"; echo $sqlUpdate; if ($conn->multi_query($sqlUpdate) === TRUE) { echo "Record updated successfully"; $risposta= "Record updated successfully"; } else { echo "Error updating record: " . $conn->error; $risposta= "Error updating record: " . $conn->error; } $conn->close(); } ?> </body></html>
随时随地看视频慕课网APP
PHP