{"id":3530,"date":"2017-08-16T20:07:34","date_gmt":"2017-08-16T17:07:34","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/build-crud-application-php-mysql-intro-to-pdo\/"},"modified":"2020-04-09T00:33:55","modified_gmt":"2020-04-08T21:33:55","slug":"build-crud-application-php-mysql-intro-to-pdo","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/phpmysql\/build-crud-application-php-mysql-intro-to-pdo\/","title":{"rendered":"Build CRUD Application PHP &#038; Mysql. Intro to PDO"},"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. Intro to PDO&#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;]Today we&#8217;ll continue to create our first web app, write function for getting data with php pdo and print this data.<!--more--><br \/>\n[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=-WBq4l2VUZw&#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&#8217;ll consider why code from <a href=\"https:\/\/kamil-abzalov.com\/en\/tutorials\/phpmysql-tuts\/build-crud-application-php-mysql\/\">last lesson<\/a> is excess. Try&#8230;catch block will print error. But if you wont&#8217; use try&#8230;catch in this situation you will see such error, which will tell you about wrong database connection configuration.<br \/>\nAs far as the function <strong>getAllPlayers<\/strong>, which we will write, its logic is very simple: first of all you must pass $db argument, which we defined in db.php. This is necessary because this function (and others) will work with database. Next we&#8217;ll create string variable as sql query and prepare it.<\/p>\n<p>Prepare queries useful because they initialized once, next only parameters are substituted. In fact it is templates for MySQL.<\/p>\n<p>Next we execute our query with execute function. Then we begin to work with data. But this data we must fetch. For this php has got fetch, fetchAll and other functions. Fetch has got one important parameter &#8211; fetching style (array, objects and so on).<br \/>\nAnd now we are ready to print our data.<br \/>\n[\/et_pb_text][et_pb_dmb_code_snippet title=&#8221;Code lesson (api.php)&#8221; code=&#8221;PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7CgogICAgJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHBsYXllcnMiOwogICAgJHJlc3VsdCA9IGFycmF5KCk7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAvL3ByaW50X3IoJHN0bXQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgIC8vcHJpbnRfcigkc3RtdCk7CgogICAgd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgeyAvLyDRgNCw0YHRgdC80L7RgtGA0LXRgtGMIGZldGNoQWxsICjRgNC10LbQuNC8IEZFVENIX0JPVEgpCiAgICAgICAgJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0gPSAkcm93OwogICAgICAgIC8qZWNobyAiPHByZT4iOwogICAgICAgIHByaW50X3IoJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0pOwogICAgICAgIGVjaG8gIjwvcHJlPiI7Ki8KICAgIH0KCiAgICAvLyRyZXN1bHQgPSAkc3RtdC0+ZmV0Y2hBbGwoKTsKCiAgICAvKmVjaG8gIjxwcmU+IjsKICAgIHByaW50X3IoJHJlc3VsdCk7CiAgICBlY2hvICI8L3ByZT4iOyovCgogICAgcmV0dXJuICRyZXN1bHQ7Cn0=&#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;]PD9waHAKCmZ1bmN0aW9uIGdldEFsbFBsYXllcnMoJGRiKSB7CgogICAgJHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHBsYXllcnMiOwogICAgJHJlc3VsdCA9IGFycmF5KCk7CgogICAgJHN0bXQgPSAkZGItPnByZXBhcmUoJHNxbCk7CiAgICAvL3ByaW50X3IoJHN0bXQpOwogICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgIC8vcHJpbnRfcigkc3RtdCk7CgogICAgd2hpbGUoJHJvdyA9ICRzdG10LT5mZXRjaChQRE86OkZFVENIX0FTU09DKSkgeyAvLyDRgNCw0YHRgdC80L7RgtGA0LXRgtGMIGZldGNoQWxsICjRgNC10LbQuNC8IEZFVENIX0JPVEgpCiAgICAgICAgJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0gPSAkcm93OwogICAgICAgIC8qZWNobyAiPHByZT4iOwogICAgICAgIHByaW50X3IoJHJlc3VsdFskcm93WydwbGF5ZXJfaWQnXV0pOwogICAgICAgIGVjaG8gIjwvcHJlPiI7Ki8KICAgIH0KCiAgICAvLyRyZXN1bHQgPSAkc3RtdC0+ZmV0Y2hBbGwoKTsKCiAgICAvKmVjaG8gIjxwcmU+IjsKICAgIHByaW50X3IoJHJlc3VsdCk7CiAgICBlY2hvICI8L3ByZT4iOyovCgogICAgcmV0dXJuICRyZXN1bHQ7Cn0=[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (index.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+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0ZD48P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+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+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0ZD48P3BocCBlY2hvICRwbGF5ZXJbJ3BsYXllcl9uYW1lJ107ID8+PC90ZD4KICAgICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgPD9waHAgfSA\/PgoKICAgICAgICAgICAgIDwvdGFibGU+CiAgICAgICAgPC9kaXY+CgogICAgICAgIDxmb290ZXI+CgogICAgICAgIDwvZm9vdGVyPgogICAgPC9ib2R5Pgo8L2h0bWw+[\/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 to create our first web app, write function for getting data with php pdo and print this data. First of all we&#8217;ll consider why code from last lesson is excess. Try&#8230;catch block will print error. But if you wont&#8217; use try&#8230;catch in this situation you will see such error, which will tell [&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":"\u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0432\u0438\u0434\u0435\u043e\u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u043c \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0432\u0435\u0431 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0432 \u0441\u0432\u044f\u0437\u043a\u0435 \u0441 MySQL. \u041c\u044b \u043d\u0430\u043f\u0438\u0448\u0435\u043c \u0444\u0443\u043d\u043a\u0446\u0438\u044e \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0432\u0441\u0435\u0445 \u0438\u0433\u0440\u043e\u043a\u043e\u0432 \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 PHP PDO \u0438 \u0432\u044b\u0432\u0435\u0434\u0435\u043c \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u0411\u0414 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440.<!--more-->\r\n\r\nhttps:\/\/www.youtube.com\/watch?v=-WBq4l2VUZw\r\n\r\n\u041d\u043e \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043c\u044b \u043e\u0442\u0432\u0435\u0442\u0438\u043c \u043d\u0430 \u0432\u043e\u043f\u0440\u043e\u0441, \u043f\u043e\u0447\u0435\u043c\u0443 \u043a\u043e\u0434 \u0438\u0437 <a href=\"http:\/\/kamil-abzalov.com\/videouroki\/create-simple-php-application\/\">\u043f\u0440\u043e\u0448\u043b\u043e\u0433\u043e \u0443\u0440\u043e\u043a\u0430<\/a> \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0431\u044b\u0442\u043e\u0447\u043d\u044b\u043c? \u0414\u0435\u043b\u043e \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e try..catch \u0432 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u0440\u043e\u0441\u0442\u043e \u0432\u044b\u0432\u043e\u0434\u0438\u0442 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u043e\u0431 \u043e\u0448\u0438\u0431\u043a\u0435, \u043d\u043e \u0435\u0441\u043b\u0438 \u0432\u044b \u0443\u0431\u0435\u0440\u0435\u0442\u0435 try...catch \u0438 \u0437\u0430\u0434\u0430\u0434\u0438\u0442\u0435 \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435, \u0442\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0435 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u044b\u0439 \u0432\u044b\u0432\u043e\u0434 \u043e\u0431 \u043e\u0448\u0438\u0431\u043a\u0435, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0441\u043e\u043e\u0431\u0449\u0438\u0442 \u0432\u0430\u043c \u043e \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e\u0441\u0442\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u0438\u043c\u0435\u0435\u0442 \u0441\u043c\u044b\u0441\u043b \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0442\u044c \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u0439 \u0432 \u0443\u0440\u043e\u043a\u0435 \u043a\u043e\u0434 \u0432 try...catch, \u0435\u0441\u043b\u0438 \u0432\u044b \u0431\u0443\u0434\u0435\u0442\u0435 \u043e\u0442\u043b\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0438 \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0442\u044c \u043e\u0448\u0438\u0431\u043a\u0443 \u043a\u0430\u043a\u0438\u043c-\u043b\u0438\u0431\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c.\r\n\r\n\u0427\u0442\u043e \u043a\u0430\u0441\u0430\u0435\u0442\u0441\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u0438 <strong>getAllPlayers<\/strong>, \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u043c\u044b \u043d\u0430\u043f\u0438\u0448\u0435\u043c, \u0442\u043e \u043b\u043e\u0433\u0438\u043a\u0430 \u0435\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u0430: \u0432\u043e-\u043f\u0435\u0440\u0432\u044b\u0445 \u0432 \u0444\u0443\u043d\u043a\u0446\u0438\u044e \u043d\u0435\u043e\u0431\u043e\u0445\u043e\u0434\u0438\u043c\u043e \u043f\u0435\u0440\u0435\u0434\u0430\u0442\u044c \u043e\u0431\u044a\u0435\u043a\u0442 $db, \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0439 \u0432 \u0444\u0430\u0439\u043b\u0435 db.php. \u042d\u0442\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u0434\u0430\u043d\u043d\u0430\u044f \u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043d\u0430\u0448\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0431\u0443\u0434\u0443\u0442 \u043d\u0435\u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u043e\u0431\u0440\u0430\u0449\u0430\u0442\u044c\u0441\u044f \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u0414\u0430\u043b\u0435\u0435 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0441\u0442\u0440\u043e\u043a\u043e\u0432\u0443\u044e \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e \u0432 \u0432\u0438\u0434\u0435 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0438 \u043f\u043e\u0434\u0433\u043e\u0442\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0435\u0433\u043e.\r\n\r\n\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0445\u043e\u0440\u043e\u0448\u0438 \u0442\u0435\u043c, \u0447\u0442\u043e \u0438\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u043e\u0434\u0438\u043d \u0440\u0430\u0437, \u0430 \u0434\u0430\u043b\u044c\u0448\u0435 \u0432 \u043d\u0438\u0445 \u043f\u043e\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b. \u041f\u043e \u0441\u0443\u0442\u0438 \u044d\u0442\u043e \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0448\u0430\u0431\u043b\u043e\u043d\u044b \u0434\u043b\u044f MySQl.\r\n\r\n\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 execute. \u0410 \u0434\u0430\u043b\u0435\u0435 \u043d\u0430\u0447\u0438\u043d\u0430\u0435\u0442\u0441\u044f \u0440\u0430\u0431\u043e\u0442\u0430 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. \u0412\u0430\u0436\u043d\u043e \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c, \u0447\u0442\u043e \u044d\u0442\u0438 \u0434\u0430\u043d\u043d\u044b\u0435 \u043d\u0430\u0434\u043e \u0440\u0430\u0437\u043e\u0431\u0440\u0430\u0442\u044c \u0434\u043b\u044f \u0432\u0438\u0434\u0430, \u043f\u043e\u043d\u044f\u0442\u043d\u043e\u0433\u043e \u0438 \u0443\u0434\u043e\u0431\u043d\u043e\u0433\u043e \u0434\u043b\u044f php. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 fetch, fetchAll \u0438 \u043f\u0440. \u0424\u0443\u043d\u043a\u0446\u0438\u0438 fetch \u0438\u043c\u0435\u044e\u0442 \u043e\u0434\u0438\u043d \u0432\u0430\u0436\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 - \u0441\u0442\u0438\u043b\u044c \u0440\u0430\u0437\u0431\u043e\u0440\u0430. \u0412\u044b\u0440\u0430\u0436\u0430\u044f\u0441\u044c \u043f\u0440\u043e\u0449\u0435, \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u0440\u0430\u0437\u0431\u0438\u0440\u0430\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u043e\u0439 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0435 \u0434\u043b\u044f php (\u043c\u0430\u0441\u0441\u0438\u0432, \u043e\u0431\u044a\u0435\u043a\u0442 \u0438 \u043f\u0440.).\r\n\r\n\u0414\u0430\u043b\u0435\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u044e\u0442\u0441\u044f \u0438\u0437 \u0432\u044b\u0437\u043e\u0432\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0438 \u0432\u044b\u0432\u043e\u0434\u044f\u0442\u0441\u044f \u0432 \u0431\u0440\u0430\u0437\u0443\u0435\u0440.\r\n\r\n\u0424\u0430\u0439\u043b api.php\r\n\r\n<pre><code><?php\r\n\r\nfunction getAllPlayers($db) {\r\n\r\n    $sql = \"SELECT * FROM players\";\r\n    $result = array();\r\n\r\n    $stmt = $db->prepare($sql);\r\n    \/\/print_r($stmt);\r\n    $stmt->execute();\r\n    \/\/print_r($stmt);\r\n\r\n    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { \/\/ \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c fetchAll (\u0440\u0435\u0436\u0438\u043c FETCH_BOTH)\r\n        $result[$row['player_id']] = $row;\r\n        \/*echo \"<pre>\";\r\n        print_r($result[$row['player_id']]);\r\n        echo \"<\/pre>\";*\/\r\n    }\r\n\r\n    \/\/$result = $stmt->fetchAll();\r\n\r\n    \/*echo \"<pre>\";\r\n    print_r($result);\r\n    echo \"<\/pre>\";*\/\r\n\r\n    return $result;\r\n}\r\n<\/code><\/pre>\r\n\r\n\u0424\u0430\u0439\u043b players.php\r\n\r\n<pre><code><br \/><!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><?php echo $player['player_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>","_et_gb_content_width":"","footnotes":""},"categories":[274,219],"tags":[248,240],"class_list":["post-3530","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. Intro to PDO - Kamil Abzalov&#039;s blog<\/title>\n<meta name=\"description\" content=\"Today we&#039;ll continue to create our first web app, write function for getting data with php pdo and print this 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-intro-to-pdo\/\" \/>\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. Intro to PDO - Kamil Abzalov&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"Today we&#039;ll continue to create our first web app, write function for getting data with php pdo and print this data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/\" \/>\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:07:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-08T21:33:55+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. Intro to PDO\" \/>\n<meta name=\"twitter:description\" content=\"Today we&#039;ll continue to create our first web app, write function for getting data with php pdo and print this 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=\"7 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-intro-to-pdo\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Build CRUD Application PHP &#038; Mysql. Intro to PDO\",\"datePublished\":\"2017-08-16T17:07:34+00:00\",\"dateModified\":\"2020-04-08T21:33:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/\"},\"wordCount\":1316,\"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-intro-to-pdo\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/\",\"name\":\"Build CRUD Application PHP & Mysql. Intro to PDO - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-16T17:07:34+00:00\",\"dateModified\":\"2020-04-08T21:33:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"description\":\"Today we'll continue to create our first web app, write function for getting data with php pdo and print this data.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/create-web-app-intro-to-pdo\\\/#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. Intro to PDO\"}]},{\"@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. Intro to PDO - Kamil Abzalov's blog","description":"Today we'll continue to create our first web app, write function for getting data with php pdo and print this 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-intro-to-pdo\/","og_locale":"en_US","og_type":"article","og_title":"Build CRUD Application PHP & Mysql. Intro to PDO - Kamil Abzalov's blog","og_description":"Today we'll continue to create our first web app, write function for getting data with php pdo and print this data.","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/","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:07:34+00:00","article_modified_time":"2020-04-08T21:33:55+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_title":"Build CRUD Application PHP & Mysql. Intro to PDO","twitter_description":"Today we'll continue to create our first web app, write function for getting data with php pdo and print this data.","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Build CRUD Application PHP &#038; Mysql. Intro to PDO","datePublished":"2017-08-16T17:07:34+00:00","dateModified":"2020-04-08T21:33:55+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/"},"wordCount":1316,"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-intro-to-pdo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/","name":"Build CRUD Application PHP & Mysql. Intro to PDO - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-16T17:07:34+00:00","dateModified":"2020-04-08T21:33:55+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"description":"Today we'll continue to create our first web app, write function for getting data with php pdo and print this data.","breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/create-web-app-intro-to-pdo\/#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. Intro to PDO"}]},{"@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\/3530","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=3530"}],"version-history":[{"count":9,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3530\/revisions"}],"predecessor-version":[{"id":31894,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3530\/revisions\/31894"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}