{"id":24418,"date":"2025-01-31T01:15:54","date_gmt":"2025-01-31T01:15:54","guid":{"rendered":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/"},"modified":"2025-06-16T12:08:37","modified_gmt":"2025-06-16T12:08:37","slug":"programacion-con-php-y-mysql","status":"publish","type":"product","link":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/","title":{"rendered":"PROGRAMACI\u00d3N CON PHP Y MYSQL"},"content":{"rendered":"

1. INSTALACI\u00d3N
\n 1.1. Introducci\u00f3n
\n 1.2. Obtener el paquete XAMPP
\n 1.3. Instalar el paquete XAMPP
\n 1.4. Apache y MySQL como servicios
\n 1.5. Resumen de la instalaci\u00f3n<\/p>\n

2. CREAR UN SITIO WEB
\n 2.1. \u00bfC\u00f3mo funcionan las p\u00e1ginas PHP?
\n 2.2. Crear un alias en Apache
\n 2.3. Crear un sitio en Dreamweaver
\n 2.4. La p\u00e1gina principal<\/p>\n

3. INTRODUCCI\u00d3N A PHP
\n 3.1. Las etiquetas PHP
\n 3.2. Variables
\n 3.3. Tipos de datos
\n 3.4. Constantes<\/p>\n

4. ARRAYS Y ESTRUCTURAS DE CONTROL
\n 4.1. Arrays
\n 4.2. Estructuras de repetici\u00f3n
\n 4.3. Estructuras de decisi\u00f3n
\n 4.4. Combinar estructuras<\/p>\n

5. FUNCIONES
\n 5.1. Introducci\u00f3n
\n 5.2. Crear funciones
\n 5.3. Llamar a una funci\u00f3n
\n 5.4. Paso de par\u00e1metros
\n 5.5. Par\u00e1metros por defecto<\/p>\n

6. INCLUIR ARCHIVOS
\n 6.1. \u00c1mbito de las variables
\n 6.2. Variables est\u00e1ticas
\n 6.3. Uso de include y require
\n 6.4. Incluir una sola vez
\n 6.5. Seguridad de los archivos incluidos<\/p>\n

7. PROGRAMACI\u00d3N ORIENTADA A OBJETOS (I)
\n 7.1. Introducci\u00f3n
\n 7.2. Clases
\n 7.3. Propiedades
\n 7.4. M\u00e9todoss<\/p>\n

8. PROGRAMACI\u00d3N ORIENTADA A OBJETOS (II)
\n 8.1. Visibilidad
\n 8.2. Crear objetos
\n 8.3. Destructores<\/p>\n

9. RECOGER DATOS DEL USUARIO (I)
\n 9.1. Introducci\u00f3n
\n 9.2. La directiva eliminada register_globals
\n 9.3. El array $_GET
\n 9.4. El array $_POST<\/p>\n

10. RECOGER DATOS DEL USUARIO (II)
\n 10.1. Recoger datos del usuario (II)
\n 10.2. Recogerlos en la misma p\u00e1gina
\n 10.3. Entradas requeridas<\/p>\n

11. VALIDACI\u00d3N DE FORMULARIOS
\n 11.1. Expresiones regulares
\n 11.2. Limpiando la informaci\u00f3n
\n 11.3. Comprobar el formulario de origen<\/p>\n

12. TRABAJAR CON COOKIES
\n 12.1. Introducci\u00f3n
\n 12.2. Crear cookies
\n 12.3. Caducidad de las cookies
\n 12.4. Dependencia del navegador
\n 12.5. Caracter\u00edsticas de las cookies<\/p>\n

13. SESIONES EN PHP
\n 13.1. \u00bfQu\u00e9 es una sesi\u00f3n?
\n 13.2. El array $_SESSION
\n 13.3. Finalizar la sesi\u00f3n
\n 13.4. El identificador de las sesiones
\n 13.5. \u00bfD\u00f3nde se almacena la informaci\u00f3n de sesi\u00f3n?<\/p>\n

14. ACCESO A ARCHIVOS
\n 14.1. Introducci\u00f3n
\n 14.2. Crear el archivo
\n 14.3. Escribir en el archivo
\n 14.4. Leer de un archivo<\/p>\n

15. TRATAMIENTO DE ERRORES
\n 15.1. Introducci\u00f3n
\n 15.2. Nivel de registro de errores
\n 15.3. Mensajes de error personalizados
\n 15.4. Lanzar errores
\n 15.5. Guardar los errores en un registro<\/p>\n

16. BASES DE DATOS
\n 16.1. MySQL
\n 16.2. Contrase\u00f1a para el root
\n 16.3. Extensi\u00f3n mysqli
\n 16.4. PHP MyAdmin
\n 16.5. Administraci\u00f3n de usuarios<\/p>\n

17. LA BASE DE DATOS DE EJEMPLO
\n 17.1. Tipos de tablas en MySQL
\n 17.2. Crear tablas
\n 17.3. Relaciones 1 a muchos
\n 17.4. Relaciones muchos a muchos<\/p>\n

18. EL LENGUAJE SQL
\n 18.1. Introducci\u00f3n
\n 18.2. La setencia SELECT
\n 18.3. Selecciones complejas
\n 18.4. Funciones agregadas
\n 18.5. La sentencia INSERT
\n 18.6. La setencia UPDATE
\n 18.7. La setencia DELETE<\/p>\n

19. ACCEDER A LA BASE DE DATOS
\n 19.1. Introducci\u00f3n
\n 19.2. Establecer la conexi\u00f3n
\n 19.3. Mostrar los datos en una tabla
\n 19.4. Cerrar la conexi\u00f3n
\n 19.5. Mejorar el aspecto<\/p>\n

20. BUSCANDO M\u00c1S FUNCIONALIDAD
\n 20.1. Ordenar el resultado
\n 20.2. Dividir el resultado en p\u00e1ginas
\n 20.3. Consultas preparadas<\/p>\n

21. AUTENTICACI\u00d3N DE LOS USUARIOS
\n 21.1. La p\u00e1gina de login
\n 21.2. La p\u00e1gina de registro
\n 21.3. Asegurar la confidencialidad<\/p>\n

22. EL PROCESO DE COMPRA (I)
\n 22.1. Introducci\u00f3n
\n 22.2. Modificar listaproductos.php
\n 22.3. La p\u00e1gina comprar.php
\n 22.4. Identificar al cliente<\/p>\n

23. EL PROCESO DE COMPRA (II)
\n 23.1. La p\u00e1gina carritocompra.php
\n 23.2. Confirmar el pedido
\n 23.3. La p\u00e1gina de desconexi\u00f3n
\n 23.4. Migrar el carrito de la compra
\n 23.5. Probar la compra<\/p>\n","protected":false},"excerpt":{"rendered":"

Crear y mantener bases de datos con el gestor de BBDD MySQL.<\/p>\n","protected":false},"featured_media":24101,"template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[48],"product_tag":[],"class_list":["post-24418","product","type-product","status-publish","has-post-thumbnail","product_cat-informatica-y-comunicaciones","first","instock","virtual","taxable","purchasable","product-type-simple"],"yoast_head":"\nPROGRAMACI\u00d3N CON PHP Y MYSQL -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PROGRAMACI\u00d3N CON PHP Y MYSQL -\" \/>\n<meta property=\"og:description\" content=\"Crear y mantener bases de datos con el gestor de BBDD MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaliser\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T12:08:37+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/\",\"name\":\"PROGRAMACI\u00d3N CON PHP Y MYSQL -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"datePublished\":\"2025-01-31T01:15:54+00:00\",\"dateModified\":\"2025-06-16T12:08:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"width\":587,\"height\":506},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/programacion-con-php-y-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/abexis.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursos\",\"item\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/cursos-online-profesionales-y-subvencionados\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PROGRAMACI\u00d3N CON PHP Y MYSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"name\":\"Formaliser\",\"description\":\"Formaci\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/abexis.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\",\"name\":\"Formaliser\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"width\":1000,\"height\":295,\"caption\":\"Formaliser\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PROGRAMACI\u00d3N CON PHP Y MYSQL -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/","og_locale":"es_ES","og_type":"article","og_title":"PROGRAMACI\u00d3N CON PHP Y MYSQL -","og_description":"Crear y mantener bases de datos con el gestor de BBDD MySQL.","og_url":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/","og_site_name":"Formaliser","article_modified_time":"2025-06-16T12:08:37+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/","url":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/","name":"PROGRAMACI\u00d3N CON PHP Y MYSQL -","isPartOf":{"@id":"https:\/\/abexis.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/#primaryimage"},"image":{"@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","datePublished":"2025-01-31T01:15:54+00:00","dateModified":"2025-06-16T12:08:37+00:00","breadcrumb":{"@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/#primaryimage","url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","width":587,"height":506},{"@type":"BreadcrumbList","@id":"https:\/\/abexis.es\/index.php\/product\/programacion-con-php-y-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/abexis.es\/"},{"@type":"ListItem","position":2,"name":"Cursos","item":"https:\/\/abexis.es\/index.php\/cursos-online-profesionales-y-subvencionados\/"},{"@type":"ListItem","position":3,"name":"PROGRAMACI\u00d3N CON PHP Y MYSQL"}]},{"@type":"WebSite","@id":"https:\/\/abexis.es\/#website","url":"https:\/\/abexis.es\/","name":"Formaliser","description":"Formaci\u00f3n","publisher":{"@id":"https:\/\/abexis.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/abexis.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/abexis.es\/#organization","name":"Formaliser","url":"https:\/\/abexis.es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/","url":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","width":1000,"height":295,"caption":"Formaliser"},"image":{"@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product\/24418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media\/24101"}],"wp:attachment":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media?parent=24418"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_brand?post=24418"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_cat?post=24418"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_tag?post=24418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}