PDO en la gestión de infraestructura educativa web: Caso de estudio atlas de Puebla

Violeta Martínez Ramírez; Susana Martínez Rabanales; Efrén Armando Osorio Ramírez; Teresa Luciano Machorro; Aldo Yahir Ara Mora

doi:10.61117/ipsumtec.v8i2.421

Authors

Violeta Martínez Ramírez National Technological Institute of Mexico https://orcid.org/0000-0003-1518-786X
Susana Martínez Rabanales National Technological Institute of Mexico
Efrén Armando Osorio Ramírez National Technological Institute of Mexico
Teresa Luciano Machorro National Technological Institute of Mexico
Aldo Yahir Ara Mora National Technological Institute of Mexico https://orcid.org/0009-0008-1746-4633

DOI:

https://doi.org/10.61117/ipsumtec.v8i2.421

Keywords:

software, Agile Methodology, PDO, Management of facilities, web

Abstract

The present technological research describes the development methodology used in creating the system "Atlas de Puebla de la Infraestructura Educativa", a web application for managing and consulting information about educational institutions in the state of Puebla. A step-by-step approach in the coding process is detailed, highlighting the key phases, the technologies used, and the methodological decisions that ensured the functionality and scalability of the project. The aim is to provide a clear view of how the application was built, from the initial conception of the modules to the implementation of its main features.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Author Biographies

Violeta Martínez Ramírez , National Technological Institute of Mexico

Dr. Violeta Martínez Ramírez, who studied Computer Systems Engineering in Programming, holds a Master's Degree in Education Sciences and a Doctorate in Education. She is a professor in the Systems and Computing Department at the Technological Institute of Puebla, teaching mainly Programming in Information Technology and Communications Engineering. She is a PRODEP Desirable Profile (2020), leader of the Academic Body “Applied Computing” (2021), and head of Outreach Projects (2020).

Susana Martínez Rabanales , National Technological Institute of Mexico

Susana Martínez Rabanales, MDU, has been a full-time professor in the Department of Systems and Computing at TecNM's Puebla campus since 1992. Education: Bachelor's degree in Computer Science (ITO) and Master's degree in University Teaching (Ibero Puebla). She teaches programming, algorithms, and data structures in various engineering programs. She coordinated the Computer Science and ICT Engineering programs from 1992 to 1994 and from 2014 to 2016. She has served as academic secretary on multiple occasions and is a candidate for PRODEP Master, awaiting certification.

Efrén Armando Osorio Ramírez , National Technological Institute of Mexico

Dr. Efrén Armando Osorio Ramírez has more than 30 years of experience in teaching, technological research, and senior public management. He holds a PhD in Business Planning and Regional Development, with master's degrees in Computer Systems and Administration. Since 1993, he has been a full-time professor at TecNM Campus Puebla and was a member of SNI Level 1, with extensive academic production and software development. He has held management positions at SEP Puebla, the Poblano Institute for Migrant Assistance, and is currently the administrative director at CAPCEE.

Teresa Luciano Machorro , National Technological Institute of Mexico

MI. Teresa Luciano Machorro is a professor at TecNM, Puebla campus, with a degree in Computer Systems Engineering and a Master's degree in Engineering. She has 21 years of professional experience in teaching and academic-administrative management. She has been a professor at IT Puebla at various times between 2015 and the present. She has held management positions as Academic Deputy Director at IT Atitalaquia and Coordinator of ICT Engineering at IT Puebla. She has also held positions at TecNM and DGEST, as well as teaching and heading Human Resources at IT Tlaxiaco.

Aldo Yahir Ara Mora , National Technological Institute of Mexico

Aldo Yahir Ara Mora is an Information and Communications Technology Engineer who graduated from the Technological Institute of Puebla. During his studies, he participated in the development of management systems for the National Technological Institute of Mexico and academic administration projects. With a particular interest in databases and programming, he currently works as an analyst at CAPCEE, providing technical and administrative support for the state's educational infrastructure.

References

Bretón Ángeles. ¿Cuántas escuelas públicas hay en Puebla? El Universal Puebla [Internet]. 2024 mayo 20 [citado 2025 jul 31]. Disponible en: https://www.eluniversalpuebla.com.mx/educacion/cuantas-escuelas-publicas-hay-en-puebla/

CAPCEE. Quiénes somos [Internet]. 2024 [citado 2025 ago 1]. Disponible en: https://capcee.puebla.gob.mx/

Folchini Sebbe VH. Segurança em Sistemas Web: Uma Análise da Extensão PDO como forma de Proteção de Sistemas PHP Contra Injeções de SQL [Internet]. Passo Fundo (BR): Instituto Federal de Educação, Ciência e Tecnologia Sul-rio-grandense - IFSUL; 2014 [citado 2025 ago 1]. Disponible en: https://painel.passofundo.ifsul.edu.br/uploads/arq/201603311637221874655301.pdf

Nakagawa WT. Segurança em aplicação Web: comparativo entre API MySQL e API PDO [Internet]. Americana (BR): Faculdade de Tecnologia de Americana; 2017 [citado 2025 ago 1]. Disponible en: http://ric.cps.sp.gov.br/handle/123456789/1916

Mendoza I, Franco V, Mera A, Muñoz V, Quiroz D. Sistema de subastas inglesa desarrollado con PHP POO PDO + MYSQL. Nexos Científicos [Internet]. 2022;6(2):42-6 [citado 2025 ago 1]. Disponible en: https://nexoscientificos.vidanueva.edu.ec/index.php/ojs/article/view/60/208

Villamil Rodríguez JH. Diseño e Implementación de un Sistema POS, con Módulo de Gestión de Inventario de Productos para Clientes y Perfiles de Usuario, Aplicando Metodología RUP [Internet]. Bogotá (CO): Universidad Nacional Abierta y a Distancia; 2021 [citado 2025 ago 1]. Disponible en: https://repository.unad.edu.co/bitstream/handle/10596/41806/jhvillamilr.pdf

Bastos, R. R., & de Magalhães, F. B. (2025). SQL Injection: Entendendo e evitando. Cuadernos de Educación y Desarrollo, 17(3), e7856-e7856. Mestre em Ciência da ComputaçãoInstituição: Universidade Federal de Pelotas. Pelotas, Brasil [consultado: 1 de agosto de 2025] Disponible en: https://ojs.cuadernoseducacion.com/ojs/index.php/ced/article/view/7856/5465 DOI: https://doi.org/10.55905/cuadv17n3-107

Inaba. Uso de PDO (PHP Data Objects) para la conexión y gestión de bases de datos en PHP [Internet]. República Dominicana; 2025 [citado 2025 jul 31]. Disponible en: https://www.inabaweb.com/uso-de-pdo-php-data-objects-para-la-conexion-y-gestion-de-bases-de-datos-en-php/

PHP. Introducción [Internet]. 2025 [citado 2025 ago 1]. Disponible en: https://www.php.net/manual/es/intro.pdo.php

Melendez Cahuas JA. Sistema web en la gestión de mantenimiento del taller automotriz VIP2CARS en el año 2024 [Internet]. Lima (PE): Universidad Tecnológica del Perú; 2025 [citado 2025 ago 1]. Disponible en: https://repositorio.utp.edu.pe/handle/20.500.12867/12873

González L, Eduardo J. Aplicación web de sistema de inventario para tiendas de artesanía del mercado de Chillán [Internet]. Chillán (CL): Universidad del Bío-Bío; 2015 [citado 2025 ago 1]. Disponible en: http://repobib.ubiobio.cl/jspui/handle/123456789/648

Cepeda GV, Santos EN, Santos JP, Yamamoto DH. Desenvolvimento de meios digitais para a biblioteca e os alunos: aplicação web [Internet]. 2023 [citado 2025 ago 1]. Disponible en: http://ric-cps.eastus2.cloudapp.azure.com/bitstream/123456789/12964/1/Desenvolvimento%20de%20meios%20digitais%20para%20a%20Biblioteca.pdf

sitePoint. Reintroduciendo la PDO – La forma correcta de acceder a las bases de datos en PHP [Internet]. 2025 [citado 2025 ago 1]. Disponible en: https://www.sitepoint.com/re-introducing-pdo-the-right-way-to-access-databases-in-php/

PHP. Introducción [Internet]. 2025 [citado 2025 ago 1]. Disponible en: https://www.php.net/manual/es/intro.pdo.php

CEIBOO. ¿Qué usar en un nuevo proyecto de PHP: PDO o MySQLi? [Internet]. 2021 [citado 2025 ago 1]. Disponible en: https://www.ceiboo.com/blog/que-usar-en-un-nuevo-proyecto-de-php-pdo-o-mysqli-5