{"id":13132,"date":"2023-01-14T13:36:24","date_gmt":"2023-01-14T11:36:24","guid":{"rendered":"https:\/\/www.beseit.net\/?p=13132"},"modified":"2023-01-14T13:51:48","modified_gmt":"2023-01-14T11:51:48","slug":"php-mysql-copiant-dades-duna-taula-a-una-altra","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=13132","title":{"rendered":"PHP MySQL copiant dades d’una taula a una altra"},"content":{"rendered":"

[php]
\n<?php
\n\/\/ Aquest script carrega la taula 9000_CAMPS a la taula words les dos taules son de polidic_eng
\n\/\/ 9000_CAMPS -> ENGLISH_POLIDIC.words
\n\/\/ ES FA LA CONNEXI\u00d3
\n$conn= mysqli_connect("localhost", "miquel", "Beseit1968!","polidic_eng");\/\/ fa la conexi\u00f3
\nif (!$conn) { echo "Error: No s’ha pogut connectar a:". DB_NAME ;}
\nelse{echo "Connected successfully";}
\n$SQL="TRUNCATE TABLE words"; \/\/buida la taula
\nmysqli_query($conn, $SQL);
\n$sql="INSERT INTO words (tipus, catala, castella, pron) SELECT * FROM 9000_CAMPS";
\nmysqli_query($conn, $sql);
\necho "fet";
\n?>
\n[\/php]\n<\/p>\n

\"\"\/<\/p>\n","protected":false},"excerpt":{"rendered":"

[php] <?php \/\/ Aquest script carrega la taula 9000_CAMPS a la taula words les dos taules son de polidic_eng \/\/ 9000_CAMPS -> ENGLISH_POLIDIC.words \/\/ ES FA LA CONNEXI\u00d3 $conn= mysqli_connect("localhost", "miquel", "Beseit1968!","polidic_eng");\/\/ fa la conexi\u00f3 if (!$conn) { echo "Error: … Continua llegint →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72],"tags":[],"class_list":["post-13132","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/13132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13132"}],"version-history":[{"count":4,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/13132\/revisions"}],"predecessor-version":[{"id":13136,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/13132\/revisions\/13136"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}