{"id":14,"date":"2015-01-17T00:06:37","date_gmt":"2015-01-16T16:06:37","guid":{"rendered":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/?p=14"},"modified":"2022-12-12T15:06:23","modified_gmt":"2022-12-12T07:06:23","slug":"%e6%9c%ac%e6%a0%a1%e7%8f%ad%e7%b4%9a%e7%b6%b2%e9%a0%81%e7%b3%bb%e7%b5%b1%e7%a7%bb%e6%a9%9f%e8%a8%98%e4%ba%8b","status":"publish","type":"post","link":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/archives\/14","title":{"rendered":"\u672c\u6821\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u79fb\u6a5f\u8a18\u4e8b"},"content":{"rendered":"

\u672c\u6821\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\uff1aweb.bhes.ntpc.edu.tw\/ClassSystem<\/p>\n

\u539f\u672c\u4ee5php3\u7a0b\u5f0f\u78bc\u5efa\u7f6e\u5728iChip nsp6 1.08 (\u6559\u80b2\u7248)\u4e0a\uff0cFreeBSD+Apache+MySQL 5.045\uff0cphp \u7684\u7de8\u78bc\u70babig5, MySQL\u4f3a\u670d\u5668\u9023\u7dda\u7de8\u78bc\u70balatin1\uff0c\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u7684MySQL\u8cc7\u6599\u5eab\u53ca\u8cc7\u6599\u8868\u7684\u7de8\u78bc\u70ba latin1\u3002<\/p>\n

\u56e0\u70baiChip\u7cfb\u7d71\u5b89\u5168\u6f0f\u6d1e\u592a\u591a\uff0c\u53c8\u7121\u6cd5\u4fee\u88dc\uff0c\u52a0\u4e0aphp \u53caMySQL \u7248\u672c\u592a\u820a\uff0c\u56e0\u800c\u6c7a\u5b9a\u5c07\u539f\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u79fb\u81f3 Windows Server 2012R2 + IIS 8 + PHP 5.6 + MySQL 5.6.22-log \uff0cphp \u7684\u7de8\u78bc\u70bautf8, MySQL\u4f3a\u670d\u5668\u9023\u7dda\u7de8\u78bc\u70babig5\uff0c\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u7684MySQL\u8cc7\u6599\u5eab\u53ca\u8cc7\u6599\u8868\u7684\u7de8\u78bc\u70ba latin1\u3002<\/p>\n

105\u5e741\u67081\u65e5\u958b\u59cb\u79fb\u8f49\u7a0b\u5f0f\uff0c\u6311\u6230\u958b\u59cb\u2026<\/p>\n

    \n
  1. \u7a0b\u5f0f\u78bc\u7adf\u7136\u5b8c\u5168\u4e0d\u80fd\u8dd1\uff0c\u6240\u6709\u7a0b\u5f0f\u78bc\u76f4\u63a5\u986f\u793a\u5728\u7db2\u9801\u4e0a\uff1a
    \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
    \n<? \u5168\u6539\u6210 <?php<\/li>\n
  2. \u7db2\u9801\u5448\u73fe\u51fa\u4f86\u7684\uff0c\u5168\u662futf8\u7de8\u78bc\uff0c\u5373\u4f7f\u7db2\u9801\u8a2d\u5b9a
    \n<meta http-equiv=\"Content-Type\" content=\"text\/html; charset=big5″>
    \n\u4f9d\u7136\u4ee5utf8\u7de8\u78bc\u5448\u73fe\uff1a
    \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
    \n<?php header(“Content-Type:text\/html; charset=big5″); ?><\/li>\n
  3. \u7db2\u9801\u7d42\u65bc\u6b63\u5e38\u7de8\u78bc\u70babig5\uff0c\u4f46\u6240\u6709\u5f9eMySQL\u8cc7\u6599\u5eab\u4e2d\u8b80\u51fa\u4f86\u7684\u8cc7\u6599\u4ecd\u4ee5\u4e82\u78bc\u986f\u793a\u3002
    \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
    \n<?php
    \n$LINK = mysql_connect($DATABASE_URL, $DATABASE_USER, $DATABASE_PASSWORD);
    \nmysql_query(“SET NAMES ‘latin1′\", $LINK);
    \nmysql_select_db($DATABASE_BASE, $LINK);
    \n?><\/li>\n
  4. \u6240\u6709get \u6216 post \u7684\u53c3\u6578\u90fd\u7121\u6cd5\u6b63\u5e38\u904b\u4f5c\u3002
    \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
    \n<?php
    \n$teacher_id = $_GET[“teacher_id\"];
    \n$teacher_name = $_POST[“teacher_name\"];
    \n?><\/li>\n
  5. \u90e8\u4efd\u5f9e\u8cc7\u6599\u5eab\u8b80\u51fa\u4f86\u7684\u8cc7\u6599\u4ecd\u7121\u6cd5\u986f\u793a
    \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
    \n<?php =$teacher_id ?>
    \n\u6539\u6210
    \n<?php echo($teacher_id); ?> \u6216\u00a0<?php echo $teacher_id ?><\/li>\n<\/ol>\n

    <?php
    \n$document_title = htmlspecialchars($document_title);
    \n?>
    \n\u8a3b\u89e3\u6389\uff0c\u6539\u6210
    \n<?php
    \n\/\/$document_title = htmlspecialchars($document_title);
    \n?><\/p>\n

      \n
    1. \u90e8\u4efd\u7db2\u9801\u4e2d\u6587\u5b57\u5982\u300c\u8a31\u3001\u529f\u3001\u84cb\u3001\u6703\u2026\u300d\u5b58\u5165\u8cc7\u6599\u5eab\u5f8c\u6703\u8b8a\u6210\u4e82\u78bc
      \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
      \n<?php
      \n$document_content = AddSlashes($document_content);
      \n?><\/li>\n
    2. \u7db2\u7ad9\u52a0\u88dd phpMyAdmin \u7121\u6cd5\u6b63\u5e38\u57f7\u884c
      \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
      \n\u770b\u5b98\u65b9\u7db2\u7ad9\u8aaa\u660e\uff0c\u76ee\u524d\u6700\u65b0\u7248\u7684 phpMyAdmin \u53ea\u652f\u63f4\u5230 php 5.3 \u7248
      \n\u8a2d\u5b9a phpMyAdmin \u70ba\u61c9\u7528\u7a0b\u5f0f\uff0cphp \u6539\u7528 php 5.3 \u7248<\/li>\n
    3. \u7559\u8a00\u7248\u7684ip\u6b04\u4f4d\u53ea\u652f\u63f4IPv4\uff0c\u5b58\u5165 IPv6 \u4f4d\u5740\u6642\u6703\u767c\u751f\u932f\u8aa4
      \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
      \n\u5c07 ip \u6b04\u4f4d\u7684\u9577\u5ea6\u6539\u70ba 40<\/li>\n
    4. \u7559\u8a00\u7248\u529f\u80fd\uff0c\u5373\u4f7f\u7ba1\u7406\u8005\u5c07\u5176\u95dc\u9589\uff0c\u4ecd\u80fd\u900f\u904e\u7db2\u5740\u4f7f\u7528\u8a72\u529f\u80fd\u3002\u5176\u5be6\u6240\u6709\u7684\u529f\u80fd\u90fd\u6709\u9019\u500b\u554f\u984c\uff0c\u4f46\u56e0\u672c\u6821\u7559\u8a00\u7248\u66fe\u88ab\u4e0d\u7576\u4f7f\u7528\u6210\u63f4\u4ea4\u7559\u8a00\u7db2\u7ad9\uff0c\u906d\u8b66\u5bdf\u5c40\u4f86\u6587\u8abf\u67e5\uff0c\u56e0\u800c\u767c\u73fe\u6b64\u554f\u984c\u3002
      \n\u24ea \u89e3\u6c7a\u6cd5\uff1a
      \n\u589e\u52a0\u5224\u65b7\u7ba1\u7406\u8005\u662f\u5426\u5df2\u958b\u555f\u8a72\u529f\u80fd<\/li>\n
    5. \u5168\u7db2\u7ad9\u6bcf\u4e00\u500b\u7db2\u9801\u6aa2\u67e5\uff0c\u4fee\u6b63\u539f\u7a0b\u5f0f\u78bc\u7684\u932f\u8aa4\u3002<\/li>\n
    6. 105\u5e741\u67085\u65e5\u4e0a\u73ed\uff0c\u6b63\u5f0f\u4e0a\u7dda<\/li>\n
    7. phpMyAdmin \u6700\u65b0\u7248 4.3.5\u7248\u91cb\u51fa\uff0c\u4e0b\u8f09\uff0c\u91cd\u5b89\u88dd\uff0c\u5df2\u53ef\u4ee5\u6b63\u5e38\u5728php 5.6\u4e0b\u57f7\u884c<\/li>\n<\/ol>\n

      \u54c8\u54c8\uff01\u6211\u7684\u5047\u65e5\u5c31\u662f\u9019\u6a23\u904e\u7684<\/p>\n

      \u88dc\u5145\uff1a\u79fb\u81f3 Windows Server 2012R2 \u5f8c\uff0c\u539f\u672c\u4e2d\u6587\u8def\u5f91\u7684\u7db2\u9801\u4e0d\u80fd\u986f\u793a\u7684\u554f\u984c\uff0c\u5168\u90fd\u4e0d\u85e5\u800c\u7609\uff0c\u4e2d\u6587\u5b57\u986f\u793a\u4e0d\u5fc5\u505a\u4efb\u4f55\u8655\u7406\uff0c\u5c31\u53ef\u76f4\u63a5\u8f38\u51fa\u3002(\u8655\u7406\u53cd\u800c\u6703\u51fa\u554f\u984c)<\/p>\n","protected":false},"excerpt":{"rendered":"

      \u672c\u6821\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\uff1aweb.bhes.ntpc.edu.tw\/ClassSystem<\/p>\n

      \u539f\u672c\u4ee5php3\u7a0b\u5f0f\u78bc\u5efa\u7f6e\u5728iChip nsp6 1.08 (\u6559\u80b2\u7248)\u4e0a\uff0cFreeBSD+Apache+MySQL 5.045\uff0cphp \u7684\u7de8\u78bc\u70babig5, MySQL\u4f3a\u670d\u5668\u9023\u7dda\u7de8\u78bc\u70balatin1\uff0c\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u7684MySQL\u8cc7\u6599\u5eab\u53ca\u8cc7\u6599\u8868\u7684\u7de8\u78bc\u70ba latin1\u3002<\/p>\n

      \u56e0\u70baiChip\u7cfb\u7d71\u5b89\u5168\u6f0f\u6d1e\u592a\u591a\uff0c\u53c8\u7121\u6cd5\u4fee\u88dc\uff0c\u52a0\u4e0aphp \u53caMySQL \u7248\u672c\u592a\u820a\uff0c\u56e0\u800c\u6c7a\u5b9a\u5c07\u539f\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u79fb\u81f3 Windows Server 2012R2 + IIS 8 + PHP 5.6 + MySQL 5.6.22-log \uff0cphp \u7684\u7de8\u78bc\u70bautf8, MySQL\u4f3a\u670d\u5668\u9023\u7dda\u7de8\u78bc\u70babig5\uff0c\u73ed\u7d1a\u7db2\u9801\u7cfb\u7d71\u7684MySQL\u8cc7\u6599\u5eab\u53ca\u8cc7\u6599\u8868\u7684\u7de8\u78bc\u70ba latin1\u3002<\/p>\n

      105\u5e741\u67081\u65e5\u958b\u59cb\u79fb\u8f49\u7a0b\u5f0f\uff0c\u6311\u6230\u958b\u59cb\u2026<\/p>\n

      \u7a0b\u5f0f\u78bc\u7adf\u7136\u5b8c\u5168\u4e0d\u80fd\u8dd1\uff0c\u6240\u6709\u7a0b\u5f0f\u78bc\u76f4\u63a5\u986f\u793a\u5728\u7db2\u9801\u4e0a\uff1a \u24ea \u89e3\u6c7a\u6cd5\uff1a <? \u5168\u6539\u6210 <?php \u7db2\u9801\u5448\u73fe\u51fa\u4f86\u7684\uff0c\u5168\u662futf8\u7de8\u78bc\uff0c\u5373\u4f7f\u7db2\u9801\u8a2d\u5b9a <meta http-equiv=\"Content-Type\" content=\"text\/html; charset=big5″> \u4f9d\u7136\u4ee5utf8\u7de8\u78bc\u5448\u73fe\uff1a \u24ea \u89e3\u6c7a\u6cd5\uff1a <?php header(“Content-Type:text\/html; charset=big5″); ?> \u7db2\u9801\u7d42\u65bc\u6b63\u5e38\u7de8\u78bc\u70babig5\uff0c\u4f46\u6240\u6709\u5f9eMySQL\u8cc7\u6599\u5eab\u4e2d\u8b80\u51fa\u4f86\u7684\u8cc7\u6599\u4ecd\u4ee5\u4e82\u78bc\u986f\u793a\u3002 \u24ea \u89e3\u6c7a\u6cd5\uff1a <?php $LINK = mysql_connect($DATABASE_URL, $DATABASE_USER, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/posts\/14"}],"collection":[{"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":0,"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/webnas.bhes.ntpc.edu.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}