{"id":3567,"date":"2017-08-17T00:57:54","date_gmt":"2017-08-16T21:57:54","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/cookie-and-sql-injections\/"},"modified":"2020-04-09T23:30:12","modified_gmt":"2020-04-09T20:30:12","slug":"cookie-and-sql-injections","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/php\/cookie-and-sql-injections\/","title":{"rendered":"Cookie and SQL injections"},"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;Cookie and SQL injections&#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;]In this lesson we&#8217;ll consider COOKIE, which is similar with SESSIONS. Also we&#8217;ll discuss problem with safety &#8211; SQL injections.<!--more--><br \/>\n[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=_CUwLanUIRU&#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;]COOKIE is similar with SESSIONS. You can store any data of application in cookie. But what is difference between cookie and session? Cookie stores data in user&#8217;s browser, which means that anymore can get cookie, change it, or steal. It means to store login and password in coolie is not good idea. Ok. Why do you need cookie? For example, you can use it in basket. Let&#8217;s imagine, you put products to basket, but didn&#8217;t finish order. Then you return and you needn&#8217;t put products to basket. It&#8217;s all thanks to cookie.<\/p>\n<p>The second question is SQL injection. This problem has already decided. But for absolute beginners it is important to understand danger of this problem. The reason is you don&#8217;t validate data from thr client. For example, if user enter &#8216;admin&#8217; or 1=1, query will be SELECT * FROM table_name WHERE user = &#8216;admin&#8217; or 1=1.<br \/>\nSecond part of this query is always true. And some &#8220;bad guy&#8221; get all data from table. In this lesson we considered example, where sql injection drops database<br \/>\n[\/et_pb_text][et_pb_dmb_code_snippet title=&#8221;Code lesson (cookie.php)&#8221; code=&#8221;PD9waHAKLy\/Qv9GA0LjQvNC10YAg0YHQviDRgdGH0LXRgtGH0LjQutC+0Lwg0L\/QvtGB0LXRidC10L3QuNGPINGB0YLRgNCw0L3QuNGGCiRjb3VudGVyID0gMDsKCmlmIChpc3NldCgkX0NPT0tJRVsnY291bnQnXSkpIHsKICAkY291bnRlciA9ICRfQ09PS0lFWydjb3VudCddOwogICRjb3VudGVyKys7Cn0KCnNldGNvb2tpZSgiY291bnQiLCAkY291bnRlcik7CgplY2hvICRjb3VudGVyOw==&#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;]PD9waHAKLy\/Qv9GA0LjQvNC10YAg0YHQviDRgdGH0LXRgtGH0LjQutC+0Lwg0L\/QvtGB0LXRidC10L3QuNGPINGB0YLRgNCw0L3QuNGGCiRjb3VudGVyID0gMDsKCmlmIChpc3NldCgkX0NPT0tJRVsnY291bnQnXSkpIHsKICAkY291bnRlciA9ICRfQ09PS0lFWydjb3VudCddOwogICRjb3VudGVyKys7Cn0KCnNldGNvb2tpZSgiY291bnQiLCAkY291bnRlcik7CgplY2hvICRjb3VudGVyOw==[\/et_pb_dmb_code_snippet][et_pb_dmb_code_snippet title=&#8221;Code lesson (injection.php)&#8221; code=&#8221;PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgPC9oZWFkPgogICAgPGJvZHk+CgogICAgICAgIDxmb3JtIGNsYXNzPSIiIG1ldGhvZD0icG9zdCI+CiAgICAgICAgICAgIDxpbnB1dCB0eXBlPSJ0ZXh0IiBuYW1lPSJuYW1lIiB2YWx1ZT0iIj4KICAgICAgICAgICAgPGJ1dHRvbiB0eXBlPSJzdWJtaXQiIG5hbWU9ImJ1dHRvbiI+0J7RgtC\/0YDQsNCy0LjRgtGMPC9idXR0b24+CiAgICAgICAgPC9mb3JtPgoKICAgICAgICA8P3BocAoKICAgICAgICAgICAgJG5hbWUgPSAkX1BPU1RbJ25hbWUnXTsKICAgICAgICAgICAgJHVzZXIgPSAicm9vdCI7CiAgICAgICAgICAgICRwYXNzd29yZCA9ICJyb290IjsKICAgICAgICAgICAgJG15ZGIgPSBuZXcgUERPKCJteXNxbDpob3N0PWxvY2FsaG9zdDtkYm5hbWU9bXlkYiIsICJyb290IiwgInJvb3QiKTsKICAgICAgICAgICAgJHNxbCA9ICJzZWxlY3QgKiBmcm9tIHVzZXJzIHdoZXJlIHVzZXJfbmFtZSA9ICRuYW1lIjsgLy\/Qv9GA0LjQvNC10YAg0LLQvdC10LTRgNC10L3QuNGPIHNxbCDQuNC90YrQtdC60YbQuNC4CiAgICAgICAgICAgIGVjaG8gJHNxbDsKICAgICAgICAgICAgJHEgPSAkbXlkYi0+cXVlcnkoJHNxbCk7CiAgICAgICAgICAgICRxLT5leGVjdXRlKCk7CiAgICAgICAgICAgIHdoaWxlKCRyZXMgPSAkcS0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKICAgICAgICAgICAgICAgIGVjaG8gIjxwcmU+IjsKICAgICAgICAgICAgICAgIHZhcl9kdW1wKCRyZXMpOwogICAgICAgICAgICAgICAgZWNobyAiPC9wcmU+IjsKICAgICAgICAgICAgICAgIGVjaG8gIjxicj4iOwogICAgICAgICAgICB9CgogICAgICAgID8+CiAgICA8L2JvZHk+CjwvaHRtbD4=&#8221; admin_label=&#8221;\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430 &#8221; style=&#8221;docco&#8221; linenums=&#8221;on&#8221; usetabwidth=&#8221;on&#8221; tabwidth=&#8221;4&#8243; _builder_version=&#8221;4.4.2&#8243; hover_enabled=&#8221;0&#8243;]PCFET0NUWVBFIGh0bWw+CjxodG1sPgogICAgPGhlYWQ+CiAgICAgICAgPG1ldGEgY2hhcnNldD0idXRmLTgiPgogICAgICAgIDx0aXRsZT48L3RpdGxlPgogICAgPC9oZWFkPgogICAgPGJvZHk+CgogICAgICAgIDxmb3JtIGNsYXNzPSIiIG1ldGhvZD0icG9zdCI+CiAgICAgICAgICAgIDxpbnB1dCB0eXBlPSJ0ZXh0IiBuYW1lPSJuYW1lIiB2YWx1ZT0iIj4KICAgICAgICAgICAgPGJ1dHRvbiB0eXBlPSJzdWJtaXQiIG5hbWU9ImJ1dHRvbiI+0J7RgtC\/0YDQsNCy0LjRgtGMPC9idXR0b24+CiAgICAgICAgPC9mb3JtPgoKICAgICAgICA8P3BocAoKICAgICAgICAgICAgJG5hbWUgPSAkX1BPU1RbJ25hbWUnXTsKICAgICAgICAgICAgJHVzZXIgPSAicm9vdCI7CiAgICAgICAgICAgICRwYXNzd29yZCA9ICJyb290IjsKICAgICAgICAgICAgJG15ZGIgPSBuZXcgUERPKCJteXNxbDpob3N0PWxvY2FsaG9zdDtkYm5hbWU9bXlkYiIsICJyb290IiwgInJvb3QiKTsKICAgICAgICAgICAgJHNxbCA9ICJzZWxlY3QgKiBmcm9tIHVzZXJzIHdoZXJlIHVzZXJfbmFtZSA9ICRuYW1lIjsgLy\/Qv9GA0LjQvNC10YAg0LLQvdC10LTRgNC10L3QuNGPIHNxbCDQuNC90YrQtdC60YbQuNC4CiAgICAgICAgICAgIGVjaG8gJHNxbDsKICAgICAgICAgICAgJHEgPSAkbXlkYi0+cXVlcnkoJHNxbCk7CiAgICAgICAgICAgICRxLT5leGVjdXRlKCk7CiAgICAgICAgICAgIHdoaWxlKCRyZXMgPSAkcS0+ZmV0Y2goUERPOjpGRVRDSF9BU1NPQykpIHsKICAgICAgICAgICAgICAgIGVjaG8gIjxwcmU+IjsKICAgICAgICAgICAgICAgIHZhcl9kdW1wKCRyZXMpOwogICAgICAgICAgICAgICAgZWNobyAiPC9wcmU+IjsKICAgICAgICAgICAgICAgIGVjaG8gIjxicj4iOwogICAgICAgICAgICB9CgogICAgICAgID8+CiAgICA8L2JvZHk+CjwvaHRtbD4=[\/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>In this lesson we&#8217;ll consider COOKIE, which is similar with SESSIONS. Also we&#8217;ll discuss problem with safety &#8211; SQL injections. COOKIE is similar with SESSIONS. You can store any data of application in cookie. But what is difference between cookie and session? Cookie stores data in user&#8217;s browser, which means that anymore can get cookie, [&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":[273,274,219],"tags":[248,240],"class_list":["post-3567","post","type-post","status-publish","format-standard","hentry","category-php","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>Cookie and SQL injections - Kamil Abzalov&#039;s blog<\/title>\n<meta name=\"description\" content=\"In this tutorial we considered COOKIE and SQL injection with example\" \/>\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\/cookie-and-sql-injection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cookie and SQL injections - Kamil Abzalov&#039;s blog\" \/>\n<meta property=\"og:description\" content=\"In this tutorial we considered COOKIE and SQL injection with example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/\" \/>\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-16T21:57:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-09T20:30:12+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=\"Cookie and SQL injections\" \/>\n<meta name=\"twitter:description\" content=\"In this tutorial we considered COOKIE and SQL injection with example\" \/>\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=\"4 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\\\/cookie-and-sql-injection\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Cookie and SQL injections\",\"datePublished\":\"2017-08-16T21:57:54+00:00\",\"dateModified\":\"2020-04-09T20:30:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/\"},\"wordCount\":881,\"commentCount\":0,\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"PHP\",\"PHP+MySQL\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/\",\"name\":\"Cookie and SQL injections - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-16T21:57:54+00:00\",\"dateModified\":\"2020-04-09T20:30:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"description\":\"In this tutorial we considered COOKIE and SQL injection with example\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/phpmysql\\\/cookie-and-sql-injection\\\/#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\":\"Cookie and SQL injections\"}]},{\"@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":"Cookie and SQL injections - Kamil Abzalov's blog","description":"In this tutorial we considered COOKIE and SQL injection with example","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\/cookie-and-sql-injection\/","og_locale":"en_US","og_type":"article","og_title":"Cookie and SQL injections - Kamil Abzalov's blog","og_description":"In this tutorial we considered COOKIE and SQL injection with example","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/","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-16T21:57:54+00:00","article_modified_time":"2020-04-09T20:30:12+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_title":"Cookie and SQL injections","twitter_description":"In this tutorial we considered COOKIE and SQL injection with example","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Cookie and SQL injections","datePublished":"2017-08-16T21:57:54+00:00","dateModified":"2020-04-09T20:30:12+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/"},"wordCount":881,"commentCount":0,"keywords":["mysql","php"],"articleSection":["PHP","PHP+MySQL","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/","name":"Cookie and SQL injections - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-16T21:57:54+00:00","dateModified":"2020-04-09T20:30:12+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"description":"In this tutorial we considered COOKIE and SQL injection with example","breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/phpmysql\/cookie-and-sql-injection\/#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":"Cookie and SQL injections"}]},{"@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\/3567","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=3567"}],"version-history":[{"count":7,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3567\/revisions"}],"predecessor-version":[{"id":31914,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3567\/revisions\/31914"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}