{"id":502,"date":"2017-02-11T22:52:36","date_gmt":"2017-02-11T14:52:36","guid":{"rendered":"http:\/\/www.rainweb.site\/?p=502"},"modified":"2023-08-07T20:57:29","modified_gmt":"2023-08-07T12:57:29","slug":"php-article49","status":"publish","type":"post","link":"http:\/\/rain1024.com\/index.php\/2017\/02\/11\/php-article49\/","title":{"rendered":"PHP+MySQL\u9879\u76ee\u5f00\u53d1\u7ec6\u8282\u603b\u7ed3"},"content":{"rendered":"

PHP+MySQL\u9879\u76ee\u5f00\u53d1\u7ec6\u8282\u603b\u7ed3<\/h2>\n
    \n
  1. \u5199\u51fa\u9879\u76ee\u6d41\u7a0b\uff0c\u8981\u54ea\u4e9b\u9875\u9762\uff0c\u5217\u51fa\u63d0\u7eb2<\/p>\n<\/li>\n
  2. \n

    \u521b\u5efa\u6570\u636e\u5e93<\/p>\n<\/li>\n

  3. \n

    \u521b\u5efa\u914d\u7f6e\u6587\u4ef6dbconfig.php<\/p>\n<\/li>\n

  4. \n

    \u521b\u5efa\u9875\u9762\uff0c\u6dfb\u52a0\u4fe1\u606f<\/p>\n<\/li>\n

  5. \n

    \u5728\u9700\u8981\u7684\u9875\u9762\u6267\u884c\u76f8\u5e94\u7684\u64cd\u4f5c\u5904\u7406\uff0c\u4e3b\u8981\u662f\u6dfb\u52a0\uff0c\u5220\u9664\uff0c\u4fee\u6539\u7b49\u4fe1\u606f\u64cd\u4f5c\u5904\u7406<\/p>\n<\/li>\n<\/ol>\n

    \u64cd\u4f5c\u6570\u636e\u5e93\u65f6<\/h3>\n
      \n
    1. \n

      \u5148\u5bfc\u5165\u6570\u636e\u5e93\u914d\u7f6e\u6587\u4ef6<\/p>\n<\/li>\n

    2. \n

      \u83b7\u53d6\u8981\u6267\u884c\u7684\u4fe1\u606f<\/p>\n<\/li>\n

    3. \n

      \u62fc\u63a5SQL\u8bed\u53e5\uff0c\u5e76\u6267\u884c\u64cd\u4f5c\u3002\u4e00\u822c\u662f\u7528switch\u8bed\u53e5\u5b9e\u73b0\uff0c\u6839\u636e\u4f20\u9012\u8fc7\u6765\u7684\u53d8\u91cf\u505a\u51fa\u5904\u7406\u3002<\/p>\n<\/li>\n

    4. \n

      \u5b8c\u6210\u64cd\u4f5c\u540e\u8fdb\u884c\u8df3\u8f6c\uff0c\u53ef\u4ee5\u8d85\u7ea7\u94fe\u63a5<\/a>\u6765\u5b9e\u73b0\uff0c\u4e5f\u53ef\u4ee5\u7528header(\"location:url\");<\/p>\n<\/li>\n

    5. \n

      \u5bf9\u4e8e\u4e00\u4e9b\u53ef\u80fd\u4f1a\u629b\u51fa\u5f02\u5e38\u7684\u4fe1\u606f\u7528@\u6765\u5c4f\u853d<\/p>\n<\/li>\n<\/ol>\n

      \u4f8b\u5982\uff1a<\/p>\n

      $sql=\"select * from news where order by addtime desc\";
      \n\u00a0\u00a0\u00a0 \/\/\u5c06\u6700\u65b0\u7684\u65b0\u95fb\u5148\u663e\u793a\u51fa\u6765
      \n\u00a0\u00a0\u00a0 $result=@mysql_query($sql,$conn);<\/p>\n

      \u5728php+mysql\u5f00\u53d1\u6709\u5173\u6570\u636e\u5e93\u7684\u9879\u76ee\u5e38\u7528\u7684\u8bed\u53e5\uff1a<\/h2>\n
        \n
      1. \u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u8fde\u63a5mysql\u670d\u52a1\u5668\uff0c\u9009\u62e9\u6570\u636e\u5e93\uff0c\u8bbe\u7f6e\u7f16\u7801<\/li>\n<\/ol>\n
        <?php\nheader(\"content-Type:text\/html;charset=utf-8\");\n\u00a0\u00a0\u00a0 \/\/\u8fde\u63a5\u6570\u636e\u5e93\u914d\u7f6e\uff0c\u4e3b\u673a\uff0c\u6570\u636e\u5e93\u7528\u6237\uff0c\u5bc6\u7801\n\u00a0\u00a0\u00a0 $conn=@mysql_connect(\"localhost\",\"root\",\"1234\")or die(\"error:\".mysql_error());\n\u00a0\u00a0\u00a0 mysql_select_db(\"newsdb\",$conn);\/\/\u6570\u636e\u5e93\u540d\u9009\u62e9\n\u00a0\u00a0\u00a0 mysql_query(\"set names utf8\");\/\/\u8bbe\u7f6e\u6570\u636e\u5e93\u7f16\u7801\n<\/code><\/pre>\n
          \n
        1. \u6dfb\u52a0\u64cd\u4f5c
          \n\u6839\u636e\u4e0a\u4e00\u6b21\u63d2\u5165\u7684\u6570\u636e\u7684id\u6765\u5224\u65ad\u4f7f\u7528\u51fd\u6570\uff1amysql_insert_id($conn)>0\u6765\u505a\u51fa\u5904\u7406\u3002<\/li>\n<\/ol>\n
          $sql=\"insert into news values(null,'{$title}','{$keywords}','{$author}','{$addtime}','{$content}')\";\n\u00a0\u00a0\u00a0 \/\/echo $sql;\n\u00a0\u00a0\u00a0 \/\/insert into news values(null,'\u5927\u5927','2','2','1367984131','4')\n\u00a0\u00a0\u00a0 \/\/3 \u5224\u65ad\u662f\u5426\u6210\u529f\n\u00a0\u00a0\u00a0 if(empty($content)){\n\u00a0\u00a0\u00a0 die(\"\u5185\u5bb9\u4e0d\u80fd\u4e3a\u7a7a\uff01\".\"<a href='add.php'>\u6dfb\u52a0\u65b0\u95fb\u4fe1\u606f<\/a>\");\n\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 mysql_query($sql,$conn);\n\u00a0\u00a0\u00a0 if(mysql_insert_id($conn)>0){\n\u00a0\u00a0\u00a0 echo \"\u6dfb\u52a0\u6210\u529f\uff01\";\n\u00a0\u00a0\u00a0 }else{echo \"\u6dfb\u52a0\u5931\u8d25!\".mysql_error();}\n\u00a0\u00a0\u00a0 echo \"<a href='javascript:window.history.back();'>\u8fd4\u56de<\/a>\";\/\/\u8fd4\u56de\n\u00a0\u00a0\u00a0 echo \"<br><a href='index.php'>\u6d4f\u89c8\u65b0\u95fb\u4fe1\u606f<\/a>\";\n<\/code><\/pre>\n
            \n
          1. \u5220\u9664\u4fe1\u606f
            \n\u901a\u8fc7\u5f71\u54cd\u7684\u884c\u6570mysql_affected_rows($conn)>0;\u6765\u5224\u65ad\u662f\u5426\u5220\u9664\u6210\u529f<\/li>\n<\/ol>\n
              $sd=$_GET['id'];\n\u00a0\u00a0\u00a0 $sql=\"delete from news where id={$sd}\";\n\u00a0\u00a0\u00a0 mysql_query($sql,$conn);\n\u00a0\u00a0\u00a0 if(mysql_affected_rows($conn)>0){\n\u00a0\u00a0\u00a0 echo \"\u5220\u9664\u6210\u529f\uff01\";\n\u00a0\u00a0\u00a0 }else{echo \"\u5220\u9664\u5931\u8d25\uff01\".mysql_error();}\n\u00a0\u00a0\u00a0 echo \"<br><a href='index.php'>\u6d4f\u89c8\u65b0\u95fb\u4fe1\u606f<\/a>\";\n<\/code><\/pre>\n
            4 \u66f4\u65b0\u4fe1\u606f\u64cd\u4f5c
            \n\u4e5f\u662f\u7528\u5f71\u54cd\u7684\u884c\u6570\u6765\u5224\u65ad<\/p>\n
            $id=$_POST['id'];\n\u00a0\u00a0\u00a0 $title=$_POST['title'];\n\u00a0\u00a0\u00a0 $keywords=$_POST['keywords'];\n\u00a0\u00a0\u00a0 $author=$_POST['author'];\n\u00a0\u00a0\u00a0 $content=$_POST['content'];\n\u00a0\u00a0\u00a0 $sql=\"update news set title='{$title}',keywords='{$keywords}',author='{$author}',content='{$content}' where id={$id}\";\n\u00a0\u00a0\u00a0 \/\/\u5224\u65ad\u662f\u5426\u6253\u901a\u7ebf\n\u00a0\u00a0\u00a0 \/\/echo $sql;\n\u00a0\u00a0\u00a0 mysql_query($sql,$conn);\n\u00a0\u00a0\u00a0 if(mysql_affected_rows($conn)>0){\n\u00a0\u00a0\u00a0 echo \"<script>alert('\u4fee\u6539\u6210\u529f\uff01');window.location='index.php';<\/script>\";\n\u00a0\u00a0\u00a0 }else{\n\u00a0\u00a0\u00a0 echo \"<script>alert('\u4fee\u6539\u5931\u8d25\uff01');history.go(-1);<\/script>\";\n\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 \/\/header(\"location:index.php\");\n<\/code><\/pre>\n
            \u65e0\u8bba\u662f\u589e\uff0c\u5220\uff0c\u6539\uff0c\u67e5\u7b49\u64cd\u4f5c\uff0c\u91cd\u5fc3\u662f\u7406\u6e05\u903b\u8f91\u601d\u8def\uff0c\u7136\u540e\u505a\u51fa\u54cd\u5e94\u7684\u64cd\u4f5c\u3002<\/h3>\n