{"id":409,"date":"2015-05-06T21:35:53","date_gmt":"2015-05-06T20:35:53","guid":{"rendered":"http:\/\/heymowski.es\/mydevnotepad\/?p=409"},"modified":"2015-05-06T21:35:53","modified_gmt":"2015-05-06T20:35:53","slug":"sql-transaccionales-con-php","status":"publish","type":"post","link":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/","title":{"rendered":"SQL Transaccionales con php"},"content":{"rendered":"<p><a href=\"http:\/\/php.net\/manual\/es\/mysqli.commit.php\" target=\"_blank\">http:\/\/php.net\/manual\/es\/mysqli.commit.php<\/a><\/p>\n<div class=\"example-contents\">\n<pre class=\"phpcode\"><code> &lt;?php\r\n$mysqli\u00a0=\u00a0new\u00a0mysqli(\"localhost\",\u00a0\"my_user\",\u00a0\"my_password\",\u00a0\"world\");\r\n\r\n\/*\u00a0Comprobar\u00a0la\u00a0conexi\u00f3n\u00a0*\/\r\nif\u00a0(mysqli_connect_errno())\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0printf(\"Fall\u00f3\u00a0la\u00a0conexi\u00f3n:\u00a0%s\\n\",\u00a0mysqli_connect_error());\r\n\u00a0\u00a0\u00a0\u00a0exit();\r\n}\r\n\r\n$mysqli-&gt;query(\"CREATE\u00a0TABLE\u00a0Language\u00a0LIKE\u00a0CountryLanguage\");\r\n\r\n\/*\u00a0Desactivar\u00a0la\u00a0autoconsigna\u00a0*\/\r\n$mysqli-&gt;autocommit(FALSE);\r\n\r\n\/*\u00a0Inserta\u00a0algunos\u00a0valores\u00a0*\/\r\n$mysqli-&gt;query(\"INSERT\u00a0INTO\u00a0Language\u00a0VALUES\u00a0('DEU',\u00a0'Bavarian',\u00a0'F',\u00a011.2)\");\r\n$mysqli-&gt;query(\"INSERT\u00a0INTO\u00a0Language\u00a0VALUES\u00a0('DEU',\u00a0'Swabian',\u00a0'F',\u00a09.4)\");\r\n\r\n\/*\u00a0Consignar\u00a0la\u00a0transacci\u00f3n\u00a0*\/\r\nif\u00a0(!$mysqli-&gt;commit())\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0print(\"Fall\u00f3\u00a0la\u00a0consignaci\u00f3n\u00a0de\u00a0la\u00a0transacci\u00f3n\\n\");\r\n\u00a0\u00a0\u00a0\u00a0exit();\r\n}\r\n\r\n\/*\u00a0Eliminar\u00a0la\u00a0tabla\u00a0*\/\r\n$mysqli-&gt;query(\"DROP\u00a0TABLE\u00a0Language\");\r\n\r\n\/*\u00a0Cerrar\u00a0la\u00a0conexi\u00f3n\u00a0*\/\r\n$mysqli-&gt;close();\r\n?&gt;  <\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/php.net\/manual\/es\/mysqli.commit.php &lt;?php $mysqli\u00a0=\u00a0new\u00a0mysqli(\u00ablocalhost\u00bb,\u00a0\u00abmy_user\u00bb,\u00a0\u00abmy_password\u00bb,\u00a0\u00abworld\u00bb); \/*\u00a0Comprobar\u00a0la\u00a0conexi\u00f3n\u00a0*\/ if\u00a0(mysqli_connect_errno())\u00a0{ \u00a0\u00a0\u00a0\u00a0printf(\u00abFall\u00f3\u00a0la\u00a0conexi\u00f3n:\u00a0%s\\n\u00bb,\u00a0mysqli_connect_error()); \u00a0\u00a0\u00a0\u00a0exit(); } $mysqli-&gt;query(\u00abCREATE\u00a0TABLE\u00a0Language\u00a0LIKE\u00a0CountryLanguage\u00bb); \/*\u00a0Desactivar\u00a0la\u00a0autoconsigna\u00a0*\/ $mysqli-&gt;autocommit(FALSE); \/*\u00a0Inserta\u00a0algunos\u00a0valores\u00a0*\/ $mysqli-&gt;query(\u00abINSERT\u00a0INTO\u00a0Language\u00a0VALUES\u00a0(&#8216;DEU&#8217;,\u00a0&#8216;Bavarian&#8217;,\u00a0&#8216;F&#8217;,\u00a011.2)\u00bb); $mysqli-&gt;query(\u00abINSERT\u00a0INTO\u00a0Language\u00a0VALUES\u00a0(&#8216;DEU&#8217;,\u00a0&#8216;Swabian&#8217;,\u00a0&#8216;F&#8217;,\u00a09.4)\u00bb); \/*\u00a0Consignar\u00a0la\u00a0transacci\u00f3n\u00a0*\/ if\u00a0(!$mysqli-&gt;commit())\u00a0{ \u00a0\u00a0\u00a0\u00a0print(\u00abFall\u00f3\u00a0la\u00a0consignaci\u00f3n\u00a0de\u00a0la\u00a0transacci\u00f3n\\n\u00bb); \u00a0\u00a0\u00a0\u00a0exit(); } \/*\u00a0Eliminar\u00a0la\u00a0tabla\u00a0*\/ $mysqli-&gt;query(\u00abDROP\u00a0TABLE\u00a0Language\u00bb); \/*\u00a0Cerrar\u00a0la\u00a0conexi\u00f3n\u00a0*\/ $mysqli-&gt;close(); ?&gt;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24,10],"tags":[],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Transaccionales con php | mydevnotepad<\/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:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"jjuanh\" \/>\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:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\"},\"author\":{\"name\":\"jjuanh\",\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3\"},\"headline\":\"SQL Transaccionales con php\",\"datePublished\":\"2015-05-06T20:35:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\"},\"wordCount\":12,\"commentCount\":0,\"articleSection\":[\"MySQL\",\"PHP\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\",\"url\":\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\",\"name\":\"SQL Transaccionales con php | mydevnotepad\",\"isPartOf\":{\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#website\"},\"datePublished\":\"2015-05-06T20:35:53+00:00\",\"author\":{\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#website\",\"url\":\"https:\/\/heymowski.es\/mydevnotepad\/\",\"name\":\"mydevnotepad\",\"description\":\"echo &quot;Blog sobre Php y otros entretenimientos, para reforzar mi fr\u00e1gil memoria&quot;;\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/heymowski.es\/mydevnotepad\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3\",\"name\":\"jjuanh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bf9cff5d33a0b664a36c8a2188742797ff6063e120fd22b1a15f3b45616b6707?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bf9cff5d33a0b664a36c8a2188742797ff6063e120fd22b1a15f3b45616b6707?s=96&d=mm&r=g\",\"caption\":\"jjuanh\"},\"sameAs\":[\"http:\/\/www.heymowski.es\"],\"url\":\"https:\/\/heymowski.es\/mydevnotepad\/author\/jjuanh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Transaccionales con php | mydevnotepad","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:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/","twitter_misc":{"Escrito por":"jjuanh","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/#article","isPartOf":{"@id":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/"},"author":{"name":"jjuanh","@id":"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3"},"headline":"SQL Transaccionales con php","datePublished":"2015-05-06T20:35:53+00:00","mainEntityOfPage":{"@id":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/"},"wordCount":12,"commentCount":0,"articleSection":["MySQL","PHP"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/","url":"https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/","name":"SQL Transaccionales con php | mydevnotepad","isPartOf":{"@id":"https:\/\/heymowski.es\/mydevnotepad\/#website"},"datePublished":"2015-05-06T20:35:53+00:00","author":{"@id":"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/heymowski.es\/mydevnotepad\/2015\/05\/06\/sql-transaccionales-con-php\/"]}]},{"@type":"WebSite","@id":"https:\/\/heymowski.es\/mydevnotepad\/#website","url":"https:\/\/heymowski.es\/mydevnotepad\/","name":"mydevnotepad","description":"echo &quot;Blog sobre Php y otros entretenimientos, para reforzar mi fr\u00e1gil memoria&quot;;","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/heymowski.es\/mydevnotepad\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/d2129df7ef4a39b5e02c54ae9f426ea3","name":"jjuanh","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/heymowski.es\/mydevnotepad\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bf9cff5d33a0b664a36c8a2188742797ff6063e120fd22b1a15f3b45616b6707?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bf9cff5d33a0b664a36c8a2188742797ff6063e120fd22b1a15f3b45616b6707?s=96&d=mm&r=g","caption":"jjuanh"},"sameAs":["http:\/\/www.heymowski.es"],"url":"https:\/\/heymowski.es\/mydevnotepad\/author\/jjuanh\/"}]}},"_links":{"self":[{"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/posts\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":1,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/posts\/409\/revisions"}],"predecessor-version":[{"id":410,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/posts\/409\/revisions\/410"}],"wp:attachment":[{"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/media?parent=409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/categories?post=409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heymowski.es\/mydevnotepad\/wp-json\/wp\/v2\/tags?post=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}