Podpora komunity:<\/strong> D\u00edky sv\u00e9 popularit\u011b m\u00e1 MySQL rozs\u00e1hlou komunitu, kter\u00e1 poskytuje podporu a sd\u00edl\u00ed n\u00e1stroje.<\/li>\n<\/ol>\n\n\n\nJak se p\u0159ipojit k MySQL z PHP<\/h3>\n\n\n\n
P\u0159ipojen\u00ed k MySQL z PHP je jednoduch\u00e9 d\u00edky rozhran\u00ed PDO (PHP Data Objects). Uk\u00e1zkov\u00fd k\u00f3d vypad\u00e1 takto:<\/p>\n\n\n\n
<?php\ntry {\n $dsn = 'mysql:host=localhost;dbname=mojedb';\n $username = 'root';\n $password = '';\n\n $pdo = new PDO($dsn, $username, $password);\n $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\n echo \"P\u0159ipojen\u00ed \u00fasp\u011b\u0161n\u00e9!\";\n} catch (PDOException $e) {\n echo \"Chyba p\u0159ipojen\u00ed: \" . $e->getMessage();\n}\n?><\/code><\/pre>\n\n\n\nZ\u00e1kladn\u00ed SQL dotazy<\/h3>\n\n\n\n\n- Vlo\u017een\u00ed dat:<\/strong><\/li>\n<\/ol>\n\n\n\n
INSERT INTO uzivatele (jmeno, email) VALUES ('Petr', 'petr@email.cz');<\/code><\/pre>\n\n\n\n\n- Z\u00edsk\u00e1n\u00ed dat:<\/strong><\/li>\n<\/ol>\n\n\n\n
SELECT * FROM uzivatele;<\/code><\/pre>\n\n\n\n\n- Aktualizace dat:<\/strong><\/li>\n<\/ol>\n\n\n\n
UPDATE uzivatele SET email = 'novy@email.cz' WHERE id = 1;<\/code><\/pre>\n\n\n\n\n- Smaz\u00e1n\u00ed dat:<\/strong><\/li>\n<\/ol>\n\n\n\n
DELETE FROM uzivatele WHERE id = 2;<\/code><\/pre>\n\n\n\nP\u0159\u00edklad pou\u017eit\u00ed MySQL v re\u00e1ln\u00e9m projektu<\/h3>\n\n\n\n
P\u0159edstavme si, \u017ee vytv\u00e1\u0159\u00edte jednoduchou webovou aplikaci, kde si u\u017eivatel\u00e9 mohou vytvo\u0159it \u00fa\u010det. Po registraci jejich data ulo\u017e\u00edte do datab\u00e1ze a p\u0159i p\u0159ihl\u00e1\u0161en\u00ed je ov\u011b\u0159\u00edte.<\/p>\n\n\n\n
Registrace:<\/p>\n\n\n\n
<?php\n$stmt = $pdo->prepare('INSERT INTO uzivatele (jmeno, email) VALUES (?, ?)');\n$stmt->execute(['Karel', 'karel@email.cz']);<\/code><\/pre>\n\n\n\nP\u0159ihl\u00e1\u0161en\u00ed:<\/p>\n\n\n\n
<?php\n$stmt = $pdo->prepare('SELECT * FROM uzivatele WHERE email = ?');\n$stmt->execute(['karel@email.cz']);\n$user = $stmt->fetch();\nif ($user) {\n echo \"U\u017eivatel nalezen: \" . $user['jmeno'];\n} else {\n echo \"U\u017eivatel neexistuje.\";\n}<\/code><\/pre>\n\n\n\nV\u00fdhody a nev\u00fdhody MySQL<\/h3>\n\n\n\n
V\u00fdhody:<\/strong><\/p>\n\n\n\n\n- Rychlost a spolehlivost.<\/li>\n\n\n\n
- Snadn\u00e1 integrace s programovac\u00edmi jazyky.<\/li>\n\n\n\n
- \u0160irok\u00e1 podpora komunitou.<\/li>\n\n\n\n
- Open-source s mo\u017enost\u00ed komer\u010dn\u00edho vyu\u017eit\u00ed.<\/li>\n<\/ul>\n\n\n\n
Nev\u00fdhody:<\/strong><\/p>\n\n\n\n\n- Omezen\u00ed p\u0159i pr\u00e1ci s velmi komplexn\u00edmi dotazy nebo pokro\u010dil\u00fdmi funkcemi.
Nevy\u017eaduje transakce, kter\u00e9 jsou nap\u0159\u00edklad v PostgreSql nutnost\u00ed. <\/li>\n<\/ul>\n\n\n\nJak za\u010d\u00edt s MySQL<\/h3>\n\n\n\n\n- Instalace:<\/strong> Nainstalujte MySQL server (nap\u0159. pomoc\u00ed XAMPP, WAMP nebo Dockeru).<\/li>\n\n\n\n
- Spr\u00e1va:<\/strong> Pou\u017eijte n\u00e1stroje jako phpMyAdmin nebo MySQL Workbench pro spr\u00e1vu datab\u00e1z\u00ed.<\/li>\n\n\n\n
- Z\u00e1klady SQL:<\/strong> Nau\u010dte se z\u00e1kladn\u00ed p\u0159\u00edkazy SQL, jako jsou
SELECT<\/code>, INSERT<\/code>, UPDATE<\/code> a DELETE<\/code>.<\/li>\n\n\n\n- Integrace:<\/strong> Vyzkou\u0161ejte p\u0159ipojen\u00ed MySQL s va\u0161\u00ed aplikac\u00ed v PHP nebo jin\u00e9m jazyce.<\/li>\n<\/ol>\n\n\n\n
MySQL je siln\u00fd n\u00e1stroj pro spr\u00e1vu datab\u00e1z\u00ed, kter\u00fd z\u016fst\u00e1v\u00e1 obl\u00edbenou volbou jak pro mal\u00e9 projekty, tak pro rozs\u00e1hl\u00e9 aplikace. D\u00edky sv\u00e9 jednoduchosti a v\u00fdkonu je skv\u011bl\u00fdm v\u00fdchoz\u00edm bodem pro ka\u017ed\u00e9ho v\u00fdvoj\u00e1\u0159e.<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL je jedn\u00edm z nejpopul\u00e1rn\u011bj\u0161\u00edch syst\u00e9m\u016f pro spr\u00e1vu rela\u010dn\u00edch datab\u00e1z\u00ed na sv\u011bt\u011b. Byla vytvo\u0159ena v roce 1995 \u0161v\u00e9dskou spole\u010dnost\u00ed MySQL AB a dnes je vlastn\u011bna spole\u010dnost\u00ed Oracle Corporation. MySQL je open-source software, co\u017e znamen\u00e1, \u017ee je zdarma dostupn\u00e1, a z\u00e1rove\u0148<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[77],"tags":[22,73,47,74,78],"class_list":["post-102","post","type-post","status-publish","format-standard","hentry","category-technologie","tag-devops","tag-mysql","tag-php","tag-postgrsql","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/posts\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":1,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":103,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions\/103"}],"wp:attachment":[{"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/josefnemec.cz\/blog\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}