使ç¨JSONè¿æ¥AndroidåPHP Mysqlæ°æ®åºæ¹æ³ï¼
1ãæå¼å®è£
WAMP Serverçæ件夹ï¼æå¼wwwæ件夹ï¼ä¸ºä½ ç项ç®å建ä¸ä¸ªæ°çæ件夹ãå¿
é¡»æ项ç®ä¸ææçæ件æ¾å°è¿ä¸ªæ件夹ä¸ã
2ãæ°å»ºä¸ä¸ªå为android_connectçæ件夹ï¼å¹¶æ°å»ºä¸ä¸ªphpæ件ï¼å½å为test.phpï¼å°è¯è¾å
¥ä¸äºç®åçphp代ç ï¼å¦ä¸æ示ï¼ã
test.php
<?php
echo"Welcome, I am connecting Android to PHP, MySQL";
?>
3ãå建MySQLæ°æ®åºå表
å建äºä¸ä¸ªç®åçåªæä¸å¼ 表çæ°æ®åºãç¨è¿ä¸ªè¡¨æ¥æ§è¡ä¸äºç¤ºä¾æä½ãç°å¨ï¼è¯·å¨æµè§å¨ä¸è¾å
¥
http://localhost/phpmyadmin/ï¼å¹¶æå¼phpmyadminãä½ å¯ä»¥ç¨PhpMyAdminå·¥å
·å建æ°æ®åºå表ã
å建æ°æ®åºå表ï¼æ°æ®åºåï¼androidhiveï¼è¡¨ï¼product
CREATE TABLE products(
pid int(11) primary key auto_increment,
name varchar(100) not null,
price decimal(10,2) not null,
description text,
created_at timestamp default now(),
updated_at timestamp
);
4ãç¨PHPè¿æ¥MySQLæ°æ®åº
ç°å¨ï¼çæ£çæå¡å¨ç«¯ç¼ç¨å¼å§äºãæ°å»ºä¸ä¸ªPHPç±»æ¥è¿æ¥MYSQLæ°æ®åºãè¿ä¸ªç±»ç主è¦åè½æ¯æå¼æ°æ®åºè¿æ¥åå¨ä¸éè¦æ¶å
³éæ°æ®åºè¿æ¥ã
æ°å»ºä¸¤ä¸ªæ件db_config.php,db_connect.php
db_config.php--------åå¨æ°æ®åºè¿æ¥åé
db_connect.php-------è¿æ¥æ°æ®åºçç±»æ件
db_config.php
<?php
/*
* All database connection variables
*/
define('DB_USER', "root"); // db user
define('DB_PASSWORD', ""); // db password (mention your db password here)
define('DB_DATABASE', "androidhive"); // database name
define('DB_SERVER', "localhost"); // db server
?>
5ãå¨PHP项ç®ä¸æ°å»ºä¸ä¸ªphpæ件ï¼å½å为create_product.phpï¼å¹¶è¾å
¥ä»¥ä¸ä»£ç ã该æ件主è¦å®ç°å¨products表ä¸æå
¥ä¸ä¸ªæ°ç产åã
<?php
/*
* Following code will create a new product row
* All product details are read from HTTP Post Request
*/
// array for JSON response
$response = array();
// check for required fields
if (isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) {
$name = $_POST['name'];
$price = $_POST['price'];
$description = $_POST['description'];
// include db connect class
require_once __DIR__ . '/db_connect.php';
// connecting to db
$db = new DB_CONNECT();
// mysql inserting a new row
$result = mysql_query("INSERT INTO products(name, price, description) VALUES('$name', '$price', '$description')");
// check if row inserted or not
if ($result) {
// successfully inserted into database
$response["success"] = 1;
$response["message"] = "Product successfully created.";
// echoing JSON response
echo json_encode($response);
} else {
// failed to insert row
$response["success"] = 0;
$response["message"] = "Oops! An error occurred.";
// echoing JSON response
echo json_encode($response);
}
} else {
// required field is missing
$response["success"] = 0;
$response["message"] = "Required field(s) is missing";
// echoing JSON response
echo json_encode($response);
}
?>
JSONçè¿åå¼ä¼æ¯ï¼
å½POST åæ°ä¸¢å¤±
[php] view plaincopy
{
"success": 0,
"message": "Required field(s) is missing"
}