douzuanze0486 2014-05-17 15:12
浏览 34

得到苗条框架的请求

I'm using the slim framework to build a restful web service. I have two tables with the following entries:

Table team
id_team    name
1          Brasil
2          England
3          Portugal

Table Person
id_pesorn id_team name     age ...
1          1       Rafinha 23  ...

and the following code:

require '../Slim/Slim/Slim.php';
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app->response()->header('Content-Type', 'application/json;charset=utf-8');

$app->get('/person/team/:name/:team','getPerson');
$app->run();

function getConn(){
...
}

function getPerson($name, $team){
    $conn = getConn();
    $sql = "SELECT id_team FROM team WHERE name=:team";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $pessoa = $stmt->fetchObject();

    $sql1 = "SELECT * FROM person WHERE id_team=".$pessoa->id_team."and name=:name";
    $stmt1 = $conn->prepare($sql1);
    $stmt1->bindParam("team", $team);
    $stmt1->bindParam("name", $name);
    $stmt1->execute();
    $pessoa1 = $stmt1->fetchObject();

    echo "{pessoas:".json_encode($pessoa1)."}";
}

when I call it by GET: localhost/services/pesorn/team/Rafinha/Brasil gives me a error:

Slim Application Error
Details

Type: ErrorException
Code: 2
Message: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
File: /Applications/XAMPP/xamppfiles/htdocs/aw014/webservice/services/index.php
Line: 38

but should return in JSON:

{"id_person":"1","id_team":"1","nome":"Rafinha","idade":"23",...}

I don't know what I'm doing wrong. Could anyone help me. Thanks.

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料