{"id":3035,"date":"2012-06-16T18:56:25","date_gmt":"2012-06-16T18:56:25","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=3035"},"modified":"2012-08-30T18:36:12","modified_gmt":"2012-08-30T18:36:12","slug":"interactuar-con-una-base-de-datos-utilizando-mysqli","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/","title":{"rendered":"Interactuar con una base de datos utilizando Mysqli"},"content":{"rendered":"<p>En este art\u00edculo vamos a hacer una introducci\u00f3n a Mysqli, una de las opciones disponibles a la hora de desarrollar una aplicaci\u00f3n PHP que necesite interactuar con una base de datos MySQL.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-3036\" title=\"mysqli\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\" alt=\"\" width=\"218\" height=\"218\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg 218w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli-150x150.jpg 150w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli-80x80.jpg 80w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli-180x180.jpg 180w\" sizes=\"auto, (max-width: 218px) 100vw, 218px\" \/><\/a>La extensi\u00f3n <em>mysqli<\/em>, o como a veces se le conoce, la extensi\u00f3n de MySQL <em>mejorada<\/em>, se desarroll\u00f3 para aprovechar las nuevas funcionalidades encontradas en los sistemas MySQL con versi\u00f3n 4.1.3 o posterior. La extensi\u00f3n <em>mysqli<\/em> viene incluida en las versiones PHP 5 y posteriores.<\/p>\n<p>La extensi\u00f3n <em>mysqli<\/em> contiene numerosos beneficios, siendo estas las mejoras principales respecto a la extensi\u00f3n <em>mysql<\/em>:<\/p>\n<ul>\n<li>Interfaz orientada a objetos aunque tambi\u00e9n con posibilidad de utilizar procedimientos.<\/li>\n<li>Soporte para m\u00faltiples declaraciones<\/li>\n<li>Soporte para transacciones<\/li>\n<li>Mejoradas las opciones de depuraci\u00f3n<\/li>\n<li>Soporte para servidor empotrado<\/li>\n<\/ul>\n<p>Si utiliza MySQL versi\u00f3n 4.1.3 o superior, se recomienda <em>encarecidamente<\/em> utilizar esta extensi\u00f3n.<\/p>\n<p>Vamos a ver algunos ejemplos:<\/p>\n<p>Para conectar con una base de datos deber\u00eda ejecutar la siguiente sentencia:<\/p>\n<pre>$conexion = new mysqli(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);<\/pre>\n<p>Para obtener una tupla o columna de una tabla de la base de datos:<\/p>\n<pre>$result = $conexion-&gt;query(\"SELECT name FROM users WHERE user_id = 1);\r\n$coins = $result-&gt;fetch_assoc();<\/pre>\n<p>Para obtener varios campos de varios registros:<\/p>\n<pre>$result = $conexion-&gt;query(\"SELECT `planet_id`, `name` FROM `planets` ORDER BY planet_id\");\r\nif ($result-&gt;num_rows &gt; 0) {\r\n\u00a0\u00a0 \u00a0while ($row_planets = $result-&gt;fetch_assoc()) {\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$planets[] = array('id' =&gt; $row_planets['planet_id'], 'name' =&gt; $row_planets['name']);\r\n\u00a0\u00a0 \u00a0}\r\n}<\/pre>\n<p>Para realizar una modificaci\u00f3n:<\/p>\n<pre>$update = \"UPDATE users SET last_update = now() WHERE user_id = 1\";\r\n$conexion-&gt;query($update);<\/pre>\n<p>Para eliminar un registro:<\/p>\n<pre>$conexion-&gt;query(\"delete from users where id_user = 1\");<\/pre>\n<p>Puede encontrar documentaci\u00f3n m\u00e1s extensa <a href=\"http:\/\/www.php.net\/manual\/es\/book.mysqli.php\" target=\"_blank\">aqu\u00ed<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo vamos a hacer una introducci\u00f3n a Mysqli, una de las opciones disponibles a la hora de desarrollar una aplicaci\u00f3n PHP que necesite interactuar con una base de datos MySQL. La extensi\u00f3n mysqli, o como a veces se le conoce, la extensi\u00f3n de MySQL mejorada, se desarroll\u00f3 para aprovechar las nuevas funcionalidades encontradas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3036,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3],"tags":[112],"class_list":["post-3035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-php","tag-registros"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo vamos a hacer una introducci\u00f3n a Mysqli, una de las opciones disponibles a la hora de desarrollar una aplicaci\u00f3n PHP que necesite interactuar con una base de datos MySQL. La extensi\u00f3n mysqli, o como a veces se le conoce, la extensi\u00f3n de MySQL mejorada, se desarroll\u00f3 para aprovechar las nuevas funcionalidades encontradas [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-16T18:56:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-08-30T18:36:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"218\" \/>\n\t<meta property=\"og:image:height\" content=\"218\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/\",\"name\":\"Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\",\"datePublished\":\"2012-06-16T18:56:25+00:00\",\"dateModified\":\"2012-08-30T18:36:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg\",\"width\":218,\"height\":218},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interactuar con una base de datos utilizando Mysqli\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog","og_description":"En este art\u00edculo vamos a hacer una introducci\u00f3n a Mysqli, una de las opciones disponibles a la hora de desarrollar una aplicaci\u00f3n PHP que necesite interactuar con una base de datos MySQL. La extensi\u00f3n mysqli, o como a veces se le conoce, la extensi\u00f3n de MySQL mejorada, se desarroll\u00f3 para aprovechar las nuevas funcionalidades encontradas [&hellip;]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2012-06-16T18:56:25+00:00","article_modified_time":"2012-08-30T18:36:12+00:00","og_image":[{"width":218,"height":218,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/","url":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/","name":"Interactuar con una base de datos utilizando Mysqli - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg","datePublished":"2012-06-16T18:56:25+00:00","dateModified":"2012-08-30T18:36:12+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/mysqli.jpg","width":218,"height":218},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/interactuar-con-una-base-de-datos-utilizando-mysqli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Interactuar con una base de datos utilizando Mysqli"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/3035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=3035"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/3035\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/3036"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=3035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=3035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=3035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}