{"id":308,"date":"2012-03-14T16:00:59","date_gmt":"2012-03-14T15:00:59","guid":{"rendered":"http:\/\/vermiip.es\/blog\/?p=308"},"modified":"2012-03-14T16:06:18","modified_gmt":"2012-03-14T15:06:18","slug":"saber-el-id-de-una-insercion-con-php-y-mysql","status":"publish","type":"post","link":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/","title":{"rendered":"Saber el ID de una inserci\u00f3n con PHP y MySQL"},"content":{"rendered":"<p>Cuando realizamos un insert en MySQL muchas veces necesitamos conocer el ID auton\u00famerico que nos ha asignado la base de datos para incluirla en otras consultas asociadas. Para ello, MySQL cuenta con la funci\u00f3n <strong>mysql_insert_id(<em>NOMBRE_CONEXION_BD<\/em>)<\/strong> que devuelve el ID del \u00faltimo insert realizado por la conexi\u00f3n que hemos abierto a la base de datos.<\/p>\n<p>Veamos un ejemplo:<\/p>\n<p>[PHP]<br \/>\n$query = \u00abINSERT INTO tabla(campo1, campo2) VALUES (&#8216;valor1&#8242;,&#8217;valor2&#8217;);\u00bb;<br \/>\nmysql_query($query,$conexion);<br \/>\n$id_query = mysql_insert_id($conexion);<\/p>\n<p>echo($id_query);<br \/>\n\/\/$id_query contiene el ID del \u00faltimo INSERT<br \/>\n\/\/realizado durante la conexi\u00f3n a la base de datos.<br \/>\n[\/PHP]<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cuando realizamos un insert en MySQL muchas veces necesitamos conocer el ID auton\u00famerico que nos ha asignado la base de datos para incluirla en otras consultas asociadas. Para ello, MySQL cuenta con la funci\u00f3n     mysql_insert_id(NOMBRE_CONEXION_BD) que devuelve el ID del \u00faltimo insert realizado por la conexi\u00f3n que hemos abierto a la base de datos.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,82],"tags":[],"class_list":["post-308","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"_wp_attached_file":null,"_wp_attachment_metadata":null,"_wp_old_slug":null,"_aioseop_description":"Cuando realizamos un insert en MySQL muchas veces necesitamos conocer el ID auton\u00famerico que nos ha asignado la base de datos para incluirla en otras consultas asociadas. Para ello, MySQL cuenta con la funci\u00f3n     mysql_insert_id(NOMBRE_CONEXION_BD) que devuelve el ID del \u00faltimo insert realizado por la conexi\u00f3n que hemos abierto a la base de datos.","_wp_attachment_image_alt":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP<\/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:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-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=\"Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP\" \/>\n<meta property=\"og:description\" content=\"Cuando realizamos un insert en MySQL muchas veces necesitamos conocer el ID auton\u00famerico que nos ha asignado la base de datos para incluirla en otras consultas asociadas. Para ello, MySQL cuenta con la funci\u00f3n   mysql_insert_id(NOMBRE_CONEXION_BD) que devuelve el ID del \u00faltimo insert realizado por la conexi\u00f3n que hemos abierto a la base de datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ver mi IP\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-14T15:00:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-03-14T15:06:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vermiip.es\/blog\/wp-content\/uploads\/2023\/10\/cropped-logo-vermiip-naranja.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Xose de la Paz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Xose de la Paz\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/\"},\"author\":{\"name\":\"Xose de la Paz\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#\\\/schema\\\/person\\\/0617918e61a75dc2d11c09238bf84200\"},\"headline\":\"Saber el ID de una inserci\u00f3n con PHP y MySQL\",\"datePublished\":\"2012-03-14T15:00:59+00:00\",\"dateModified\":\"2012-03-14T15:06:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/\"},\"wordCount\":119,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#organization\"},\"articleSection\":[\"MySQL\",\"php\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/\",\"url\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/\",\"name\":\"Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#website\"},\"datePublished\":\"2012-03-14T15:00:59+00:00\",\"dateModified\":\"2012-03-14T15:06:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/saber-el-id-de-una-insercion-con-php-y-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Saber el ID de una inserci\u00f3n con PHP y MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/\",\"name\":\"Cual es mi ip - Internet y otras locuras\",\"description\":\"Internet y otras locuras\",\"publisher\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#organization\"},\"alternateName\":\"Cual es mi IP\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#organization\",\"name\":\"Ver mi IP\",\"alternateName\":\"vermiip\",\"url\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/cropped-logo-vermiip-naranja.png\",\"contentUrl\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/cropped-logo-vermiip-naranja.png\",\"width\":512,\"height\":512,\"caption\":\"Ver mi IP\"},\"image\":{\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/vermiip.es\\\/blog\\\/#\\\/schema\\\/person\\\/0617918e61a75dc2d11c09238bf84200\",\"name\":\"Xose de la Paz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g\",\"caption\":\"Xose de la Paz\"},\"description\":\"M\u00e1s de 20 a\u00f1os transformando pasi\u00f3n en profesi\u00f3n. Experto en desarrollo Full Stack con una visi\u00f3n integral que abarca desde la gesti\u00f3n de servidores y redes hasta el dise\u00f1o de interfaz. Soy un \\\"todoterreno\\\" tecnol\u00f3gico que cree en el aprendizaje continuo y la visi\u00f3n global de los proyectos. Entre despliegue y despliegue, me pierdo por el mundo con mi c\u00e1mara al hombro.\",\"sameAs\":[\"https:\\\/\\\/www.enfocado.com\",\"https:\\\/\\\/www.instagram.com\\\/xose_de_la_paz\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/xosedelapaz\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP","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:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/","og_locale":"es_ES","og_type":"article","og_title":"Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP","og_description":"Cuando realizamos un insert en MySQL muchas veces necesitamos conocer el ID auton\u00famerico que nos ha asignado la base de datos para incluirla en otras consultas asociadas. Para ello, MySQL cuenta con la funci\u00f3n   mysql_insert_id(NOMBRE_CONEXION_BD) que devuelve el ID del \u00faltimo insert realizado por la conexi\u00f3n que hemos abierto a la base de datos.","og_url":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/","og_site_name":"Ver mi IP","article_published_time":"2012-03-14T15:00:59+00:00","article_modified_time":"2012-03-14T15:06:18+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/vermiip.es\/blog\/wp-content\/uploads\/2023\/10\/cropped-logo-vermiip-naranja.png","type":"image\/png"}],"author":"Xose de la Paz","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Xose de la Paz","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/#article","isPartOf":{"@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/"},"author":{"name":"Xose de la Paz","@id":"https:\/\/vermiip.es\/blog\/#\/schema\/person\/0617918e61a75dc2d11c09238bf84200"},"headline":"Saber el ID de una inserci\u00f3n con PHP y MySQL","datePublished":"2012-03-14T15:00:59+00:00","dateModified":"2012-03-14T15:06:18+00:00","mainEntityOfPage":{"@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/"},"wordCount":119,"commentCount":2,"publisher":{"@id":"https:\/\/vermiip.es\/blog\/#organization"},"articleSection":["MySQL","php"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/","url":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/","name":"Saber el ID de una inserci\u00f3n con PHP y MySQL - Ver mi IP","isPartOf":{"@id":"https:\/\/vermiip.es\/blog\/#website"},"datePublished":"2012-03-14T15:00:59+00:00","dateModified":"2012-03-14T15:06:18+00:00","breadcrumb":{"@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vermiip.es\/blog\/saber-el-id-de-una-insercion-con-php-y-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/vermiip.es\/blog\/"},{"@type":"ListItem","position":2,"name":"Saber el ID de una inserci\u00f3n con PHP y MySQL"}]},{"@type":"WebSite","@id":"https:\/\/vermiip.es\/blog\/#website","url":"https:\/\/vermiip.es\/blog\/","name":"Cual es mi ip - Internet y otras locuras","description":"Internet y otras locuras","publisher":{"@id":"https:\/\/vermiip.es\/blog\/#organization"},"alternateName":"Cual es mi IP","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vermiip.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/vermiip.es\/blog\/#organization","name":"Ver mi IP","alternateName":"vermiip","url":"https:\/\/vermiip.es\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/vermiip.es\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/vermiip.es\/blog\/wp-content\/uploads\/2023\/10\/cropped-logo-vermiip-naranja.png","contentUrl":"https:\/\/vermiip.es\/blog\/wp-content\/uploads\/2023\/10\/cropped-logo-vermiip-naranja.png","width":512,"height":512,"caption":"Ver mi IP"},"image":{"@id":"https:\/\/vermiip.es\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/vermiip.es\/blog\/#\/schema\/person\/0617918e61a75dc2d11c09238bf84200","name":"Xose de la Paz","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d248b555dd18abd5e7350d28ecf07116718da621eb85762e02558c2cef2bb8bc?s=96&d=mm&r=g","caption":"Xose de la Paz"},"description":"M\u00e1s de 20 a\u00f1os transformando pasi\u00f3n en profesi\u00f3n. Experto en desarrollo Full Stack con una visi\u00f3n integral que abarca desde la gesti\u00f3n de servidores y redes hasta el dise\u00f1o de interfaz. Soy un \"todoterreno\" tecnol\u00f3gico que cree en el aprendizaje continuo y la visi\u00f3n global de los proyectos. Entre despliegue y despliegue, me pierdo por el mundo con mi c\u00e1mara al hombro.","sameAs":["https:\/\/www.enfocado.com","https:\/\/www.instagram.com\/xose_de_la_paz\/","https:\/\/www.linkedin.com\/in\/xosedelapaz\/"]}]}},"_links":{"self":[{"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/posts\/308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/comments?post=308"}],"version-history":[{"count":7,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/posts\/308\/revisions"}],"predecessor-version":[{"id":311,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/posts\/308\/revisions\/311"}],"wp:attachment":[{"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/media?parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/categories?post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vermiip.es\/blog\/wp-json\/wp\/v2\/tags?post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}