Pridanie z\u00e1znamu<\/h4>\n<?php\r\n$servername = \"localhost\";\r\n$username = \"xxx\";\r\n$password = \"*******\";\r\n$dbname = \"myDB\";\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif (!$conn) {\r\ndie(\"Chyba pripojenia: \" . mysqli_connect_error());\r\n}\r\n\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com')\";\r\n\r\nif (mysqli_query($conn, $sql)) {\r\necho \"Nov\u00fd z\u00e1znam \u00faspe\u0161ne pridan\u00fd.\";\r\n} else {\r\necho \"Chyba: \" . $sql . \"<br>\" . mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/pre>\n <\/p>\n
Pridanie viac z\u00e1znamov<\/h4>\n
<\/p>\n
<?php\r\n$servername = \"localhost\";\r\n$username = \"xxx\";\r\n$password = \"*******\";\r\n$dbname = \"myDB\";\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif (!$conn) {\r\ndie(\"Pripojenie zlyhalo: \" . mysqli_connect_error());\r\n}\r\n\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com');\";\r\n$sql .= \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('Mary', 'Moe', 'mary@example.com');\";\r\n$sql .= \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('Julie', 'Dooley', 'julie@example.com')\";\r\n\r\nif (mysqli_multi_query($conn, $sql)) {\r\necho \"Nov\u00e9 z\u00e1znamy vytvoren\u00e9\";\r\n} else {\r\necho \"Chyba: \" . $sql . \"<br>\" . mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/pre>\n <\/p>\n
V\u00fdpis z\u00e1znamov<\/h4>\n
<\/p>\n
<?php\r\n$servername = \"localhost\";\r\n$username = \"xxx\";\r\n$password = \"******\";\r\n$dbname = \"myDB\";\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif (!$conn) {\r\ndie(\"Pripojenie zlyhalo: \" . mysqli_connect_error());\r\n}\r\n\r\n$sql = \"SELECT id, firstname, lastname FROM MyGuests\";\r\n$result = mysqli_query($conn, $sql);\r\n\r\nif (mysqli_num_rows($result) > 0) {\r\n\/\/ output data of each row\r\nwhile($row = mysqli_fetch_assoc($result)) {\r\necho \"id: \" . $row[\"id\"]. \" - Name: \" . $row[\"firstname\"]. \" \" . $row[\"lastname\"]. \"<br>\";\r\n}\r\n} else {\r\necho \"0 results\";\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/pre>\n <\/p>\n
Mazanie z\u00e1znamu<\/h4>\n
<\/p>\n
<?php\r\n$servername = \"localhost\";\r\n$username = \"xxx\";\r\n$password = \"******\";\r\n$dbname = \"myDB\";\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif (!$conn) {\r\ndie(\"Chyba pripojenia: \" . mysqli_connect_error());\r\n}\r\n\r\n\/\/ sql to delete a record\r\n$sql = \"DELETE FROM MyGuests WHERE id=3\";\r\n\r\nif (mysqli_query($conn, $sql)) {\r\necho \"Z\u00e1znam \u00faspe\u0161ne zmazan\u00fd\";\r\n} else {\r\necho \"Chyba zmazania z\u00e1znamu: \" . mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/pre>\n <\/p>\n
Zobrazenie posledn\u00e9ho z\u00e1znamu<\/h4>\n
<\/p>\n
<?php\r\n$servername = \"localhost\";\r\n$username = \"xxx\";\r\n$password = \"*****\";\r\n$dbname = \"myDB\";\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif (!$conn) {\r\ndie(\"Pripojenie zlyhalo: \" . mysqli_connect_error());\r\n}\r\n\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com')\";\r\n\r\nif (mysqli_query($conn, $sql)) {\r\n$last_id = mysqli_insert_id($conn);\r\necho \"Nov\u00fd z\u00e1znam vytvoren\u00fd. Posledn\u00e9 vlo\u017een\u00e9 ID je: \" . $last_id;\r\n} else {\r\necho \"Chyba: \" . $sql . \"<br>\" . mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"T\u00e9ma: Pr\u00e1ca s MySQL datab\u00e1zami II. \u00daloha: Vysk\u00fa\u0161ajte skripty pomocou ktor\u00fdch vytvor\u00edte nov\u00fa tabu\u013eku vo vytvorenej datab\u00e1ze, prid\u00e1te z\u00e1znamy a skontrolujete tabu\u013eky v datab\u00e1ze. Skripty bud\u00fa ulo\u017een\u00e9 v s\u00faboroch s n\u00e1zvom: vytvor_table.php, pridaj_zaznam.php, viac_zaznamov.php a vypis_zaznamov.php. Podmienky: Vytvoren\u00e9 s\u00fabory so skriptami umiestnite na svoj blog v polo\u017eke PHP \u201eZadanie \u010d.16 Pr\u00e1ca s MySQL datab\u00e1zami II.\u201c […]<\/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-455","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/455","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=455"}],"version-history":[{"count":9,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/455\/revisions"}],"predecessor-version":[{"id":465,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/455\/revisions\/465"}],"wp:attachment":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}