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条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥88 实在没有想法,需要个思路
    • ¥15 python中合并修改日期相同的CSV文件并按照修改日期的名字命名文件
    • ¥15 有赏,i卡绘世画不出
    • ¥15 如何用stata画出文献中常见的安慰剂检验图
    • ¥15 c语言链表结构体数据插入
    • ¥40 使用MATLAB解答线性代数问题
    • ¥15 COCOS的问题COCOS的问题
    • ¥15 FPGA-SRIO初始化失败
    • ¥15 MapReduce实现倒排索引失败
    • ¥15 ZABBIX6.0L连接数据库报错,如何解决?(操作系统-centos)