{"id":1911,"date":"2010-05-19T23:07:20","date_gmt":"2010-05-19T20:07:20","guid":{"rendered":"http:\/\/www.blog.atbliss.ru\/?p=1911"},"modified":"2014-01-12T03:33:18","modified_gmt":"2014-01-12T01:33:18","slug":"protection-from-sql-injection","status":"publish","type":"post","link":"https:\/\/atbliss.ru\/protection-from-sql-injection\/","title":{"rendered":"\u0417\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL-\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0438"},"content":{"rendered":"<p>\u041f\u0440\u0435\u0436\u0434\u0435, \u0447\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441<\/p>\n<pre><code>$res = mysql_query(\"SELECT * FROM news WHERE id = '.$_GET['id'].'\");<\/code><\/pre>\n<p>\u043d\u0443\u0436\u043d\u043e \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 <strong><code>id<\/code><\/strong>. \u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f <strong><code>id<\/code><\/strong> \u0438\u043c\u0435\u0435\u0442 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u0439 \u0442\u0438\u043f \u0438 \u0434\u043e\u043b\u0436\u043d\u0430 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u043e\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435. \u0412 \u0442\u0430\u043a\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u044f <strong><code>intval<\/code>,<\/strong> \u043a\u043e\u0442\u043e\u0440\u0430\u044f\u00a0 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e \u043a \u0446\u0435\u043b\u043e\u043c\u0443 \u0442\u0438\u043f\u0443.<\/p>\n<pre><code>$_GET['id']   = intval($_GET['id']);<\/code><\/pre>\n<p>\u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043c\u044b \u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0432\u043d\u0435\u0434\u0440\u0435\u043d\u0438\u044f SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0436\u0434\u0435, \u0447\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441 $res = mysql_query(&#171;SELECT * FROM news WHERE id = &#8216;.$_GET[&#8216;id&#8217;].'&#187;); \u043d\u0443\u0436\u043d\u043e \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 id. \u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f id \u0438\u043c\u0435\u0435\u0442 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u0439 \u0442\u0438\u043f \u0438 \u0434\u043e\u043b\u0436\u043d\u0430 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u043e\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435. \u0412 \u0442\u0430\u043a\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u044f intval, \u043a\u043e\u0442\u043e\u0440\u0430\u044f\u00a0 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e \u043a \u0446\u0435\u043b\u043e\u043c\u0443 \u0442\u0438\u043f\u0443. $_GET[&#8216;id&#8217;] = intval($_GET[&#8216;id&#8217;]); \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043c\u044b \u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0432\u043d\u0435\u0434\u0440\u0435\u043d\u0438\u044f [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0417\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL-\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0438<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/atbliss.ru\/protection-from-sql-injection\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0417\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL-\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0438\" \/>\n<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0436\u0434\u0435, \u0447\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441 $res = mysql_query(&quot;SELECT * FROM news WHERE id = &#039;.$_GET[&#039;id&#039;].&#039;&quot;); \u043d\u0443\u0436\u043d\u043e \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 id. \u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f id \u0438\u043c\u0435\u0435\u0442 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u0439 \u0442\u0438\u043f \u0438 \u0434\u043e\u043b\u0436\u043d\u0430 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0446\u0435\u043b\u043e\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435. \u0412 \u0442\u0430\u043a\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u044f intval, \u043a\u043e\u0442\u043e\u0440\u0430\u044f\u00a0 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e \u043a \u0446\u0435\u043b\u043e\u043c\u0443 \u0442\u0438\u043f\u0443. $_GET[&#039;id&#039;] = intval($_GET[&#039;id&#039;]); \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043c\u044b \u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0432\u043d\u0435\u0434\u0440\u0435\u043d\u0438\u044f [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atbliss.ru\/protection-from-sql-injection\/\" \/>\n<meta property=\"og:site_name\" content=\"\u265b atbliss.ru\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-19T20:07:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-12T01:33:18+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@fortresseo\" \/>\n<meta name=\"twitter:site\" content=\"@fortresseo\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/atbliss.ru\/#website\",\"url\":\"https:\/\/atbliss.ru\/\",\"name\":\"\\u265b atbliss.ru\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/atbliss.ru\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#webpage\",\"url\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/\",\"name\":\"\\u0417\\u0430\\u0449\\u0438\\u0442\\u0430 \\u043e\\u0442 SQL-\\u0438\\u043d\\u044a\\u0435\\u043a\\u0446\\u0438\\u0438\",\"isPartOf\":{\"@id\":\"https:\/\/atbliss.ru\/#website\"},\"datePublished\":\"2010-05-19T20:07:20+00:00\",\"dateModified\":\"2014-01-12T01:33:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/atbliss.ru\/protection-from-sql-injection\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/\",\"url\":\"https:\/\/atbliss.ru\/\",\"name\":\"atbliss.ru\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/marketing\/\",\"url\":\"https:\/\/atbliss.ru\/marketing\/\",\"name\":\"\\u0418\\u043d\\u0442\\u0435\\u0440\\u043d\\u0435\\u0442-\\u043c\\u0430\\u0440\\u043a\\u0435\\u0442\\u0438\\u043d\\u0433\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/marketing\/seo\/\",\"url\":\"https:\/\/atbliss.ru\/marketing\/seo\/\",\"name\":\"SEO\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#webpage\"},\"author\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"headline\":\"\\u0417\\u0430\\u0449\\u0438\\u0442\\u0430 \\u043e\\u0442 SQL-\\u0438\\u043d\\u044a\\u0435\\u043a\\u0446\\u0438\\u0438\",\"datePublished\":\"2010-05-19T20:07:20+00:00\",\"dateModified\":\"2014-01-12T01:33:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#webpage\"},\"wordCount\":2,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"articleSection\":[\"SEO\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/atbliss.ru\/protection-from-sql-injection\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\",\"name\":\"atbliss.ru\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/atbliss.ru\/#personlogo\",\"inLanguage\":\"ru-RU\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61034ac273e6e5c82bf4c34dfe7a3318?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61034ac273e6e5c82bf4c34dfe7a3318?s=96&r=g\",\"caption\":\"atbliss.ru\"},\"logo\":{\"@id\":\"https:\/\/atbliss.ru\/#personlogo\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts\/1911"}],"collection":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/comments?post=1911"}],"version-history":[{"count":0,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts\/1911\/revisions"}],"wp:attachment":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/media?parent=1911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/categories?post=1911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/tags?post=1911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}