mysql - Slim API，连接后不起作用

Question

我正在尝试制作一个 API。我已经按照 OpenClassRoom 中的教程使用 MySQL 发出请求，并且我想要一个带有 Slim v3.2 的 API。所以我收到了连接的答案，但是当我想从 get 中恢复数据时，我遇到了“Slim Application Error”，我不知道该怎么做。我使用 MAMP 而不是“php -S localhost:8080 -t public public/index.php ”，因为我与数据库的连接良好。我向您展示我的 API:

<?php
use \Psr\Http\Message\ServerRequestInterface as Request;
use \Psr\Http\Message\ResponseInterface as Response;

require '/Users/kravennagen/Downloads/Api/api/racehistory/vendor/autoload.php';

$app = new \Slim\App();
echo "hello";
try{
    $bdd = new PDO('mysql:host=localhost;dbname=racehistory;charset=utf8', 'root', 'root', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
    echo "connexion...";
}
catch(Exception $e){
    die('Erreur connexion BDD:' . $e->getMessage());
}
echo "avant le get";
$app->get('/', function(){
  $reponse = $bdd->query('SELECT * FROM user');
  while($data = $reponse->fetch()){
    echo $data['mail'];
    echo $data['password'];
  }
  $reponse->closeCursor();
});
$app->get('/connexion/{identifiant}/{password}', function($login, $pass){
    $reponseMail = $bdd->query('SELECT mail FROM user');
    $reponsePass = $bdd->query('SELECT password FROM user');
  echo "test1";
    While($donnees = $reponseMail->fetch() && $donnees = $reponsePass->fetch()){
        if($donnees['mail'] == $login && $donnees['password'] == $pass){
      echo "true";
            //return true;
        }
        else{
      echo "false";
            //return false;
        }
    }
$reponsePass->closeCursor();
$reponseMail->closeCursor();
});

$app->get("/register/{identifiant}/{password}", function($login, $pass){
    $add = 'INSERT INTO user(mail, password) VALUES ($login, $pass)';

    if(!preg_match("#^[a-z0-9._-]+@[a-z0-9._-]{2,}\.[a-z]{2,4}$#", $login))
       $errors['mail'] = 'adresse mail non valide';

    else if (!preg_match("#^(?=.*[A-Z])(?=.*[a-zA-Z])(?=.*\d)([\w]{8,15})$#", $pass))
       $errors['password'] = "le mot de passe n'est pas conforme(majuscule au debut, de 8 a 15 caractères)";

    else if($bdd->exec($add) === false){
        echo "ERREUR INSERTION";
    }
    else{
        echo "User bien ajouté la base de donnée";
    }
});
$app->run();
?>

Answer 1

您必须使用“use”将您的 $bdd 连接对象注入(inject)路由:

$app->get('/', function() use ($bdd) {