我正在嘗試以第三方服務(wù)可以使用的格式從我的數(shù)據(jù)庫(kù)中導(dǎo)出數(shù)據(jù)。將數(shù)據(jù)從 MySQL DB 轉(zhuǎn)換為 JSON 非常簡(jiǎn)單。我目前正在使用以下內(nèi)容進(jìn)行測(cè)試，盡管它不是我的完整數(shù)據(jù)集。$result = $dblink->query("SELECT * FROM Contracts LIMIT 3"); $dbdata = array(); while ( $row = $result->fetch_assoc()) { $rowarray['id'] = $row['ContractID']; $rowarray['title'] = $row['Service_Name']; $rowarray['currency'] = 'GBP'; $rowarray['amountAppliedFor'] = $row['Sum_Requested']; $rowarray['amountAwarded'] = $row['Sum_Approved']; $rowarray['awardDate'] = $row['Decision_Date']; $rowarray['recipientOrganization'] = $row['Provider']; $dbdata[]=$rowarray; } echo json_encode($dbdata);這很容易輸出：[ { "id":"147", "title":"Whatever", "currency":"GBP", "amountAppliedFor":"5000.00", "amountAwarded":"5000.00", "awardDate":"2019-07-14", "recipientOrganization":"32" }, { "id":"146", "title":"Test", "currency":"GBP", "amountAppliedFor":"1000.00", "amountAwarded":"0.00", "awardDate":"2019-07-04", "recipientOrganization":"32" }, { "id":"144", "title":"Test", "currency":"GBP", "amountAppliedFor":"15000.00", "amountAwarded":"15000.00", "awardDate":"0000-00-00", "recipientOrganization":"32" }]很容易。但我試圖創(chuàng)建的模式看起來像：{ "grants" : [ { "id" : "", "recipientOrganization" : [ { "id" : "", "companyNumber" : "", "charityNumber" : "", "name" : "", } ], "fundingOrganization" : [ { "id" : "", "name" : "" } ], "title" : "", "currency" : "", "amountAwarded" : "" }]}我不清楚如何使用對(duì)象等來構(gòu)造數(shù)據(jù)。目前我只是輸出平面 JSON。我是不是打算使用類似的東西：json_encode($dbdata, array(...)); ?
1 回答
繁花如伊
TA貢獻(xiàn)2012條經(jīng)驗(yàn) 獲得超12個(gè)贊
看起來你的結(jié)構(gòu)應(yīng)該是
? while ( $row = $result->fetch_assoc())? {
? ? $rowarray['id'] = $row['ContractID'];
? ? $rowarray['recipientOrganization'] = array(
? ? ? ? ?"id" => $row['id'],
? ? ? ? ?"companyNumber" => $row['companyNumber'],
? ? ? ? ?"charityNumber" => $row['charityNumber'],
? ? ? ? ?"name" => $row['name']
? ? );
? ? $rowarray['fundingOrganization'] = array(
? ? ? ? ?"id" => $row['id'],
? ? ? ? ?"name" => $row['name']
? ? );
? ? $rowarray['title'] = $row['Service_Name'];
? ? $rowarray['currency'] = 'GBP';
? ? //$rowarray['amountAppliedFor'] = $row['Sum_Requested'];
? ? $rowarray['amountAwarded'] = $row['Sum_Approved'];
? ? //$rowarray['awardDate'] = $row['Decision_Date'];
? ? $dbdata['grants'][] = $rowarray;
? }
我喜歡做的另一個(gè)技巧是將 json 放入 phpsandbox 并將其轉(zhuǎn)換為數(shù)組以查看結(jié)構(gòu)。
- 1 回答
- 0 關(guān)注
- 169 瀏覽
添加回答
舉報(bào)
0/150
提交
取消