{"id":229998,"date":"2022-11-29T13:05:00","date_gmt":"2022-11-29T10:05:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=229998"},"modified":"2022-11-09T19:38:46","modified_gmt":"2022-11-09T16:38:46","slug":"anvaender-sprintf-och-like-i-sql-queries-i-wordpress","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/sv\/anvaender-sprintf-och-like-i-sql-queries-i-wordpress\/","title":{"rendered":"Anv\u00e4nder sprintf och LIKE i SQL Queries i WordPress"},"content":{"rendered":"

N\u00e4r du arbetar med fr\u00e5gor i WordPress \u00e4r det alltid b\u00e4st att f\u00f6rbereda<\/a> fr\u00e5gan innan du k\u00f6r den; men om du r\u00e5kar ha gr\u00e4nssnitt med ett tredjeparts-API eller arbetar med en annan variant av SQL (som Transact-SQL), kan saker och ting fungera lite annorlunda.<\/p>\n

Om bara databaser verkligen vore s\u00e5 snygga.<\/p>\n

TL ;DR<\/strong> f\u00f6r allt detta \u00e4r att hantering av sprintf<\/a> och LIKE i T-SQL<\/a><\/strong> kr\u00e4ver lite strategisk hantering. Och kodexemplet i n\u00e4sta avsnitt b\u00f6r ge allt du beh\u00f6ver.<\/p>\n

sprintf och LIKE i SQL<\/h2>\n

Lite bakgrund om problemet:<\/p>\n

S\u00e4g att du arbetar med ett projekt d\u00e4r du ringer till ett tredjeparts-API och n\u00e4mnda API anv\u00e4nder T-SQL f\u00f6r att gr\u00e4nssnittet med sin databas.<\/p>\n

L\u00e5t oss vidare s\u00e4ga att du vill h\u00e4mta poster som har ett segment av str\u00e4ngen som ska fr\u00e5gas (du vet, en LIKE-<\/strong> sats). Varningen \u00e4r att du inte kan anv\u00e4nda standardfunktionen f\u00f6r f\u00f6rberedelse<\/strong> som tillhandah\u00e5lls av WordPress s\u00e5 du v\u00e4ljer att anv\u00e4nda sprintf<\/strong> f\u00f6r att hj\u00e4lpa till att sanera den inkommande informationen.<\/p>\n

Eftersom sprintf<\/strong> anv\u00e4nder %s<\/code>f\u00f6r str\u00e4ngar och eftersom du anv\u00e4nder en LIKE-<\/strong> sats som ocks\u00e5 kr\u00e4ver %<\/code>, hur hanterar man fallet med att anv\u00e4nda b\u00e5da?<\/p>\n

H\u00e4r \u00e4r ett exempel<\/a><\/strong> p\u00e5 hur det kan fungera f\u00f6r dig:<\/p>\n

<?php\n\/**\n * Queries a third-party API using sprintf and a LIKE clause to retrieve the users \n * with a last name like the specified argument.\n * \n * @param string $lastName An unsanitized version of the user's last name.\n *\/\npublic function getUserByLastName(string $lastName)\n{\n    \/\/ Sanitize the argument as you see fit here.\n\n    $query = sprintf(\"\n        SELECT FIRST_NAME, LAST_NAME\n        FROM USERINFO\n        WHERE LAST_NAME LIKE '%%%s%%'\n    \", $lastName);\n\n    \/\/ Make a query to the third-party API here.\n}\n<\/code><\/pre>\n
Naturligtvis tror jag fortfarande att anv\u00e4nda n\u00e5gon typ av flykt p\u00e5 $name<\/code>argumentet men det finns ett antal olika s\u00e4tt att g\u00f6ra detta och det \u00e4r bortom po\u00e4ngen med det h\u00e4r inl\u00e4gget.<\/p>\n
Kort sagt, prefix och suffix till %s<\/code>med %%<\/code>och du borde vara bra att g\u00e5.<\/p>\n
Inspelningsk\u00e4lla:  tommcfarlin.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Att hantera sprintf och LIKE i T-SQL kr\u00e4ver lite strategisk hantering och det \u00e4r s\u00e5 h\u00e4r man g\u00f6r.<\/p>\n","protected":false},"author":1,"featured_media":163659,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[848,724,868],"tags":[1173],"class_list":["post-229998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-handledningar","category-utvecklaren","category-wordpress-9","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/229998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=229998"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/229998\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/163659"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=229998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=229998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=229998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}