{"id":35765,"date":"2015-02-09T11:21:16","date_gmt":"2015-02-09T17:21:16","guid":{"rendered":"http:\/\/webirix.com\/?p=35765"},"modified":"2015-06-08T07:56:44","modified_gmt":"2015-06-08T12:56:44","slug":"crear-una-conexion-a-una-base-de-datos-php-mysql","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/crear-una-conexion-a-una-base-de-datos-php-mysql\/","title":{"rendered":"Create a connection to a php mysql database"},"content":{"rendered":"

\"php-mysql-project\"<\/a><\/h3>\n

\u00bfQu\u00e9 tengo que hacer?<\/strong><\/h3>\n

MySQL es el sistema gestor de bases de datos de c\u00f3digo abierto m\u00e1s popular en la actualidad. MySQL est\u00e1 disponible para distintos sistemas operativos, como Linux, Mac OS X, Solaris, Windows y otros m\u00e1s. MySQL es muy popular en el desarrollo de aplicaciones web, ya que forma parte como sistema gestor de bases de datos de las plataformas LAMP<\/abbr>, BAMP<\/abbr>, MAMP<\/abbr> Y WAMP<\/abbr>.<\/p>\n

Este simple ejemplo muestra como conectar, ejecutar una consulta, imprimir las filas resultantes y desconectar a una base de datos MySQL.<\/p>\n

\n

Ejemplo #1 Ejemplo general de la extensi\u00f3n MySQL<\/strong><\/p>\n

\n
<?php
\n\/\/\u00a0Conectando,\u00a0seleccionando\u00a0la\u00a0base\u00a0de\u00a0datos
\n$link\u00a0=\u00a0mysql_connect('mysql_host',\u00a0'mysql_user',\u00a0'mysql_password')
\nor\u00a0die('No\u00a0se\u00a0pudo\u00a0conectar:\u00a0'\u00a0.\u00a0mysql_error());
\necho\u00a0'Connected\u00a0successfully';
\nmysql_select_db('my_database')\u00a0or\u00a0die('No\u00a0se\u00a0pudo\u00a0seleccionar\u00a0la\u00a0base\u00a0de\u00a0datos');<\/code><\/div>\n<\/div>\n<\/div>\n

\/\/\u00a0Realizar\u00a0una\u00a0consulta\u00a0MySQL
\n$query\u00a0=\u00a0‘SELECT\u00a0*\u00a0FROM\u00a0my_table’;
\n$result\u00a0=\u00a0mysql_query($query)\u00a0or\u00a0die(‘Consulta\u00a0fallida:\u00a0‘\u00a0.\u00a0mysql_error());<\/p>\n

\/\/\u00a0Imprimir\u00a0los\u00a0resultados\u00a0en\u00a0HTML
\necho “<table>\\n”;
\nwhile\u00a0($line\u00a0=\u00a0mysql_fetch_array($result,\u00a0MYSQL_ASSOC))\u00a0{
\necho “\\t<tr>\\n”;
\nforeach\u00a0($line\u00a0as\u00a0$col_value)\u00a0{
\necho “\\t\\t<td>$col_value<\/td>\\n”;
\n}
\necho “\\t<\/tr>\\n”;
\n}
\necho “<\/table>\\n”;<\/p>\n

\/\/\u00a0Liberar\u00a0resultados
\nmysql_free_result($result);<\/p>\n

\/\/\u00a0Cerrar\u00a0la\u00a0conexi\u00f3n
\nmysql_close($link);
\n?><\/p>\n

<\/div>\n
Para obtener los datos de la base de datos, es necesario seguir los pasos del siguiente tutorial:<\/div>\n
– http:\/\/webirix.com\/crear-base-de-datos\/<\/div>","protected":false},"excerpt":{"rendered":"

That I have to do? MySQL is the most popular open source database management system today. MySQL is available for different operating systems, such as Linux, Mac OS X, Solaris, Windows, and more. MySQL is very popular in the development of web applications, since it is part of the management system ...<\/p>","protected":false},"author":2,"featured_media":35766,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2013,2014],"tags":[],"class_list":["post-35765","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-disenoweb","category-programacionweb"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2015\/02\/php-mysql-project.gif","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=35765"}],"version-history":[{"count":4,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35765\/revisions"}],"predecessor-version":[{"id":37362,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/35765\/revisions\/37362"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/35766"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=35765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=35765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=35765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}