{"id":2048,"date":"2022-08-27T10:34:45","date_gmt":"2022-08-27T08:34:45","guid":{"rendered":"https:\/\/www.areaweb.sk\/?p=2048"},"modified":"2022-12-16T23:54:15","modified_gmt":"2022-12-16T22:54:15","slug":"pripojenie-na-databazu-a-zakladne-sql-prikazy","status":"publish","type":"post","link":"https:\/\/www.areaweb.sk\/cs\/pripojenie-na-databazu-a-zakladne-sql-prikazy\/","title":{"rendered":"Pripojenie na datab\u00e1zu a z\u00e1kladne SQL pr\u00edkazy"},"content":{"rendered":"
\"\"<\/figure>\n\n\n\n
\/\/ database configuration\n$config = [\n\n\t'db' => [\n\t\t'type'     => 'mysql',\n\t\t'name'     => 'meno_databazy',\n\t\t'server'   => 'domena.sk',\n\t\t'username' => 'meno',\n\t\t'password' => 'tvoje_heslo',\n\t\t'charset'  => 'utf8'\n\t]\n];\n\n\n\/\/ connect to db\n$db = new PDO(\n\t\"{$config['db']['type']}:host={$config['db']['server']};\n\tdbname={$config['db']['name']};charset={$config['db']['charset']}\",\n\t$config['db']['username'], $config['db']['password']\n);\n\n$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);\n<\/code><\/pre>\n\n\n\n
takto vytiahne\u0161 d\u00e1ta z datab\u00e1zy pomocou SQL<\/p>\n\n\n\n
$data = $db->query(\"SELECT * FROM api_attendance_users\") ;\n$first_name = $db->query(\"SELECT first_name FROM api_attendance_users\") ;\n$last_name= $db->query(\"SELECT last_name FROM api_attendance_users\") ;\n$prihlaseny= $db->query(\"SELECT prihlaseny FROM api_attendance_users\") ;\n$user_id= $db->query(\"SELECT id FROM api_attendance_users\") ;\n$cele_mena = $db->query(\"SELECT first_name,last_name FROM api_attendance_users ORDER BY last_name ASC\") ;<\/code><\/pre>\n\n\n\n
takto vlo\u017e\u00ed\u0161 \u00fadaje do datab\u00e1zy s n\u00e1zvom zaznamy_dochadzky<\/p>\n\n\n\n
$db->query(\"INSERT INTO `zaznamy_dochadzky` (ID, Meno, Priezvisko, D\u00e1tum, Fotka) VALUES ( $id, '$prve_meno', '$druhe_meno', NOW(), '$fotka')\") ;\n<\/code><\/pre>\n\n\n\n
takto vyp\u00ed\u0161e\u0161 \u00fadaje z datab\u00e1zy<\/p>\n\n\n\n
 $stav_prihlasenia = $db->query(\"SELECT prihlaseny FROM api_attendance_users WHERE first_name = '$prve_meno' AND last_name = '$druhe_meno' \" ) ;\n\n\n   $pole_prihlasenia = [];\n   foreach ( $stav_prihlasenia as $item) {\n        \/\/print_r($item);\n        array_push($pole_prihlasenia,$item[0]);\t\n    }\n<\/code><\/pre>\n\n\n\n
alebo takto<\/p>\n\n\n\n
\n  \n$pole_dnes_neaktivny_meno = [];\n  $pole_dnes_neaktivny_priezvisko = [];\n    foreach ( $stav_aktivity as $item) {\n        array_push($pole_dnes_neaktivny_meno,$item);\t\n        array_push($pole_dnes_neaktivny_priezvisko,$item);\n    }\n\n    foreach ( $pole_dnes_neaktivny_meno as $zaznam) {\n        echo $zaznam[0];\n        echo ' ';\n        echo $zaznam[1];\n        echo '<br>';\n        echo '<hr>';\n    }\n}<\/code><\/pre>\n\n\n\n
takto aktualizuje\u0161 z\u00e1znam<\/p>\n\n\n\n
  if ($pole_prihlasenia[0] == 1 ){\n        $db->query(\"UPDATE `api_attendance_users` SET `prihlaseny` = 0 WHERE first_name = '$prve_meno' AND last_name = '$druhe_meno' \") ;\n    }<\/code><\/pre>\n\n\n\n
Pou\u017eitie z\u00e1poru<\/code><\/pre>\n\n\n\n
   $stav_aktivity= $db->query(\"SELECT first_name, last_name FROM api_attendance_users WHERE NOT prihlaseny = 1\" ) ;<\/code><\/pre>\n\n\n\n
Vytiahnutie z\u00e1znamu cez PDO re\u017eim:<\/p>\n\n\n\n
\/* vytiahnutie zaznamu *\/ \n$adma = $db->prepare(\"SELECT * FROM `api_attendance_users` WHERE last_name = 'Priezvisko' \");\n$adma->execute();\n$row = $adma->fetch(PDO::FETCH_ASSOC);\nprint_r( $row );\nprint_r($row['first_name']\n\n$user = $db->query(\"SELECT * from api_attendance_users LIMIT 1\")->fetch(PDO::FETCH_BOTH);\nprint_r($user);\n\n\/* vytiahnutie viac z\u00e1znamov*\/\n$user = $db->query(\"SELECT * from api_attendance_users LIMIT 15\")->fetchAll(PDO::FETCH_GROUP);\nprint_r($user);<\/code><\/pre>\n\n\n\n
Viac o re\u017eimoch na\u010d\u00edtania PDO:
https:\/\/phpdelusions.net\/pdo\/fetch_modes<\/a><\/p>\n\n\n\n
U\u017eito\u010dn\u00e9 pr\u00edkazy<\/p>\n\n\n\n
UPDATE `api_attendance_users` SET first_name = REPLACE(first_name, 'a', '?');   -- nahradi string<\/code><\/pre>","protected":false},"excerpt":{"rendered":"
\/\/ database configuration $config = [ ‚db‘ => [ ‚type‘ => ‚mysql‘, ‚name‘ => ‚meno_databazy‘, ‚server‘ => ‚domena.sk‘, ‚username‘ => ‚meno‘, ‚password‘ => ‚tvoje_heslo‘, ‚charset‘ => ‚utf8‘ ] ]; \/\/ connect to db $db =\u2026<\/p>\n","protected":false},"author":1,"featured_media":2052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,38],"tags":[],"class_list":["post-2048","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-sql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/posts\/2048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/comments?post=2048"}],"version-history":[{"count":0,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/posts\/2048\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/media\/2052"}],"wp:attachment":[{"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/media?parent=2048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/categories?post=2048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.areaweb.sk\/cs\/wp-json\/wp\/v2\/tags?post=2048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}