{"id":509,"date":"2023-04-07T08:45:51","date_gmt":"2022-12-14T09:53:24","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/index.php\/2023\/11\/30\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/"},"modified":"2025-08-02T14:46:44","modified_gmt":"2025-08-02T06:46:44","slug":"%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/","title":{"rendered":"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd"},"content":{"rendered":"<p>Android\u7684\u767b\u5f55\u548c\u6ce8\u518c\u662f\u975e\u5e38\u5e38\u89c1\u7684\u573a\u666f\u3002\u5728\u6211\u4eec\u9700\u8981\u7528\u6237\u4fe1\u606f\u7684\u6240\u6709\u5e94\u7528\u7a0b\u5e8f\u4e2d\uff0c\u60a8\u5c06\u627e\u5230\u6ce8\u518c\u548c\u767b\u5f55\u64cd\u4f5c\u3002\u5728\u672c\u6559\u7a0b\u4e2d\uff0c\u6211\u4eec\u5c06\u5efa\u7acb\u4e00\u4e2a\u672c\u5730Web\u670d\u52a1\u5668\u548cMySQL\u6570\u636e\u5e93\u3002\u6211\u4eec\u5c06\u5f00\u53d1Android\u767b\u5f55\u548c\u6ce8\u518c\u5e94\u7528\u7a0b\u5e8f\u3002\u6211\u4eec\u5c06\u4f7f\u7528PHP\u811a\u672c\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\u3002<\/p>\n<h2>\u5b89\u5353\u767b\u5f55\u6ce8\u518c\u7b2c\u4e00\u6b65\u662f\u521b\u5efa\u540e\u7aef web \u670d\u52a1\u5668\u3002\u6211\u6b63\u5728\u4f7f\u7528 Mac OS X\uff0c\u53ef\u4ee5\u4f7f\u7528 XAMPP \u5feb\u901f\u8bbe\u7f6e\u672c\u5730 Apache web \u670d\u52a1\u5668\u548c MySQL \u6570\u636e\u5e93\u3002<\/p>\n<h3>\u5b89\u88c5 XAMPP \u670d\u52a1\u5668XAMPP\uff08\u6216WAMP\uff09\u662f\u4e00\u4e2a\u4e00\u952e\u5b89\u88c5\u8f6f\u4ef6\uff0c\u7528\u4e8e\u521b\u5efa\u5f00\u53d1PHP\u3001MySQL\u7f51\u9875\u5e94\u7528\u7a0b\u5e8f\u7684\u73af\u5883\uff08\u6211\u4eec\u5c06\u548c\u6211\u4eec\u7684\u5b89\u5353\u5e94\u7528\u7a0b\u5e8f\u8fde\u63a5\uff09\u3002\u4ece\u8fd9\u91cc\u4e0b\u8f7d\u5e76\u5b89\u88c5XAMPP\u3002\u5b89\u88c5\u5b8c\u6210\u540e\u542f\u52a8XAMPP\u5e94\u7528\uff0c\u5c06\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u754c\u9762\u3002\u901a\u8fc7\u6253\u5f00https:\/\/localhost\u6765\u6d4b\u8bd5\u4f60\u7684\u670d\u52a1\u5668\uff0c\u5e94\u8be5\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u754c\u9762\u3002\u540c\u65f6\uff0c\u4f60\u53ef\u4ee5\u901a\u8fc7\u6253\u5f00https:\/\/localhost\/phpmyadmin\u6765\u68c0\u67e5phpMyAdmin\u3002\u8ba9\u6211\u4eec\u770b\u4e00\u4e0b\u5b83\u663e\u793a\u4e86\u4ec0\u4e48\uff01\u54ce\u5440\uff01\u4f60\u53ef\u80fd\u4f1a\u5f97\u5230\u7c7b\u4f3c\u8fd9\u6837\u7684\u754c\u9762\u3002\u4f3c\u4e4eMySQL\u670d\u52a1\u5668\u6ca1\u6709\u6b63\u5e38\u8fd0\u884c\u3002\u5728XAMPP\u5e94\u7528\u4e2d\u8f6c\u5230\u201c\u7ba1\u7406\u670d\u52a1\u5668\u201d\u9009\u9879\u5361\uff0c\u7136\u540e\u70b9\u51fb\u201c\u91cd\u65b0\u542f\u52a8\u5168\u90e8\u201d\u3002\u670d\u52a1\u5668\u5e94\u8be5\u4f1a\u6b63\u5e38\u8fd0\u884c\uff0c\u5c31\u50cf\u4e0b\u9762\u7684\u56fe\u7247\u663e\u793a\u7684\u90a3\u6837\u3002\u73b0\u5728\u5728localhost\u4e0a\u6d4b\u8bd5phpMyAdmin\uff0c\u4f60\u4f1a\u770b\u5230\u7c7b\u4f3c\u8fd9\u6837\u7684\u754c\u9762\u3002\u73b0\u5728\u8ba9\u6211\u4eec\u6d4b\u8bd5\u4e00\u4e2a\u7b80\u5355\u7684php\u811a\u672c\u3002\u521b\u5efa\u4e00\u4e2a\u65b0\u7684test.php\u6587\u4ef6\uff0c\u7136\u540e\u5c06\u4ee5\u4e0b\u4ee3\u7801\u6dfb\u52a0\u8fdb\u53bb\u3002<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\necho \"Hello, World\";\r\n?&gt;\r\n<\/code><\/pre>\n<p>\u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff1a<\/p>\n<ul class=\"post-ul\">\n<li>?php starts opening tag for any PHP script.<\/li>\n<li>?&gt; means closing tag like closing bracket in Java.<\/li>\n<\/ul>\n<p>\u8bf7\u6ce8\u610f\uff1a\u5bf9\u4e8e\u672c\u6559\u7a0b\u6765\u8bf4\uff0c\u4e86\u89e3PHP\u5e76\u4e0d\u662f\u5fc5\u987b\u7684\u3002\u5982\u679c\u4f60\u4f7f\u7528\u7684\u662fMAC\u7535\u8111\uff0c\u90a3\u4e48\u524d\u5f80Applications-&gt;Xampp-&gt;htdocs\u3002\u5728\u8fd9\u91cc\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6\u5939\uff0c\u6bd4\u5982\u53eb\u505atest_android\uff0c\u5e76\u5c06\u4e4b\u524d\u521b\u5efa\u7684test.php\u590d\u5236\u7c98\u8d34\u5230\u8fd9\u4e2a\u6587\u4ef6\u5939\u4e2d\u3002\u73b0\u5728\u6253\u5f00URL\u94fe\u63a5https:\/\/localhost\/test_android\/test.php\uff0c\u4f60\u5c06\u4f1a\u770b\u5230\u4e00\u4e2a\u5982\u4e0b\u7684\u5c4f\u5e55\uff1a<\/p>\n<h3>\u5efa\u7acbMySQL\u6570\u636e\u5e93\u901a\u8fc7\u8bbf\u95eehttps:\/\/localhost\/phpmyadmin\u6253\u5f00phpMyAdmin\u3002\u73b0\u5728\u9009\u62e9\u9876\u90e8\u5de6\u4fa7\u7684\u6807\u9898\u884c\u4e2d\u7684 &#8220;\u6570\u636e\u5e93&#8221; \u9009\u9879\u5361\u3002\u7ed9\u5b83\u8d77\u4e00\u4e2a\u968f\u673a\u540d\u79f0\u5e76\u521b\u5efa\u3002\u65b0\u521b\u5efa\u7684\u7a7a\u6570\u636e\u5e93\u5c06\u4f1a\u5728\u5de6\u4fa7\u7684\u4fa7\u8fb9\u680f\u4e2d\u53ef\u89c1\u3002\u8ba9\u6211\u4eec\u5728\u65b0\u521b\u5efa\u7684\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2a &#8220;\u7528\u6237\u8868&#8221;\u3002\u5728\u63a7\u5236\u53f0\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u67e5\u8be2\u3002<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE  `firstDB`.`users` (\r\n    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\r\n    `username` VARCHAR( 20 ) NOT NULL ,\r\n    `password` VARCHAR( 20 ) NOT NULL\r\n)\r\n<\/code><\/pre>\n<p>\u5982\u679c\u6210\u529f\u521b\u5efa\u4e86\u8868\u683c\uff0c\u4f60\u6700\u7ec8\u4f1a\u770b\u5230\u4e00\u4e2a\u7c7b\u4f3c\u4e8e\u8fd9\u6837\u7684\u5c4f\u5e55\u3002<\/p>\n<h3>\u5c06PHP\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\u8981\u5c06\u4e00\u4e2aPHP\u811a\u672c\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\uff0c\u9700\u8981\u4e09\u4e2a\u8f93\u5165\u503c\u3002\u4ee5\u4e0b\u662f\u8fd9\u4e9b\u8f93\u5165\u503c\u53ca\u5176\u5728XAMPP\u670d\u52a1\u5668\u4e0a\u7684\u9ed8\u8ba4\u503c\u3002<\/p>\n<ul class=\"post-ul\">\n<li>Host name: localhost<\/li>\n<li>MySQL user name : root<\/li>\n<li>MySQL password : It is blank. \u201c\u201d<\/li>\n<\/ul>\n<p>\u8ba9\u6211\u4eec\u521b\u5efa\u4e00\u4e2atest-connect.php\u811a\u672c\uff0c\u5e76\u5c06\u5176\u6dfb\u52a0\u5230htdocs-&gt;test-android\u6587\u4ef6\u5939\u4e2d\u3002<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\n$host=\"localhost\";\r\n$user=\"root\";\r\n$password=\"\";\r\n$con=mysql_connect($host,$user,$password);\r\nif($con) {\r\n    echo '&lt;h1&gt;Connected to MySQL&lt;\/h1&gt;';\r\n} else {\r\n    echo '&lt;h1&gt;MySQL Server is not connected&lt;\/h1&gt;';\r\n}\r\n?&gt;\r\n<\/code><\/pre>\n<p>mysql_connect() \u662f PHP \u5185\u7f6e\u7684\u8fde\u63a5\u5230 MySQL \u6570\u636e\u5e93\u7684\u51fd\u6570\uff0c\u4f7f\u7528\u4e0a\u8ff0\u53c2\u6570\u3002\u5c1d\u8bd5\u8fd0\u884c https:\/\/localhost\/test_android\/test-connect.php \u5e76\u67e5\u770b\u8f93\u51fa\u7ed3\u679c\u3002\u5982\u679c\u8fde\u63a5\u5931\u8d25\uff0c\u8bf7\u5c1d\u8bd5\u91cd\u65b0\u542f\u52a8 XAMPP \u670d\u52a1\u5668\u3002<\/p>\n<h3>\u5b89\u5353\u767b\u5f55\u6ce8\u518c\u5e94\u7528\u7a0b\u5e8f<\/p>\n<p>\u8fd9\u662f\u300a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u767b\u5f55\u4e0e\u6ce8\u518c\u529f\u80fd\u300b\u7cfb\u5217\u6559\u7a0b\u7684\u7b2c2\u90e8\u5206\uff08\u51714\u90e8\u5206\uff09\u3002<\/p>\n<p>\u5185\u5bb9\u7247\u6bb5\uff1a\u5728\u4e0a\u4e00\u90e8\u5206\u4e2d\uff0c\u6211\u4eec\u5df2\u7ecf\u8ba8\u8bba\u4e86PHP\u548cMySQL\u7684\u57fa\u672c\u914d\u7f6e\u3002\u73b0\u5728\uff0c\u8ba9\u6211\u4eec\u5f00\u59cb\u6784\u5efaAndroid\u767b\u5f55\u5e94\u7528\u7a0b\u5e8f\u3002\u6211\u4eec\u5c06\u5f00\u53d1\u4e00\u4e2a\u5177\u6709\u767b\u5f55\u548c\u6ce8\u518c\u529f\u80fd\u7684\u5e94\u7528\u7a0b\u5e8f\u3002\u4e3a\u4e86\u786e\u4fdd\u7cfb\u7edf\u7684\u7b80\u6d01\u6027\u548c\u660e\u786e\u6027\uff0c\u6211\u4eec\u5c06\u5728\u6ce8\u518c\u8fc7\u7a0b\u4e2d\u9a8c\u8bc1\u7528\u6237\u540d\u548c\u7535\u5b50\u90ae\u4ef6\u7684\u552f\u4e00\u6027\u3002\u5728\u5f00\u59cb\u7f16\u5199\u5e94\u7528\u7a0b\u5e8f\u903b\u8f91\u4e4b\u524d\uff0c\u8ba9\u6211\u4eec\u5148\u51c6\u5907\u597dPHP\u811a\u672c\u548cMySQL\u6570\u636e\u5e93\u3002\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u5220\u9664\u73b0\u6709\u7684\u7528\u6237\u8868\uff0c\u7136\u540e\u4e3a\u6211\u4eec\u7684\u5e94\u7528\u7a0b\u5e8f\u521b\u5efa\u4e00\u4e2a\u5168\u65b0\u7684\u6570\u636e\u8868\u3002<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE IF NOT EXISTS `firstDB`.`users` (\r\n`id` int(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,\r\n`username` varchar(70) NOT NULL,\r\n`password` varchar(40) NOT NULL,\r\n`email` varchar(50) NOT NULL,\r\n`created_at` datetime NOT NULL,\r\n`updated_at` datetime DEFAULT NULL\r\n\r\n)\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u662f\u60a8\u53ef\u4ee5\u590d\u5236\u7c98\u8d34\u5230htdocs-&gt;test_android\u6587\u4ef6\u5939\u4e2d\u7684PHP\u811a\u672c\u3002config.php<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\n    define(\"DB_HOST\", \"localhost\");\r\n    define(\"DB_USER\", \"root\");\r\n    define(\"DB_PASSWORD\", \"\");\r\n    define(\"DB_NAME\", \"firstDB\");\r\n    ?&gt;\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u662f\u7528\u4e8e\u6570\u636e\u5e93\u8fde\u63a5\u7684\u811a\u672c\u3002db-connect.php<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\n    \r\n    include_once 'config.php';\r\n    \r\n    class DbConnect{\r\n        \r\n        private $connect;\r\n        \r\n        public function __construct(){\r\n            \r\n            $this-&gt;connect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);\r\n            \r\n            if (mysqli_connect_errno($this-&gt;connect)){\r\n                echo \"\u65e0\u6cd5\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\uff1a\" . mysqli_connect_error();\r\n            }\r\n        }\r\n        \r\n        public function getDb(){\r\n            return $this-&gt;connect;\r\n        }\r\n    }\r\n    ?&gt;\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u811a\u672c\u5305\u542b\u5e94\u7528\u7a0b\u5e8f\u7684\u6240\u6709\u6838\u5fc3\u529f\u80fd\u3002user.php<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\n    \r\n    include_once 'db-connect.php';\r\n    \r\n    class User{\r\n        \r\n        private $db;\r\n        \r\n        private $db_table = \"users\";\r\n        \r\n        public function __construct(){\r\n            $this-&gt;db = new DbConnect();\r\n        }\r\n        \r\n        public function isLoginExist($username, $password){\r\n            \r\n            $query = \"select * from \".$this-&gt;db_table.\" where username = '$username' AND password = '$password' Limit 1\";\r\n            \r\n            $result = mysqli_query($this-&gt;db-&gt;getDb(), $query);\r\n            \r\n            if(mysqli_num_rows($result) &gt; 0){\r\n                \r\n                mysqli_close($this-&gt;db-&gt;getDb());\r\n                \r\n                \r\n                return true;\r\n                \r\n            }\r\n            \r\n            mysqli_close($this-&gt;db-&gt;getDb());\r\n            \r\n            return false;\r\n            \r\n        }\r\n        \r\n        public function isEmailUsernameExist($username, $email){\r\n            \r\n            $query = \"select * from \".$this-&gt;db_table.\" where username = '$username' AND email = '$email'\";\r\n            \r\n            $result = mysqli_query($this-&gt;db-&gt;getDb(), $query);\r\n            \r\n            if(mysqli_num_rows($result) &gt; 0){\r\n                \r\n                mysqli_close($this-&gt;db-&gt;getDb());\r\n                \r\n                return true;\r\n                \r\n            }\r\n               \r\n            return false;\r\n            \r\n        }\r\n        \r\n        public function isValidEmail($email){\r\n            return filter_var($email, FILTER_VALIDATE_EMAIL) !== false;\r\n        }\r\n        \r\n        public function createNewRegisterUser($username, $password, $email){\r\n              \r\n            $isExisting = $this-&gt;isEmailUsernameExist($username, $email);\r\n            \r\n            if($isExisting){\r\n                \r\n                $json['success'] = 0;\r\n                $json['message'] = \"\u6ce8\u518c\u5931\u8d25\u3002\u7528\u6237\u540d\/\u90ae\u7bb1\u53ef\u80fd\u5df2\u5b58\u5728\";\r\n            }\r\n            \r\n            else{\r\n                \r\n            $isValid = $this-&gt;isValidEmail($email);\r\n                \r\n                if($isValid)\r\n                {\r\n                $query = \"insert into \".$this-&gt;db_table.\" (username, password, email, created_at, updated_at) values ('$username', '$password', '$email', NOW(), NOW())\";\r\n                \r\n                $inserted = mysqli_query($this-&gt;db-&gt;getDb(), $query);\r\n                \r\n                if($inserted == 1){\r\n                    \r\n                    $json['success'] = 1;\r\n                    $json['message'] = \"\u7528\u6237\u6ce8\u518c\u6210\u529f\";\r\n                    \r\n                }else{\r\n                    \r\n                    $json['success'] = 0;\r\n                    $json['message'] = \"\u6ce8\u518c\u5931\u8d25\u3002\u7528\u6237\u540d\/\u90ae\u7bb1\u53ef\u80fd\u5df2\u5b58\u5728\";\r\n                    \r\n                }\r\n                \r\n                mysqli_close($this-&gt;db-&gt;getDb());\r\n                }\r\n                else{\r\n                    $json['success'] = 0;\r\n                    $json['message'] = \"\u6ce8\u518c\u5931\u8d25\u3002\u90ae\u7bb1\u5730\u5740\u65e0\u6548\";\r\n                }\r\n                \r\n            }\r\n            \r\n            return $json;\r\n            \r\n        }\r\n        \r\n        public function loginUsers($username, $password){\r\n            \r\n            $json = array();\r\n            \r\n            $canUserLogin = $this-&gt;isLoginExist($username, $password);\r\n            \r\n            if($canUserLogin){\r\n                \r\n                $json['success'] = 1;\r\n                $json['message'] = \"\u767b\u5f55\u6210\u529f\";\r\n                \r\n            }else{\r\n                $json['success'] = 0;\r\n                $json['message'] = \"\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef\";\r\n            }\r\n            return $json;\r\n        }\r\n    }\r\n    ?&gt;\r\n<\/code><\/pre>\n<p>\u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c$json\u53d8\u91cf\u5305\u542b\u8fd4\u56de\u7684JSON\u5bf9\u8c61\u3002\u4e0b\u9762\u7684PHP\u811a\u672c\u662f\u5e94\u7528\u7a0b\u5e8f\u9996\u5148\u8c03\u7528\u7684\u811a\u672c\u3002index.php<\/p>\n<pre class=\"post-pre\"><code>&lt;?php\r\n    \r\n    require_once 'user.php';\r\n    \r\n    $username = \"\";\r\n    \r\n    $password = \"\";\r\n    \r\n    $email = \"\";\r\n    \r\n    if(isset($_POST['username'])){\r\n        \r\n        $username = $_POST['username'];\r\n        \r\n    }\r\n    \r\n    if(isset($_POST['password'])){\r\n        \r\n        $password = $_POST['password'];\r\n        \r\n    }\r\n    \r\n    if(isset($_POST['email'])){\r\n        \r\n        $email = $_POST['email'];\r\n        \r\n    }\r\n    \r\n    $userObject = new User();\r\n    \r\n    \/\/ \u6ce8\u518c\r\n    \r\n    if(!empty($username) &amp;&amp; !empty($password) &amp;&amp; !empty($email)){\r\n        \r\n        $hashed_password = md5($password);\r\n        \r\n        $json_registration = $userObject-&gt;createNewRegisterUser($username, $hashed_password, $email);\r\n        \r\n        echo json_encode($json_registration);\r\n        \r\n    }\r\n    \r\n    \/\/ \u767b\u5f55\r\n    \r\n    if(!empty($username) &amp;&amp; !empty($password) &amp;&amp; empty($email)){\r\n        \r\n        $hashed_password = md5($password);\r\n        \r\n        $json_array = $userObject-&gt;loginUsers($username, $hashed_password);\r\n        \r\n        echo json_encode($json_array);\r\n    }\r\n    ?&gt;\r\n<\/code><\/pre>\n<p>\u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c\u6211\u4eec\u68c0\u67e5\u7535\u5b50\u90ae\u4ef6\u5b57\u6bb5\u662f\u5426\u4e3a\u7a7a\u3002\u5982\u679c\u662f\u7a7a\u7684\uff0c\u5219\u4f1a\u8c03\u7528PHP\u811a\u672c\u4e2d\u7684\u767b\u5f55\u51fd\u6570\uff1b\u5426\u5219\uff0c\u6211\u4eec\u5c06\u8f6c\u5230\u6ce8\u518c\u51fd\u6570\u3002JSON\u54cd\u5e94\u8fd4\u56de\u4e24\u4e2a\u53c2\u6570\uff1a\u6210\u529f\uff080\u62161\uff09\u548c\u6d88\u606f\u3002<\/p>\n<ul class=\"post-ul\">\n<li>md5()\u51fd\u6570\u4f7f\u7528RSA\u6570\u636e\u5b89\u5168\u516c\u53f8\u7684MD5\u6d88\u606f\u6458\u8981\u7b97\u6cd5\u6765\u521b\u5efa\u5bc6\u7801\u7684\u54c8\u5e0c\u5b57\u7b26\u4e32\u3002<\/li>\n<li>\u4e3a\u4e86\u68c0\u67e5\u90ae\u7bb1\u5730\u5740\u662f\u5426\u6709\u6548\uff0c\u6211\u4eec\u5b9e\u73b0\u4e86isValidEmail()\u65b9\u6cd5\u3002FILTER_VALIDATE_EMAIL\u9002\u7528\u4e8ePHP 5.2.0\u53ca\u4ee5\u4e0a\u7248\u672c\u3002<\/li>\n<\/ul>\n<h3>Android\u767b\u5f55\u6ce8\u518c\u9879\u76ee\u7ed3\u6784<\/h3>\n<h3>Android\u767b\u5f55\u6ce8\u518c\u4ee3\u7801\u89e3\u6790<\/h3>\n<p>\u5728\u8fd9\u4e2a\u9879\u76ee\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528\u4e86\u4e09\u4e2a\u5e93\u6765\u5b9e\u73b0\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684HTTP\u8c03\u7528\u3002JSON\u89e3\u6790\u5668\u7c7b\u7528\u4e8e\u6267\u884cPOST\u548cGET HTTP\u8bf7\u6c42\u5230\u672c\u5730\u4e3b\u673a\uff0c\u5e76\u4ee5JSONObject\u5f62\u5f0f\u8fd4\u56de\u54cd\u5e94\u3002<\/p>\n<h4>activity_main.xml\u5e03\u5c40\u5b9a\u4e49<\/h4>\n<pre class=\"post-pre\"><code>&lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;\r\n&lt;ScrollView xmlns:android=\"https:\/\/schemas.android.com\/apk\/res\/android\"\r\n    android:layout_width=\"fill_parent\"\r\n    android:layout_height=\"fill_parent\"\r\n    android:fillViewport=\"true\"&gt;\r\n\r\n    &lt;RelativeLayout\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"&gt;\r\n\r\n        &lt;LinearLayout\r\n            android:orientation=\"vertical\"\r\n            android:layout_width=\"match_parent\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:layout_centerInParent=\"true\"\r\n            android:paddingLeft=\"24dp\"\r\n            android:paddingRight=\"24dp\"\r\n            android:id=\"@+id\/linearLayout\"&gt;\r\n\r\n                &lt;EditText android:id=\"@+id\/editName\"\r\n                    android:layout_width=\"match_parent\"\r\n                    android:layout_height=\"wrap_content\"\r\n                    android:hint=\"\u7528\u6237\u540d\"\r\n                    android:textColor=\"#FF192133\"\r\n                    android:textColorHint=\"#A0192133\"\r\n                    android:fontFamily=\"sans-serif-light\"\r\n                    android:focusable=\"true\"\r\n                    android:focusableInTouchMode=\"true\" \/&gt;\r\n\r\n                &lt;EditText android:id=\"@+id\/editPassword\"\r\n                    android:layout_width=\"match_parent\"\r\n                    android:layout_height=\"wrap_content\"\r\n                    android:inputType=\"textPassword\"\r\n                    android:textColor=\"#FF192133\"\r\n                    android:textColorHint=\"#A0192133\"\r\n                    android:fontFamily=\"sans-serif-light\"\r\n                    android:hint=\"\u5bc6\u7801\"\r\n                    android:focusable=\"true\"\r\n                    android:focusableInTouchMode=\"true\" \/&gt;\r\n\r\n                &lt;EditText android:id=\"@+id\/editEmail\"\r\n                    android:layout_width=\"match_parent\"\r\n                    android:layout_height=\"wrap_content\"\r\n                    android:inputType=\"textEmailAddress\"\r\n                    android:textColor=\"#FF192133\"\r\n                    android:visibility=\"gone\"\r\n                    android:textColorHint=\"#A0192133\"\r\n                    android:fontFamily=\"sans-serif-light\"\r\n                    android:hint=\"\u7535\u5b50\u90ae\u7bb1\"\r\n                    android:focusable=\"true\"\r\n                    android:focusableInTouchMode=\"true\" \/&gt;\r\n\r\n            &lt;Button\r\n                android:layout_width=\"match_parent\"\r\n                android:layout_height=\"wrap_content\"\r\n                android:id=\"@+id\/btnSignIn\"\r\n                android:text=\"\u767b\u5f55\"\r\n                android:textStyle=\"bold\"\r\n                \/&gt;\r\n\r\n            &lt;Button\r\n                android:layout_width=\"match_parent\"\r\n                android:layout_height=\"wrap_content\"\r\n                android:id=\"@+id\/btnRegister\"\r\n                android:text=\"\u6ce8\u518c\"\r\n                android:textStyle=\"bold\"\r\n                \/&gt;\r\n\r\n        &lt;\/LinearLayout&gt;\r\n\r\n    &lt;\/RelativeLayout&gt;\r\n\r\n&lt;\/ScrollView&gt;\r\n<\/code><\/pre>\n<h4>MainActivity.java\u4ee3\u7801<\/h4>\n<pre class=\"post-pre\"><code>package com.Olivia.loginphpmysql;\r\n\r\nimport android.content.Intent;\r\nimport android.content.SharedPreferences;\r\nimport android.graphics.Color;\r\nimport android.os.AsyncTask;\r\nimport android.support.v7.app.AppCompatActivity;\r\nimport android.os.Bundle;\r\nimport android.util.Log;\r\nimport android.view.View;\r\nimport android.widget.Button;\r\nimport android.widget.EditText;\r\nimport android.widget.Toast;\r\n\r\nimport org.apache.http.NameValuePair;\r\nimport org.apache.http.message.BasicNameValuePair;\r\nimport org.json.JSONException;\r\nimport org.json.JSONObject;\r\n\r\nimport java.util.ArrayList;\r\n\r\npublic class MainActivity extends AppCompatActivity {\r\n\r\n\r\n    EditText editEmail, editPassword, editName;\r\n    Button btnSignIn, btnRegister;\r\n\r\n    String URL= \"https:\/\/10.0.3.2\/test_android\/index.php\";\r\n\r\n    JSONParser jsonParser=new JSONParser();\r\n\r\n    int i=0;\r\n\r\n    @Override\r\n    protected void onCreate(Bundle savedInstanceState) {\r\n        super.onCreate(savedInstanceState);\r\n        setContentView(R.layout.activity_main);\r\n\r\n        editEmail=(EditText)findViewById(R.id.editEmail);\r\n        editName=(EditText)findViewById(R.id.editName);\r\n        editPassword=(EditText)findViewById(R.id.editPassword);\r\n\r\n        btnSignIn=(Button)findViewById(R.id.btnSignIn);\r\n        btnRegister=(Button)findViewById(R.id.btnRegister);\r\n\r\n        btnSignIn.setOnClickListener(new View.OnClickListener() {\r\n            @Override\r\n            public void onClick(View view) {\r\n                AttemptLogin attemptLogin= new AttemptLogin();\r\n                attemptLogin.execute(editName.getText().toString(),editPassword.getText().toString(),\"\");\r\n            }\r\n        });\r\n\r\n        btnRegister.setOnClickListener(new View.OnClickListener() {\r\n            @Override\r\n            public void onClick(View view) {\r\n\r\n                if(i==0)\r\n                {\r\n                    i=1;\r\n                    editEmail.setVisibility(View.VISIBLE);\r\n                    btnSignIn.setVisibility(View.GONE);\r\n                    btnRegister.setText(\"\u521b\u5efa\u8d26\u6237\");\r\n                }\r\n                else{\r\n\r\n                    btnRegister.setText(\"\u6ce8\u518c\");\r\n                    editEmail.setVisibility(View.GONE);\r\n                    btnSignIn.setVisibility(View.VISIBLE);\r\n                    i=0;\r\n\r\n                    AttemptLogin attemptLogin= new AttemptLogin();\r\n                    attemptLogin.execute(editName.getText().toString(),editPassword.getText().toString(),editEmail.getText().toString());\r\n\r\n                }\r\n\r\n            }\r\n        });\r\n\r\n\r\n    }\r\n\r\n    private class AttemptLogin extends AsyncTask&lt;String, String, JSONObject&gt; {\r\n\r\n        @Override\r\n\r\n        protected void onPreExecute() {\r\n\r\n            super.onPreExecute();\r\n\r\n        }\r\n\r\n        @Override\r\n\r\n        protected JSONObject doInBackground(String... args) {\r\n\r\n\r\n\r\n            String email = args[2];\r\n            String password = args[1];\r\n            String name= args[0];\r\n\r\n            ArrayList params = new ArrayList();\r\n            params.add(new BasicNameValuePair(\"username\", name));\r\n            params.add(new BasicNameValuePair(\"password\", password));\r\n            if(email.length()&gt;0)\r\n            params.add(new BasicNameValuePair(\"email\",email));\r\n\r\n            JSONObject json = jsonParser.makeHttpRequest(URL, \"POST\", params);\r\n\r\n\r\n            return json;\r\n\r\n        }\r\n\r\n        protected void onPostExecute(JSONObject result) {\r\n\r\n            \/\/ dismiss the dialog once product deleted\r\n            \/\/Toast.makeText(getApplicationContext(),result,Toast.LENGTH_LONG).show();\r\n\r\n            try {\r\n                if (result != null) {\r\n                    Toast.makeText(getApplicationContext(),result.getString(\"message\"),Toast.LENGTH_LONG).show();\r\n                } else {\r\n                    Toast.makeText(getApplicationContext(), \"\u65e0\u6cd5\u4ece\u670d\u52a1\u5668\u68c0\u7d22\u4efb\u4f55\u6570\u636e\", Toast.LENGTH_LONG).show();\r\n                }\r\n            } catch (JSONException e) {\r\n                e.printStackTrace();\r\n            }\r\n\r\n\r\n        }\r\n\r\n    }\r\n}\r\n<\/code><\/pre>\n<h4>\u4ee3\u7801\u89e3\u6790<\/h4>\n<p>\u8fd9\u662f\u4e00\u6bb5\u76f8\u5f53\u5e9e\u5927\u7684\u4ee3\u7801\uff01\u8ba9\u6211\u4eec\u4ece\u4e0a\u8ff0\u4ee3\u7801\u4e2d\u5f97\u51fa\u91cd\u8981\u7684\u63a8\u7406\uff1a<\/p>\n<ol>\n<li>https:\/\/10.0.3.2\u662f\u672c\u5730\u56de\u8def\u5730\u5740\u3002\u53ea\u6709\u5728\u4f7f\u7528Genymotion\u6a21\u62df\u5668\u65f6\u624d\u80fd\u4f7f\u7528\u8be5\u5730\u5740\u3002\u4f7f\u7528https:\/\/10.0.2.2\u6765\u5bf9AVD\u6a21\u62df\u5668\u8fdb\u884c\u6539\u8fdb\u3002\u5982\u679c\u60a8\u662f\u5728\u60a8\u81ea\u5df1\u7684\u8bbe\u5907\u4e0a\u4f7f\u7528\u8ba1\u7b97\u673a\u7684WIFI\u5730\u5740\u8fd0\u884c\u5e94\u7528\u7a0b\u5e8f\uff0c\u8bf7\u4f7f\u7528https:\/\/192.168.0.143\u3002<\/li>\n<li>\u70b9\u51fb&#8221;\u6ce8\u518c&#8221;\u6309\u94ae\u540e\uff0c\u6211\u4eec\u4f1a\u4ee5\u7f16\u7a0b\u7684\u65b9\u5f0f\u9690\u85cf&#8221;\u767b\u5f55&#8221;\u6309\u94ae\uff0c\u5e76\u663e\u793a\u7535\u5b50\u90ae\u7bb1\u5730\u5740\u8f93\u5165\u6587\u672c\u6846\u3002<\/li>\n<li>AttemptLogin\u7c7b\u5728\u540e\u53f0\u6267\u884c\u5bf9\u6211\u4eec\u672c\u5730\u56de\u8def\u7684\u7f51\u7edcHTTP\u8bf7\u6c42\u3002<\/li>\n<li>\u7528\u6237\u540d\u3001\u5bc6\u7801\u548c\u7535\u5b50\u90ae\u7bb1\u53c2\u6570\u88ab\u6dfb\u52a0\u5230ArrayList\u4e2d\uff0c\u5e76\u5728JSONParser\u7c7b\u7684makeHttpRequest(URL, &#8220;POST&#8221;, params)\u65b9\u6cd5\u4e2d\u4f20\u9012\u3002<\/li>\n<li>\u5728onPostExecute\u65b9\u6cd5\u4e2d\uff0c\u6211\u4eec\u5c06\u4ece\u670d\u52a1\u5668\u8fd4\u56de\u7684\u6d88\u606f\u5b57\u7b26\u4e32\u663e\u793a\u5728\u4e00\u4e2aToast\u6d88\u606f\u4e2d\u3002<\/li>\n<\/ol>\n<h4>JSONParser.java\u7c7b<\/h4>\n<pre class=\"post-pre\"><code>package com.Olivia.loginphpmysql;\r\n\r\nimport android.util.Log;\r\n\r\nimport org.apache.http.HttpEntity;\r\nimport org.apache.http.HttpResponse;\r\nimport org.apache.http.NameValuePair;\r\nimport org.apache.http.client.ClientProtocolException;\r\nimport org.apache.http.client.HttpClient;\r\nimport org.apache.http.client.entity.UrlEncodedFormEntity;\r\nimport org.apache.http.client.methods.HttpGet;\r\nimport org.apache.http.client.methods.HttpPost;\r\nimport org.apache.http.client.utils.URLEncodedUtils;\r\nimport org.apache.http.impl.client.DefaultHttpClient;\r\nimport org.json.JSONArray;\r\nimport org.json.JSONException;\r\nimport org.json.JSONObject;\r\n\r\nimport java.io.BufferedReader;\r\nimport java.io.IOException;\r\nimport java.io.InputStream;\r\nimport java.io.InputStreamReader;\r\nimport java.io.UnsupportedEncodingException;\r\nimport java.util.ArrayList;\r\n\r\n\/**\r\n * Created by anupamchugh on 29\/08\/16.\r\n *\/\r\npublic class JSONParser {\r\n\r\n    static InputStream is = null;\r\n    static JSONObject jObj = null;\r\n    static JSONArray jArr = null;\r\n    static String json = \"\";\r\n    static String error = \"\";\r\n\r\n    \/\/ constructor\r\n    public JSONParser() {\r\n\r\n    }\r\n\r\n    \/\/ function get json from url\r\n    \/\/ by making HTTP POST or GET mehtod\r\n    public JSONObject makeHttpRequest(String url, String method,\r\n                                      ArrayList params) {\r\n\r\n        \/\/ Making HTTP request\r\n        try {\r\n\r\n            \/\/ check for request method\r\n            if(method.equals(\"POST\")){\r\n                \/\/ request method is POST\r\n                \/\/ defaultHttpClient\r\n                HttpClient httpClient = new DefaultHttpClient();\r\n                HttpPost httpPost = new HttpPost(url);\r\n                httpPost.setEntity(new UrlEncodedFormEntity(params));\r\n                try {\r\n                    Log.e(\"API123\", \" \" +convertStreamToString(httpPost.getEntity().getContent()));\r\n                    Log.e(\"API123\",httpPost.getURI().toString());\r\n                } catch (Exception e) {\r\n                    e.printStackTrace();\r\n                }\r\n\r\n                HttpResponse httpResponse = httpClient.execute(httpPost);\r\n                Log.e(\"API123\",\"\"+httpResponse.getStatusLine().getStatusCode());\r\n                error= String.valueOf(httpResponse.getStatusLine().getStatusCode());\r\n                HttpEntity httpEntity = httpResponse.getEntity();\r\n                is = httpEntity.getContent();\r\n\r\n            }else if(method.equals(\"GET\")){\r\n                \/\/ request method is GET\r\n                DefaultHttpClient httpClient = new DefaultHttpClient();\r\n                String paramString = URLEncodedUtils.format(params, \"utf-8\");\r\n                url += \"?\" + paramString;\r\n                HttpGet httpGet = new HttpGet(url);\r\n\r\n                HttpResponse httpResponse = httpClient.execute(httpGet);\r\n                HttpEntity httpEntity = httpResponse.getEntity();\r\n                is = httpEntity.getContent();\r\n            }\r\n\r\n        } catch (UnsupportedEncodingException e) {\r\n            e.printStackTrace();\r\n        } catch (ClientProtocolException e) {\r\n            e.printStackTrace();\r\n        } catch (IOException e) {\r\n            e.printStackTrace();\r\n        }\r\n\r\n        try {\r\n            BufferedReader reader = new BufferedReader(new InputStreamReader(\r\n                    is, \"iso-8859-1\"), 8);\r\n            StringBuilder sb = new StringBuilder();\r\n            String line = null;\r\n            while ((line = reader.readLine()) != null) {\r\n                sb.append(line + \"\\n\");\r\n            }\r\n            is.close();\r\n            json = sb.toString();\r\n            Log.d(\"API123\",json);\r\n        } catch (Exception e) {\r\n            Log.e(\"Buffer Error\", \"Error converting result \" + e.toString());\r\n        }\r\n\r\n        \/\/ try to parse the string to a JSON object\r\n        try {\r\n            jObj = new JSONObject(json);\r\n            jObj.put(\"error_code\",error);\r\n        } catch (JSONException e) {\r\n            Log.e(\"JSON Parser\", \"Error parsing data \" + e.toString());\r\n        }\r\n\r\n        \/\/ return JSON String\r\n        return jObj;\r\n\r\n    }\r\n\r\n    private String convertStreamToString(InputStream is) throws Exception {\r\n        BufferedReader reader = new BufferedReader(new InputStreamReader(is));\r\n        StringBuilder sb = new StringBuilder();\r\n        String line = null;\r\n        while ((line = reader.readLine()) != null) {\r\n            sb.append(line);\r\n        }\r\n        is.close();\r\n        return sb.toString();\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>\u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c\u6211\u4eec\u6839\u636e\u4f20\u5165makeHttpRequest\u51fd\u6570\u7684\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u8c03\u7528\u76f8\u5e94\u7684HTTPPost\u7c7b\u6216HTTPGet\u7c7b\u3002<\/p>\n<pre class=\"post-pre\"><code>jObj.put(\"error_code\",error);\r\n<\/code><\/pre>\n<p>\u5728\u4e0a\u9762\uff0c\u6211\u4eec\u5c06\u4ece\u670d\u52a1\u5668\u8fd4\u56de\u7684\u54cd\u5e94\u72b6\u6001\u7801\u9644\u52a0\u5728\u6700\u7ec8\u8fd4\u56de\u7ed9MainActivity\u7c7b\u7684JSONObject\u4e2d\u3002\u6ce8\u610f\uff1a\u4e0d\u8981\u5fd8\u8bb0\u5728\u4f60\u7684AndroidManifest.xml\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code>&lt;uses-permission android:name=\"android.permission.INTERNET\"\/&gt;\r\n<\/code><\/pre>\n<p>\u5f88\u591a\u7528\u6237\u5728\u672c\u6559\u7a0b\u7684\u5e95\u90e8\u53d1\u5e03\u4e86\u4ed6\u4eec\u7684\u8bc4\u8bba\uff0c\u8868\u793a\u4ed6\u4eec\u6536\u5230\u4e86&#8221;\u65e0\u6cd5\u68c0\u7d22\u6570\u636e&#8221;\u7684\u63d0\u793a\u3002\u8bf7\u6ce8\u610f\uff0c\u5728Android 6.0\u53ca\u4ee5\u4e0a\u7248\u672c\u4e2d\uff0c\u60a8\u9700\u8981\u5728Manifest.xml\u6587\u4ef6\u4e2d\u7684\u5e94\u7528\u6807\u7b7e\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u5c5e\u6027\uff1aandroid:usesCleartextTraffic=&#8221;true&#8221;\u3002\u4e3a\u4ec0\u4e48\u8981\u8fd9\u6837\u505a\u5462\uff1f\u4e3a\u4e86\u5141\u8bb8\u6a21\u62df\u5668\/\u8bbe\u5907\u7684\u7f51\u7edc\u5b89\u5168\u8fdb\u884cHTTP\u8c03\u7528\u3002\u8bf7\u67e5\u770b\u4e0b\u9762Android Q\u6a21\u62df\u5668\u7684\u6700\u65b0\u622a\u56fe\u8f93\u51fa\u3002\u5e26\u6709\u5bf9AndroidManifest.xml\u6587\u4ef6\u8fdb\u884c\u66f4\u6539\u7684\u6700\u65b0\u6e90\u4ee3\u7801\u5df2\u5728\u94fe\u63a5\u548c\u6211\u4eec\u7684Github\u5b58\u50a8\u5e93\u4e2d\u66f4\u65b0\u3002<\/p>\n<h4>\u5e94\u7528\u7a0b\u5e8f\u8fd0\u884c\u8f93\u51fa\u7ed3\u679c<\/h4>\n<h4>\u5b89\u5353\u7528\u6237\u6ce8\u518c<\/h4>\n<p>\u5728\u4e0b\u9762\u7684\u622a\u56fe\u4e2d\uff0c\u6211\u4eec\u6ce8\u518c\u4e86\u4e00\u4e2a\u65b0\u7528\u6237\u5e76\u5c06\u5176\u6dfb\u52a0\u5230\u6570\u636e\u5e93\u4e2d\u3002\u7136\u540e\uff0c\u6211\u4eec\u4f7f\u7528\u5728\u6ce8\u518c\u8fc7\u7a0b\u4e2d\u8f93\u5165\u7684\u51ed\u636e\u8fdb\u884c\u767b\u5f55\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/65648655a4b2f92e6c7310bd\/51-0.gif\" alt=\"Android\u4f7f\u7528PHP MySQL\u767b\u5f55\u6700\u7ec8\u8f93\u51fa\" \/><\/div>\n<p>\u8fd9\u7ed3\u675f\u4e86\u5173\u4e8eAndroid\u4f7f\u7528PHP MySQL\u8fdb\u884c\u767b\u5f55\u6559\u7a0b\u7684\u90e8\u5206\u3002\u60a8\u53ef\u4ee5\u4ece\u4e0b\u9762\u7684\u94fe\u63a5\u4e0b\u8f7d\u8fd9\u4e2a\u9879\u76ee\u3002\u5b83\u8fd8\u5305\u542b\u4e00\u4e2a\u540d\u4e3atest_android\u7684\u6587\u4ef6\u5939\uff0c\u91cc\u9762\u5b58\u653e\u7740PHP\u6587\u4ef6\u3002\u8bf7\u5c06\u5176\u590d\u5236\u5230xampp\\htdocs\u6587\u4ef6\u5939\u4e2d\uff01\u795d\u60a8\u597d\u8fd0\u3002<\/p>\n<p><a href=\"#\">\u4e0b\u8f7d\u5b89\u5353\u767b\u5f55\u6ce8\u518cPHP MySQL\u9879\u76ee<\/a><\/p>\n<p>\u60a8\u8fd8\u53ef\u4ee5\u4ece\u6211\u4eec\u7684GitHub\u5b58\u50a8\u5e93\u4e2d\u8bbf\u95ee\u5b8c\u6574\u7684\u6e90\u4ee3\u7801\uff0c\u8bf7\u53c2\u9605\u4e0b\u65b9\u94fe\u63a5\u3002<\/p>\n<p><a href=\"#\">GitHub \u9879\u76ee\u94fe\u63a5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Android\u7684\u767b\u5f55\u548c\u6ce8\u518c\u662f\u975e\u5e38\u5e38\u89c1\u7684\u573a\u666f\u3002\u5728\u6211\u4eec\u9700\u8981\u7528\u6237\u4fe1\u606f\u7684\u6240\u6709\u5e94\u7528\u7a0b\u5e8f\u4e2d\uff0c\u60a8\u5c06\u627e\u5230\u6ce8\u518c\u548c\u767b\u5f55\u64cd\u4f5c\u3002\u5728\u672c\u6559 [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[900,1526,1525,1163,1065],"class_list":["post-509","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-android","tag-mysql","tag-php","tag-1163","tag-1065"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528php-mysql\u8fdb\u884candroid\u767b\u5f55\u548c\u6ce8\u518c\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528php-mysql\u8fdb\u884candroid\u767b\u5f55\u548c\u6ce8\u518c\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-14T09:53:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T06:46:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/65648655a4b2f92e6c7310bd\/51-0.gif\" \/>\n<meta name=\"author\" content=\"\u79d1, \u96c5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u96c5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/\",\"name\":\"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2022-12-14T09:53:24+00:00\",\"dateModified\":\"2025-08-02T06:46:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\"},\"description\":\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\",\"name\":\"\u79d1, \u96c5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u96c5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd - Blog - Silicon Cloud","description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528php-mysql\u8fdb\u884candroid\u767b\u5f55\u548c\u6ce8\u518c\/","og_locale":"zh_CN","og_type":"article","og_title":"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd","og_description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528php-mysql\u8fdb\u884candroid\u767b\u5f55\u548c\u6ce8\u518c\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2022-12-14T09:53:24+00:00","article_modified_time":"2025-08-02T06:46:44+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/65648655a4b2f92e6c7310bd\/51-0.gif"}],"author":"\u79d1, \u96c5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u96c5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/","name":"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2022-12-14T09:53:24+00:00","dateModified":"2025-08-02T06:46:44+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a"},"description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528PHP\u548cMySQL\u4e3aAndroid\u5e94\u7528\u521b\u5efa\u5b8c\u6574\u7684\u7528\u6237\u767b\u5f55\u548c\u6ce8\u518c\u7cfb\u7edf\u3002\u5305\u542b\u540e\u7aefAPI\u5f00\u53d1\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001Android\u5ba2\u6237\u7aef\u5b9e\u73b0\u4ee5\u53ca\u5b89\u5168\u9a8c\u8bc1\u7b49\u5173\u952e\u6b65\u9aa4\uff0c\u9002\u5408\u521d\u5b66\u8005\u548c\u4e2d\u7ea7\u5f00\u53d1\u8005\u5b66\u4e60\u79fb\u52a8\u5e94\u7528\u540e\u7aef\u96c6\u6210\u6280\u672f\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"2023\u5e74\u5b8c\u6574\u6559\u7a0b\uff1a\u4f7f\u7528PHP\u548cMySQL\u5b9e\u73b0Android\u5e94\u7528\u767b\u5f55\u6ce8\u518c\u529f\u80fd"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a","name":"\u79d1, \u96c5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","caption":"\u79d1, \u96c5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8php-mysql%e8%bf%9b%e8%a1%8candroid%e7%99%bb%e5%bd%95%e5%92%8c%e6%b3%a8%e5%86%8c\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=509"}],"version-history":[{"count":4,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions"}],"predecessor-version":[{"id":110172,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions\/110172"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}