{"id":2689,"date":"2026-01-02T10:39:16","date_gmt":"2026-01-02T02:39:16","guid":{"rendered":"https:\/\/www.explore.name\/wordpress\/?p=2689"},"modified":"2026-01-02T10:39:16","modified_gmt":"2026-01-02T02:39:16","slug":"mysql%e6%9f%a5%e8%af%a2%e6%95%b0%e6%8d%ae%ef%bc%8c%e7%ac%ac%e4%ba%8c%e4%b8%aarow%e6%b2%a1%e6%9c%89%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/www.explore.name\/wordpress\/index.php\/2026\/01\/02\/mysql%e6%9f%a5%e8%af%a2%e6%95%b0%e6%8d%ae%ef%bc%8c%e7%ac%ac%e4%ba%8c%e4%b8%aarow%e6%b2%a1%e6%9c%89%e6%95%b0%e6%8d%ae\/","title":{"rendered":"mysql\u67e5\u8be2\u6570\u636e\uff0c\u7b2c\u4e8c\u4e2arow\u6ca1\u6709\u6570\u636e"},"content":{"rendered":"

\u4f60\u60f3\u77e5\u9053\u4e3a\u4ec0\u4e48\u4ee3\u7801\u4e2d\u7b2c\u4e8c\u4e2arow<\/code>\u6ca1\u6709\u6570\u636e\uff0c\u6838\u5fc3\u539f\u56e0\u662fMySQLi \u7ed3\u679c\u96c6\u7684\u6307\u9488\u5df2\u7ecf\u904d\u5386\u5230\u672b\u5c3e\uff0c\u65e0\u6cd5\u518d\u6b21\u8bfb\u53d6\u6570\u636e<\/strong><\/p>\n

\uff0c\u5177\u4f53\u5206\u6790\u548c\u89e3\u51b3\u65b9\u6848\u5982\u4e0b\uff1a<\/div>\n

\u4e00\u3001\u6838\u5fc3\u539f\u56e0\uff1a\u7ed3\u679c\u96c6\u6307\u9488\u5df2\u8017\u5c3d\uff08\u4e00\u6b21\u6027\u904d\u5386\u7279\u6027\uff09<\/h3>\n
    \n
  1. \n
    \u7ed3\u679c\u96c6\u6307\u9488\u7684\u5de5\u4f5c\u673a\u5236<\/strong>\uff1a$stmt->get_result(<\/code>\u00a0\u83b7\u53d6\u7684\u00a0$result<\/code>\u00a0\u662f\u4e00\u4e2a\u5355\u5411\u79fb\u52a8\u7684\u7ed3\u679c\u96c6<\/strong>\uff0c\u5b83\u5185\u90e8\u6709\u4e00\u4e2a \u201c\u6307\u9488\u201d\uff0c\u7528\u4e8e\u6307\u5411\u5f53\u524d\u8981\u8bfb\u53d6\u7684\u6570\u636e\u884c\u3002\u5f53\u4f60\u6267\u884c\u00a0while $row = mysqli_fetch_assoc($result))<\/code>\u00a0\u65f6\uff0c\u5faa\u73af\u4f1a\u4e0d\u65ad\u8c03\u7528\u00a0mysqli_fetch_assoc(<\/code>\u00a0\u65b9\u6cd5\uff1a<\/div>\n
      \n
    • \u6bcf\u6b21\u8c03\u7528\u4f1a\u8bfb\u53d6\u5f53\u524d\u6307\u9488\u6307\u5411\u7684\u884c\u6570\u636e\uff0c\u5e76\u5c06\u6307\u9488\u5411\u540e\u79fb\u52a8\u4e00\u4f4d<\/strong>\uff1b<\/li>\n
    • \u5f53\u6307\u9488\u79fb\u52a8\u5230\u7ed3\u679c\u96c6\u672b\u5c3e<\/strong>\uff08\u6ca1\u6709\u66f4\u591a\u6570\u636e\u884c\uff09\u65f6\uff0cmysqli_fetch_assoc()<\/code>\u00a0\u4f1a\u8fd4\u56de\u00a0false<\/code>\uff0c\u5faa\u73af\u7ec8\u6b62\u3002\n
      <\/div>\n

      \u6b64\u65f6\uff0c\u7ed3\u679c\u96c6\u6307\u9488\u5df2\u7ecf\u505c\u7559\u5728\u672b\u5c3e\uff0c\u65e0\u6cd5\u518d\u5411\u524d\u79fb\u52a8\uff0c\u8fd9\u5c31\u662f MySQLi \u7ed3\u679c\u96c6\u7684\u4e00\u6b21\u6027\u904d\u5386\u7279\u6027<\/strong>\uff08\u9ed8\u8ba4\u4e0d\u53ef\u91cd\u590d\u8bfb\u53d6\uff09\u3002<\/li>\n<\/ul>\n<\/li>\n

    • \n
      \u4f60\u7684\u4ee3\u7801\u6267\u884c\u6d41\u7a0b\u5bfc\u81f4\u6307\u9488\u8017\u5c3d<\/strong>\uff1a<\/div>\n
        \n
      • \u7b2c\u4e00\u6b65\uff1a\u7b2c\u4e00\u4e2a\u00a0while ($row = mysqli_fetch_assoc($result<\/code>\u00a0\u5faa\u73af\u5df2\u7ecf\u5b8c\u6574\u904d\u5386\u4e86\u6240\u6709\u7ed3\u679c\u884c\uff0c\u6307\u9488\u79fb\u52a8\u5230\u672b\u5c3e\uff0c\u5faa\u73af\u7ed3\u675f\uff1b<\/li>\n
      • \u7b2c\u4e8c\u6b65\uff1a\u5f53\u4f60\u540e\u7eed\u5c1d\u8bd5\u518d\u6b21\u4f7f\u7528\u00a0while ($row = mysqli_fetch_assoc($result<\/code>\uff08else \u5206\u652f\u4e2d\uff09\uff0c\u6216\u8005\u76f4\u63a5\u6253\u5370\u00a0$row<\/code>\u00a0\u65f6\uff0c\u7531\u4e8e\u6307\u9488\u5df2\u7ecf\u5728\u672b\u5c3e\uff0cmysqli_fetch_assoc($result<\/code>\u00a0\u53ea\u80fd\u8fd4\u56de\u00a0false<\/code>\uff0c\u56e0\u6b64\u00a0$row<\/code>\u00a0\u6ca1\u6709\u6709\u6548\u6570\u636e\uff08\u8981\u4e48\u662f\u00a0false<\/code>\uff0c\u8981\u4e48\u662f\u6700\u540e\u4e00\u884c\u6570\u636e\u7684\u6b8b\u7559\uff0c\u4f46\u65e0\u6cd5\u8bfb\u53d6\u65b0\u6570\u636e\uff09\u3002<\/li>\n<\/ul>\n<\/li>\n
      • \n
        \u8865\u5145\uff1a\u5173\u4e8e$row<\/code>\u53d8\u91cf\u7684\u6b8b\u7559\u95ee\u9898<\/strong>\u4f60\u540e\u7eed\u6253\u5370\u7684\u00a0$row<\/code>\u00a0\u5e76\u975e \u201c\u65b0\u8bfb\u53d6\u7684\u6570\u636e\u201d\uff0c\u800c\u662f\u7b2c\u4e00\u4e2a\u5faa\u73af\u7ed3\u675f\u540e\u7684\u503c\uff1a<\/div>\n
          \n
        • \u5faa\u73af\u7ec8\u6b62\u65f6\uff0c$row = .....mysqli_fetch_assoc($result<\/code>\u00a0\u8d4b\u503c\u4e3a\u00a0false<\/code>\uff08\u56e0\u4e3a\u6307\u9488\u5230\u672b\u5c3e\uff09\uff1b<\/li>\n
        • \u82e5\u4f60\u7528\u00a0isset$row)<\/code>\u00a0\u5224\u65ad\uff0cfalse<\/code>\u00a0\u5728 PHP \u4e2d\u662f \u201c\u5df2\u8bbe\u7f6e\u201d \u72b6\u6001\uff0c\u56e0\u6b64\u4f1a\u6253\u5370\u00a0false<\/code>\uff08\u770b\u8d77\u6765\u6ca1\u6709\u6709\u6548\u6570\u636e\uff09\uff1b<\/li>\n
        • \u5373\u4f7f\u6709\u6b8b\u7559\uff0c\u4e5f\u53ea\u662f\u6700\u540e\u4e00\u884c\u6570\u636e\u7684\u526f\u672c\uff0c\u5e76\u975e\u91cd\u65b0\u8bfb\u53d6\u7684\u7ed3\u679c\uff0c\u4e14\u65e0\u6cd5\u83b7\u53d6\u5176\u4ed6\u884c\u6570\u636e\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

          \u65b9\u6cd5 3\uff1a\u4f7f\u7528\u00a0mysqli_fetch_all()<\/code>\u00a0\u4e00\u6b21\u6027\u83b7\u53d6\u6240\u6709\u884c\uff08\u7b80\u5316\u7248\u65b9\u6cd5 1\uff09<\/h4>\n
          PHP 5.3+ \u652f\u6301\u00a0mysqli_fetch_all($result, MYSQLI_ASSOC)<\/code>\u00a0\u65b9\u6cd5\uff0c\u53ef\u76f4\u63a5\u5c06\u7ed3\u679c\u96c6\u7684\u6240\u6709\u884c\u4e00\u6b21\u6027\u8bfb\u53d6\u4e3a\u5173\u8054\u6570\u7ec4\uff0c\u65e0\u9700\u624b\u52a8\u5faa\u73af\uff0c\u66f4\u7b80\u6d01\u3002<\/div>\n","protected":false},"excerpt":{"rendered":"

          \u4f60\u60f3\u77e5\u9053\u4e3a\u4ec0\u4e48\u4ee3\u7801\u4e2d\u7b2c\u4e8c\u4e2arow\u6ca1\u6709\u6570\u636e\uff0c\u6838\u5fc3\u539f\u56e0\u662fMySQLi \u7ed3\u679c\u96c6\u7684\u6307\u9488\u5df2\u7ecf\u904d\u5386\u5230\u672b\u5c3e\uff0c\u65e0\u6cd5\u518d\u6b21\u8bfb\u53d6\u6570\u636e \uff0c\u5177\u4f53\u5206\u6790\u548c\u89e3\u51b3\u65b9\u6848\u5982\u4e0b\uff1a \u4e00\u3001\u6838\u5fc3\u539f\u56e0\uff1a\u7ed3\u679c\u96c6\u6307\u9488\u5df2\u8017\u5c3d\uff08\u4e00\u6b21\u6027\u904d\u5386\u7279\u6027\uff09 \u7ed3\u679c\u96c6\u6307\u9488\u7684\u5de5\u4f5c\u673a\u5236\uff1a$stmt->get_result(\u00a0\u83b7\u53d6\u7684\u00a0$result\u00a0\u662f\u4e00\u4e2a\u5355\u5411\u79fb\u52a8\u7684\u7ed3\u679c\u96c6\uff0c\u5b83\u5185\u90e8\u6709\u4e00\u4e2a \u201c\u6307\u9488\u201d\uff0c\u7528\u4e8e\u6307\u5411\u5f53\u524d\u8981\u8bfb\u53d6\u7684\u6570\u636e\u884c\u3002\u5f53\u4f60\u6267\u884c\u00a0while $row = mysqli_fetch_assoc($result))\u00a0\u65f6\uff0c\u5faa\u73af\u4f1a\u4e0d\u65ad\u8c03\u7528\u00a0mysqli_fetch_assoc(\u00a0\u65b9\u6cd5\uff1a \u6bcf\u6b21\u8c03\u7528\u4f1a\u8bfb\u53d6\u5f53\u524d\u6307\u9488\u6307\u5411\u7684\u884c\u6570\u636e\uff0c\u5e76\u5c06\u6307\u9488\u5411\u540e\u79fb\u52a8\u4e00\u4f4d\uff1b \u5f53\u6307\u9488\u79fb\u52a8\u5230\u7ed3\u679c\u96c6\u672b\u5c3e\uff08\u6ca1\u6709\u66f4\u591a\u6570\u636e\u884c\uff09\u65f6\uff0cmysqli_fetch_assoc()\u00a0\u4f1a\u8fd4\u56de\u00a0false\uff0c\u5faa\u73af\u7ec8\u6b62\u3002 \u6b64\u65f6\uff0c\u7ed3\u679c\u96c6\u6307\u9488\u5df2\u7ecf\u505c\u7559\u5728\u672b\u5c3e\uff0c\u65e0\u6cd5\u518d\u5411\u524d\u79fb\u52a8\uff0c\u8fd9\u5c31\u662f MySQLi \u7ed3\u679c\u96c6\u7684\u4e00\u6b21\u6027\u904d\u5386\u7279\u6027\uff08\u9ed8\u8ba4\u4e0d\u53ef\u91cd\u590d\u8bfb\u53d6\uff09\u3002 \u4f60\u7684\u4ee3\u7801\u6267\u884c\u6d41\u7a0b\u5bfc\u81f4\u6307\u9488\u8017\u5c3d\uff1a \u7b2c\u4e00\u6b65\uff1a\u7b2c\u4e00\u4e2a\u00a0while ($row = mysqli_fetch_assoc($result\u00a0\u5faa\u73af\u5df2\u7ecf\u5b8c\u6574\u904d\u5386\u4e86\u6240\u6709\u7ed3\u679c\u884c\uff0c\u6307\u9488\u79fb\u52a8\u5230\u672b\u5c3e\uff0c\u5faa\u73af\u7ed3\u675f\uff1b \u7b2c\u4e8c\u6b65\uff1a\u5f53\u4f60\u540e\u7eed\u5c1d\u8bd5\u518d\u6b21\u4f7f\u7528\u00a0while ($row = mysqli_fetch_assoc($result\uff08else \u5206\u652f\u4e2d\uff09\uff0c\u6216\u8005\u76f4\u63a5\u6253\u5370\u00a0$row\u00a0\u65f6\uff0c\u7531\u4e8e\u6307\u9488\u5df2\u7ecf\u5728\u672b\u5c3e\uff0cmysqli_fetch_assoc($result\u00a0\u53ea\u80fd\u8fd4\u56de\u00a0false\uff0c\u56e0\u6b64\u00a0$row\u00a0\u6ca1\u6709\u6709\u6548\u6570\u636e\uff08\u8981\u4e48\u662f\u00a0false\uff0c\u8981\u4e48\u662f\u6700\u540e\u4e00\u884c\u6570\u636e\u7684\u6b8b\u7559\uff0c\u4f46\u65e0\u6cd5\u8bfb\u53d6\u65b0\u6570\u636e\uff09\u3002 \u8865\u5145\uff1a\u5173\u4e8e$row\u53d8\u91cf\u7684\u6b8b\u7559\u95ee\u9898\u4f60\u540e\u7eed\u6253\u5370\u7684\u00a0$row\u00a0\u5e76\u975e \u201c\u65b0\u8bfb\u53d6\u7684\u6570\u636e\u201d\uff0c\u800c\u662f\u7b2c\u4e00\u4e2a\u5faa\u73af\u7ed3\u675f\u540e\u7684\u503c\uff1a \u5faa\u73af\u7ec8\u6b62\u65f6\uff0c$row = …..mysqli_fetch_assoc($result\u00a0\u8d4b\u503c\u4e3a\u00a0false\uff08\u56e0\u4e3a\u6307\u9488\u5230\u672b\u5c3e\uff09\uff1b \u82e5\u4f60\u7528\u00a0isset$row)\u00a0\u5224\u65ad\uff0cfalse\u00a0\u5728 PHP \u4e2d\u662f \u201c\u5df2\u8bbe\u7f6e\u201d \u72b6\u6001\uff0c\u56e0\u6b64\u4f1a\u6253\u5370\u00a0false\uff08\u770b\u8d77\u6765\u6ca1\u6709\u6709\u6548\u6570\u636e\uff09\uff1b \u5373\u4f7f\u6709\u6b8b\u7559\uff0c\u4e5f\u53ea\u662f\u6700\u540e\u4e00\u884c\u6570\u636e\u7684\u526f\u672c\uff0c\u5e76\u975e\u91cd\u65b0\u8bfb\u53d6\u7684\u7ed3\u679c\uff0c\u4e14\u65e0\u6cd5\u83b7\u53d6\u5176\u4ed6\u884c\u6570\u636e\u3002 \u65b9\u6cd5 3\uff1a\u4f7f\u7528\u00a0mysqli_fetch_all()\u00a0\u4e00\u6b21\u6027\u83b7\u53d6\u6240\u6709\u884c\uff08\u7b80\u5316\u7248\u65b9\u6cd5 1\uff09 PHP 5.3+ \u652f\u6301\u00a0mysqli_fetch_all($result, MYSQLI_ASSOC)\u00a0\u65b9\u6cd5\uff0c\u53ef\u76f4\u63a5\u5c06\u7ed3\u679c\u96c6\u7684\u6240\u6709\u884c\u4e00\u6b21\u6027\u8bfb\u53d6\u4e3a\u5173\u8054\u6570\u7ec4\uff0c\u65e0\u9700\u624b\u52a8\u5faa\u73af\uff0c\u66f4\u7b80\u6d01\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-2689","post","type-post","status-publish","format-standard","hentry","category-28"],"_links":{"self":[{"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/2689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=2689"}],"version-history":[{"count":1,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/2689\/revisions"}],"predecessor-version":[{"id":2690,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/2689\/revisions\/2690"}],"wp:attachment":[{"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=2689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=2689"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.explore.name\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=2689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}