$app->response()->header('Content-Type', 'application/json'); echo json_encode($layersAvailable); }); // Créer les points de terminaison API foreach ($xml_reqs as $req) { $endPoint = sprintf('/layers/%s', $req['name']); $app->get($endPoint, function () use($app, $req) { $httpReq = $app->request; $env = $app->environment(); $dbh = $env['db_conn']; $lon = floatval($app->request->params("x")); $lat = floatval($app->request->params("y")); if (validWKT($lon) == false || validWKT($lat) == false) { throw new Exception("Format des points incorrect", 1); } $query = $dbh->query(bindParams((string) $req->sql, $lat, $lon), PDO::FETCH_OBJ); $oResult = $query->fetch(PDO::FETCH_OBJ); if ($oResult == FALSE) { throw new Exception(sprintf("Aucun résultat pour le point [x=%s y=%s]", $lon, $lat), 1); } $app->response()->header('Content-Type', 'application/json'); echo json_encode($oResult); }); } /** @todo : tout layers d'un coup ? */ $app->run(); } catch (Exception $ex) { echo json_encode(array('result' => false, 'message' => $ex->getMessage())); } /** *
public static function updateOrInsertVerifyCode($phone, $code) { $sql = "SELECT count(1) from VerifyCode where phone=?"; bindParams($sql, array($phone)); $count = db_fetch_value($sql); $date = date('Y-m-d H:i:s', time()); if ($count > 0) { $sql = "UPDATE VerifyCode set status=0, time=?, code=? where phone=?"; bindParams($sql, array($date, $code, $phone)); $r = db_execute($sql); return $r; } $sql = "INSERT INTO VerifyCode(phone, code, status, time) VALUES(?, ?, 0, ?)"; bindParams($sql, array($phone, $code, $date)); $r = db_execute($sql); return $r; }