id
catala
pron
tipus
c_a_t
qualificador
castella
ajuda
data_creacio
data_modif
found
num_alea
encert
nota
estrelles
aux<\/p>\n\n\n\n
==============editar registre=================<\/p>\n\n\n\n
id<\/code> (per exemple, editar.php?id=1<\/code><\/mark>), es realitza una consulta preparada per obtenir totes les dades del registre corresponent.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\nedit.php<\/p>\n\n\n\n
<?php\n\/\/ Configuraci\u00f3 de la connexi\u00f3 a la base de dades\n$servername = \"localhost\";\n$username = \"root\"; \/\/ Substitueix pel teu usuari\n$password = \"\"; \/\/ Substitueix per la teva contrasenya\n$dbname = \"word\"; \/\/ Nom de la base de dades\n\n\/\/ Crear connexi\u00f3\n$conn = new mysqli($servername, $username, $password, $dbname);\n\n\/\/ Comprovar la connexi\u00f3\nif ($conn->connect_error) {\n die(\"Error de connexi\u00f3: \" . $conn->connect_error);\n}\n\n\/\/ Variables per emmagatzemar les dades del registre\n$id = \"\";\n$update_success = false;\n\n\/\/ Inicialitzar variables per cada camp de la taula\n$data = [\n 'catala' => '',\n 'pron' => '',\n 'tipus' => '',\n 'c_a_t' => '',\n 'qualificador' => '',\n 'castella' => '',\n 'ajuda' => '',\n 'data_creacio' => '',\n 'data_modi' => '',\n 'found' => 0,\n 'num_alea' => 0,\n 'encert' => 0,\n 'nota' => '',\n 'estrelles' => 0,\n 'aux' => ''\n];\n\n\/\/ Si s'envia el formulari per POST\nif ($_SERVER[\"REQUEST_METHOD\"] == \"POST\") {\n \/\/ Validar i obtenir l'ID del registre\n $id = intval($_POST['id']); \/\/ Assegurar que l'ID sigui un enter\n\n \/\/ Obtenir i sanejar les dades del formulari\n foreach ($data as $key => &$value) {\n if (isset($_POST[$key])) {\n $value = $conn->real_escape_string(trim($_POST[$key]));\n }\n }\n\n \/\/ Actualitzar el registre amb una consulta preparada\n $sql = \"UPDATE diccionari SET \n catala = ?, pron = ?, tipus = ?, c_a_t = ?, qualificador = ?, \n castella = ?, ajuda = ?, data_creacio = ?, data_modi = ?, \n found = ?, num_alea = ?, encert = ?, nota = ?, estrelles = ?, aux = ? \n WHERE id = ?\";\n $stmt = $conn->prepare($sql);\n\n if ($stmt) {\n \/\/ Vincular tots els par\u00e0metres\n $stmt->bind_param(\n \"ssssssssiisissii\", \/\/ Tipus de dades: cadenes (s), enters (i)\n $data['catala'], $data['pron'], $data['tipus'], $data['c_a_t'], $data['qualificador'],\n $data['castella'], $data['ajuda'], $data['data_creacio'], $data['data_modi'],\n $data['found'], $data['num_alea'], $data['encert'], $data['nota'], $data['estrelles'], $data['aux'],\n $id\n );\n\n if ($stmt->execute()) {\n $update_success = true; \/\/ Indicar que l'actualitzaci\u00f3 ha estat exitosa\n } else {\n echo \"Error en l'actualitzaci\u00f3: \" . $stmt->error;\n }\n $stmt->close();\n } else {\n echo \"Error en preparar la consulta: \" . $conn->error;\n }\n}\n\n\/\/ Obtenir el registre seleccionat per ID (si s'especifica)\nif (isset($_GET['id'])) {\n $id = intval($_GET['id']); \/\/ Assegurar que l'ID sigui un enter\n\n \/\/ Consulta per obtenir les dades del registre\n $sql = \"SELECT id, catala, pron, tipus, c_a_t, qualificador, castella, ajuda, \n data_creacio, data_modi, found, num_alea, encert, nota, estrelles, aux \n FROM diccionari WHERE id = ?\";\n $stmt = $conn->prepare($sql);\n\n if ($stmt) {\n $stmt->bind_param(\"i\", $id); \/\/ \"i\" = enter\n $stmt->execute();\n $stmt->store_result();\n\n if ($stmt->num_rows > 0) {\n $stmt->bind_result(\n $id, $data['catala'], $data['pron'], $data['tipus'], $data['c_a_t'], $data['qualificador'],\n $data['castella'], $data['ajuda'], $data['data_creacio'], $data['data_modi'],\n $data['found'], $data['num_alea'], $data['encert'], $data['nota'], $data['estrelles'], $data['aux']\n );\n $stmt->fetch(); \/\/ Emplenar les variables amb les dades del registre\n } else {\n echo \"No s'ha trobat cap registre amb l'ID especificat.\";\n }\n $stmt->close();\n } else {\n echo \"Error en preparar la consulta: \" . $conn->error;\n }\n}\n\n\/\/ Tancar la connexi\u00f3\n$conn->close();\n?>\n\n<!DOCTYPE html>\n<html lang=\"ca\">\n<head>\n <meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>Editar Registre<\/title>\n<\/head>\n<body>\n <h1>Editar Registre<\/h1>\n\n <?php if ($update_success): ?>\n <p style=\"color:green;\">Registre actualitzat correctament.<\/p>\n <?php endif; ?>\n\n <!-- Formulari per editar el registre -->\n <form method=\"POST\" action=\"<?php echo htmlspecialchars($_SERVER[\"PHP_SELF\"]); ?>\">\n <input type=\"hidden\" name=\"id\" value=\"<?php echo htmlspecialchars($id); ?>\">\n\n <label for=\"catala\">Catal\u00e0:<\/label><br>\n <input type=\"text\" id=\"catala\" name=\"catala\" value=\"<?php echo htmlspecialchars($data['catala']); ?>\" required><br><br>\n\n <label for=\"pron\">pronunciaci\u00f3:<\/label><br>\n <input type=\"text\" id=\"pron\" name=\"pron\" value=\"<?php echo htmlspecialchars($data['pron']); ?>\"><br><br>\n\n <label for=\"tipus\">Tipus:<\/label><br>\n <input type=\"text\" id=\"tipus\" name=\"tipus\" value=\"<?php echo htmlspecialchars($data['tipus']); ?>\"><br><br>\n\n <label for=\"c_a_t\">Categoria:<\/label><br>\n <input type=\"text\" id=\"c_a_t\" name=\"c_a_t\" value=\"<?php echo htmlspecialchars($data['c_a_t']); ?>\"><br><br>\n\n <label for=\"qualificador\">Qualificador:<\/label><br>\n <input type=\"text\" id=\"qualificador\" name=\"qualificador\" value=\"<?php echo htmlspecialchars($data['qualificador']); ?>\"><br><br>\n\n <label for=\"castella\">Castell\u00e0:<\/label><br>\n <input type=\"text\" id=\"castella\" name=\"castella\" value=\"<?php echo htmlspecialchars($data['castella']); ?>\"><br><br>\n\n <label for=\"ajuda\">Ajuda:<\/label><br>\n <textarea id=\"ajuda\" name=\"ajuda\" rows=\"4\" cols=\"50\"><?php echo htmlspecialchars($data['ajuda']); ?><\/textarea><br><br>\n\n <label for=\"data_creacio\">Data de creaci\u00f3:<\/label><br>\n <input type=\"date\" id=\"data_creacio\" name=\"data_creacio\" value=\"<?php echo htmlspecialchars($data['data_creacio']); ?>\"><br><br>\n\n <label for=\"data_modi\">Data de modificaci\u00f3:<\/label><br>\n <input type=\"date\" id=\"data_modi\" name=\"data_modi\" value=\"<?php echo htmlspecialchars($data['data_modi']); ?>\"><br><br>\n\n <label for=\"found\">Freq\u00fc\u00e8ncia\/Trobada:<\/label><br>\n <input type=\"number\" id=\"found\" name=\"found\" value=\"<?php echo htmlspecialchars($data['found']); ?>\"><br><br>\n\n <label for=\"num_alea\">N\u00famero aleatori:<\/label><br>\n <input type=\"number\" id=\"num_alea\" name=\"num_alea\" value=\"<?php echo htmlspecialchars($data['num_alea']); ?>\"><br><br>\n\n <label for=\"encert\">Encerts:<\/label><br>\n <input type=\"number\" id=\"encert\" name=\"encert\" value=\"<?php echo htmlspecialchars($data['encert']); ?>\"><br><br>\n\n <label for=\"nota\">Notes:<\/label><br>\n <textarea id=\"nota\" name=\"nota\" rows=\"4\" cols=\"50\"><?php echo htmlspecialchars($data['nota']); ?><\/textarea><br><br>\n\n <label for=\"estrelles\">Nombre d'estrelles:<\/label><br>\n <input type=\"number\" id=\"estrelles\" name=\"estrelles\" value=\"<?php echo htmlspecialchars($data['estrelles']); ?>\"><br><br>\n\n <label for=\"aux\">Camp auxiliar:<\/label><br>\n <input type=\"text\" id=\"aux\" name=\"aux\" value=\"<?php echo htmlspecialchars($data['aux']); ?>\"><br><br>\n\n <button type=\"submit\">Actualitzar<\/button>\n <\/form>\n\n <!-- Enlla\u00e7 per tornar a la p\u00e0gina principal (opcional) -->\n <p><a href=\"index.php\">Tornar al llistat<\/a><\/p>\n<\/body>\n<\/html><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"idcatalaprontipusc_a_tqualificadorcastellaajudadata_creaciodata_modiffoundnum_aleaencertnotaestrellesaux ==============editar registre================= edit.php<\/p>\n","protected":false},"author":2,"featured_media":8179,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72,70],"tags":[],"class_list":["post-16120","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-programacio"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16120"}],"version-history":[{"count":8,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16120\/revisions"}],"predecessor-version":[{"id":16131,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/16120\/revisions\/16131"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/media\/8179"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16120"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}