php编程实战：小白轻松构建灵活高效的多对一通讯录代码示例

CREATE TABLE contacts (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  phone_number VARCHAR(20) NOT NULL
);

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$database = "contacts";
 
$conn = new mysqli($servername, $username, $password, $database);
 
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
?>

<?php
$results = $conn->query("SELECT * FROM contacts");
 
if ($results->num_rows > 0) {
  while ($row = $results->fetch_assoc()) {
    echo "ID: " . $row['id'] . " - Name: " . $row['name'] . " - Phone Number: " . $row['phone_number'] . "<br>";
  }
} else {
  echo "No contacts found.";
}
?>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $name = $_POST['name'];
  $phone_number = $_POST['phone_number'];
  
  $sql = "INSERT INTO contacts (name, phone_number) VALUES ('$name', '$phone_number')";
  
  if ($conn->query($sql) === TRUE) {
    echo "New contact added successfully.";
  } else {
    echo "Error: " . $sql . "<br>" . $conn->error;
  }
}
?>

<form method="post">
  Name: <input type="text" name="name"><br>
  Phone Number: <input type="text" name="phone_number"><br>
  <input type="submit" value="Add Contact">
</form>