2PMVwtfj

1
2//   COPIAR CODIGO A PARTIR DE ACA
3//   pastebin.com/u/luidat
4
5
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
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
29$app->delete('/alumnos/:code','fndelete');
30function fndelete($code) {
31    $sql="DELETE FROM alumnos WHERE id=:a";
32    $db=getConnection();
33    $stmt=$db->prepare($sql);
34    $stmt->bindParam(":a",$code);
35    $stmt->execute();
36    echo 'The register with id '.$code.' has been deleted';
37    }
38function getConnection(){
39$dbhost="127.0.0.1";
40$dbuser="root";
41$dbpass="";
42$dbname="dbsidet";
43$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname;charset=utf8",$dbuser,$dbpass);
44$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
45return $dbh;
46}
47
48$app->run();
49///       SCRIP BASE DE DATOS
50/*
51CREATE DATABASE IF NOT EXISTS `dbsidet` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci;
52USE `dbsidet`;
53
54-- --------------------------------------------------------
55
56--
57-- Estructura de tabla para la tabla `alumnos`
58--
59
60CREATE TABLE IF NOT EXISTS `alumnos` (
61  `id` int(4) NOT NULL AUTO_INCREMENT,
62  `nombre` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
63  `apellido` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
64  `edad` int(2) NOT NULL,
65  PRIMARY KEY (`id`)
66) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci AUTO_INCREMENT=9 ;
67
68--
69-- Volcado de datos para la tabla `alumnos`
70--
71
72INSERT INTO `alumnos` (`id`, `nombre`, `apellido`, `edad`) VALUES
73(1, 'LUCHO', 'ALBERTO', 43),
74(3, 'ENRIQUE', 'CRUZ', 38),
75(4, 'JULIA', 'IGLESIAS', 23),
76(5, 'ROMULO', 'ROMERO', 39),
77(6, 'ALEJANDRA', 'DIAZ', 54),
78(7, 'LUCHO', 'ALBERTO', 43); 
79*/