· 10 years ago · Jan 30, 2016, 10:24 PM
1
2// COPIAR CODIGO A PARTIR DE ACA
3// pastebin.com/u/luidat
4
5// OBTENER EN JSON
6$app->get('/alumnos/:nombre', function($nombre){
7 $sql="SELECT * FROM alumnos";
8 $db=getConnection();
9 $stmt=$db->query($sql);
10 $alumnos=$stmt->fetchAll(PDO::FETCH_OBJ);
11 echo json_encode($alumnos);
12});
13// CREAR
14$app->post('/alumnos','fnpost');
15
16function fnpost(){
17 $request=\Slim\Slim::getInstance()->request();
18 $body=json_decode($request->getBody());
19 $sql="INSERT INTO alumnos values(null,:A, :B, :C)";
20 $db=getConnection();
21 $stmt=$db->prepare($sql);
22 $stmt->bindParam("A",$body->nombre);
23 $stmt->bindParam("B",$body->apellido);
24 $stmt->bindParam("C",$body->edad);
25 $stmt->execute();
26 echo "Se registro elemento";
27}
28// ACTUALIZAR
29$app->put('/alumnos','fnupdate');
30function fnupdate(){
31 $request=\Slim\Slim::getInstance()->request();
32 $body=json_decode($request->getBody());
33 $sql="UPDATE alumnos SET nombre=:b WHERE id=:a";
34 $db=getConnection();
35 $stmt=$db->prepare($sql);
36 $stmt->bindParam(":a",$body->id);
37 $stmt->bindParam(":b",$body->nombre);
38 $stmt->execute();
39 echo "Se actualizo elemento.";
40}
41
42$app->delete('/alumnos/:code','fndelete');
43function fndelete($code) {
44 $sql="DELETE FROM alumnos WHERE id=:a";
45 $db=getConnection();
46 $stmt=$db->prepare($sql);
47 $stmt->bindParam(":a",$code);
48 $stmt->execute();
49 echo 'The register with id '.$code.' has been deleted';
50 }
51function getConnection(){
52$dbhost="127.0.0.1";
53$dbuser="root";
54$dbpass="";
55$dbname="dbsidet";
56$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname;charset=utf8",$dbuser,$dbpass);
57$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
58return $dbh;
59}
60
61$app->run();
62/// SCRIP BASE DE DATOS
63/*
64CREATE DATABASE IF NOT EXISTS `dbsidet` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci;
65USE `dbsidet`;
66
67-- --------------------------------------------------------
68
69--
70-- Estructura de tabla para la tabla `alumnos`
71--
72
73CREATE TABLE IF NOT EXISTS `alumnos` (
74 `id` int(4) NOT NULL AUTO_INCREMENT,
75 `nombre` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
76 `apellido` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
77 `edad` int(2) NOT NULL,
78 PRIMARY KEY (`id`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci AUTO_INCREMENT=9 ;
80
81--
82-- Volcado de datos para la tabla `alumnos`
83--
84
85INSERT INTO `alumnos` (`id`, `nombre`, `apellido`, `edad`) VALUES
86(1, 'LUCHO', 'ALBERTO', 43),
87(3, 'ENRIQUE', 'CRUZ', 38),
88(4, 'JULIA', 'IGLESIAS', 23),
89(5, 'ROMULO', 'ROMERO', 39),
90(6, 'ALEJANDRA', 'DIAZ', 54),
91(7, 'LUCHO', 'ALBERTO', 43);
92*/