Po vytvoren\u00ed datab\u00e1zy a tabu\u013eky m\u00f4\u017eeme do nich za\u010da\u0165 prid\u00e1va\u0165 \u00fadaje.<\/p>\n
Tu je nieko\u013eko pravidiel syntaxe, ktor\u00e9 treba dodr\u017eiava\u0165:<\/p>\n
Pr\u00edkaz INSERT INTO sa pou\u017e\u00edva na prid\u00e1vanie nov\u00fdch z\u00e1znamov do tabu\u013eky MySQL:<\/p>\n
\nINSERT INTO table_name (column1, column2, column3,…)<\/strong>
\nVALUES (value1, value2, value3,…)<\/strong><\/div>\n<\/div>\n <\/p>\n
V predch\u00e1dzaj\u00facej kapitole sme vytvorili pr\u00e1zdnu tabu\u013eku s n\u00e1zvom „MyGuests“ s piatimi st\u013apcami: „id“, „firstname“, „lastname“, „e-mail“ a „reg_date“. Teraz vypl\u0148te tabu\u013eku \u00fadajmi.<\/p>\n
\nPozn\u00e1mka:<\/strong>\u00a0Ak je st\u013apec AUTO_INCREMENT (ako st\u013apec „id“) alebo TIMESTAMP s predvolenou aktualiz\u00e1ciou current_timesamp (ako st\u013apec „reg_date“), nie je potrebn\u00e9 ho \u0161pecifikova\u0165 v dotaze SQL; MySQL automaticky prid\u00e1 hodnotu.<\/p>\n<\/div>\nNasleduj\u00face pr\u00edklady prid\u00e1vaj\u00fa nov\u00fd z\u00e1znam do tabu\u013eky \u201eMyGuests\u201c:<\/p>\n
\nPr\u00edklad (Objektovo orientovan\u00fd MySQLi)<\/h3>\n<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n$dbname =\u00a0\"myDB\"<\/span>;\r\n\r\n\/\/ Create connection\r\n<\/span>$conn =\u00a0new<\/span>\u00a0mysqli($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\n<\/span>if<\/span>\u00a0($conn->connect_error)\u00a0{\r\n\u00a0\u00a0die<\/span>(\"Connection failed: \"<\/span>\u00a0. $conn->connect_error);\r\n}\r\n\r\n$sql =\u00a0\"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com')\"<\/span>;\r\n\r\nif<\/span>\u00a0($conn->query($sql) === TRUE) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"New record created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error: \"<\/span>\u00a0. $sql .\u00a0\"<br>\"<\/span>\u00a0. $conn->error;\r\n}\r\n\r\n$conn->close();\r\n?><\/span><\/span><\/pre>\n<\/div>\n<\/div>\n
\n\nPr\u00edklad (Proced\u00fara MySQLi)<\/h3>\n<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n$dbname =\u00a0\"myDB\"<\/span>;\r\n\r\n\/\/ Create connection\r\n<\/span>$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\n<\/span>if<\/span>\u00a0(!$conn)\u00a0{\r\n\u00a0\u00a0die<\/span>(\"Connection failed: \"<\/span>\u00a0. mysqli_connect_error());\r\n}\r\n\r\n$sql =\u00a0\"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com')\"<\/span>;\r\n\r\nif<\/span>\u00a0(mysqli_query($conn, $sql)) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"New record created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error: \"<\/span>\u00a0. $sql .\u00a0\"<br>\"<\/span>\u00a0. mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/span><\/span><\/pre>\n<\/div>\n\nPr\u00edklad (CHOP)<\/h3>\n<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n$dbname =\u00a0\"myDBPDO\"<\/span>;\r\n\r\ntry<\/span>\u00a0{\r\n\u00a0\u00a0$conn =\u00a0new<\/span>\u00a0PDO(\"mysql:host=$servername;dbname=$dbname\"<\/span>, $username, $password);\r\n\u00a0\u00a0\/\/ set the PDO error mode to exception\r\n<\/span>\u00a0 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\r\n\u00a0 $sql =\u00a0\"INSERT INTO MyGuests (firstname, lastname, email)\r\n\u00a0 VALUES ('John', 'Doe', 'john@example.com')\"<\/span>;\r\n\u00a0\u00a0\/\/ use exec() because no results are returned\r\n<\/span>\u00a0 $conn->exec($sql);\r\n\u00a0\u00a0echo<\/span>\u00a0\"New record created successfully\"<\/span>;\r\n}\u00a0catch<\/span>(PDOException $e)\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0$sql .\u00a0\"<br>\"<\/span>\u00a0. $e->getMessage();\r\n}\r\n\r\n$conn = null;\r\n?><\/span><\/span><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Vkladanie \u00fadajov do MySQL pomocou MySQLi a PDO Po vytvoren\u00ed datab\u00e1zy a tabu\u013eky m\u00f4\u017eeme do nich za\u010da\u0165 prid\u00e1va\u0165 \u00fadaje. Tu je nieko\u013eko pravidiel syntaxe, ktor\u00e9 treba dodr\u017eiava\u0165: SQL dotaz mus\u00ed by\u0165 citovan\u00fd v PHP Hodnoty re\u0165azca v dotaze SQL musia by\u0165 v \u00favodzovk\u00e1ch \u010c\u00edseln\u00e9 hodnoty sa nesm\u00fa uv\u00e1dza\u0165 v \u00favodzovk\u00e1ch Slovo NULL sa nesmie uv\u00e1dza\u0165 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-450","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=450"}],"version-history":[{"count":3,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/450\/revisions"}],"predecessor-version":[{"id":453,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/450\/revisions\/453"}],"wp:attachment":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}