Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require 'config.php';
- require 'Slim/Slim.php';
- $dns = "mysql:host=localhost;dbname=geoclock";
- $user = "root";
- $pass = "";
- try {
- $con = new PDO($dns, $user, $pass);
- if(!$con){
- echo "No se puede conectar a la base de datos";
- }
- $query = $con->prepare('SELECT * FROM marcas order by marca_id desc limit 1');
- $query->execute();
- $registros = "[";
- while($result = $query->fetch()){
- if ($registros != "[") {
- $registros .= ",";
- }
- $registros .= '{"marca_id": "'.$result["marca_id"].'"}';
- }
- $registros .= "]";
- echo $registros;
- } catch (Exception $e) {
- echo "Erro: ". $e->getMessage();
- };
- mysql_close();
- ?>
Add Comment
Please, Sign In to add comment