{"id":333,"date":"2013-03-19T18:35:53","date_gmt":"2013-03-20T01:35:53","guid":{"rendered":"http:\/\/behstant.com\/blog\/?p=333"},"modified":"2013-06-08T10:23:57","modified_gmt":"2013-06-08T16:23:57","slug":"crear-una-conexion-a-mysql-con-pdo","status":"publish","type":"post","link":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/","title":{"rendered":"Crear una conexi\u00f3n a MySQL con PDO"},"content":{"rendered":"<p>Anteriormente hice un video donde muestro como realizar una conexi\u00f3n\u00a0a base de datos MySQL con PDO (<a title=\"Conecciones a Base de Datos con PHP\" href=\"http:\/\/behstant.com\/blog\/?p=167\" target=\"_blank\">http:\/\/behstant.com\/blog\/?p=167<\/a>), pero para aquellos que les gusta las cosas simples hago este post para mostrar c\u00f3mo\u00a0realizar un conexi\u00f3n\u00a0de una forma simple.<\/p>\n<p>El significado de PDO es PHP Data Objects, lo que significa que trabajamos con Programaci\u00f3n Orientada a Objetos (POO). Para poder trabajar con PDO necesitamos crear una instancia de la clase PDO. Algunos m\u00e9todos son: prepare, execute, exec, beginTransaction, bindParam, commit. Estos m\u00e9todos los voy ir tratando durante el resto de posts en el blog.<\/p>\n<p>Lo primero que tenemos que hacer antes de crear nuestra conexi\u00f3n es verificar que tenemos PDO disponible para trabajar, entonces con el siguiente c\u00f3digo verificamos que este habilitado. Copia y guarda el archivo con un nombre de phpinfo.php y lo ejecutas en tu servidor:<\/p>\n<pre class=\"brush: php; gutter: true\">&lt;?php \r\n\r\n\tphpinfo();\r\n\r\n?&gt;<\/pre>\n<p>Esta es la informaci\u00f3n que te debe de salir:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-335\" title=\"pdo_info\" src=\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\" alt=\"\" width=\"490\" height=\"215\" \/><\/a><\/p>\n<p>Si todo esta correcto entonces ahora si procedemos a crear nuestra conexi\u00f3n con la clase PDO usando el siguiente c\u00f3digo:<\/p>\n<pre class=\"brush: php; gutter: true\">&lt;?php\r\n\t\ttry {\r\n\t\t\t$conn = new PDO(&#039;mysql:host=localhost;dbname=pruebas&#039;,&#039;admin&#039;,&#039;12345&#039;);\r\n\t\t\techo &quot;Conexi\u00f3n realizada con \u00e9xito !!!&quot;;\r\n\t\t}\r\n\t\tcatch (PDOException $ex) {\r\n\t\t\techo $ex-&gt;getMessage();\r\n\t\t\texit;\r\n\t\t}\t\r\n?&gt;<\/pre>\n<p><!--more--><br \/>\nCuando se utiliza PDO o alg\u00fan otro c\u00f3digo de dispare una excepci\u00f3n (el termino en ingles es throw) se necesita agrupar el c\u00f3digo en un bloque try-catch, si todo marcha bien nuestro c\u00f3digo se ejecuta sin error, en dado caso de que salga algo mal agarramos el error en el catch.<\/p>\n<p>El siguiente c\u00f3digo merece la pena comentarlo un \u00a0poco m\u00e1s:<\/p>\n<pre class=\"brush: php; gutter: true\">catch (PDOException $ex) {\r\n\techo $ex-&gt;getMessage();\r\n\texit;\r\n}<\/pre>\n<p>Debemos de tener cuidado de que echo $ex-&gt;getMessage(); no est\u00e9 siempre visible, ya que si se presenta un error nuestro usuario de conexi\u00f3n o nuestra contrase\u00f1a puede ser mostrada, el uso de getMessage() es para que \u00a0nosotros podamos depurar nuestro c\u00f3digo, entonces lo que debemos de hacer es mostrar otro mensaje, quedando nuestro c\u00f3digo para ser usado de la siguiente manera :<\/p>\n<pre class=\"brush: php; gutter: true\">&lt;?php\r\n\t\ttry {\r\n\t\t\t$conn = new PDO(&#039;mysql:host=localhost;dbname=pruebas&#039;,&#039;admin&#039;,&#039;12345&#039;);\r\n\t\t\techo &quot;Conexi\u00f3n realizada con \u00e9xito !!!&quot;;\r\n\t\t}\r\n\t\tcatch (PDOException $ex) {\r\n\t\t\techo &quot;Sucedio un problema al realizar la conexi\u00f3n !!&quot;;\r\n\t\t\texit;\r\n\t\t}\t\r\n?&gt;<\/pre>\n<p>Ya con este c\u00f3digo tenemos un objeto PDO con el cual podemos empezar a interactuar con la base de datos, pero estar\u00e9 haciendo uso de nuestro objeto instanciado $conn en las siguientes posts.<\/p>\n<p>El\u00a0c\u00f3digo fuente de este ejemplo lo podemos observar y descargar de aqu\u00ed:\u00a0<a href=\"http:\/\/paste.behstant.com\/index.php?show=47\" target=\"_blank\">http:\/\/paste.behstant.com\/index.php?show=47<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anteriormente hice un video donde muestro como realizar una conexi\u00f3n\u00a0a base de datos MySQL con PDO (http:\/\/behstant.com\/blog\/?p=167), pero para aquellos que les gusta las cosas simples hago este post para mostrar c\u00f3mo\u00a0realizar un conexi\u00f3n\u00a0de una forma simple. El significado de PDO es PHP Data Objects, lo que significa que trabajamos con Programaci\u00f3n Orientada a Objetos &#8230; <a title=\"Crear una conexi\u00f3n a MySQL con PDO\" class=\"read-more\" href=\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\" aria-label=\"Read more about Crear una conexi\u00f3n a MySQL con PDO\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[20,31,29],"tags":[],"class_list":["post-333","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-howto","category-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Crear una conexi\u00f3n a MySQL con PDO &#187; The Code<\/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:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crear una conexi\u00f3n a MySQL con PDO &#187; The Code\" \/>\n<meta property=\"og:description\" content=\"Anteriormente hice un video donde muestro como realizar una conexi\u00f3n\u00a0a base de datos MySQL con PDO (http:\/\/behstant.com\/blog\/?p=167), pero para aquellos que les gusta las cosas simples hago este post para mostrar c\u00f3mo\u00a0realizar un conexi\u00f3n\u00a0de una forma simple. El significado de PDO es PHP Data Objects, lo que significa que trabajamos con Programaci\u00f3n Orientada a Objetos ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\" \/>\n<meta property=\"og:site_name\" content=\"The Code\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-20T01:35:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-06-08T16:23:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\" \/>\n<meta name=\"author\" content=\"Reedyseth\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Reedyseth\" \/>\n<meta name=\"twitter:site\" content=\"@Reedyseth\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reedyseth\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\"},\"author\":{\"name\":\"Reedyseth\",\"@id\":\"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f\"},\"headline\":\"Crear una conexi\u00f3n a MySQL con PDO\",\"datePublished\":\"2013-03-20T01:35:53+00:00\",\"dateModified\":\"2013-06-08T16:23:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\"},\"wordCount\":382,\"commentCount\":4,\"image\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\",\"articleSection\":[\"Base de Datos\",\"howto\",\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\",\"url\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\",\"name\":\"Crear una conexi\u00f3n a MySQL con PDO &#187; The Code\",\"isPartOf\":{\"@id\":\"http:\/\/behstant.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\",\"datePublished\":\"2013-03-20T01:35:53+00:00\",\"dateModified\":\"2013-06-08T16:23:57+00:00\",\"author\":{\"@id\":\"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f\"},\"breadcrumb\":{\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage\",\"url\":\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\",\"contentUrl\":\"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/behstant.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Crear una conexi\u00f3n a MySQL con PDO\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/behstant.com\/blog\/#website\",\"url\":\"http:\/\/behstant.com\/blog\/\",\"name\":\"The Code\",\"description\":\"Learn Web Solutions in WordPress, PHP, jand also purchase code solutions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/behstant.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f\",\"name\":\"Reedyseth\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g\",\"caption\":\"Reedyseth\"},\"description\":\"My Google Profile+\",\"sameAs\":[\"http:\/\/behstant.com\"],\"url\":\"https:\/\/behstant.com\/blog\/author\/reedyseth\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Crear una conexi\u00f3n a MySQL con PDO &#187; The Code","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:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/","og_locale":"en_US","og_type":"article","og_title":"Crear una conexi\u00f3n a MySQL con PDO &#187; The Code","og_description":"Anteriormente hice un video donde muestro como realizar una conexi\u00f3n\u00a0a base de datos MySQL con PDO (http:\/\/behstant.com\/blog\/?p=167), pero para aquellos que les gusta las cosas simples hago este post para mostrar c\u00f3mo\u00a0realizar un conexi\u00f3n\u00a0de una forma simple. El significado de PDO es PHP Data Objects, lo que significa que trabajamos con Programaci\u00f3n Orientada a Objetos ... Read more","og_url":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/","og_site_name":"The Code","article_published_time":"2013-03-20T01:35:53+00:00","article_modified_time":"2013-06-08T16:23:57+00:00","og_image":[{"url":"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp","type":"","width":"","height":""}],"author":"Reedyseth","twitter_card":"summary_large_image","twitter_creator":"@Reedyseth","twitter_site":"@Reedyseth","twitter_misc":{"Written by":"Reedyseth","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#article","isPartOf":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/"},"author":{"name":"Reedyseth","@id":"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f"},"headline":"Crear una conexi\u00f3n a MySQL con PDO","datePublished":"2013-03-20T01:35:53+00:00","dateModified":"2013-06-08T16:23:57+00:00","mainEntityOfPage":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/"},"wordCount":382,"commentCount":4,"image":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage"},"thumbnailUrl":"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp","articleSection":["Base de Datos","howto","PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/","url":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/","name":"Crear una conexi\u00f3n a MySQL con PDO &#187; The Code","isPartOf":{"@id":"http:\/\/behstant.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage"},"image":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage"},"thumbnailUrl":"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp","datePublished":"2013-03-20T01:35:53+00:00","dateModified":"2013-06-08T16:23:57+00:00","author":{"@id":"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f"},"breadcrumb":{"@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#primaryimage","url":"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp","contentUrl":"http:\/\/behstant.com\/blog\/wp-content\/uploads\/2013\/03\/pdo_info.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/behstant.com\/blog\/base-de-datos\/crear-una-conexion-a-mysql-con-pdo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/behstant.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Crear una conexi\u00f3n a MySQL con PDO"}]},{"@type":"WebSite","@id":"http:\/\/behstant.com\/blog\/#website","url":"http:\/\/behstant.com\/blog\/","name":"The Code","description":"Learn Web Solutions in WordPress, PHP, jand also purchase code solutions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/behstant.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/behstant.com\/blog\/#\/schema\/person\/760327e1ee480ad2aabe8e40d784ec9f","name":"Reedyseth","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/117af509aa15be89968fe955258a7bf8ed362ec2adf1afcf2af50a976f2349fa?s=96&r=g","caption":"Reedyseth"},"description":"My Google Profile+","sameAs":["http:\/\/behstant.com"],"url":"https:\/\/behstant.com\/blog\/author\/reedyseth\/"}]}},"_links":{"self":[{"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/comments?post=333"}],"version-history":[{"count":0,"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/posts\/333\/revisions"}],"wp:attachment":[{"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/media?parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/categories?post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/behstant.com\/blog\/wp-json\/wp\/v2\/tags?post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}