{"id":3545,"date":"2017-08-16T22:13:25","date_gmt":"2017-08-16T19:13:25","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/build-crud-application-php-mysql-edit-and-sava-data\/"},"modified":"2020-04-09T23:18:10","modified_gmt":"2020-04-09T20:18:10","slug":"build-crud-application-php-mysql-edit-and-sava-data","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/phpmysql\/build-crud-application-php-mysql-edit-and-sava-data\/","title":{"rendered":"Build CRUD Application PHP &#038; Mysql. Edit and sava data"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.22&#8243;][et_pb_fullwidth_header title=&#8221;Build CRUD Application PHP &#038; Mysql. Edit and sava data&#8221; content_max_width=&#8221;none&#8221; _builder_version=&#8221;3.16&#8243; button_one_letter_spacing_hover=&#8221;0&#8243; button_two_letter_spacing_hover=&#8221;0&#8243; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;on&#8221; button_one_letter_spacing__hover=&#8221;0&#8243; button_two_letter_spacing__hover_enabled=&#8221;on&#8221; button_two_letter_spacing__hover=&#8221;0&#8243; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221;][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;3.22&#8243;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;0px|||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_dcsbcm_divi_breadcrumbs_module homebreadcrumbtext=&#8221;Home&#8221; hide_currentbreadcrumb=&#8221;off&#8221; _builder_version=&#8221;4.4.2&#8243; custom_padding=&#8221;0px|||&#8221; hover_enabled=&#8221;0&#8243; fontsbreadcrumbs_font_size_tablet=&#8221;51&#8243; fontsbreadcrumbs_line_height_tablet=&#8221;2&#8243; fontsseperator_font_size_tablet=&#8221;51&#8243; fontsseperator_line_height_tablet=&#8221;2&#8243; fontsbreadcrumblinks_font_size_tablet=&#8221;51&#8243; fontsbreadcrumblinks_line_height_tablet=&#8221;2&#8243;][\/et_pb_dcsbcm_divi_breadcrumbs_module][et_pb_text _builder_version=&#8221;3.27.4&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; use_border_color=&#8221;off&#8221; border_color=&#8221;#ffffff&#8221; border_style=&#8221;solid&#8221;]We continue to build our php+mysql applicaiton. Today we will realize opportunity for editing and saving data to database.<!--more--><br \/>\n[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=BpA_QvQPVlE&#8221; _builder_version=&#8221;3.0.47&#8243;][\/et_pb_video][et_pb_text _builder_version=&#8221;3.27.4&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; use_border_color=&#8221;off&#8221; border_color=&#8221;#ffffff&#8221; border_style=&#8221;solid&#8221;]First of all you need understand, how we make our object unique. The page for every object edit.php. But we will add id player which we are going to edit. In result link will be edit.php?player_id=1 (page for editing information about player with id=1).<\/p>\n<p>While saving we will act in a similar way. But we will pass id in input type=&#8221;hidden&#8221;.<br \/>\n[\/et_pb_text][et_pb_dmb_code_snippet title=&#8221;Code lesson (players.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAogICAgICAgICAgICAgICAgICAgICRwbGF5ZXJzID0gZ2V0QWxsUGxheWVycygkZGIpOwogICAgICAgICAgICAgPz4KICAgICAgICAgICAgIDx0YWJsZSBjbGFzcz0idGFibGUgdGFibGUtYm9yZGVyZWQiPgogICAgICAgICAgICAgICAgIDx0cj4KICAgICAgICAgICAgICAgICAgICAgPHRoPtCY0LPRgNC+0Lo8L3RoPgogICAgICAgICAgICAgICAgICAgICA8dGg+0JrQvtC80LDQvdC00LA8L3RoPgogICAgICAgICAgICAgICAgICAgICA8dGg+0KHRgtGA0LDQvdCwPC90aD4KICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgIDw\/cGhwIGZvcmVhY2ggKCRwbGF5ZXJzIGFzICRwbGF5ZXIpIHsgPz4KICAgICAgICAgICAgICAgICAgICA8dHI+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0ZD48YSBocmVmPSJlZGl0LnBocD9wbGF5ZXJfaWQ9PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfaWQnXTsgPz4iPjw\/cGhwIGVjaG8gJHBsYXllclsncGxheWVyX25hbWUnXTsgPz48L2E+PC90ZD4KICAgICAgICAgICAgICAgICAgICAgICAgPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsndGVhbV9uYW1lJ107ID8+PC90ZD4KICAgICAgICAgICAgICAgICAgICAgICAgPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsnY291bnRyeV9uYW1lJ107ID8+PC90ZD4KICAgICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgPD9waHAgfSA\/PgoKICAgICAgICAgICAgIDwvdGFibGU+CiAgICAgICAgPC9kaXY+CgogICAgICAgIDxmb290ZXI+CgogICAgICAgIDwvZm9vdGVyPgogICAgPC9ib2R5Pgo8L2h0bWw+&#8221; admin_label=&#8221;\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430&#8221; style=&#8221;docco&#8221; linenums=&#8221;on&#8221; usetabwidth=&#8221;on&#8221; tabwidth=&#8221;4&#8243; _builder_version=&#8221;4.4.2&#8243; hover_enabled=&#8221;0&#8243;]PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAogICAgICAgICAgICAgICAgICAgICRwbGF5ZXJzID0gZ2V0QWxsUGxheWVycygkZGIpOwogICAgICAgICAgICAgPz4KICAgICAgICAgICAgIDx0YWJsZSBjbGFzcz0idGFibGUgdGFibGUtYm9yZGVyZWQiPgogICAgICAgICAgICAgICAgIDx0cj4KICAgICAgICAgICAgICAgICAgICAgPHRoPtCY0LPRgNC+0Lo8L3RoPgogICAgICAgICAgICAgICAgICAgICA8dGg+0JrQvtC80LDQvdC00LA8L3RoPgogICAgICAgICAgICAgICAgICAgICA8dGg+0KHRgtGA0LDQvdCwPC90aD4KICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgIDw\/cGhwIGZvcmVhY2ggKCRwbGF5ZXJzIGFzICRwbGF5ZXIpIHsgPz4KICAgICAgICAgICAgICAgICAgICA8dHI+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0ZD48YSBocmVmPSJlZGl0LnBocD9wbGF5ZXJfaWQ9PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfaWQnXTsgPz4iPjw\/cGhwIGVjaG8gJHBsYXllclsncGxheWVyX25hbWUnXTsgPz48L2E+PC90ZD4KICAgICAgICAgICAgICAgICAgICAgICAgPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsndGVhbV9uYW1lJ107ID8+PC90ZD4KICAgICAgICAgICAgICAgICAgICAgICAgPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsnY291bnRyeV9uYW1lJ107ID8+PC90ZD4KICAgICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgPD9waHAgfSA\/PgoKICAgICAgICAgICAgIDwvdGFibGU+CiAgICAgICAgPC9kaXY+CgogICAgICAgIDxmb290ZXI+CgogICAgICAgIDwvZm9vdGVyPgogICAgPC9ib2R5Pgo8L2h0bWw+[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (edit.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAogICAgICAgICAgICAgICAgICAgICRpZCA9ICRfR0VUWydwbGF5ZXJfaWQnXTsKICAgICAgICAgICAgICAgICAgICBpZigkaWQpIHsKICAgICAgICAgICAgICAgICAgICAgICAgJHBsYXllciA9IGdldFBsYXllckJ5SWQoJGRiLCAkaWQpOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICBlbHNlIHsKICAgICAgICAgICAgICAgICAgICAgICAgZWNobyAnPGRpdiBjbGFzcz0iYWxlcnQgYWxlcnQtZGFuZ2VyIiByb2xlPSJhbGVydCI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9ImdseXBoaWNvbiBnbHlwaGljb24tZXhjbGFtYXRpb24tc2lnbiIgYXJpYS1oaWRkZW49InRydWUiPjwvc3Bhbj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJzci1vbmx5Ij5FcnJvcjo8L3NwYW4+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICDQmNCz0YDQvtC6INC90LUg0L3QsNC50LTQtdC9CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9kaXY+JzsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICA\/PgogICAgICAgICAgICA8Zm9ybSBhY3Rpb249InNhdmUucGhwIiBtZXRob2Q9InBvc3QiPgogICAgICAgICAgICAgICAgPGlucHV0IHR5cGU9ImhpZGRlbiIgbmFtZT0iaWQiIHZhbHVlPSI8P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9pZCddOyA\/PiI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJmb3JtLWdyb3VwIj4KICAgICAgICAgICAgICAgICAgICA8bGFiZWwgZm9yPSJuYW1lIj7QmNCz0YDQvtC6PC9sYWJlbD4KICAgICAgICAgICAgICAgICAgICA8aW5wdXQgdHlwZT0idGV4dCIgY2xhc3M9ImZvcm0tY29udHJvbCIgaWQ9Im5hbWUiIG5hbWU9Im5hbWUiIHZhbHVlPSI8P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+Ij4KICAgICAgICAgICAgICAgICAgPC9kaXY+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0ic3VibWl0IiBjbGFzcz0iYnRuIGJ0bi1kZWZhdWx0Ij7QodC+0YXRgNCw0L3QuNGC0Yw8L2J1dHRvbj4KICAgICAgICAgICAgPC9mb3JtPgogICAgICAgIDwvZGl2PgoKICAgICAgICA8Zm9vdGVyPgoKICAgICAgICA8L2Zvb3Rlcj4KICAgIDwvYm9keT4=&#8221; admin_label=&#8221;\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430 &#8221; style=&#8221;docco&#8221; linenums=&#8221;on&#8221; usetabwidth=&#8221;on&#8221; tabwidth=&#8221;4&#8243; _builder_version=&#8221;4.4.2&#8243; hover_enabled=&#8221;0&#8243;]PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAogICAgICAgICAgICAgICAgICAgICRpZCA9ICRfR0VUWydwbGF5ZXJfaWQnXTsKICAgICAgICAgICAgICAgICAgICBpZigkaWQpIHsKICAgICAgICAgICAgICAgICAgICAgICAgJHBsYXllciA9IGdldFBsYXllckJ5SWQoJGRiLCAkaWQpOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICBlbHNlIHsKICAgICAgICAgICAgICAgICAgICAgICAgZWNobyAnPGRpdiBjbGFzcz0iYWxlcnQgYWxlcnQtZGFuZ2VyIiByb2xlPSJhbGVydCI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9ImdseXBoaWNvbiBnbHlwaGljb24tZXhjbGFtYXRpb24tc2lnbiIgYXJpYS1oaWRkZW49InRydWUiPjwvc3Bhbj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJzci1vbmx5Ij5FcnJvcjo8L3NwYW4+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICDQmNCz0YDQvtC6INC90LUg0L3QsNC50LTQtdC9CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9kaXY+JzsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICA\/PgogICAgICAgICAgICA8Zm9ybSBhY3Rpb249InNhdmUucGhwIiBtZXRob2Q9InBvc3QiPgogICAgICAgICAgICAgICAgPGlucHV0IHR5cGU9ImhpZGRlbiIgbmFtZT0iaWQiIHZhbHVlPSI8P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9pZCddOyA\/PiI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJmb3JtLWdyb3VwIj4KICAgICAgICAgICAgICAgICAgICA8bGFiZWwgZm9yPSJuYW1lIj7QmNCz0YDQvtC6PC9sYWJlbD4KICAgICAgICAgICAgICAgICAgICA8aW5wdXQgdHlwZT0idGV4dCIgY2xhc3M9ImZvcm0tY29udHJvbCIgaWQ9Im5hbWUiIG5hbWU9Im5hbWUiIHZhbHVlPSI8P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+Ij4KICAgICAgICAgICAgICAgICAgPC9kaXY+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0ic3VibWl0IiBjbGFzcz0iYnRuIGJ0bi1kZWZhdWx0Ij7QodC+0YXRgNCw0L3QuNGC0Yw8L2J1dHRvbj4KICAgICAgICAgICAgPC9mb3JtPgogICAgICAgIDwvZGl2PgoKICAgICAgICA8Zm9vdGVyPgoKICAgICAgICA8L2Zvb3Rlcj4KICAgIDwvYm9keT4=[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (save.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAoKCiAgICAgICAgICAgICAgICAgICAgaWYoIWVtcHR5KCRfUE9TVFsnbmFtZSddKSAmJiAhZW1wdHkoJF9QT1NUWydpZCddKSkgewogICAgICAgICAgICAgICAgICAgICAgICAkbmFtZSA9ICRfUE9TVFsnbmFtZSddOwogICAgICAgICAgICAgICAgICAgICAgICAkaWQgPSAkX1BPU1RbJ2lkJ107CiAgICAgICAgICAgICAgICAgICAgICAgIHNhdmVQbGF5ZXIoJGRiLCAkbmFtZSwgJGlkKTsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgZWxzZSB7CiAgICAgICAgICAgICAgICAgICAgICAgIGVjaG8gJzxkaXYgY2xhc3M9ImFsZXJ0IGFsZXJ0LWRhbmdlciIgcm9sZT0iYWxlcnQiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJnbHlwaGljb24gZ2x5cGhpY29uLWV4Y2xhbWF0aW9uLXNpZ24iIGFyaWEtaGlkZGVuPSJ0cnVlIj48L3NwYW4+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8c3BhbiBjbGFzcz0ic3Itb25seSI+RXJyb3I6PC9zcGFuPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg0J7RiNC40LHQutCwINGB0L7RhdGA0LDQvdC10L3QuNGPCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9kaXY+JzsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICA\/PgoKICAgICAgICA8L2Rpdj4KCiAgICAgICAgPGZvb3Rlcj4KCiAgICAgICAgPC9mb290ZXI+CiAgICA8L2JvZHk+CjwvaHRtbD4=&#8221; admin_label=&#8221;\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430 &#8221; style=&#8221;docco&#8221; linenums=&#8221;on&#8221; usetabwidth=&#8221;on&#8221; tabwidth=&#8221;4&#8243; _builder_version=&#8221;4.4.2&#8243; hover_enabled=&#8221;0&#8243;]PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgICAgIDxsaW5rIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL3R3aXR0ZXItYm9vdHN0cmFwLzMuMy43L2Nzcy9ib290c3RyYXAuY3NzIiByZWw9InN0eWxlc2hlZXQiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPgogICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9qcXVlcnkvMy4xLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy43L2pzL2Jvb3RzdHJhcC5taW4uanMiIGNyb3Nzb3JpZ2luPSJhbm9ueW1vdXMiPjwvc2NyaXB0PgogICAgPC9oZWFkPgogICAgPGJvZHk+CiAgICAgICAgPGhlYWRlcj4KICAgICAgICAgICAgPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0Ij4KICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXItZmx1aWQiPgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0ibmF2YmFyLWhlYWRlciI+CiAgICAgICAgICAgICAgICAgIDxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSBjb2xsYXBzZWQiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9IiNicy1leGFtcGxlLW5hdmJhci1jb2xsYXBzZS0xIiBhcmlhLWV4cGFuZGVkPSJmYWxzZSI+CiAgICAgICAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgogICAgICAgICAgICAgICAgICA8L2J1dHRvbj4KICAgICAgICAgICAgICAgICAgPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgogICAgICAgICAgICAgICAgPC9kaXY+CgogICAgICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIiBpZD0iYnMtZXhhbXBsZS1uYXZiYXItY29sbGFwc2UtMSI+CiAgICAgICAgICAgICAgICAgIDx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSIvIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgogICAgICAgICAgICAgICAgICAgIDxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CiAgICAgICAgICAgICAgICAgICAgPGxpPjxhIGhyZWY9InRlYW1zLnBocCI+0JrQvtC80LDQvdC00Ys8L2E+PC9saT4KICAgICAgICAgICAgICAgICAgPC91bD4KICAgICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPC9uYXY+CiAgICAgICAgPC9oZWFkZXI+CgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CiAgICAgICAgICAgIDw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgogICAgICAgICAgICA8P3BocAoKCiAgICAgICAgICAgICAgICAgICAgaWYoIWVtcHR5KCRfUE9TVFsnbmFtZSddKSAmJiAhZW1wdHkoJF9QT1NUWydpZCddKSkgewogICAgICAgICAgICAgICAgICAgICAgICAkbmFtZSA9ICRfUE9TVFsnbmFtZSddOwogICAgICAgICAgICAgICAgICAgICAgICAkaWQgPSAkX1BPU1RbJ2lkJ107CiAgICAgICAgICAgICAgICAgICAgICAgIHNhdmVQbGF5ZXIoJGRiLCAkbmFtZSwgJGlkKTsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgZWxzZSB7CiAgICAgICAgICAgICAgICAgICAgICAgIGVjaG8gJzxkaXYgY2xhc3M9ImFsZXJ0IGFsZXJ0LWRhbmdlciIgcm9sZT0iYWxlcnQiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxzcGFuIGNsYXNzPSJnbHlwaGljb24gZ2x5cGhpY29uLWV4Y2xhbWF0aW9uLXNpZ24iIGFyaWEtaGlkZGVuPSJ0cnVlIj48L3NwYW4+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8c3BhbiBjbGFzcz0ic3Itb25seSI+RXJyb3I6PC9zcGFuPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg0J7RiNC40LHQutCwINGB0L7RhdGA0LDQvdC10L3QuNGPCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9kaXY+JzsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICA\/PgoKICAgICAgICA8L2Rpdj4KCiAgICAgICAgPGZvb3Rlcj4KCiAgICAgICAgPC9mb290ZXI+CiAgICA8L2JvZHk+CjwvaHRtbD4=[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (api.php)&#8221; code=&#8221;PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7CgogICAgJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHBsYXllcnMKICAgICAgICAgICAgSU5ORVIgSk9JTiB0ZWFtcyBPTiBwbGF5ZXJzLnRlYW1faWQgPSB0ZWFtcy50ZWFtX2lkCiAgICAgICAgICAgIElOTkVSIEpPSU4gY291bnRyaWVzIE9OIHBsYXllcnMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwogICAgIjsKICAgICRyZXN1bHQgPSBhcnJheSgpOwoKICAgICRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKCiAgICB3aGlsZSgkcm93ID0gJHN0bXQtPmZldGNoKFBETzo6RkVUQ0hfQVNTT0MpKSB7CiAgICAgICAgJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0gPSAkcm93OwogICAgfQoKICAgIHJldHVybiAkcmVzdWx0Owp9CgpmdW5jdGlvbiBnZXRBbGxUZWFtcygkZGIpIHsKICAgICRzcWwgPSAiU0VMRUNUICogRlJPTSB0ZWFtcwogICAgICAgICAgICBJTk5FUiBKT0lOIGNvdW50cmllcyBPTiB0ZWFtcy5jb3VudHJ5X2lkID0gY291bnRyaWVzLmNvdW50cnlfaWQ7CiAgICAiOwogICAgJHJlc3VsdCA9IGFycmF5KCk7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAkc3RtdC0+ZXhlY3V0ZSgpOwoKICAgIHdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKICAgICAgICAkcmVzdWx0WyRyb3dbJ3RlYW1faWQnXV0gPSAkcm93OwogICAgfQoKICAgIHJldHVybiAkcmVzdWx0Owp9CgpmdW5jdGlvbiBnZXRQbGF5ZXJCeUlkKCRkYiwgJGlkKSB7CiAgICAkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwogICAgICAgICAgICBXSEVSRSBwbGF5ZXJfaWQgPSA6cGxheWVyX2lkOwogICAgIjsKCiAgICAkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKICAgICRzdG10LT5iaW5kVmFsdWUoJ3BsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgICRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQyk7CiAgICByZXR1cm4gJHJvdzsKfQoKZnVuY3Rpb24gc2F2ZVBsYXllcigkZGIsICRuYW1lLCAkaWQpIHsKICAgICRzcWwgPSAiVVBEQVRFIHBsYXllcnMKICAgICAgICAgICAgU0VUIHBsYXllcl9uYW1lID0gOnBsYXllcl9uYW1lCiAgICAgICAgICAgIFdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKICAgICI7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkbmFtZSwgUERPOjpQQVJBTV9TVFIpOwogICAgJHN0bXQtPmJpbmRWYWx1ZSgnOnBsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKfQ==&#8221; admin_label=&#8221;\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430 &#8221; style=&#8221;docco&#8221; linenums=&#8221;on&#8221; usetabwidth=&#8221;on&#8221; tabwidth=&#8221;4&#8243; _builder_version=&#8221;4.4.2&#8243; hover_enabled=&#8221;0&#8243;]PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7CgogICAgJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHBsYXllcnMKICAgICAgICAgICAgSU5ORVIgSk9JTiB0ZWFtcyBPTiBwbGF5ZXJzLnRlYW1faWQgPSB0ZWFtcy50ZWFtX2lkCiAgICAgICAgICAgIElOTkVSIEpPSU4gY291bnRyaWVzIE9OIHBsYXllcnMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwogICAgIjsKICAgICRyZXN1bHQgPSBhcnJheSgpOwoKICAgICRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKCiAgICB3aGlsZSgkcm93ID0gJHN0bXQtPmZldGNoKFBETzo6RkVUQ0hfQVNTT0MpKSB7CiAgICAgICAgJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0gPSAkcm93OwogICAgfQoKICAgIHJldHVybiAkcmVzdWx0Owp9CgpmdW5jdGlvbiBnZXRBbGxUZWFtcygkZGIpIHsKICAgICRzcWwgPSAiU0VMRUNUICogRlJPTSB0ZWFtcwogICAgICAgICAgICBJTk5FUiBKT0lOIGNvdW50cmllcyBPTiB0ZWFtcy5jb3VudHJ5X2lkID0gY291bnRyaWVzLmNvdW50cnlfaWQ7CiAgICAiOwogICAgJHJlc3VsdCA9IGFycmF5KCk7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAkc3RtdC0+ZXhlY3V0ZSgpOwoKICAgIHdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKICAgICAgICAkcmVzdWx0WyRyb3dbJ3RlYW1faWQnXV0gPSAkcm93OwogICAgfQoKICAgIHJldHVybiAkcmVzdWx0Owp9CgpmdW5jdGlvbiBnZXRQbGF5ZXJCeUlkKCRkYiwgJGlkKSB7CiAgICAkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwogICAgICAgICAgICBXSEVSRSBwbGF5ZXJfaWQgPSA6cGxheWVyX2lkOwogICAgIjsKCiAgICAkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKICAgICRzdG10LT5iaW5kVmFsdWUoJ3BsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgICRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQyk7CiAgICByZXR1cm4gJHJvdzsKfQoKZnVuY3Rpb24gc2F2ZVBsYXllcigkZGIsICRuYW1lLCAkaWQpIHsKICAgICRzcWwgPSAiVVBEQVRFIHBsYXllcnMKICAgICAgICAgICAgU0VUIHBsYXllcl9uYW1lID0gOnBsYXllcl9uYW1lCiAgICAgICAgICAgIFdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKICAgICI7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkbmFtZSwgUERPOjpQQVJBTV9TVFIpOwogICAgJHN0bXQtPmJpbmRWYWx1ZSgnOnBsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKfQ==[\/et_pb_dmb_code_snippet][et_pb_comments _builder_version=&#8221;4.4.2&#8243; custom_margin=&#8221;30px||||false|false&#8221; hover_enabled=&#8221;0&#8243;][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We continue to build our php+mysql applicaiton. Today we will realize opportunity for editing and saving data to database. First of all you need understand, how we make our object unique. The page for every object edit.php. But we will add id player which we are going to edit. In result link will be edit.php?player_id=1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\u041c\u044b \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043d\u0430\u0448\u0435\u0433\u043e \u0432\u0435\u0431 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c php+mysql. \u0412 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u0435\u043c \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0411\u0414<!--more-->\r\n\r\nhttps:\/\/www.youtube.com\/watch?v=BpA_QvQPVlE\r\n\r\n\u0412\u043d\u0430\u0447\u0430\u043b\u0435 \u043d\u0430\u043c \u043d\u0430\u0434\u043e \u043f\u043e\u043d\u044f\u0442\u044c, \u043a\u0430\u043a \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0443\u043d\u0438\u0444\u0438\u0446\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u043e\u0442 \u043e\u0431\u044a\u0435\u043a\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043c\u044b \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u0443\u0435\u043c. \u0421\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0443 \u0432\u0441\u0435\u0445 \u0431\u0443\u0434\u0435\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e\u0439 - edit.php, \u043d\u043e \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c \u043a \u0441\u0441\u044b\u043b\u043a\u0435 id \u0442\u043e\u0433\u043e \u0438\u0433\u0440\u043e\u043a\u0430, \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043c\u044b \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u043c\u0441\u044f \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u044c. \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0441\u0441\u044b\u043b\u043a\u0430 \u0431\u0443\u0434\u0435\u0442 \u0438\u043c\u0435\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0432\u0438\u0434 - edit.php?player_id=1 (\u043c\u044b \u043f\u043e\u043f\u0430\u0434\u0435\u043c \u043d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u0433\u0440\u043e\u043a\u0430 \u0441 id=1).\r\n\r\n\u041f\u0440\u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0438 \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0434\u0435\u0439\u0441\u0442\u0432\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0445\u043e\u0436\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c - \u0432 \u0444\u043e\u0440\u043c\u0435 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u043f\u0435\u0440\u0435\u0434\u0430\u0432\u0430\u0442\u044c \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435, \u043d\u043e \u0438 id \u0438\u0433\u0440\u043e\u043a\u0430 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e input type=\"hidden\".\r\n\r\n\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430:\r\n\r\n<pre><code>players.php\r\n\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"utf-8\">\r\n        <title><\/title>\r\n        <link href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/twitter-bootstrap\/3.3.7\/css\/bootstrap.css\" rel=\"stylesheet\" crossorigin=\"anonymous\">\r\n        <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.1.0\/jquery.min.js\"><\/script>\r\n        <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" crossorigin=\"anonymous\"><\/script>\r\n    <\/head>\r\n    <body>\r\n        <header>\r\n            <nav class=\"navbar navbar-default\">\r\n              <div class=\"container-fluid\">\r\n                <div class=\"navbar-header\">\r\n                  <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n                    <span class=\"sr-only\">Toggle navigation<\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                  <\/button>\r\n                  <a class=\"navbar-brand\" href=\"#\">Sport CRM<\/a>\r\n                <\/div>\r\n\r\n                <div class=\"collapse navbar-collapse\" id=\"bs-example-navbar-collapse-1\">\r\n                  <ul class=\"nav navbar-nav\">\r\n                    <li><a href=\"\/\">\u0413\u043b\u0430\u0432\u043d\u0430\u044f<\/a><\/li>\r\n                    <li><a href=\"players.php\">\u0418\u0433\u0440\u043e\u043a\u0438<\/a><\/li>\r\n                    <li><a href=\"teams.php\">\u041a\u043e\u043c\u0430\u043d\u0434\u044b<\/a><\/li>\r\n                  <\/ul>\r\n                <\/div>\r\n              <\/div>\r\n          <\/nav>\r\n        <\/header>\r\n\r\n        <div class=\"container-fluid\">\r\n            <?php include 'db.php'; ?>\r\n            <?php include 'api.php'; ?>\r\n            <?php\r\n                    $players = getAllPlayers($db);\r\n             ?>\r\n             <table class=\"table table-bordered\">\r\n                 <tr>\r\n                     <th>\u0418\u0433\u0440\u043e\u043a<\/th>\r\n                     <th>\u041a\u043e\u043c\u0430\u043d\u0434\u0430<\/th>\r\n                     <th>\u0421\u0442\u0440\u0430\u043d\u0430<\/th>\r\n                 <\/tr>\r\n                 <?php foreach ($players as $player) { ?>\r\n                    <tr>\r\n                        <td><a href=\"edit.php?player_id=<?php echo $player['player_id']; ?>\"><?php echo $player['player_name']; ?><\/a><\/td>\r\n                        <td><?php echo $player['team_name']; ?><\/td>\r\n                        <td><?php echo $player['country_name']; ?><\/td>\r\n                    <\/tr>\r\n                <?php } ?>\r\n\r\n             <\/table>\r\n        <\/div>\r\n\r\n        <footer>\r\n\r\n        <\/footer>\r\n    <\/body>\r\n<\/html>\r\n<\/code><\/pre>\r\n\r\n<pre><code>edit.php\r\n\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"utf-8\">\r\n        <title><\/title>\r\n        <link href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/twitter-bootstrap\/3.3.7\/css\/bootstrap.css\" rel=\"stylesheet\" crossorigin=\"anonymous\">\r\n        <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.1.0\/jquery.min.js\"><\/script>\r\n        <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" crossorigin=\"anonymous\"><\/script>\r\n    <\/head>\r\n    <body>\r\n        <header>\r\n            <nav class=\"navbar navbar-default\">\r\n              <div class=\"container-fluid\">\r\n                <div class=\"navbar-header\">\r\n                  <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n                    <span class=\"sr-only\">Toggle navigation<\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                  <\/button>\r\n                  <a class=\"navbar-brand\" href=\"#\">Sport CRM<\/a>\r\n                <\/div>\r\n\r\n                <div class=\"collapse navbar-collapse\" id=\"bs-example-navbar-collapse-1\">\r\n                  <ul class=\"nav navbar-nav\">\r\n                    <li><a href=\"\/\">\u0413\u043b\u0430\u0432\u043d\u0430\u044f<\/a><\/li>\r\n                    <li><a href=\"players.php\">\u0418\u0433\u0440\u043e\u043a\u0438<\/a><\/li>\r\n                    <li><a href=\"teams.php\">\u041a\u043e\u043c\u0430\u043d\u0434\u044b<\/a><\/li>\r\n                  <\/ul>\r\n                <\/div>\r\n              <\/div>\r\n          <\/nav>\r\n        <\/header>\r\n\r\n        <div class=\"container-fluid\">\r\n            <?php include 'db.php'; ?>\r\n            <?php include 'api.php'; ?>\r\n            <?php\r\n                    $id = $_GET['player_id'];\r\n                    if($id) {\r\n                        $player = getPlayerById($db, $id);\r\n                    }\r\n                    else {\r\n                        echo '<div class=\"alert alert-danger\" role=\"alert\">\r\n                                <span class=\"glyphicon glyphicon-exclamation-sign\" aria-hidden=\"true\"><\/span>\r\n                                  <span class=\"sr-only\">Error:<\/span>\r\n                                  \u0418\u0433\u0440\u043e\u043a \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\r\n                                <\/div>';\r\n                    }\r\n             ?>\r\n            <form action=\"save.php\" method=\"post\">\r\n                <input type=\"hidden\" name=\"id\" value=\"<?php echo $player['player_id']; ?>\">\r\n                <div class=\"form-group\">\r\n                    <label for=\"name\">\u0418\u0433\u0440\u043e\u043a<\/label>\r\n                    <input type=\"text\" class=\"form-control\" id=\"name\" name=\"name\" value=\"<?php echo $player['player_name']; ?>\">\r\n                  <\/div>\r\n                  <button type=\"submit\" class=\"btn btn-default\">\u0421\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c<\/button>\r\n            <\/form>\r\n        <\/div>\r\n\r\n        <footer>\r\n\r\n        <\/footer>\r\n    <\/body>\r\n<\/html>\r\n<\/code><\/pre>\r\n\r\n<pre><code>save.php\r\n\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"utf-8\">\r\n        <title><\/title>\r\n        <link href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/twitter-bootstrap\/3.3.7\/css\/bootstrap.css\" rel=\"stylesheet\" crossorigin=\"anonymous\">\r\n        <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.1.0\/jquery.min.js\"><\/script>\r\n        <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" crossorigin=\"anonymous\"><\/script>\r\n    <\/head>\r\n    <body>\r\n        <header>\r\n            <nav class=\"navbar navbar-default\">\r\n              <div class=\"container-fluid\">\r\n                <div class=\"navbar-header\">\r\n                  <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n                    <span class=\"sr-only\">Toggle navigation<\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                    <span class=\"icon-bar\"><\/span>\r\n                  <\/button>\r\n                  <a class=\"navbar-brand\" href=\"#\">Sport CRM<\/a>\r\n                <\/div>\r\n\r\n                <div class=\"collapse navbar-collapse\" id=\"bs-example-navbar-collapse-1\">\r\n                  <ul class=\"nav navbar-nav\">\r\n                    <li><a href=\"\/\">\u0413\u043b\u0430\u0432\u043d\u0430\u044f<\/a><\/li>\r\n                    <li><a href=\"players.php\">\u0418\u0433\u0440\u043e\u043a\u0438<\/a><\/li>\r\n                    <li><a href=\"teams.php\">\u041a\u043e\u043c\u0430\u043d\u0434\u044b<\/a><\/li>\r\n                  <\/ul>\r\n                <\/div>\r\n              <\/div>\r\n          <\/nav>\r\n        <\/header>\r\n\r\n        <div class=\"container-fluid\">\r\n            <?php include 'db.php'; ?>\r\n            <?php include 'api.php'; ?>\r\n            <?php\r\n\r\n\r\n                    if(!empty($_POST['name']) && !empty($_POST['id'])) {\r\n                        $name = $_POST['name'];\r\n                        $id = $_POST['id'];\r\n                        savePlayer($db, $name, $id);\r\n                    }\r\n                    else {\r\n                        echo '<div class=\"alert alert-danger\" role=\"alert\">\r\n                                <span class=\"glyphicon glyphicon-exclamation-sign\" aria-hidden=\"true\"><\/span>\r\n                                  <span class=\"sr-only\">Error:<\/span>\r\n                                  \u041e\u0448\u0438\u0431\u043a\u0430 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f\r\n                                <\/div>';\r\n                    }\r\n             ?>\r\n\r\n        <\/div>\r\n\r\n        <footer>\r\n\r\n        <\/footer>\r\n    <\/body>\r\n<\/html>\r\n\r\n<\/code><\/pre>\r\n\r\n<pre><code>api.php\r\n\r\n<?php\r\n\r\nfunction getAllPlayers($db) {\r\n\r\n    $sql = \"SELECT * FROM players\r\n            INNER JOIN teams ON players.team_id = teams.team_id\r\n            INNER JOIN countries ON players.country_id = countries.country_id;\r\n    \";\r\n    $result = array();\r\n\r\n    $stmt = $db->prepare($sql);\r\n    $stmt->execute();\r\n\r\n    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {\r\n        $result[$row['player_id']] = $row;\r\n    }\r\n\r\n    return $result;\r\n}\r\n\r\nfunction getAllTeams($db) {\r\n    $sql = \"SELECT * FROM teams\r\n            INNER JOIN countries ON teams.country_id = countries.country_id;\r\n    \";\r\n    $result = array();\r\n\r\n    $stmt = $db->prepare($sql);\r\n    $stmt->execute();\r\n\r\n    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {\r\n        $result[$row['team_id']] = $row;\r\n    }\r\n\r\n    return $result;\r\n}\r\n\r\nfunction getPlayerById($db, $id) {\r\n    $sql = \"SELECT * FROM players\r\n            WHERE player_id = :player_id;\r\n    \";\r\n\r\n    $stmt = $db->prepare($sql);\r\n    $stmt->bindValue('player_id', $id, PDO::PARAM_INT);\r\n    $stmt->execute();\r\n    $row = $stmt->fetch(PDO::FETCH_ASSOC);\r\n    return $row;\r\n}\r\n\r\nfunction savePlayer($db, $name, $id) {\r\n    $sql = \"UPDATE players\r\n            SET player_name = :player_name\r\n            WHERE player_id = :player_id\r\n    \";\r\n\r\n    $stmt = $db->prepare($sql);\r\n    $stmt->bindValue(':player_name', $name, PDO::PARAM_STR);\r\n    $stmt->bindValue(':player_id', $id, PDO::PARAM_INT);\r\n    $stmt->execute();\r\n}\r\n\r\n<\/code><\/pre>","_et_gb_content_width":"","footnotes":""},"categories":[274,219],"tags":[248,240],"class_list":["post-3545","post","type-post","status-publish","format-standard","hentry","category-phpmysql","category-tutorials","tag-mysql-en","tag-php-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Build CRUD Application PHP &amp; Mysql. Edit and sava data - Kamil Abzalov&#039;s blog<\/title>\n<meta name=\"description\" content=\"In this lesson we&#039;ll realize opportunity for editing and saving data\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build CRUD Application PHP &amp; Mysql. Edit and sava data - Kamil Abzalov&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"In this lesson we&#039;ll realize opportunity for editing and saving data\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/kamabzalov\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-16T19:13:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-09T20:18:10+00:00\" \/>\n<meta name=\"author\" content=\"Kamil&#039; Abzalov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Build CRUD Application PHP &amp; Mysql. Edit and sava data\" \/>\n<meta name=\"twitter:description\" content=\"In this lesson we&#039;ll realize opportunity for editing and saving data\" \/>\n<meta name=\"twitter:creator\" content=\"@kamabzalov\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kamil&#039; Abzalov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Build CRUD Application PHP &#038; Mysql. Edit and sava data\",\"datePublished\":\"2017-08-16T19:13:25+00:00\",\"dateModified\":\"2020-04-09T20:18:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/\"},\"wordCount\":2738,\"commentCount\":0,\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"PHP+MySQL\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/\",\"name\":\"Build CRUD Application PHP & Mysql. Edit and sava data - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-16T19:13:25+00:00\",\"dateModified\":\"2020-04-09T20:18:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"description\":\"In this lesson we'll realize opportunity for editing and saving data\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-edit-and-save-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/kamil-abzalov.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build CRUD Application PHP &#038; Mysql. Edit and sava data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/\",\"name\":\"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kamil-abzalov.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\",\"name\":\"Kamil' Abzalov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"caption\":\"Kamil' Abzalov\"},\"sameAs\":[\"https:\\\/\\\/kamil-abzalov.com\\\/\",\"https:\\\/\\\/www.facebook.com\\\/kamabzalov\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/kamabzalov\",\"https:\\\/\\\/x.com\\\/kamabzalov\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/kamabzalov\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build CRUD Application PHP & Mysql. Edit and sava data - Kamil Abzalov's blog","description":"In this lesson we'll realize opportunity for editing and saving data","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/","og_locale":"en_US","og_type":"article","og_title":"Build CRUD Application PHP & Mysql. Edit and sava data - Kamil Abzalov's blog","og_description":"In this lesson we'll realize opportunity for editing and saving data","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/","og_site_name":"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430","article_author":"https:\/\/www.facebook.com\/kamabzalov","article_published_time":"2017-08-16T19:13:25+00:00","article_modified_time":"2020-04-09T20:18:10+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_title":"Build CRUD Application PHP & Mysql. Edit and sava data","twitter_description":"In this lesson we'll realize opportunity for editing and saving data","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Build CRUD Application PHP &#038; Mysql. Edit and sava data","datePublished":"2017-08-16T19:13:25+00:00","dateModified":"2020-04-09T20:18:10+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/"},"wordCount":2738,"commentCount":0,"keywords":["mysql","php"],"articleSection":["PHP+MySQL","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/","name":"Build CRUD Application PHP & Mysql. Edit and sava data - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-16T19:13:25+00:00","dateModified":"2020-04-09T20:18:10+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"description":"In this lesson we'll realize opportunity for editing and saving data","breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-edit-and-save-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/kamil-abzalov.com\/en\/"},{"@type":"ListItem","position":2,"name":"Build CRUD Application PHP &#038; Mysql. Edit and sava data"}]},{"@type":"WebSite","@id":"https:\/\/kamil-abzalov.com\/#website","url":"https:\/\/kamil-abzalov.com\/","name":"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kamil-abzalov.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600","name":"Kamil' Abzalov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","caption":"Kamil' Abzalov"},"sameAs":["https:\/\/kamil-abzalov.com\/","https:\/\/www.facebook.com\/kamabzalov","https:\/\/www.linkedin.com\/in\/kamabzalov","https:\/\/x.com\/kamabzalov","https:\/\/www.youtube.com\/user\/kamabzalov"]}]}},"_links":{"self":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/comments?post=3545"}],"version-history":[{"count":7,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3545\/revisions"}],"predecessor-version":[{"id":31902,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3545\/revisions\/31902"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}