{"id":103,"date":"2010-05-20T19:54:34","date_gmt":"2010-05-20T19:54:34","guid":{"rendered":"6974ce5ac660610b44d9b9fed0ff9548"},"modified":"2010-05-20T19:54:34","modified_gmt":"2010-05-20T19:54:34","slug":"","status":"publish","type":"post","link":"https:\/\/www.xiaobo.li\/notes\/archives\/103","title":{"rendered":"php \u5e38\u7528\u65b9\u6cd5"},"content":{"rendered":"

============ \u83b7\u53d6\u6587\u4ef6\u540d\uff0c\u6587\u4ef6\u6269\u5c55\u540d\u4ee5\u53ca\u6240\u5728\u76ee\u5f55\u7684\u65b9\u6cd5<\/p>\n

<?php
$path_parts = pathinfo($_SERVER['PHP_SELF']);    \/\/$_SERVER['PHP_SELF']\u662f\u76f8\u5bf9\u4e8e\u6839\u76ee\u5f55\u800c\u8a00\u7684\u8def\u5f84\u3002
echo $path_parts["dirname"] ;    \/\/\u6587\u4ef6\u6240\u5728\u76ee\u5f55
echo $path_parts["basename"] ;    \/\/\u6587\u4ef6\u540d(\u5168\u540d\uff0c\u5305\u62ec\u6269\u5c55\u540d)
echo $path_parts["extension"] ;    \/\/\u6587\u4ef6\u6269\u5c55\u540d
?><\/p>\n

 <\/p>\n

 <\/p>\n

==============php\u65f6\u95f4<\/p>\n

php5.*\u540e\u7684\u65f6\u533a\u95ee\u9898date_default_timezone_set ('Asia\/Shanghai');<\/div>\n

 <\/p>\n\n\n\n
\n
\n

\u95ee\u9898:<\/p>\n

php\u51fd\u6570date("Y-n-d   H-i-s");   \u8f93\u51fa\u7684\u65f6\u95f4\u4e0e\u5f53\u5730\u65f6\u95f4\u76f8\u5dee8\u4e2a\u5c0f\u65f6.<\/p>\n

\u89e3\u51b3\u601d\u8def<\/p>\n

\u5317\u4eac\u65f6\u95f4\u662f\u4e1c8\u533a,\u53ef\u80fd\u662f\u65f6\u533a\u95ee\u9898.\u4f46\u662f\u6b64\u524d\u90fd\u6ca1\u95ee\u9898\u554a,\u7ecf\u8fc7google\u53d1\u73b0\u539f\u6765\u4ecephp5.1.0\u5f00\u59cb\uff0cphp.ini\u91cc\u52a0\u5165\u4e86date.timezone\u8fd9\u4e2a\u9009\u9879\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u662f\u5173\u95ed\u7684,\u4e5f\u5c31\u662f\u663e\u793a\u7684\u65f6\u95f4\uff08\u65e0\u8bba\u7528\u4ec0\u4e48php\u547d\u4ee4\uff09\u90fd\u662f\u683c\u6797\u5a01\u6cbb\u6807\u51c6\u65f6\u95f4,\u548c\u6211\u4eec\u7684\u65f6\u95f4\uff08\u5317\u4eac\u65f6\u95f4\uff09\u5dee\u4e86\u6b63\u597d8\u4e2a\u5c0f\u65f6\u3002<\/p>\n

1\u3001\u53ef\u4ee5date_default_timezone_set ('Etc\/GMT-8');<\/p>\n

\u7ea2\u8272\u6807\u8bb0\u90e8\u5206\u53ef\u4ee5\u6539\u4e3a"Etc\/GMT-8","PRC"\u8fd9\u4e24\u4e2a\u5728php\u5e2e\u52a9\u624b\u518c->\u9644\u5f55 H. \u6240\u652f\u6301\u65f6\u533a\u5217\u8868->\u5176\u5b83\u65f6\u533a\u5217\u8868\u91cc\u3002<\/p>\n

\u7ea2\u8272\u6807\u8bb0\u90e8\u5206\u4e5f\u53ef\u4ee5\u6539\u4e3a"Asia\/Shanghai","Asia\/Chongqing","Asia\/Urumqi"\u8fd9\u4e09\u4e2a\u5728php\u5e2e\u52a9\u624b\u518c->\u9644\u5f55 H. \u6240\u652f\u6301\u65f6\u533a\u5217\u8868->\u4e9a\u6d32\u65f6\u533a\u5217\u8868\u91cc<\/p>\n

\u6d4b\u8bd5<\/p>\n

date_default_timezone_set ('Asia\/Shanghai');
echo date_default_timezone_get ();
echo date("Y-n-d   H-i-s");  <\/p>\n

\u8f93\u51fa\u7ed3\u679c\uff1a2007-4-21 10-28-25\u6b63\u786e\u3002
2\u3001\u4e0a\u9762\u7684\u4fee\u6539\u662f\u901a\u8fc7\u811a\u672c\u4fee\u6539\uff0c\u4f18\u70b9\u5c31\u662f\u53ef\u79fb\u690d\u6027\u597d\uff0c\u7f3a\u70b9\u5c31\u662f\u6bcf\u4e2a\u811a\u672c\u90fd\u8981\u52a0\u3002\u6211\u4eec\u4e5f\u53ef\u4ee5\u901a\u8fc7\u4fee\u6539php.ini\u7684\u914d\u7f6e\u6765\u8fbe\u5230\u76ee\u7684\u3002\u6253\u5f00php.ini\u67e5\u627edate.timezone \u53bb\u6389\u524d\u9762\u7684\u5206\u53f7\uff0c\u7b49\u53f7\u540e\u9762\u586b\u4e0a\u4e0a\u9762\u7ea2\u8272\u6807\u8bb0\u7684\u5b57\u6bb5\u3002\u4fee\u6539\u7ed3\u679c\u662fdate.timezone ="Etc\/GMT-8"<\/p>\n

date_default_timezone_set ('Asia\/Shanghai');
echo date_default_timezone_get ();
echo date("Y-n-d   H:i:s");  <\/p>\n

\u8f93\u51fa\u7ed3\u679c\uff1a2007-10-21 10:30:35\u6b63\u786e\u3002<\/p>\n

 <\/p>\n

\u5173\u4e8eXXX<\/font>
\n\uff0c\u5927\u9646\u5185\u5730\u53ef\u7528\u7684\u503c\u662f\uff1aAsia\/Chongqing \uff0cAsia\/Shanghai \uff0cAsia\/Urumqi \uff0cPRC\uff08\u4f9d\u6b21\u4e3a\u91cd\u5e86\uff0c\u4e0a\u6d77\uff0c\u4e4c\u9c81\u6728\u9f50\uff0c\u4e2d\u534e\u4eba\u6c11\u5171\u548c\u56fd\uff09
\u6e2f\u53f0\u5730\u533a\u53ef\u7528\uff1aAsia\/Macao \uff0cAsia\/Hong_Kong \uff0cAsia\/Taipei \uff08\u4f9d\u6b21\u4e3a\u6fb3\u95e8\uff0c\u9999\u6e2f\uff0c\u53f0\u5317\uff09
\u8fd8\u6709\u65b0\u52a0\u5761\uff1aAsia\/Singapore
\u5176\u5b83\uff1aEtc\/GMT-8 \uff0cSingapore \uff0cHongkong<\/p>\n

 <\/p>\n

========\u65f6\u95f4\u683c\u5f0f\u7ecf<\/p>\n

PHP\u83b7\u53d6\u5f53\u524d\u65f6\u95f4\u683c\u5f0f\u5316\u65b9\u6cd5<\/p>\n

\u4f7f\u7528\u51fd\u5f0f date() \u5b9e\u73b0
<?php echo $showtime=date("Y-m-d H:i:s");?>
\u663e\u793a\u7684\u683c\u5f0f: \u5e74-\u6708-\u65e5 \u5c0f\u65f6:\u5206\u949f:\u5999
\u76f8\u5173\u65f6\u95f4\u53c2\u6570:
a - "am" \u6216\u662f "pm"
A - "AM" \u6216\u662f "PM"
d - \u51e0\u65e5\uff0c\u4e8c\u4f4d\u6570\u5b57\uff0c\u82e5\u4e0d\u8db3\u4e8c\u4f4d\u5219\u524d\u9762\u8865\u96f6; \u5982: "01" \u81f3 "31"
D - \u661f\u671f\u51e0\uff0c\u4e09\u4e2a\u82f1\u6587\u5b57\u6bcd; \u5982: "Fri"
F - \u6708\u4efd\uff0c\u82f1\u6587\u5168\u540d; \u5982: "January"
h - 12 \u5c0f\u65f6\u5236\u7684\u5c0f\u65f6; \u5982: "01" \u81f3 "12"
H - 24 \u5c0f\u65f6\u5236\u7684\u5c0f\u65f6; \u5982: "00" \u81f3 "23"
g - 12 \u5c0f\u65f6\u5236\u7684\u5c0f\u65f6\uff0c\u4e0d\u8db3\u4e8c\u4f4d\u4e0d\u8865\u96f6; \u5982: "1" \u81f3 12"
G - 24 \u5c0f\u65f6\u5236\u7684\u5c0f\u65f6\uff0c\u4e0d\u8db3\u4e8c\u4f4d\u4e0d\u8865\u96f6; \u5982: "0" \u81f3 "23"
i - \u5206\u949f; \u5982: "00" \u81f3 "59"
j - \u51e0\u65e5\uff0c\u4e8c\u4f4d\u6570\u5b57\uff0c\u82e5\u4e0d\u8db3\u4e8c\u4f4d\u4e0d\u8865\u96f6; \u5982: "1" \u81f3 "31"
l - \u661f\u671f\u51e0\uff0c\u82f1\u6587\u5168\u540d; \u5982: "Friday"
m - \u6708\u4efd\uff0c\u4e8c\u4f4d\u6570\u5b57\uff0c\u82e5\u4e0d\u8db3\u4e8c\u4f4d\u5219\u5728\u524d\u9762\u8865\u96f6; \u5982: "01" \u81f3 "12"
n - \u6708\u4efd\uff0c\u4e8c\u4f4d\u6570\u5b57\uff0c\u82e5\u4e0d\u8db3\u4e8c\u4f4d\u5219\u4e0d\u8865\u96f6; \u5982: "1" \u81f3 "12"
M - \u6708\u4efd\uff0c\u4e09\u4e2a\u82f1\u6587\u5b57\u6bcd; \u5982: "Jan"
s - \u79d2; \u5982: "00" \u81f3 "59"
S - \u5b57\u5c3e\u52a0\u82f1\u6587\u5e8f\u6570\uff0c\u4e8c\u4e2a\u82f1\u6587\u5b57\u6bcd; \u5982: "th"\uff0c"nd"
t - \u6307\u5b9a\u6708\u4efd\u7684\u5929\u6570; \u5982: "28" \u81f3 "31"
U - \u603b\u79d2\u6570
w - \u6570\u5b57\u578b\u7684\u661f\u671f\u51e0\uff0c\u5982: "0" (\u661f\u671f\u65e5) \u81f3 "6" (\u661f\u671f\u516d)
Y - \u5e74\uff0c\u56db\u4f4d\u6570\u5b57; \u5982: "1999"
y - \u5e74\uff0c\u4e8c\u4f4d\u6570\u5b57; \u5982: "99"
z - \u4e00\u5e74\u4e2d\u7684\u7b2c\u51e0\u5929; \u5982: "0" \u81f3 "365"<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

===================================<\/font>\n<\/p>\n

php\u5b9e\u73b0escape\u548cunescape<\/div>\n
2008-03-08 00:06<\/div>\n

 <\/p>\n\n\n\n
\n
    function <\/span>
\nescape<\/span>
\n(<\/span>
\n$str<\/span>
\n<\/font>
\n) {
        <\/span>
\npreg_match_all<\/span>
\n(<\/span>
\n"\/[\\x80-\\xff].|[\\x01-\\x7f]+\/"<\/span>
\n,<\/span>
\n$str<\/span>
\n,<\/span>
\n$r<\/span>
\n<\/font>
\n);
        <\/span>
\n$ar <\/span>
\n= <\/span>
\n$r<\/span>
\n[<\/span>
\n0<\/span>
\n<\/font>
\n];
         foreach(<\/span>
\n$ar <\/span>
\nas <\/span>
\n$k<\/span>
\n=><\/span>
\n$v<\/span>
\n<\/font>
\n) {
             if(<\/span>
\nord<\/span>
\n(<\/span>
\n$v<\/span>
\n[<\/span>
\n0<\/span>
\n]) < <\/span>
\n128<\/span>
\n<\/font>
\n) {
                <\/span>
\n$ar<\/span>
\n[<\/span>
\n$k<\/span>
\n] = <\/span>
\nrawurlencode<\/span>
\n(<\/span>
\n$v<\/span>
\n<\/font>
\n);
             } else {
                <\/span>
\n$ar<\/span>
\n[<\/span>
\n$k<\/span>
\n] = <\/span>
\n"%u"<\/span>
\n.<\/span>
\nbin2hex<\/span>
\n(<\/span>
\niconv<\/span>
\n(<\/span>
\n"GB2312"<\/span>
\n,<\/span>
\n"UCS-2"<\/span>
\n,<\/span>
\n$v<\/span>
\n<\/font>
\n));
             }
         }
         return <\/span>
\njoin<\/span>
\n(<\/span>
\n""<\/span>
\n,<\/span>
\n$ar<\/span>
\n<\/font>
\n);
     }<\/p>\n

     function <\/span>
\nunescape<\/span>
\n(<\/span>
\n$str<\/span>
\n<\/font>
\n) {
        <\/span>
\n$str <\/span>
\n= <\/span>
\nrawurldecode<\/span>
\n(<\/span>
\n$str<\/span>
\n<\/font>
\n);
        <\/span>
\npreg_match_all<\/span>
\n(<\/span>
\n"\/(?:%u.{4})|.+\/"<\/span>
\n,<\/span>
\n$str<\/span>
\n,<\/span>
\n$r<\/span>
\n<\/font>
\n);
        <\/span>
\n$ar <\/span>
\n= <\/span>
\n$r<\/span>
\n[<\/span>
\n0<\/span>
\n<\/font>
\n];
         foreach(<\/span>
\n$ar <\/span>
\nas <\/span>
\n$k<\/span>
\n=><\/span>
\n$v<\/span>
\n<\/font>
\n) {  
             if(<\/span>
\nsubstr<\/span>
\n(<\/span>
\n$v<\/span>
\n,<\/span>
\n0<\/span>
\n,<\/span>
\n2<\/span>
\n) == <\/span>
\n"%u" <\/span>
\n&& <\/span>
\nstrlen<\/span>
\n(<\/span>
\n$v<\/span>
\n) == <\/span>
\n6<\/span>
\n<\/font>
\n) {
                <\/span>
\n$ar<\/span>
\n[<\/span>
\n$k<\/span>
\n] = <\/span>
\niconv<\/span>
\n(<\/span>
\n"UCS-2"<\/span>
\n,<\/span>
\n"GB2312"<\/span>
\n,<\/span>
\npack<\/span>
\n(<\/span>
\n"H4"<\/span>
\n,<\/span>
\nsubstr<\/span>
\n(<\/span>
\n$v<\/span>
\n,-<\/span>
\n4<\/span>
\n<\/font>
\n)));
             }
         }
         return <\/span>
\njoin<\/span>
\n(<\/span>
\n""<\/span>
\n,<\/span>
\n$ar<\/span>
\n<\/font>
\n);
     }<\/span>
\n<\/font>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n

========SQLite \u65f6\u95f4\u5dee========================<\/font>\n<\/p>\n

WHERE julianday(date('now')) - julianday(date(arrival_date)) > 7<\/p>\n

\u770b\u6765\u5982\u679c\u60f3\u5f97\u5230\u4e00\u4e2a\u7b26\u5408\u672c\u673a\u533a\u57df\u8bbe\u7f6e\u7684\u5f53\u524d\u65f6\u95f4\uff0c\u5fc5\u987b\u7528date\u51fd\u6570\u6765\u8f6c\u6362\uff0c
\u4f46date\u53ea\u51fd\u6570\u53ea\u8fd4\u56de\u5f53\u524d\u65e5\u671f\uff0c\u800c\u6211\u9700\u8981\u7684\u662f\u8fd4\u56de\u5f53\u524d\u65e5\u671f\u53ca\u65f6\u95f4\uff0c\u6240\u4ee5\u8fd9\u91cc\u628a\u5b83\u6362\u6210datetime\u51fd\u6570\uff0c\u5373\uff1a
datetime(CURRENT_TIMESTAMP,'localtime')
 <\/p>\n

 <\/p>\n

==============================================
 <\/p>\n","protected":false},"excerpt":{"rendered":"

============ \u83b7\u53d6\u6587\u4ef6\u540d\uff0c\u6587\u4ef6\u6269\u5c55\u540d\u4ee5\u53ca\u6240\u5728\u76ee\u5f55\u7684\u65b9\u6cd5 <?p … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273],"tags":[27],"class_list":["post-103","post","type-post","status-publish","format-standard","hentry","category-article","tag-php"],"_links":{"self":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":0,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}