mysql两个android_从2个表中检索数据PHP，MySql，Android

有谁知道我可以使用PHP从MySql数据库中的2个表中获取数据的方法？我的Android应用程序允许用户将项目放在购物车中(MySql中的表格) . 当用户点击应用程序中的购物车按钮时，它会加载“购物车活动”，并根据“会话ID”或“客户ID”(如果他们已登录)加载列表视图，其中包含已添加到购物车的所有内容我现在做的是当项目被添加到购物车时我捕获产品ID，产品名称和图像URL，数量和价格 . 它工作得很好而且很快 . 我想要做的是因为产品名称，图片网址和价格已经在“产品表”中我想做同样的事情但是当用户将项目添加到他们的购物车时只捕获产品ID和会话ID . 当客户转到购物车活动时，我希望我的PHP脚本在Shopping_Cart表中获取产品ID，然后在产品表中搜索该产品ID并返回价格，图片URL，名称等 .

这是我的PHP脚本：

if($The_Function=="LOAD_CART"){

$response = array();

require_once __DIR__ . '/db_connect.php';

$con = new DB_CONNECT();

$user_session = $_GET['session'];

$user_item_status = $_GET['status'];

$order_total = 0.00;

$result = mysql_query("SELECT * FROM shopping_cart WHERE SessionID LIKE '$user_session' AND Status LIKE '$user_item_status'");

if(!empty($result)){

if (mysql_num_rows($result) > 0) {

$response["cart_contents"] = array();

//$result = mysql_fetch_array($result);

while ($row = mysql_fetch_array($result)) {

$myItems = array();

$myItems["product_id"] = $row["PID"];

$myItems["product_name"] = $row["Item"];

$myItems["product_price"] = $row["Price"];

$myItems["product_qty"] = $row["Qty"];

$myItems["image_url"] = $row["URL"];

$myItems["line_id"] = $row["ItemCount"];

$line_total = $row["Price"] * $row["Qty"];

$order_total = $order_total + $line_total;

array_push($response["cart_contents"], $myItems);

}

// success

$response["success"] = 1;

$response["order_total"] = $order_total;

// user node

// $response["products"] = array();

// echoing JSON response

echo json_encode($response);

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

}

这是我想要做的 . 此代码不起作用 .

if($The_Function=="LOAD_CART2"){

$response = array();

require_once __DIR__ . '/db_connect.php';

$con = new DB_CONNECT();

$user_session = $_GET['session'];

$user_item_status = $_GET['status'];

$order_total = 0.00;

$result = mysql_query("SELECT * FROM shopping_cart WHERE SessionID LIKE '$user_session' AND Status LIKE '$user_item_status'");

if(!empty($result)){

if (mysql_num_rows($result) > 0) {

$response["cart_contents"] = array();

//$result = mysql_fetch_array($result);

while ($row = mysql_fetch_array($result)) {

$line_total = $row["Price"] * $row["Qty"];

$line_ID = $row["ItemCount"];

$Quantity = $row["Qty"];

$Prod_ID = $row["PID"];

$result2 = mysql_query("SELECT * FROM products WHERE pid LIKE '$Prod_ID'");

$myItems = array();

$theItem=$row["name"];

$thePrice=$row["price"];

$theImage=$row["prod_image"];

$myItems["line_id"] = $line_ID;

$myItems["product_qty"] = $Quantity;

$myItems["product_id"] = $Prod_ID;

$myItems["product_name"] = $theItem;

$myItems["product_price"] = $thePrice;

$myItems["image_url"] = $theImage;

$order_total = $order_total + $line_total;

array_push($response["cart_contents"], $myItems);

}

}

// success

$response["success"] = 1;

$response["order_total"] = $order_total;

// user node

// $response["products"] = array();

// echoing JSON response

echo json_encode($response);

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

这是我刚才所做的：

if($The_Function=="LOAD_CART2"){

$response = array();

require_once __DIR__ . '/db_connect.php';

$con = new DB_CONNECT();

$user_session = $_GET['session'];

$user_item_status = $_GET['status'];

$order_total = 0.00;

$result = mysql_query("SELECT s.*, p.* FROM shopping_cart AS s LEFT JOIN products AS p ON p.pid = s.PID WHERE s.SessionID ='$user_session' AND s.Status = '$user_item_status'");

if(!empty($result)){

if (mysql_num_rows($result) > 0) {

$response["cart_contents"] = array();

//$result = mysql_fetch_array($result);

while ($row = mysql_fetch_array($result)) {

$myItems = array();

//FROM shopping_cart Table

$line_total = $row["Price"] * $row["Qty"];

$myItems["line_id"] = $row["ItemCount"];

$myItems["product_qty"] = $row["Qty"];

$myItems["product_id"] = $row["PID"];

//FROM product TABLE

$myItems["product_name"]=$row["p.name"];

$myItems["product_price"]=$row["p.price"];

$myItems["image_url"]=$row["p.prod_image"];

}

$order_total = $order_total + $line_total;

array_push($response["cart_contents"], $myItems);

}

// success

$response["success"] = 1;

$response["order_total"] = $order_total;

// user node

// $response["products"] = array();

// echoing JSON response

echo json_encode($response);

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

} else {

// no product found

$response["success"] = 0;

$response["message"] = "No product found";

// echo no users JSON

echo json_encode($response);

}

我的计划：

products TABLE

pid|name|price|created_at|prod_image|description|catagory

shopping_cart TABLE

FirstName|LastName|OrderNumber|CustomerID|Email|Price|Qty|Status|URL|PID|SessionID|CustomerType|ItemCount