php 如何将sql数据库的内容写入表单

<code class="php">$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// 使用mysqli连接
$conn = mysqli_connect($servername, $username, $password, $dbname);

// 使用PDO（推荐）
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);</code>

<code class="sql">SELECT name, email FROM users WHERE id = ?</code>

<code class="php">// 使用mysqli
$id = 1;
$stmt = $conn->prepare("SELECT name, email FROM users WHERE id = ?");
$stmt->bind_param("i", $id);

// 使用PDO
$id = 1;
$stmt = $conn->prepare("SELECT name, email FROM users WHERE id = ?");
$stmt->bindParam(1, $id, PDO::PARAM_INT);</code>

<code class="php">$stmt->execute();</code>

<code class="php">// 使用mysqli
$name = "";
$email = "";
$stmt->bind_result($name, $email);

// 使用PDO
$name = "";
$email = "";
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $email);</code>

<code class="php">while ($stmt->fetch()) {
  echo "<input type='text' name='name' value='$name' />";
  echo "<input type='text' name='email' value='$email' />";
}</code>

<code class="php">$stmt->close();
$conn->close();</code>