{"id":3550,"date":"2017-08-16T22:27:06","date_gmt":"2017-08-16T19:27:06","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/build-crud-application-php-mysql-add-information-to-database\/"},"modified":"2020-04-09T23:20:15","modified_gmt":"2020-04-09T20:20:15","slug":"build-crud-application-php-mysql-add-information-to-database","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/phpmysql\/build-crud-application-php-mysql-add-information-to-database\/","title":{"rendered":"Build CRUD Application PHP &#038; Mysql. Add information to database"},"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. Add information to database&#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 php+mysql web application. In this lesson we realize mechanism of adding information to database through interface.<br \/>\n[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=C7QXP051yys&#038;feature=youtu.be&#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 we will add form to players.php. There will two fields in our form &#8211; player name and country (dropdown list).<br \/>\nI notice, dropdown list can be written manually, but it&#8217;s not productive. We automate this process, writing getAllCountries function.<\/p>\n<p>Next we will have to accept the data from our html form. I notice, I didn&#8217;t specify action attribute in form. If it so, form will submit data to itself page.<\/p>\n<p>Function addPlayer will work with using INSERT INTO query.<\/p>\n<p>At last homework for you:<\/p>\n<ol>\n<li>To check form for empty<\/li>\n<li>Print message, if nothing entered<\/li>\n<li>Add &#8220;team&#8221; field<\/li>\n<li>Make js\/jquery validation<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_dmb_code_snippet title=&#8221;Code lesson (players.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sIGxhbmc9ImVuIj4KPGhlYWQ+Cgk8bWV0YSBjaGFyc2V0PSJVVEYtOCI+Cgk8dGl0bGU+0JjQs9GA0L7QutC4PC90aXRsZT4KCTxsaW5rIGhyZWY9Ii8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy42L2Nzcy9ib290c3RyYXAubWluLmNzcyIgcmVsPSJzdHlsZXNoZWV0Ij4KCTxzY3JpcHQgc3JjPSJodHRwczovL2FqYXguZ29vZ2xlYXBpcy5jb20vYWpheC9saWJzL2pxdWVyeS8xLjExLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+Cgk8c2NyaXB0IHNyYz0iLy9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4zLjYvanMvYm9vdHN0cmFwLm1pbi5qcyI+PC9zY3JpcHQ+CjwvaGVhZD4KPGJvZHk+Cgk8aGVhZGVyPgoJCTxuYXYgY2xhc3M9Im5hdmJhciBuYXZiYXItZGVmYXVsdCIgcm9sZT0ibmF2aWdhdGlvbiI+CgkJCTxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CgkJCQk8ZGl2IGNsYXNzPSJuYXZiYXItaGVhZGVyIj4KCQkJCQk8YnV0dG9uIHR5cGU9ImJ1dHRvbiIgY2xhc3M9Im5hdmJhci10b2dnbGUiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9Ii5uYXZiYXItZXgxLWNvbGxhcHNlIj4KCQkJCQkJPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgoJCQkJCQk8c3BhbiBjbGFzcz0iaWNvbi1iYXIiPjwvc3Bhbj4KCQkJCQkJPHNwYW4gY2xhc3M9Imljb24tYmFyIj48L3NwYW4+CgkJCQkJCTxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgoJCQkJCTwvYnV0dG9uPgoJCQkJCTxhIGNsYXNzPSJuYXZiYXItYnJhbmQiIGhyZWY9IiMiPlNwb3J0IENSTTwvYT4KCQkJCTwvZGl2PgoJCQoJCQkJPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIG5hdmJhci1leDEtY29sbGFwc2UiPgoJCQkJCTx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgoJCQkJCQk8bGk+PGEgaHJlZj0iaW5kZXgucGhwIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0icGxheWVycy5waHAiPtCY0LPRgNC+0LrQuDwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0idGVhbXMucGhwIj7QmtC+0LzQsNC90LTRizwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0iY291bnRyaWVzLnBocCI+0KHRgtGA0LDQvdGLPC9hPjwvbGk+CgkJCQkJPC91bD4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQk8L25hdj4KCTwvaGVhZGVyPgoKCTxkaXYgaWQ9ImNvbnRlbnQiPgoJCTxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CgkJCTw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CgkJCTw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgoJCQk8P3BocAoJCQkJJHBsYXllcnMgPSBnZXRBbGxQbGF5ZXJzKCRkYik7CgkJCT8+CgkJCTx0YWJsZSBjbGFzcz0idGFibGUgdGFibGUtYm9yZGVyZWQiPgoJCQkJPHRyPgoJCQkJCTx0aD7QmNCz0YDQvtC6PC90aD4KCQkJCQk8dGg+0JrQvtC80LDQvdC00LA8L3RoPgoJCQkJCTx0aD7QodGC0YDQsNC90LA8L3RoPgoJCQkJPC90cj4KCQkJCTw\/cGhwIGZvcmVhY2ggKCRwbGF5ZXJzIGFzICRwbGF5ZXIpIHsgPz4KCQkJCQk8dHI+CgkJCQkJCTx0ZD48YSBocmVmPSJlZGl0LnBocD9wbGF5ZXJfaWQ9PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfaWQnXTs\/PiI+PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfbmFtZSddOyA\/PjwvYT48L3RkPgoJCQkJCQk8dGQ+PD9waHAgZWNobyAkcGxheWVyWyd0ZWFtX25hbWUnXTsgPz48L3RkPgoJCQkJCQk8dGQ+PD9waHAgZWNobyAkcGxheWVyWydjb3VudHJ5X25hbWUnXTsgPz48L3RkPgoJCQkJCTwvdHI+CgkJCQk8P3BocCB9ID8+CgkJCTwvdGFibGU+CgoJCQk8YnV0dG9uIGlkPSJhZGRCdXR0b24iIGNsYXNzPSJidG4gYnRuLWRlZmF1bHQiPtCU0L7QsdCw0LLQuNGC0Ywg0LjQs9GA0L7QutCwPC9idXR0b24+CgoJCQk8Zm9ybSBhY3Rpb249IiIgbWV0aG9kPSJQT1NUIiByb2xlPSJmb3JtIiBzdHlsZT0iZGlzcGxheTogbm9uZTsgbWFyZ2luLXRvcDogMjBweDsiPgoJCQoJCQk8ZGl2IGNsYXNzPSJmb3JtLWdyb3VwIj4KCQkJCTxsYWJlbCBmb3I9IiI+0JLQstC10LTQuNGC0LUg0LjQvNGPPC9sYWJlbD4KCQkJCTxpbnB1dCB0eXBlPSJ0ZXh0IiBjbGFzcz0iZm9ybS1jb250cm9sIiBpZD0ibmFtZSIgbmFtZT0ibmFtZSIgcGxhY2Vob2xkZXI9ItCS0LLQtdC00LjRgtC1INC40LzRjyI+CgkJCTwvZGl2PgoKCQkJPGRpdiBjbGFzcz0iZm9ybS1ncm91cCI+CgkJCQk8c2VsZWN0IG5hbWU9ImNvdW50cnkiIGNsYXNzPSJmb3JtLWNvbnRyb2wiIGlkPSJjb3VudHJ5Ij4KCQkJCTw\/cGhwCgkJCQkJJGNvdW50cmllcyA9IGdldEFsbENvdW50cmllcygkZGIpOwoJCQkJCWZvcmVhY2ggKCRjb3VudHJpZXMgYXMgJGtleSA9PiAkdmFsdWUpIHsKCQkJCQkJZWNobyAiPG9wdGlvbiB2YWx1ZT0iLiR2YWx1ZVsnY291bnRyeV9pZCddLiI+Ii4kdmFsdWVbJ2NvdW50cnlfbmFtZSddLiI8L29wdGlvbj4iOwkKCQkJCQl9CQoJCQkJPz4KCQkJCTwvc2VsZWN0PgoJCQk8L2Rpdj4KCQkJCgkJCTxidXR0b24gdHlwZT0ic3VibWl0IiBjbGFzcz0iYnRuIGJ0bi1kZWZhdWx0Ij7QlNC+0LHQsNCy0LjRgtGMPC9idXR0b24+CgkJPC9mb3JtPgoJCTwvZGl2PgoKCQk8P3BocAoJCQlpZihpc3NldCgkX1BPU1RbJ25hbWUnXSkgJiYgJF9QT1NUWyduYW1lJ10gIT0gJycpIHsKCQkJCSRuYW1lID0gJF9QT1NUWyduYW1lJ107CgkJCQkkY291bnRyeUlkID0gJF9QT1NUWydjb3VudHJ5J107CQoJCQkJYWRkUGxheWVyKCRkYiwgJG5hbWUsICRjb3VudHJ5SWQpOwoJCQl9CgkJCQoJCT8+CgoJPC9kaXY+CgoJPGZvb3Rlcj4KCQkKCTwvZm9vdGVyPgoKCTxzY3JpcHQ+CgkJJCgiI2FkZEJ1dHRvbiIpLmNsaWNrKGZ1bmN0aW9uKCl7CgkJCSQoImZvcm0iKS5zbGlkZURvd24oKTsKCQl9KTsKCTwvc2NyaXB0Pgo8L2JvZHk+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+CjxodG1sIGxhbmc9ImVuIj4KPGhlYWQ+Cgk8bWV0YSBjaGFyc2V0PSJVVEYtOCI+Cgk8dGl0bGU+0JjQs9GA0L7QutC4PC90aXRsZT4KCTxsaW5rIGhyZWY9Ii8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMy42L2Nzcy9ib290c3RyYXAubWluLmNzcyIgcmVsPSJzdHlsZXNoZWV0Ij4KCTxzY3JpcHQgc3JjPSJodHRwczovL2FqYXguZ29vZ2xlYXBpcy5jb20vYWpheC9saWJzL2pxdWVyeS8xLjExLjAvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+Cgk8c2NyaXB0IHNyYz0iLy9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4zLjYvanMvYm9vdHN0cmFwLm1pbi5qcyI+PC9zY3JpcHQ+CjwvaGVhZD4KPGJvZHk+Cgk8aGVhZGVyPgoJCTxuYXYgY2xhc3M9Im5hdmJhciBuYXZiYXItZGVmYXVsdCIgcm9sZT0ibmF2aWdhdGlvbiI+CgkJCTxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CgkJCQk8ZGl2IGNsYXNzPSJuYXZiYXItaGVhZGVyIj4KCQkJCQk8YnV0dG9uIHR5cGU9ImJ1dHRvbiIgY2xhc3M9Im5hdmJhci10b2dnbGUiIGRhdGEtdG9nZ2xlPSJjb2xsYXBzZSIgZGF0YS10YXJnZXQ9Ii5uYXZiYXItZXgxLWNvbGxhcHNlIj4KCQkJCQkJPHNwYW4gY2xhc3M9InNyLW9ubHkiPlRvZ2dsZSBuYXZpZ2F0aW9uPC9zcGFuPgoJCQkJCQk8c3BhbiBjbGFzcz0iaWNvbi1iYXIiPjwvc3Bhbj4KCQkJCQkJPHNwYW4gY2xhc3M9Imljb24tYmFyIj48L3NwYW4+CgkJCQkJCTxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgoJCQkJCTwvYnV0dG9uPgoJCQkJCTxhIGNsYXNzPSJuYXZiYXItYnJhbmQiIGhyZWY9IiMiPlNwb3J0IENSTTwvYT4KCQkJCTwvZGl2PgoJCQoJCQkJPGRpdiBjbGFzcz0iY29sbGFwc2UgbmF2YmFyLWNvbGxhcHNlIG5hdmJhci1leDEtY29sbGFwc2UiPgoJCQkJCTx1bCBjbGFzcz0ibmF2IG5hdmJhci1uYXYiPgoJCQkJCQk8bGk+PGEgaHJlZj0iaW5kZXgucGhwIj7Qk9C70LDQstC90LDRjzwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0icGxheWVycy5waHAiPtCY0LPRgNC+0LrQuDwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0idGVhbXMucGhwIj7QmtC+0LzQsNC90LTRizwvYT48L2xpPgoJCQkJCQk8bGk+PGEgaHJlZj0iY291bnRyaWVzLnBocCI+0KHRgtGA0LDQvdGLPC9hPjwvbGk+CgkJCQkJPC91bD4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQk8L25hdj4KCTwvaGVhZGVyPgoKCTxkaXYgaWQ9ImNvbnRlbnQiPgoJCTxkaXYgY2xhc3M9ImNvbnRhaW5lci1mbHVpZCI+CgkJCTw\/cGhwIGluY2x1ZGUgJ2RiLnBocCc7ID8+CgkJCTw\/cGhwIGluY2x1ZGUgJ2FwaS5waHAnOyA\/PgoJCQk8P3BocAoJCQkJJHBsYXllcnMgPSBnZXRBbGxQbGF5ZXJzKCRkYik7CgkJCT8+CgkJCTx0YWJsZSBjbGFzcz0idGFibGUgdGFibGUtYm9yZGVyZWQiPgoJCQkJPHRyPgoJCQkJCTx0aD7QmNCz0YDQvtC6PC90aD4KCQkJCQk8dGg+0JrQvtC80LDQvdC00LA8L3RoPgoJCQkJCTx0aD7QodGC0YDQsNC90LA8L3RoPgoJCQkJPC90cj4KCQkJCTw\/cGhwIGZvcmVhY2ggKCRwbGF5ZXJzIGFzICRwbGF5ZXIpIHsgPz4KCQkJCQk8dHI+CgkJCQkJCTx0ZD48YSBocmVmPSJlZGl0LnBocD9wbGF5ZXJfaWQ9PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfaWQnXTs\/PiI+PD9waHAgZWNobyAkcGxheWVyWydwbGF5ZXJfbmFtZSddOyA\/PjwvYT48L3RkPgoJCQkJCQk8dGQ+PD9waHAgZWNobyAkcGxheWVyWyd0ZWFtX25hbWUnXTsgPz48L3RkPgoJCQkJCQk8dGQ+PD9waHAgZWNobyAkcGxheWVyWydjb3VudHJ5X25hbWUnXTsgPz48L3RkPgoJCQkJCTwvdHI+CgkJCQk8P3BocCB9ID8+CgkJCTwvdGFibGU+CgoJCQk8YnV0dG9uIGlkPSJhZGRCdXR0b24iIGNsYXNzPSJidG4gYnRuLWRlZmF1bHQiPtCU0L7QsdCw0LLQuNGC0Ywg0LjQs9GA0L7QutCwPC9idXR0b24+CgoJCQk8Zm9ybSBhY3Rpb249IiIgbWV0aG9kPSJQT1NUIiByb2xlPSJmb3JtIiBzdHlsZT0iZGlzcGxheTogbm9uZTsgbWFyZ2luLXRvcDogMjBweDsiPgoJCQoJCQk8ZGl2IGNsYXNzPSJmb3JtLWdyb3VwIj4KCQkJCTxsYWJlbCBmb3I9IiI+0JLQstC10LTQuNGC0LUg0LjQvNGPPC9sYWJlbD4KCQkJCTxpbnB1dCB0eXBlPSJ0ZXh0IiBjbGFzcz0iZm9ybS1jb250cm9sIiBpZD0ibmFtZSIgbmFtZT0ibmFtZSIgcGxhY2Vob2xkZXI9ItCS0LLQtdC00LjRgtC1INC40LzRjyI+CgkJCTwvZGl2PgoKCQkJPGRpdiBjbGFzcz0iZm9ybS1ncm91cCI+CgkJCQk8c2VsZWN0IG5hbWU9ImNvdW50cnkiIGNsYXNzPSJmb3JtLWNvbnRyb2wiIGlkPSJjb3VudHJ5Ij4KCQkJCTw\/cGhwCgkJCQkJJGNvdW50cmllcyA9IGdldEFsbENvdW50cmllcygkZGIpOwoJCQkJCWZvcmVhY2ggKCRjb3VudHJpZXMgYXMgJGtleSA9PiAkdmFsdWUpIHsKCQkJCQkJZWNobyAiPG9wdGlvbiB2YWx1ZT0iLiR2YWx1ZVsnY291bnRyeV9pZCddLiI+Ii4kdmFsdWVbJ2NvdW50cnlfbmFtZSddLiI8L29wdGlvbj4iOwkKCQkJCQl9CQoJCQkJPz4KCQkJCTwvc2VsZWN0PgoJCQk8L2Rpdj4KCQkJCgkJCTxidXR0b24gdHlwZT0ic3VibWl0IiBjbGFzcz0iYnRuIGJ0bi1kZWZhdWx0Ij7QlNC+0LHQsNCy0LjRgtGMPC9idXR0b24+CgkJPC9mb3JtPgoJCTwvZGl2PgoKCQk8P3BocAoJCQlpZihpc3NldCgkX1BPU1RbJ25hbWUnXSkgJiYgJF9QT1NUWyduYW1lJ10gIT0gJycpIHsKCQkJCSRuYW1lID0gJF9QT1NUWyduYW1lJ107CgkJCQkkY291bnRyeUlkID0gJF9QT1NUWydjb3VudHJ5J107CQoJCQkJYWRkUGxheWVyKCRkYiwgJG5hbWUsICRjb3VudHJ5SWQpOwoJCQl9CgkJCQoJCT8+CgoJPC9kaXY+CgoJPGZvb3Rlcj4KCQkKCTwvZm9vdGVyPgoKCTxzY3JpcHQ+CgkJJCgiI2FkZEJ1dHRvbiIpLmNsaWNrKGZ1bmN0aW9uKCl7CgkJCSQoImZvcm0iKS5zbGlkZURvd24oKTsKCQl9KTsKCTwvc2NyaXB0Pgo8L2JvZHk+CjwvaHRtbD4=[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (api.php)&#8221; code=&#8221;PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwoJCQlMRUZUIEpPSU4gdGVhbXMgT04gcGxheWVycy50ZWFtX2lkID0gdGVhbXMudGVhbV9pZAoJCQlMRUZUIEpPSU4gY291bnRyaWVzIE9OIHBsYXllcnMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwoJIjsKCSRyZXN1bHQgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXN1bHRbJHJvd1sncGxheWVyX2lkJ11dID0gJHJvdzsKCX0KCglyZXR1cm4gJHJlc3VsdDsKfQoKZnVuY3Rpb24gZ2V0QWxsVGVhbXMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gdGVhbXMKCQkJSU5ORVIgSk9JTiBjb3VudHJpZXMgT04gdGVhbXMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwoJIjsKCSRyZXN1bHQgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXN1bHRbJHJvd1sndGVhbV9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXN1bHQ7Cn0KCmZ1bmN0aW9uIGdldFBsYXllckJ5SWQoJGRiLCAkaWQpIHsKCSRzcWwgPSAiU0VMRUNUICogRlJPTSBwbGF5ZXJzCgkJCVdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKCQkJIjsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCSRzdG10LT5iaW5kVmFsdWUoJ3BsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwoJJHN0bXQtPmV4ZWN1dGUoKTsKCSRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQyk7CglyZXR1cm4gJHJvdzsKfQoKZnVuY3Rpb24gc2F2ZVBsYXllcigkZGIsICRuYW1lLCAkaWQpIHsKCSRzcWwgPSAiIFVQREFURSBwbGF5ZXJzCgkJCSBTRVQgcGxheWVyX25hbWUgPSA6cGxheWVyX25hbWUKCQkJIFdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKCSI7CgoJJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7Cgkkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkbmFtZSwgUERPOjpQQVJBTV9TVFIpOwoJJHN0bXQtPmJpbmRWYWx1ZSgnOnBsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwoKCSRzdG10LT5leGVjdXRlKCk7Cn0KCgpmdW5jdGlvbiBnZXRBbGxDb3VudHJpZXMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gY291bnRyaWVzIjsKCSRyZXMgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXNbJHJvd1snY291bnRyeV9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXM7Cn0KCmZ1bmN0aW9uIGFkZFBsYXllcigkZGIsICRwbGF5ZXJOYW1lLCAkY291bnRyeUlkKSB7Cgkkc3FsID0gIklOU0VSVCBJTlRPIHBsYXllcnMocGxheWVyX25hbWUsIGNvdW50cnlfaWQpIAoJCQlWQUxVRVMoOnBsYXllcl9uYW1lLCA6Y291bnRyeV9pZCkKCSI7CgoJJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7Cgkkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkcGxheWVyTmFtZSwgUERPOjpQQVJBTV9TVFIpOwoJJHN0bXQtPmJpbmRWYWx1ZSgnOmNvdW50cnlfaWQnLCAkY291bnRyeUlkLCBQRE86OlBBUkFNX0lOVCk7CgoJJHN0bXQtPmV4ZWN1dGUoKTsKCn0=&#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;]PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwoJCQlMRUZUIEpPSU4gdGVhbXMgT04gcGxheWVycy50ZWFtX2lkID0gdGVhbXMudGVhbV9pZAoJCQlMRUZUIEpPSU4gY291bnRyaWVzIE9OIHBsYXllcnMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwoJIjsKCSRyZXN1bHQgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXN1bHRbJHJvd1sncGxheWVyX2lkJ11dID0gJHJvdzsKCX0KCglyZXR1cm4gJHJlc3VsdDsKfQoKZnVuY3Rpb24gZ2V0QWxsVGVhbXMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gdGVhbXMKCQkJSU5ORVIgSk9JTiBjb3VudHJpZXMgT04gdGVhbXMuY291bnRyeV9pZCA9IGNvdW50cmllcy5jb3VudHJ5X2lkOwoJIjsKCSRyZXN1bHQgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXN1bHRbJHJvd1sndGVhbV9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXN1bHQ7Cn0KCmZ1bmN0aW9uIGdldFBsYXllckJ5SWQoJGRiLCAkaWQpIHsKCSRzcWwgPSAiU0VMRUNUICogRlJPTSBwbGF5ZXJzCgkJCVdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKCQkJIjsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCSRzdG10LT5iaW5kVmFsdWUoJ3BsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwoJJHN0bXQtPmV4ZWN1dGUoKTsKCSRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQyk7CglyZXR1cm4gJHJvdzsKfQoKZnVuY3Rpb24gc2F2ZVBsYXllcigkZGIsICRuYW1lLCAkaWQpIHsKCSRzcWwgPSAiIFVQREFURSBwbGF5ZXJzCgkJCSBTRVQgcGxheWVyX25hbWUgPSA6cGxheWVyX25hbWUKCQkJIFdIRVJFIHBsYXllcl9pZCA9IDpwbGF5ZXJfaWQKCSI7CgoJJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7Cgkkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkbmFtZSwgUERPOjpQQVJBTV9TVFIpOwoJJHN0bXQtPmJpbmRWYWx1ZSgnOnBsYXllcl9pZCcsICRpZCwgUERPOjpQQVJBTV9JTlQpOwoKCSRzdG10LT5leGVjdXRlKCk7Cn0KCgpmdW5jdGlvbiBnZXRBbGxDb3VudHJpZXMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gY291bnRyaWVzIjsKCSRyZXMgPSBhcnJheSgpOwoKCSRzdG10ID0gJGRiLT5wcmVwYXJlKCRzcWwpOwoKCSRzdG10LT5leGVjdXRlKCk7CgoJd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgewoJCSRyZXNbJHJvd1snY291bnRyeV9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXM7Cn0KCmZ1bmN0aW9uIGFkZFBsYXllcigkZGIsICRwbGF5ZXJOYW1lLCAkY291bnRyeUlkKSB7Cgkkc3FsID0gIklOU0VSVCBJTlRPIHBsYXllcnMocGxheWVyX25hbWUsIGNvdW50cnlfaWQpIAoJCQlWQUxVRVMoOnBsYXllcl9uYW1lLCA6Y291bnRyeV9pZCkKCSI7CgoJJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7Cgkkc3RtdC0+YmluZFZhbHVlKCc6cGxheWVyX25hbWUnLCAkcGxheWVyTmFtZSwgUERPOjpQQVJBTV9TVFIpOwoJJHN0bXQtPmJpbmRWYWx1ZSgnOmNvdW50cnlfaWQnLCAkY291bnRyeUlkLCBQRE86OlBBUkFNX0lOVCk7CgoJJHN0bXQtPmV4ZWN1dGUoKTsKCn0=[\/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 php+mysql web application. In this lesson we realize mechanism of adding information to database through interface. First of all we will add form to players.php. There will two fields in our form &#8211; player name and country (dropdown list). I notice, dropdown list can be written manually, but it&#8217;s not productive. [&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":"","_et_gb_content_width":"","footnotes":""},"categories":[274,219],"tags":[],"class_list":["post-3550","post","type-post","status-publish","format-standard","hentry","category-phpmysql","category-tutorials"],"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. Add information to database - Kamil Abzalov&#039;s blog<\/title>\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\/add-info-to-database-in-app\/\" \/>\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. Add information to database - Kamil Abzalov&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"We continue to build php+mysql web application. In this lesson we realize mechanism of adding information to database through interface. First of all we will add form to players.php. There will two fields in our form - player name and country (dropdown list). I notice, dropdown list can be written manually, but it&#039;s not productive. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/\" \/>\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:27:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-09T20:20:15+00:00\" \/>\n<meta name=\"author\" content=\"Kamil&#039; Abzalov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"10 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\\\/add-info-to-database-in-app\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Build CRUD Application PHP &#038; Mysql. Add information to database\",\"datePublished\":\"2017-08-16T19:27:06+00:00\",\"dateModified\":\"2020-04-09T20:20:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/\"},\"wordCount\":1932,\"commentCount\":0,\"articleSection\":[\"PHP+MySQL\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/\",\"name\":\"Build CRUD Application PHP & Mysql. Add information to database - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-16T19:27:06+00:00\",\"dateModified\":\"2020-04-09T20:20:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/add-info-to-database-in-app\\\/#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. Add information to database\"}]},{\"@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. Add information to database - Kamil Abzalov's blog","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\/add-info-to-database-in-app\/","og_locale":"en_US","og_type":"article","og_title":"Build CRUD Application PHP & Mysql. Add information to database - Kamil Abzalov's blog","og_description":"We continue to build php+mysql web application. In this lesson we realize mechanism of adding information to database through interface. First of all we will add form to players.php. There will two fields in our form - player name and country (dropdown list). I notice, dropdown list can be written manually, but it's not productive. [&hellip;]","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/","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:27:06+00:00","article_modified_time":"2020-04-09T20:20:15+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Build CRUD Application PHP &#038; Mysql. Add information to database","datePublished":"2017-08-16T19:27:06+00:00","dateModified":"2020-04-09T20:20:15+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/"},"wordCount":1932,"commentCount":0,"articleSection":["PHP+MySQL","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/","name":"Build CRUD Application PHP & Mysql. Add information to database - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-16T19:27:06+00:00","dateModified":"2020-04-09T20:20:15+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/add-info-to-database-in-app\/#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. Add information to database"}]},{"@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\/3550","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=3550"}],"version-history":[{"count":7,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3550\/revisions"}],"predecessor-version":[{"id":31904,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3550\/revisions\/31904"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}