Slim Framework - 如何在正常函数中查询db

Question

I'm very new to PHP and Slim Framework which helps creating APIs. Everything is ok If i query db inside $app->post or get. But I want to separate it to normal function. It will help when I need to use it later in other APIs.

I tried to call this

$app->get('/search/[{phone}]', function($request, $response, $args) use ($app){
    $token = $response->getHeader('token');
    // $phone = $args['phone'];
    if (isTokenValid($token)){
        return $this->response->withJson("valid");
    }
    return $this->response->withJson("invalid");

});

My isTokenValid() function

function isTokenValid($token){
    $sql = 'SELECT id FROM users WHERE token = :token';
    $s = $app->db->prepare($sql); //<< this line 25
    $s->bindParam(':token', $token);
    if ($s->execute()){
        if($sth->rowCount() > 0){
            return true;
        }
    }
    return false;
}

But I get 500 Internal Server Error

Type: Error
Message: Call to a member function prepare() on null
File: /Applications/MAMP/htdocs/aigoido/src/functions.php
Line: 25

How to call it outside $app? Thanks.

Answer 1

Pass $app to your function as parameter. The function has it own context so $app is not available without that.

function isTokenValid($token, $app){
    $sql = 'SELECT id FROM users WHERE token = :token';
    $s = $app->db->prepare($sql); //<< this line 25
    $s->bindParam(':token', $token);
    if ($s->execute()){
        if($sth->rowCount() > 0){
            return true;
        }
    }
    return false;
}