我有一個(gè)名為 city 的表，其中有 city_id 和 city_name 列。我想要的是我想從 city 表中查詢 city_id 的值到另一個(gè)名為 spinner 的表中，該表也包含 city_id 列。兩個(gè) city_id 都具有相同的 int 數(shù)據(jù)類型。這是我的 php 代碼示例<?php$response = array();include 'DBConnect.php';//Get the input request parameters// $inputJSON = file_get_contents('php://input');// $input = json_decode($inputJSON, TRUE); //convert JSON into array//Check for Mandatory parameters $city_name = $_POST['city_name'];// $city_id = $_POST['city_id'];// $city_query = "SELECT city.city_id FROM city INNER JOIN spinner ON city.city_id = spinner.city_id";// $sql = "SELECT city_id FROM city WHERE $city_name ";// $stmt = $con->query("SELECT city_id FROM city WHERE $city_name");// $city_id = $stmt; // $insertQuery = "INSERT INTO spinner(city_id) VALUES (?)"; $insertQuery = "INSERT INTO spinner(city_id) SELECT city_id FROM city WHERE $city_name"; if($stmt = $con->prepare($insertQuery)){ // $stmt->bind_param('s',$city_id); $stmt->execute(); $response["status"] = 0; $response["message"] = "city data sent"; $stmt->close(); } else{ $reponse["message"] = "cannot send data"; }echo json_encode($response);?>
2 回答
慕田峪4524236
TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超5個(gè)贊
子查詢部分總是在(). 并根據(jù)您的需要檢查 WHERE 條件：
INSERT INTO spinner(city_id) VALUES((SELECT city_id FROM city WHERE city_name = "$city_name"))
元芳怎么了
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超7個(gè)贊
你忘記了設(shè)定你的價(jià)值觀。你的語(yǔ)法應(yīng)該是這樣的
INSERT INTO spinner(city_id) VALUES((SELECT city_id FROM city WHERE city_name = '$city_name'))
只是一個(gè)快速評(píng)論，我會(huì)親自將我的查詢分開(kāi)。我不會(huì)嵌套它們
- 2 回答
- 0 關(guān)注
- 158 瀏覽
添加回答
舉報(bào)
0/150
提交
取消