{"id":3535,"date":"2017-08-16T20:48:30","date_gmt":"2017-08-16T17:48:30","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/build-crud-application-php-mysql-getting-data-from-several-tables\/"},"modified":"2020-04-09T00:35:31","modified_gmt":"2020-04-08T21:35:31","slug":"build-crud-application-php-mysql-getting-data-from-several-tables","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/phpmysql\/build-crud-application-php-mysql-getting-data-from-several-tables\/","title":{"rendered":"Build CRUD Application PHP &#038; Mysql. Getting data from several tables"},"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. Getting data from several tables&#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;3.1.1&#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;]Today we&#8217;ll continue create our web application. We&#8217;ll select data from two tables.<!--more--><br \/>\n[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=n7l9qWSh7Gg&#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;]In last lesson we selected all players from players tables. On players.php page we have got table with three columns. Two of them are situated in another tables (&#8220;teams&#8221; and &#8220;countries&#8221;). That&#8217;s why we need to modify our sql query with using INNER JOIN.<br \/>\n[\/et_pb_text][et_pb_dmb_code_snippet title=&#8221;Code lesson (api.php)&#8221; code=&#8221;PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwoJCQlMRUZUIEpPSU4gdGVhbXMgT04gcGxheWVycy50ZWFtX2lkID0gdGVhbXMudGVhbV9pZDsKCSI7CgkkcmVzdWx0ID0gYXJyYXkoKTsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCgkkc3RtdC0+ZXhlY3V0ZSgpOwoKCXdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKCQkkcmVzdWx0WyRyb3dbJ3BsYXllcl9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXN1bHQ7Cn0KCmZ1bmN0aW9uIGdldEFsbFRlYW1zKCRkYikgewoJJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHRlYW1zCgkJCUlOTkVSIEpPSU4gY291bnRyaWVzIE9OIHRlYW1zLmNvdW50cnlfaWQgPSBjb3VudHJpZXMuY291bnRyeV9pZDsKCSI7CgkkcmVzdWx0ID0gYXJyYXkoKTsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCgkkc3RtdC0+ZXhlY3V0ZSgpOwoKCXdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKCQkkcmVzdWx0WyRyb3dbJ3RlYW1faWQnXV0gPSAkcm93OwoJfQoKCXJldHVybiAkcmVzdWx0Owp9&#8243; 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;3.1.1&#8243; hover_enabled=&#8221;0&#8243;]PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7Cgkkc3FsID0gIlNFTEVDVCAqIEZST00gcGxheWVycwoJCQlMRUZUIEpPSU4gdGVhbXMgT04gcGxheWVycy50ZWFtX2lkID0gdGVhbXMudGVhbV9pZDsKCSI7CgkkcmVzdWx0ID0gYXJyYXkoKTsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCgkkc3RtdC0+ZXhlY3V0ZSgpOwoKCXdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKCQkkcmVzdWx0WyRyb3dbJ3BsYXllcl9pZCddXSA9ICRyb3c7Cgl9CgoJcmV0dXJuICRyZXN1bHQ7Cn0KCmZ1bmN0aW9uIGdldEFsbFRlYW1zKCRkYikgewoJJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHRlYW1zCgkJCUlOTkVSIEpPSU4gY291bnRyaWVzIE9OIHRlYW1zLmNvdW50cnlfaWQgPSBjb3VudHJpZXMuY291bnRyeV9pZDsKCSI7CgkkcmVzdWx0ID0gYXJyYXkoKTsKCgkkc3RtdCA9ICRkYi0+cHJlcGFyZSgkc3FsKTsKCgkkc3RtdC0+ZXhlY3V0ZSgpOwoKCXdoaWxlKCRyb3cgPSAkc3RtdC0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKCQkkcmVzdWx0WyRyb3dbJ3RlYW1faWQnXV0gPSAkcm93OwoJfQoKCXJldHVybiAkcmVzdWx0Owp9[\/et_pb_dmb_code_snippet][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+CgkJCQkJCTx0ZD48P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+PC90ZD4KCQkJCQkJPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsndGVhbV9uYW1lJ107ID8+PC90ZD4KCQkJCQk8L3RyPgoJCQkJPD9waHAgfSA\/PgoJCQk8L3RhYmxlPgoJCTwvZGl2PgoJPC9kaXY+CgoJPGZvb3Rlcj4KCQkKCTwvZm9vdGVyPgo8L2JvZHk+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;3.1.1&#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+CgkJCQkJCTx0ZD48P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+PC90ZD4KCQkJCQkJPHRkPjw\/cGhwIGVjaG8gJHBsYXllclsndGVhbV9uYW1lJ107ID8+PC90ZD4KCQkJCQk8L3RyPgoJCQkJPD9waHAgfSA\/PgoJCQk8L3RhYmxlPgoJCTwvZGl2PgoJPC9kaXY+CgoJPGZvb3Rlcj4KCQkKCTwvZm9vdGVyPgo8L2JvZHk+CjwvaHRtbD4=[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (teams.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sIGxhbmc9ImVuIj4KPGhlYWQ+Cgk8bWV0YSBjaGFyc2V0PSJVVEYtOCI+Cgk8dGl0bGU+0JrQvtC80LDQvdC00Ys8L3RpdGxlPgoJPGxpbmsgaHJlZj0iLy9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4zLjYvY3NzL2Jvb3RzdHJhcC5taW4uY3NzIiByZWw9InN0eWxlc2hlZXQiPgoJPHNjcmlwdCBzcmM9Imh0dHBzOi8vYWpheC5nb29nbGVhcGlzLmNvbS9hamF4L2xpYnMvanF1ZXJ5LzEuMTEuMC9qcXVlcnkubWluLmpzIj48L3NjcmlwdD4KCTxzY3JpcHQgc3JjPSIvL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjMuNi9qcy9ib290c3RyYXAubWluLmpzIj48L3NjcmlwdD4KPC9oZWFkPgo8Ym9keT4KCTxoZWFkZXI+CgkJPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0IiByb2xlPSJuYXZpZ2F0aW9uIj4KCQkJPGRpdiBjbGFzcz0iY29udGFpbmVyLWZsdWlkIj4KCQkJCTxkaXYgY2xhc3M9Im5hdmJhci1oZWFkZXIiPgoJCQkJCTxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSIgZGF0YS10b2dnbGU9ImNvbGxhcHNlIiBkYXRhLXRhcmdldD0iLm5hdmJhci1leDEtY29sbGFwc2UiPgoJCQkJCQk8c3BhbiBjbGFzcz0ic3Itb25seSI+VG9nZ2xlIG5hdmlnYXRpb248L3NwYW4+CgkJCQkJCTxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgoJCQkJCQk8c3BhbiBjbGFzcz0iaWNvbi1iYXIiPjwvc3Bhbj4KCQkJCQkJPHNwYW4gY2xhc3M9Imljb24tYmFyIj48L3NwYW4+CgkJCQkJPC9idXR0b24+CgkJCQkJPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgoJCQkJPC9kaXY+CgkJCgkJCQk8ZGl2IGNsYXNzPSJjb2xsYXBzZSBuYXZiYXItY29sbGFwc2UgbmF2YmFyLWV4MS1jb2xsYXBzZSI+CgkJCQkJPHVsIGNsYXNzPSJuYXYgbmF2YmFyLW5hdiI+CgkJCQkJCTxsaT48YSBocmVmPSJpbmRleC5waHAiPtCT0LvQsNCy0L3QsNGPPC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJ0ZWFtcy5waHAiPtCa0L7QvNCw0L3QtNGLPC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJjb3VudHJpZXMucGhwIj7QodGC0YDQsNC90Ys8L2E+PC9saT4KCQkJCQk8L3VsPgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCTwvbmF2PgoJPC9oZWFkZXI+CgoJPGRpdiBpZD0iY29udGVudCI+CgkJPGRpdiBjbGFzcz0iY29udGFpbmVyLWZsdWlkIj4KCQkJPD9waHAgaW5jbHVkZSAnZGIucGhwJzsgPz4KCQkJPD9waHAgaW5jbHVkZSAnYXBpLnBocCc7ID8+CgkJCTw\/cGhwCgkJCQkkdGVhbXMgPSBnZXRBbGxUZWFtcygkZGIpOwoJCQk\/PgoJCQk8dGFibGUgY2xhc3M9InRhYmxlIHRhYmxlLWJvcmRlcmVkIj4KCQkJCTx0cj4KCQkJCQk8dGg+0JrQvtC80LDQvdC00LA8L3RoPgoJCQkJCTx0aD7QodGC0YDQsNC90LA8L3RoPgoJCQkJPC90cj4KCQkJCTw\/cGhwIGZvcmVhY2ggKCR0ZWFtcyBhcyAkdGVhbSkgeyA\/PgoJCQkJCTx0cj4KCQkJCQkJPHRkPjw\/cGhwIGVjaG8gJHRlYW1bJ3RlYW1fbmFtZSddOyA\/PjwvdGQ+CgkJCQkJCTx0ZD48P3BocCBlY2hvICR0ZWFtWydjb3VudHJ5X25hbWUnXTsgPz48L3RkPgoJCQkJCTwvdHI+CgkJCQk8P3BocCB9ID8+CgkJCTwvdGFibGU+CgkJPC9kaXY+Cgk8L2Rpdj4KCgk8Zm9vdGVyPgoJCQoJPC9mb290ZXI+CjwvYm9keT4KPC9odG1sPg==&#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;3.1.1&#8243; hover_enabled=&#8221;0&#8243;]PCFET0NUWVBFIGh0bWw+CjxodG1sIGxhbmc9ImVuIj4KPGhlYWQ+Cgk8bWV0YSBjaGFyc2V0PSJVVEYtOCI+Cgk8dGl0bGU+0JrQvtC80LDQvdC00Ys8L3RpdGxlPgoJPGxpbmsgaHJlZj0iLy9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4zLjYvY3NzL2Jvb3RzdHJhcC5taW4uY3NzIiByZWw9InN0eWxlc2hlZXQiPgoJPHNjcmlwdCBzcmM9Imh0dHBzOi8vYWpheC5nb29nbGVhcGlzLmNvbS9hamF4L2xpYnMvanF1ZXJ5LzEuMTEuMC9qcXVlcnkubWluLmpzIj48L3NjcmlwdD4KCTxzY3JpcHQgc3JjPSIvL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjMuNi9qcy9ib290c3RyYXAubWluLmpzIj48L3NjcmlwdD4KPC9oZWFkPgo8Ym9keT4KCTxoZWFkZXI+CgkJPG5hdiBjbGFzcz0ibmF2YmFyIG5hdmJhci1kZWZhdWx0IiByb2xlPSJuYXZpZ2F0aW9uIj4KCQkJPGRpdiBjbGFzcz0iY29udGFpbmVyLWZsdWlkIj4KCQkJCTxkaXYgY2xhc3M9Im5hdmJhci1oZWFkZXIiPgoJCQkJCTxidXR0b24gdHlwZT0iYnV0dG9uIiBjbGFzcz0ibmF2YmFyLXRvZ2dsZSIgZGF0YS10b2dnbGU9ImNvbGxhcHNlIiBkYXRhLXRhcmdldD0iLm5hdmJhci1leDEtY29sbGFwc2UiPgoJCQkJCQk8c3BhbiBjbGFzcz0ic3Itb25seSI+VG9nZ2xlIG5hdmlnYXRpb248L3NwYW4+CgkJCQkJCTxzcGFuIGNsYXNzPSJpY29uLWJhciI+PC9zcGFuPgoJCQkJCQk8c3BhbiBjbGFzcz0iaWNvbi1iYXIiPjwvc3Bhbj4KCQkJCQkJPHNwYW4gY2xhc3M9Imljb24tYmFyIj48L3NwYW4+CgkJCQkJPC9idXR0b24+CgkJCQkJPGEgY2xhc3M9Im5hdmJhci1icmFuZCIgaHJlZj0iIyI+U3BvcnQgQ1JNPC9hPgoJCQkJPC9kaXY+CgkJCgkJCQk8ZGl2IGNsYXNzPSJjb2xsYXBzZSBuYXZiYXItY29sbGFwc2UgbmF2YmFyLWV4MS1jb2xsYXBzZSI+CgkJCQkJPHVsIGNsYXNzPSJuYXYgbmF2YmFyLW5hdiI+CgkJCQkJCTxsaT48YSBocmVmPSJpbmRleC5waHAiPtCT0LvQsNCy0L3QsNGPPC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJwbGF5ZXJzLnBocCI+0JjQs9GA0L7QutC4PC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJ0ZWFtcy5waHAiPtCa0L7QvNCw0L3QtNGLPC9hPjwvbGk+CgkJCQkJCTxsaT48YSBocmVmPSJjb3VudHJpZXMucGhwIj7QodGC0YDQsNC90Ys8L2E+PC9saT4KCQkJCQk8L3VsPgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCTwvbmF2PgoJPC9oZWFkZXI+CgoJPGRpdiBpZD0iY29udGVudCI+CgkJPGRpdiBjbGFzcz0iY29udGFpbmVyLWZsdWlkIj4KCQkJPD9waHAgaW5jbHVkZSAnZGIucGhwJzsgPz4KCQkJPD9waHAgaW5jbHVkZSAnYXBpLnBocCc7ID8+CgkJCTw\/cGhwCgkJCQkkdGVhbXMgPSBnZXRBbGxUZWFtcygkZGIpOwoJCQk\/PgoJCQk8dGFibGUgY2xhc3M9InRhYmxlIHRhYmxlLWJvcmRlcmVkIj4KCQkJCTx0cj4KCQkJCQk8dGg+0JrQvtC80LDQvdC00LA8L3RoPgoJCQkJCTx0aD7QodGC0YDQsNC90LA8L3RoPgoJCQkJPC90cj4KCQkJCTw\/cGhwIGZvcmVhY2ggKCR0ZWFtcyBhcyAkdGVhbSkgeyA\/PgoJCQkJCTx0cj4KCQkJCQkJPHRkPjw\/cGhwIGVjaG8gJHRlYW1bJ3RlYW1fbmFtZSddOyA\/PjwvdGQ+CgkJCQkJCTx0ZD48P3BocCBlY2hvICR0ZWFtWydjb3VudHJ5X25hbWUnXTsgPz48L3RkPgoJCQkJCTwvdHI+CgkJCQk8P3BocCB9ID8+CgkJCTwvdGFibGU+CgkJPC9kaXY+Cgk8L2Rpdj4KCgk8Zm9vdGVyPgoJCQoJPC9mb290ZXI+CjwvYm9keT4KPC9odG1sPg==[\/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>Today we&#8217;ll continue create our web application. We&#8217;ll select data from two tables. In last lesson we selected all players from players tables. On players.php page we have got table with three columns. Two of them are situated in another tables (&#8220;teams&#8221; and &#8220;countries&#8221;). That&#8217;s why we need to modify our sql query with using [&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":"<p>\u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u043c \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u043d\u0430\u0448\u0435\u0433\u043e \u0432\u0435\u0431 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f. \u041c\u044b \u0441\u0434\u0435\u043b\u0430\u0435\u043c \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0438\u0437 \u0434\u0432\u0443\u0445 \u0442\u0430\u0431\u043b\u0438\u0446, \u0440\u0430\u0441\u0448\u0438\u0440\u0438\u0432 \u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u044b\u0431\u043e\u0440\u043a\u0438 \u0438\u0433\u0440\u043e\u043a\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043c\u044b \u043d\u0430\u043f\u0438\u0441\u0430\u043b\u0438 \u043d\u0430 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0443\u0440\u043e\u043a\u0435.<!--more--><\/p><p>https:\/\/www.youtube.com\/watch?v=n7l9qWSh7Gg<\/p><p>\u041d\u0430 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u0432\u044b\u0431\u0440\u0430\u043b\u0438 \u0432\u0441\u0435\u0445 \u0438\u0433\u0440\u043e\u043a\u043e\u0432 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b players. \u041d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0435 players.php \u0443 \u043d\u0430\u0441 \u0438\u043c\u0435\u0435\u0442\u0441\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0441 \u043a\u043e\u043b\u043e\u043d\u043a\u0430\u043c\u0438 \"\u0418\u043c\u044f \u0438\u0433\u0440\u043e\u043a\u0430\", \"\u041a\u043e\u043c\u0430\u043d\u0434\u0430\" \u0438 \"\u0421\u0442\u0440\u0430\u043d\u0430\". \u041d\u043e \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u044b \u0438 \u0441\u0442\u0440\u0430\u043d\u044b \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u0432 \u0434\u0440\u0443\u0433\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 (\"\u041a\u043e\u043c\u0430\u043d\u0434\u044b (teams)\" \u0438 \"\u0421\u0442\u0440\u0430\u043d\u044b (countries)\"). \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u043d\u0430\u043c \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u043c\u043e\u0434\u0438\u0444\u0438\u0446\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043d\u0430\u0448 \u0437\u0430\u043f\u0440\u043e\u0441 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c INNER JOIN.<\/p><p>\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430: \u0444\u0430\u0439\u043b api.php<\/p><pre><code><?php\r\n\r\nfunction getAllPlayers($db) {\r\n    $sql = \"SELECT * FROM players\r\n            LEFT JOIN teams ON players.team_id = teams.team_id;\r\n    \";\r\n    $result = array();\r\n\r\n    $stmt = $db->prepare($sql);\r\n\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\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<\/code><\/pre><p>\u0444\u0430\u0439\u043b players.php<\/p><pre><code><!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n    <meta charset=\"UTF-8\">\r\n    <title>\u0418\u0433\u0440\u043e\u043a\u0438<\/title>\r\n    <link href=\"\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.6\/css\/bootstrap.min.css\" rel=\"stylesheet\">\r\n    <script src=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.0\/jquery.min.js\"><\/script>\r\n    <script src=\"\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.6\/js\/bootstrap.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n    <header>\r\n        <nav class=\"navbar navbar-default\" role=\"navigation\">\r\n            <div class=\"container-fluid\">\r\n                <div class=\"navbar-header\">\r\n                    <button type=\"button\" class=\"navbar-toggle\" data-toggle=\"collapse\" data-target=\".navbar-ex1-collapse\">\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 navbar-ex1-collapse\">\r\n                    <ul class=\"nav navbar-nav\">\r\n                        <li><a href=\"index.php\">\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                        <li><a href=\"countries.php\">\u0421\u0442\u0440\u0430\u043d\u044b<\/a><\/li>\r\n                    <\/ul>\r\n                <\/div>\r\n            <\/div>\r\n        <\/nav>\r\n    <\/header>\r\n\r\n    <div id=\"content\">\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><?php echo $player['player_name']; ?><\/td>\r\n                        <td><?php echo $player['team_name']; ?><\/td>\r\n                    <\/tr>\r\n                <?php } ?>\r\n            <\/table>\r\n        <\/div>\r\n    <\/div>\r\n\r\n    <footer>\r\n\r\n    <\/footer>\r\n<\/body>\r\n<\/html>\r\n<\/code><\/pre><p>\u0444\u0430\u0439\u043b teams.php<\/p><pre><code><!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n    <meta charset=\"UTF-8\">\r\n    <title>\u041a\u043e\u043c\u0430\u043d\u0434\u044b<\/title>\r\n    <link href=\"\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.6\/css\/bootstrap.min.css\" rel=\"stylesheet\">\r\n    <script src=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.0\/jquery.min.js\"><\/script>\r\n    <script src=\"\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.6\/js\/bootstrap.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n    <header>\r\n        <nav class=\"navbar navbar-default\" role=\"navigation\">\r\n            <div class=\"container-fluid\">\r\n                <div class=\"navbar-header\">\r\n                    <button type=\"button\" class=\"navbar-toggle\" data-toggle=\"collapse\" data-target=\".navbar-ex1-collapse\">\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 navbar-ex1-collapse\">\r\n                    <ul class=\"nav navbar-nav\">\r\n                        <li><a href=\"index.php\">\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                        <li><a href=\"countries.php\">\u0421\u0442\u0440\u0430\u043d\u044b<\/a><\/li>\r\n                    <\/ul>\r\n                <\/div>\r\n            <\/div>\r\n        <\/nav>\r\n    <\/header>\r\n\r\n    <div id=\"content\">\r\n        <div class=\"container-fluid\">\r\n            <?php include 'db.php'; ?>\r\n            <?php include 'api.php'; ?>\r\n            <?php\r\n                $teams = getAllTeams($db);\r\n            ?>\r\n            <table class=\"table table-bordered\">\r\n                <tr>\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 ($teams as $team) { ?>\r\n                    <tr>\r\n                        <td><?php echo $team['team_name']; ?><\/td>\r\n                        <td><?php echo $team['country_name']; ?><\/td>\r\n                    <\/tr>\r\n                <?php } ?>\r\n            <\/table>\r\n        <\/div>\r\n    <\/div>\r\n\r\n    <footer>\r\n\r\n    <\/footer>\r\n<\/body>\r\n<\/html>\r\n<\/code><\/pre>","_et_gb_content_width":"","footnotes":""},"categories":[274,219],"tags":[248,240],"class_list":["post-3535","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. Getting data from several tables - Kamil Abzalov&#039;s blog<\/title>\n<meta name=\"description\" content=\"In this lesson we will modify code from last lesson - make select from two tables\" \/>\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-join\/\" \/>\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. Getting data from several tables - Kamil Abzalov&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"In this lesson we will modify code from last lesson - make select from two tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/\" \/>\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-16T17:48:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-08T21:35:31+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. Getting data from several tables\" \/>\n<meta name=\"twitter:description\" content=\"In this lesson we will modify code from last lesson - make select from two tables\" \/>\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=\"9 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-join\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Build CRUD Application PHP &#038; Mysql. Getting data from several tables\",\"datePublished\":\"2017-08-16T17:48:30+00:00\",\"dateModified\":\"2020-04-08T21:35:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/\"},\"wordCount\":1856,\"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-join\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/\",\"name\":\"Build CRUD Application PHP & Mysql. Getting data from several tables - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-16T17:48:30+00:00\",\"dateModified\":\"2020-04-08T21:35:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"description\":\"In this lesson we will modify code from last lesson - make select from two tables\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-join\\\/#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 & Mysql. Getting data from several tables\"}]},{\"@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. Getting data from several tables - Kamil Abzalov's blog","description":"In this lesson we will modify code from last lesson - make select from two tables","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-join\/","og_locale":"en_US","og_type":"article","og_title":"Build CRUD Application PHP & Mysql. Getting data from several tables - Kamil Abzalov's blog","og_description":"In this lesson we will modify code from last lesson - make select from two tables","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/","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-16T17:48:30+00:00","article_modified_time":"2020-04-08T21:35:31+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_title":"Build CRUD Application PHP & Mysql. Getting data from several tables","twitter_description":"In this lesson we will modify code from last lesson - make select from two tables","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Build CRUD Application PHP &#038; Mysql. Getting data from several tables","datePublished":"2017-08-16T17:48:30+00:00","dateModified":"2020-04-08T21:35:31+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/"},"wordCount":1856,"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-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/","name":"Build CRUD Application PHP & Mysql. Getting data from several tables - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-16T17:48:30+00:00","dateModified":"2020-04-08T21:35:31+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"description":"In this lesson we will modify code from last lesson - make select from two tables","breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-join\/#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 & Mysql. Getting data from several tables"}]},{"@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\/3535","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=3535"}],"version-history":[{"count":8,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3535\/revisions"}],"predecessor-version":[{"id":31897,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3535\/revisions\/31897"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}