Slim Framework+Angular开发CRUD应用遇404/500错误求助

Hey there! Let's work through your problems step by step—since you're new to Slim Framework, these are super common hiccups when getting started, so we'll get you sorted.

1. 404 Error When Accessing Edit Page #

First, let's tackle the blank edit page and 404 error:

• Verify Slim Route Configuration: Make sure you have a GET route defined for editing authors that exactly matches the URL your Angular app navigates to. For example, if your frontend links to /authors/edit/1, your Slim route should look like:

  $app->get('/authors/edit/{id}', function ($request, $response, $args) {
      $author = getAuthor($args['id']);
      return $response->withJson($author); // Return data for Angular to render
  });
  

  Double-check for typos (like missing pluralization, extra slashes) that might break route matching.
• Fix Your getAuthor SQL Query: The code you shared cuts off at WHER—make sure you complete the query with valid syntax and proper parameter binding (critical for security and avoiding errors):

  function getAuthor($id) {
      global $pdo; // Or pass your DB connection properly instead of using global
      $sql = "SELECT * FROM authors WHERE id = ?";
      $stmt = $pdo->prepare($sql);
      $stmt->execute([$id]);
      return $stmt->fetch(PDO::FETCH_ASSOC);
  }
  

• Angular Routing Check: If you're using Angular's PathLocationStrategy (no # in URLs), your server needs to rewrite all non-file/directory requests to index.php. This is where your .htaccess becomes essential—we'll cover that next.

2. 500 Internal Server Error on POST (Add Author) #

For the 500 error when adding authors, let's dig into the most likely causes:

• Validate Your POST Route: Ensure you have a properly defined POST route in Slim that handles incoming author data:

  $app->post('/authors', function ($request, $response) {
      $data = $request->getParsedBody();
      // First validate required fields
      if (!isset($data['name']) || empty($data['name'])) {
          return $response->withJson(['error' => 'Name is required'], 400);
      }
      // Execute insert query with parameter binding
      $sql = "INSERT INTO authors (name, email) VALUES (?, ?)";
      $stmt = $pdo->prepare($sql);
      $stmt->execute([$data['name'], $data['email']]);
      return $response->withJson(['id' => $pdo->lastInsertId()], 201);
  });
  

• Enable Database Error Reporting: For PDO connections, turn on exception mode to catch database-related issues (like missing fields or syntax errors):

  $pdo = new PDO($dsn, $user, $pass, [
      PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  ]);
  

• Turn On Slim's Debug Mode: Add error middleware to your Slim bootstrap file (index.php) to see detailed error messages instead of a generic 500:

  $app = Slim\Factory\AppFactory::create();
  // Enable detailed error reporting for development
  $errorMiddleware = $app->addErrorMiddleware(true, true, true);
  

  This will show you exactly what's breaking (e.g., undefined variable, SQL syntax mistake).

3. .htaccess Configuration Check #

Since you suspect .htaccess, let's confirm you're using the correct setup for Slim. Place this file in your public directory (the web root where index.php lives):

RewriteEngine On
# Rewrite all requests that aren't files/directories to index.php
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^ index.php [QSA,L]

Also, make sure:

• Apache's mod_rewrite module is enabled (check via phpinfo() or your server admin panel)
• Your Apache virtual host allows .htaccess overrides with AllowOverride All for your web root directory.

Quick Debug Tips #

• Test your API endpoints directly with tools like Postman or curl (bypass Angular) to isolate if the issue is in the backend or frontend.
• Check your server's error logs (Apache error log, PHP error log) for detailed traces—this is often the fastest way to find the root cause.

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