超薄框架REST服务两次获得输出
我正在使用SLIM框架用php创建一个REST服务。一切都很正常,但有一些奇怪的地方。我总是得到两倍或三倍的数据。以下是我的index.php:
<?php
require 'Slim/Slim.php';
SlimSlim::registerAutoloader();
$app = new SlimSlim();
if($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
header( "HTTP/1.1 200 OK" );
exit();
}
function getConnection() {
try {
$db_username = "root";
$db_password="admin";
$conn = new PDO('mysql:host=localhost;dbname=dats24', $db_username);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
return $conn;
}
$app->get('/problem/find/:id/','getProblem'); // Using Get HTTP Method and process getUser function
$app->get('/problem/find-all/','getProblems'); // Using Get HTTP Method and process getUsers function
$app->post('/problem/add/', 'addProblem'); // Using Post HTTP Method and process addUser function
$app->delete('/problem/delete/:id','deleteProblem'); // Using Delete HTTP Method and process deleteUser function
$app->run();
function getProblems() {
$sql_query = "select * FROM problems ORDER BY Station";
try {
$dbCon = getConnection();
$stmt = $dbCon->query($sql_query);
$problems = $stmt->fetchAll(PDO::FETCH_OBJ);
$dbCon = null;
echo '{"probfems": ' . json_encode($problems) . '}';
}
catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
function getProblem($id) {
$sql = "SELECT * FROM problems WHERE idproblems=:id";
try {
$dbCon = getConnection();
$stmt = $dbCon->prepare($sql);
$stmt->bindParam("id", $id);
$stmt->execute();
$problem = $stmt->fetchObject();
$dbCon = null;
echo json_encode($problem);
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
function addProblem() {
global $app;
$postdata = file_get_contents("php://input");
echo $postdata;
$req = json_decode($postdata);; // Getting parameter with names
$paramName = $req->station; // Getting parameter with names
$paramAdres = $req->address; // Getting parameter with names
$paramCity = $req->city;// Getting parameter with names
$parampostal = $req->postalcode;
$parampic = $req->pictureOfDamage;
$paramdescrip= $req->description;
$sql = "INSERT INTO problems (Station,Address,Postalcode,City,PictureOfDamage,Description) VALUES (:station,:address,:postalcode,:city,:pictureOfDamage,:description)";
try {
$dbCon = getConnection();
$stmt = $dbCon->prepare($sql);
$stmt->bindParam(':station', $paramName);
$stmt->bindParam(':address', $paramAdres);
$stmt->bindParam(':city', $paramCity);
$stmt->bindParam(':postalcode', $parampostal);
$stmt->bindParam(':pictureOfDamage', $parampic);
$stmt->bindParam(':description', $paramdescrip);
$stmt->execute();
$dbCon = null;
echo json_encode("toegevoegd ");
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
function deleteProblem($id) {
$sql = "DELETE FROM problems WHERE idproblems=:id";
try {
$dbCon = getConnection();
$stmt = $dbCon->prepare($sql);
$stmt->bindParam("id", $id);
$stmt->execute();
$dbCon = null;
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
$app->run();
我选择哪种方法(如/Find-all)将其作为输出(数据库当前为空):
{"problems": []}{"problems": []}{"problems": []}
如果我预先形成一个帖子,它会将它两次添加到数据库中。更奇怪的是,当我输入错误的URL时,我会收到双重的404错误。
作为最后一次,这是我的.htaccess文件
RewriteEngine On
RewriteBase /Dats24/
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [QSA,L]
Header always set Access-Control-Allow-Origin "*"
Header always set Access-Control-Allow-Methods "PUT, GET, POST, DELETE, OPTIONS"
Header always set Access-Control-Allow-Headers "Origin, X-Requested-With, Content-Type, Access-Control-Allow-Origin"
方法被调用的次数不会超过我检查它的一次。我真的不知道问题出在哪里。提前感谢您的帮助:)
解决方案
这是因为您有多行:
$app->run();
每一个都执行应用程序的整个逻辑,并提供全部输出。
在配置路由、中间件等之后,Run方法应始终只执行一次。
奇怪的是,我在Slim docs...
中找不到此信息(或有关Slim类的Run方法的任何内容)...相关文章