{"id":446,"date":"2024-04-15T06:59:07","date_gmt":"2024-04-15T04:59:07","guid":{"rendered":"https:\/\/gdm.sosthe.sk\/?page_id=446"},"modified":"2024-04-15T07:02:15","modified_gmt":"2024-04-15T05:02:15","slug":"vytvorenie-tabulky-php-mysql","status":"publish","type":"page","link":"https:\/\/gdm.sosthe.sk\/?page_id=446","title":{"rendered":"Vytvorenie tabu\u013eky PHP MySQL"},"content":{"rendered":"

Datab\u00e1zov\u00e1 tabu\u013eka m\u00e1 svoj vlastn\u00fd jedine\u010dn\u00fd n\u00e1zov a sklad\u00e1 sa zo st\u013apcov a riadkov.<\/p>\n

\n

Vytvorenie tabu\u013eky MySQL pomocou MySQLi a PDO<\/h3>\n

Pr\u00edkaz CREATE TABLE sa pou\u017e\u00edva na vytvorenie tabu\u013eky v MySQL.<\/p>\n

Vytvor\u00edme tabu\u013eku s n\u00e1zvom „MyGuests“ s piatimi st\u013apcami: „id“, „firstname“, „lastname“, „email“ a „reg_date“:<\/p>\n

\n
CREATE TABLE MyGuests (\r\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\nfirstname VARCHAR(30) NOT NULL,\r\nlastname VARCHAR(30) NOT NULL,\r\nemail VARCHAR(50),\r\nreg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\r\n)<\/pre>\n<\/div>\n
Pozn\u00e1mky k tabu\u013eke vy\u0161\u0161ie:<\/b><\/p>\n
Typ \u00fadajov ur\u010duje, ak\u00fd typ \u00fadajov m\u00f4\u017ee st\u013apec obsahova\u0165. \u00dapln\u00fa referenciu o v\u0161etk\u00fdch dostupn\u00fdch typoch \u00fadajov n\u00e1jdete v na\u0161ej\u00a0referencii o typoch \u00fadajov\u00a0.<\/p>\n
Po type \u00fadajov m\u00f4\u017eete pre ka\u017ed\u00fd st\u013apec zada\u0165 \u010fal\u0161ie volite\u013en\u00e9 atrib\u00faty:<\/p>\n
    \n
  • NOT NULL \u2013 ka\u017ed\u00fd riadok mus\u00ed obsahova\u0165 hodnotu pre dan\u00fd st\u013apec, hodnoty null nie s\u00fa povolen\u00e9<\/li>\n
  • DEFAULT hodnota \u2013 nastavte predvolen\u00fa hodnotu, ktor\u00e1 sa prid\u00e1, ke\u010f sa neodovzd\u00e1 \u017eiadna in\u00e1 hodnota<\/li>\n
  • UNSIGNED – Pou\u017e\u00edva sa pre typy \u010d\u00edsel, obmedzuje ulo\u017een\u00e9 \u00fadaje na kladn\u00e9 \u010d\u00edsla a nulu<\/li>\n
  • AUTOMATICK\u00c9 ZV\u00dd\u0160ENIE \u2013 MySQL automaticky zv\u00fd\u0161i hodnotu po\u013ea o 1 pri ka\u017edom pridan\u00ed nov\u00e9ho z\u00e1znamu<\/li>\n
  • PRIM\u00c1RNY K\u013d\u00da\u010c \u2013 Pou\u017e\u00edva sa na jedine\u010dn\u00fa identifik\u00e1ciu riadkov v tabu\u013eke. St\u013apec s nastaven\u00edm PRIMARY KEY je \u010dasto ID \u010d\u00edslo a \u010dasto sa pou\u017e\u00edva s AUTO_INCREMENT<\/li>\n<\/ul>\n
    Ka\u017ed\u00e1 tabu\u013eka by mala ma\u0165 st\u013apec prim\u00e1rneho k\u013e\u00fa\u010da (v tomto pr\u00edpade: st\u013apec \u201eid\u201c). Jeho hodnota mus\u00ed by\u0165 jedine\u010dn\u00e1 pre ka\u017ed\u00fd z\u00e1znam v tabu\u013eke.<\/p>\n
    Nasleduj\u00face pr\u00edklady ukazuj\u00fa, ako vytvori\u0165 tabu\u013eku v PHP:<\/p>\n
    \n
    Pr\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 to create table\r\n<\/span>$sql =\u00a0\"CREATE TABLE MyGuests (\r\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\nfirstname VARCHAR(30) NOT NULL,\r\nlastname VARCHAR(30) NOT NULL,\r\nemail VARCHAR(50),\r\nreg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\r\n)\"<\/span>;\r\n\r\nif<\/span>\u00a0($conn->query($sql) === TRUE) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"Table MyGuests created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error creating table: \"<\/span>\u00a0. $conn->error;\r\n}\r\n\r\n$conn->close();\r\n?><\/span><\/span><\/pre>\n<\/div>\n
    <\/div>\n
    \n
    \n
    Pr\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 to create table\r\n<\/span>$sql =\u00a0\"CREATE TABLE MyGuests (\r\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\nfirstname VARCHAR(30) NOT NULL,\r\nlastname VARCHAR(30) NOT NULL,\r\nemail VARCHAR(50),\r\nreg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\r\n)\"<\/span>;\r\n\r\nif<\/span>\u00a0(mysqli_query($conn, $sql)) {\r\n\u00a0\u00a0echo<\/span>\u00a0\"Table MyGuests created successfully\"<\/span>;\r\n}\u00a0else<\/span>\u00a0{\r\n\u00a0\u00a0echo<\/span>\u00a0\"Error creating table: \"<\/span>\u00a0. mysqli_error($conn);\r\n}\r\n\r\nmysqli_close($conn);\r\n?><\/span><\/span><\/pre>\n<\/div>\n
    \n
    <\/h3>\n
    \n
    Pr\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\r\n\u00a0\u00a0\/\/ sql to create table\r\n<\/span>\u00a0\u00a0<\/span>$sql =\u00a0\"CREATE TABLE MyGuests (\r\n\u00a0\u00a0id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\n\u00a0\u00a0firstname VARCHAR(30) NOT NULL,\r\n\u00a0 lastname VARCHAR(30) NOT NULL,\r\n\u00a0 email VARCHAR(50),\r\n\u00a0 reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\r\n\u00a0\u00a0)\"<\/span>;\r\n\r\n\u00a0\u00a0\/\/ use exec() because no results are returned\r\n<\/span>\u00a0 $conn->exec($sql);\r\n\u00a0\u00a0echo<\/span>\u00a0\"Table MyGuests 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":"
    Datab\u00e1zov\u00e1 tabu\u013eka m\u00e1 svoj vlastn\u00fd jedine\u010dn\u00fd n\u00e1zov a sklad\u00e1 sa zo st\u013apcov a riadkov. Vytvorenie tabu\u013eky MySQL pomocou MySQLi a PDO Pr\u00edkaz CREATE TABLE sa pou\u017e\u00edva na vytvorenie tabu\u013eky v MySQL. Vytvor\u00edme tabu\u013eku s n\u00e1zvom „MyGuests“ s piatimi st\u013apcami: „id“, „firstname“, „lastname“, „email“ a „reg_date“: CREATE TABLE MyGuests ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, […]<\/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-446","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/446","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=446"}],"version-history":[{"count":3,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/446\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=\/wp\/v2\/pages\/446\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/gdm.sosthe.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}