点击按钮无法向PHP数据库插入值，求助解决action未定义索引错误

Hey there! I totally get how frustrating it is to hit a roadblock when you're just starting out with PHP—let's get this sorted out together. That "Undefined index: action" error means your PHP script is trying to access the action parameter (from either $_GET or $_POST) but that parameter isn't being sent when you click your image button. Here's how to fix it step by step:

1. Make Sure Your Frontend Sends the action Parameter #

First, let's check how your image button is set up. Since it's a button with an image, you need to ensure clicking it passes the action value to your PHP script. Here are two common scenarios:

If you're using a form: #

Wrap your button in a form and add a hidden input to carry the action value:

<form method="POST" action="/Applications/MAMP/htdocs/back-end/Development/your-script.php">
  <!-- Hidden input to send the action -->
  <input type="hidden" name="action" value="like">
  <button type="submit">
    <img src="your-like-image.png" alt="Like this content">
  </button>
</form>

If you're using a link (GET request): #

Turn the image into a clickable link that includes the action parameter in the URL:

<a href="/Applications/MAMP/htdocs/back-end/Development/your-script.php?action=like">
  <img src="your-like-image.png" alt="Like this content">
</a>

2. Add a Check in Your PHP Script #

Even if you fix the frontend, it's good practice to verify the action parameter exists before using it. This prevents the "Undefined index" error and makes your code more robust.

For POST requests: #

// First, check if the action parameter exists and is set to "like"
if (isset($_POST['action']) && $_POST['action'] === 'like') {
  // Now run your database insertion code
  try {
    $pdo = new PDO('mysql:host=localhost;dbname=your-database-name', 'username', 'password');
    $stmt = $pdo->prepare("INSERT INTO ic_likes (your-column-names) VALUES (your-values)");
    $stmt->execute();
    echo "Like added successfully!";
  } catch(PDOException $e) {
    echo "Error inserting like: " . $e->getMessage();
  }
}

For GET requests: #

If you used the link approach above, replace $_POST with $_GET:

if (isset($_GET['action']) && $_GET['action'] === 'like') {
  // Your insertion code here
}

3. Check for JavaScript Interference (If Applicable) #

If you're using JavaScript/AJAX to handle the button click instead of a form or link, make sure your AJAX request includes the action parameter in the data being sent. For example:

document.querySelector('.like-button').addEventListener('click', function(e) {
  e.preventDefault();
  fetch('/Applications/MAMP/htdocs/back-end/Development/your-script.php', {
    method: 'POST',
    headers: {
      'Content-Type': 'application/x-www-form-urlencoded',
    },
    // Include the action parameter here
    body: 'action=like'
  })
  .then(response => response.text())
  .then(result => console.log(result))
  .catch(error => console.error('Error:', error));
});

By following these steps, you should eliminate that "Undefined index" error and get your like button inserting values into the ic_likes database correctly.

内容的提问来源于stack exchange，提问作者Lucas Verhoest