{"id":430,"date":"2024-04-08T06:56:55","date_gmt":"2024-04-08T04:56:55","guid":{"rendered":"https:\/\/gdm.sosthe.sk\/?p=430"},"modified":"2024-04-08T06:56:55","modified_gmt":"2024-04-08T04:56:55","slug":"vytvorenie-databazy-mysql-pomocou-php","status":"publish","type":"post","link":"https:\/\/gdm.sosthe.sk\/?p=430","title":{"rendered":"Vytvorenie datab\u00e1zy MySQL pomocou php"},"content":{"rendered":"
<\/div>\n

Datab\u00e1za pozost\u00e1va z jednej alebo viacer\u00fdch tabuliek.<\/span><\/p>\n

Na vytvorenie alebo odstr\u00e1nenie datab\u00e1zy MySQL budete potrebova\u0165 \u0161peci\u00e1lne privil\u00e9gi\u00e1 CREATE.<\/span><\/p>\n

\n

Vytvorte datab\u00e1zu MySQL pomocou MySQLi a PDO<\/span><\/h2>\n

Pr\u00edkaz CREATE DATABASE sa pou\u017e\u00edva na vytvorenie datab\u00e1zy v MySQL.<\/span><\/p>\n

Nasleduj\u00face pr\u00edklady vytv\u00e1raj\u00fa datab\u00e1zu s n\u00e1zvom „myDB“:<\/span><\/p>\n

\n

Pr\u00edklad (Objektovo orientovan\u00fd MySQLi)<\/span><\/h3>\n
<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n\r\n\/\/ Create connection\r\n<\/span>$conn =\u00a0new<\/span>\u00a0mysqli($servername, $username, $password);\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\/\/ Create database\r\n<\/span>$sql =\u00a0\"CREATE DATABASE myDB\"<\/span>;\r\nif<\/span>\u00a0($conn->query($sql) === TRUE) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"Database created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error creating database: \"<\/span>\u00a0. $conn->error;\r\n}\r\n\r\n$conn->close();\r\n?><\/span><\/span><\/pre>\n<\/div>\n
\n
Pozn\u00e1mka:<\/span><\/strong>\u00a0Ke\u010f vytv\u00e1rate nov\u00fa datab\u00e1zu, mus\u00edte zada\u0165 iba prv\u00e9 tri argumenty objektu mysqli (meno servera, meno pou\u017e\u00edvate\u013ea a heslo).<\/span><\/p>\n
Tip:<\/span><\/strong>\u00a0Ak mus\u00edte pou\u017ei\u0165 konkr\u00e9tny port, pridajte pr\u00e1zdny re\u0165azec pre argument n\u00e1zvu datab\u00e1zy, napr\u00edklad takto: new mysqli(„localhost“, „username“, „password“, „“, port)<\/span><\/p>\n<\/div>\n
\n
<\/div>\n
\n
\n
Pr\u00edklad (Proced\u00fara MySQLi)<\/span><\/h3>\n
<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n\r\n\/\/ Create connection\r\n<\/span>$conn = mysqli_connect($servername, $username, $password);\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\/\/ Create database\r\n<\/span>$sql =\u00a0\"CREATE DATABASE myDB\"<\/span>;\r\nif<\/span>\u00a0(mysqli_query($conn, $sql)) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"Database created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error creating database: \"<\/span>\u00a0. mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/span><\/span><\/pre>\n<\/div>\n
Pozn\u00e1mka:<\/span><\/strong>\u00a0Nasleduj\u00faci pr\u00edklad PDO vytvor\u00ed datab\u00e1zu s n\u00e1zvom „myDBPDO“:<\/span><\/p>\n
\n
Pr\u00edklad (CHOP)<\/span><\/h3>\n
<?php<\/span>\r\n$servername =\u00a0\"localhost\"<\/span>;\r\n$username =\u00a0\"username\"<\/span>;\r\n$password =\u00a0\"password\"<\/span>;\r\n\r\ntry<\/span>\u00a0{\r\n\u00a0\u00a0$conn =\u00a0new<\/span>\u00a0PDO(\"mysql:host=$servername\"<\/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\"CREATE DATABASE myDBPDO\"<\/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\"Database created successfully<br>\"<\/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
Tip:<\/span><\/strong>\u00a0Ve\u013ekou v\u00fdhodou PDO je, \u017ee m\u00e1 triedu v\u00fdnimiek na rie\u0161enie ak\u00fdchko\u013evek probl\u00e9mov, ktor\u00e9 sa m\u00f4\u017eu vyskytn\u00fa\u0165 v na\u0161ich datab\u00e1zov\u00fdch dotazoch. Ak je v bloku try{ } vyvolan\u00e1 v\u00fdnimka, skript sa zastav\u00ed a prejde priamo do prv\u00e9ho bloku catch(){ }. Vo vy\u0161\u0161ie uvedenom bloku catch opakujeme pr\u00edkaz SQL a vygenerovan\u00fa chybov\u00fa spr\u00e1vu.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Datab\u00e1za pozost\u00e1va z jednej alebo viacer\u00fdch tabuliek. Na vytvorenie alebo odstr\u00e1nenie datab\u00e1zy MySQL budete potrebova\u0165 \u0161peci\u00e1lne privil\u00e9gi\u00e1 CREATE. Vytvorte datab\u00e1zu MySQL pomocou MySQLi a PDO Pr\u00edkaz CREATE DATABASE sa pou\u017e\u00edva na vytvorenie datab\u00e1zy v MySQL. Nasleduj\u00face pr\u00edklady vytv\u00e1raj\u00fa datab\u00e1zu s n\u00e1zvom „myDB“: Pr\u00edklad (Objektovo orientovan\u00fd MySQLi) <?php $servername =\u00a0„localhost“; $username =\u00a0„username“; $password =\u00a0„password“; \/\/ Create […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-430","post","type-post","status-publish","format-standard","hentry","category-nezaradene"],"_links":{"self":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/posts\/430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"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=430"}],"version-history":[{"count":1,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/posts\/430\/revisions"}],"predecessor-version":[{"id":431,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/posts\/430\/revisions\/431"}],"wp:attachment":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}