{"id":5312,"date":"2012-11-19T13:57:09","date_gmt":"2012-11-19T13:57:09","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=5312"},"modified":"2012-11-21T14:53:12","modified_gmt":"2012-11-21T14:53:12","slug":"mostrar-todas-las-tablas-de-una-base-de-datos","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/","title":{"rendered":"Mostrar todas las tablas de una base de datos MySQL"},"content":{"rendered":"<p>En este art\u00edculo vamos a ver una funci\u00f3n de PHP que nos permite mostrar todas las tablas de una base de datos seleccionada.<\/p>\n<p>Esta funci\u00f3n suele ser \u00fatil en momentos muy escasos pero si llegara la ocasi\u00f3n ser\u00eda interesante acordarse de ella. Se trata de la funci\u00f3n <strong>mysql_list_tables()<\/strong> que no hace m\u00e1s que lista las tablas de una base de datos MySQL.<\/p>\n<p>La funci\u00f3n devuelve una lista con el nombre de las tablas de una base de datos MySQL.<\/p>\n<p>La podr\u00edamos utilizar de la siguiente forma:<\/p>\n<pre>&lt;?php\r\nmysql_connect($dbhost, $dbuser, $dbpassword);\r\n\r\n$tablas = mysql_list_tables($dbname);\r\n\r\nwhile (list($tabla) = mysql_fetch_row($tablas)) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 echo $tabla.\"&lt;br \/&gt;\";\r\n} \r\n?&gt;<\/pre>\n<p>Donde conectamos a la base de datos deseada con sus 3 par\u00e1metros, creamos una variable donde vamos a guardar la lista de los nombres de la base de datos y recorremos esta lista mediante un bucle tradicional.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo vamos a ver una funci\u00f3n de PHP que nos permite mostrar todas las tablas de una base de datos seleccionada. Esta funci\u00f3n suele ser \u00fatil en momentos muy escasos pero si llegara la ocasi\u00f3n ser\u00eda interesante acordarse de ella. Se trata de la funci\u00f3n mysql_list_tables() que no hace m\u00e1s que lista las [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5280,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5312","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mostrar todas las tablas de una base de datos MySQL - 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=\"Mostrar todas las tablas de una base de datos MySQL - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo vamos a ver una funci\u00f3n de PHP que nos permite mostrar todas las tablas de una base de datos seleccionada. Esta funci\u00f3n suele ser \u00fatil en momentos muy escasos pero si llegara la ocasi\u00f3n ser\u00eda interesante acordarse de ella. Se trata de la funci\u00f3n mysql_list_tables() que no hace m\u00e1s que lista las [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/\" \/>\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-11-19T13:57:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-11-21T14:53:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"128\" \/>\n\t<meta property=\"og:image:height\" content=\"128\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\/mostrar-todas-las-tablas-de-una-base-de-datos\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/\",\"name\":\"Mostrar todas las tablas de una base de datos MySQL - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png\",\"datePublished\":\"2012-11-19T13:57:09+00:00\",\"dateModified\":\"2012-11-21T14:53:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png\",\"width\":128,\"height\":128},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mostrar todas las tablas de una base de datos MySQL\"}]},{\"@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":"Mostrar todas las tablas de una base de datos MySQL - 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":"Mostrar todas las tablas de una base de datos MySQL - Jose Aguilar Blog","og_description":"En este art\u00edculo vamos a ver una funci\u00f3n de PHP que nos permite mostrar todas las tablas de una base de datos seleccionada. Esta funci\u00f3n suele ser \u00fatil en momentos muy escasos pero si llegara la ocasi\u00f3n ser\u00eda interesante acordarse de ella. Se trata de la funci\u00f3n mysql_list_tables() que no hace m\u00e1s que lista las [&hellip;]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2012-11-19T13:57:09+00:00","article_modified_time":"2012-11-21T14:53:12+00:00","og_image":[{"width":128,"height":128,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png","type":"image\/png"}],"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\/mostrar-todas-las-tablas-de-una-base-de-datos\/","url":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/","name":"Mostrar todas las tablas de una base de datos MySQL - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png","datePublished":"2012-11-19T13:57:09+00:00","dateModified":"2012-11-21T14:53:12+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/11\/php2.png","width":128,"height":128},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/mostrar-todas-las-tablas-de-una-base-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Mostrar todas las tablas de una base de datos MySQL"}]},{"@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\/5312","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=5312"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/5312\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/5280"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=5312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=5312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=5312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}