{"id":1142,"date":"2016-04-03T10:26:50","date_gmt":"2016-04-03T02:26:50","guid":{"rendered":"http:\/\/ufqi.com\/blog\/?p=1142"},"modified":"2016-04-03T10:41:33","modified_gmt":"2016-04-03T02:41:33","slug":"gwa2-core-updates-orphan-var","status":"publish","type":"post","link":"https:\/\/ufqi.com\/blog\/gwa2-core-updates-orphan-var\/","title":{"rendered":"-GWA2 core updates: \u5bb9\u9519\u5904\u7406,\u5b64\u513f\u5360\u4f4d\u7b26"},"content":{"rendered":"

-GWA2 \u7684\u6838\u5fc3\u5347\u7ea7\u4e86\u4e00\u5904\u5bb9\u9519\u5904\u7406\uff0c\u95ee\u9898\u63cf\u8ff0<\/strong>\u4e3a\uff1a<\/p>\n

\u5982\u679c\u67d0\u4e2aWebApp\u7684\u5b9e\u4f8b$obj, \u5728\u8fdb\u884cSQL\u7ec4\u88c5\u65f6\uff0c\u5982\u679c$obj->set \u7684\u53d8\u91cf\u6570\u636e\u4e0eSQL\u4e2d\u7684\u5360\u4f4d\u7b26(?)\u4e0d\u4e00\u81f4\u65f6\uff0c\u7279\u522b\u662f\u5360\u4f4d\u7b26(?)\u6240\u6307\u4ee3\u7684\u53d8\u91cf\u540d\u672a\u51fa\u73b0\u65f6\uff0c\u5728SQL\u62fc\u88c5\u65f6\uff0c\u5bb9\u6613\u4ea7\u751f\u5c06idxArr[0]\u7684\u503c\u8d4b\u4e88\u7ed9\u8fd9\u4e2a\u7f3a\u5931\u7684\u53d8\u91cf\u503c\u3002\u8fd9\u6837\u5c31\u5bfc\u81f4\u5360\u4f4d\u7b26\u5e8f\u5217\u548c\u53d8\u91cf\u5e8f\u5217\u9519\u4f4d\u73b0\u8c61\uff0c\u4ece\u800c\u53ef\u80fd\u5230SQL\u5728\u5199\u5165\u65f6\u7684\u9519\u8bef\u3002\u8fd9\u79cd\u9519\u8bef\u53ef\u79f0\u4e4b\u4e3a\u201c\u5b64\u513f\u5360\u4f4d\u7b26\u201d\u3002<\/p>\n

\u95ee\u9898\u7684\u539f\u56e0<\/strong>\u662f\uff0c\u8c03\u7528\u8005\u5728\u4f7f\u7528$obj->set\u65f6\uff0c\u5728SQL\u4e2d\u5199\u5165\u4e86\u67d0\u4e2a\u5360\u4f4d\u7b26\uff0c\u4f46\u5e76\u672a\u5728$obj-hmf\u4e2d\u7ed9\u5b9a\u76f8\u5e94\u7684\u503c\u3002\u4e00\u4e2a\u9519\u8bef\u7684\u8c03\u7528\u5982\uff1a
\n$obj->set(‘b’, $aVal);
\n$obj->set(‘c’, $bVal);
\n$result = $obj->setBy(‘a, b, c’, null);
\n\u6b64\u65f6\u7684a\uff0c\u6ca1\u6709\u901a\u8fc7$obj->set\u8d4b\u503c\uff0c\u4f1a\u5728\u540e\u7eed\u62fc\u88c5SQL\u65f6\u51fa\u9519\u3002<\/p>\n

\u89e3\u51b3\u7684\u529e\u6cd5<\/strong>\u662f\uff0c\u5728\u62fc\u88c5\u5339\u914d\u5360\u4f4d\u7b26\u548c\u53d8\u91cf\u65f6\uff0c\u505a\u53d8\u91cf\u540d\u548c\u53d8\u91cf\u503c\u7684\u68c0\u67e5\u3002\u6d89\u53ca\u5230\u7684\u4ee3\u7801\u5728 inc\/mysql.class , \u5982\u4e0b:<\/p>\n

if(strpos($t, $idxarr[$i]) === false){
\n# in case that, field was not set by $obj->set but written in sql with ‘?’, Sat Apr 2 23:54:48 CST 2016
\ndebug(__FILE__.”: found unmatched field:[$t].”);
\n$sql = substr($sql,$a+1);
\n$a = strpos($sql,”?”);
\n$newsql .= str_replace(“?”, ‘\\’\\”, $t);
\n}
\nelse{
\n$sql = substr($sql,$a+1);
\n$a = strpos($sql,”?”);
\n$newsql .= str_replace(“?”,$this->_QuoteSafe($hmvars[$idxarr[$i]]),$t);
\n$i++;
\n}<\/p>\n

\u540c\u65f6\u4e5f\u5c06\u4fee\u6539\u540c\u6b65\u5230\u57fa\u4e8e -GWA2 \u7684 -gMIS<\/a> \u4e2d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

-GWA2 \u7684\u6838\u5fc3\u5347\u7ea7\u4e86\u4e00\u5904\u5bb9\u9519\u5904\u7406\uff0c\u95ee\u9898\u63cf\u8ff0\u4e3a\uff1a \u5982\u679c\u67d0\u4e2aWebApp\u7684\u5b9e\u4f8b$ … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[42,6,2],"tags":[86,108,110,109],"_links":{"self":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1142"}],"collection":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/comments?post=1142"}],"version-history":[{"count":5,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1142\/revisions"}],"predecessor-version":[{"id":1146,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1142\/revisions\/1146"}],"wp:attachment":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/media?parent=1142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/categories?post=1142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/tags?post=1142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}