php - 将 JSON 添加到数据表

Question

我正在尝试将 PHP 脚本生成的 JSON 添加到 VB.net 数据表中，但我的 JSON 格式不正确（缺少双引号）。

PHP：

 header('Content-type: text/html; charset=utf8');
 $conn = mysqli_connect();
 $query = mysqli_query($conn, "SELECT * FROM installations where hwid = '".$_GET["hwid"]."'");
 while($row = mysqli_fetch_assoc($query)) {
 $data[] = $row;
 }

 echo htmlspecialchars(json_encode($data), ENT_QUOTES, 'UTF-8');
 json_last_error_msg();
 ?>

生成缺少额外双引号的 JSON：

 [{"idinstallations":"9","hwid":"74D435E5185A","naziv_racunala":"DESKTOP-0U5","naziv_instalacije":"prip","adresa_instalacije":"Vel","ukupno_artikala":"152","ukupno_dokumenata_d":"3","ukupno_dokumenata_arh":"0","ukupno":"20.50","prva_instalacija":"2019-06-14 05:25:45","licenca":"0","Opis_opa":"beb tipo","lastContact":"2019-06-30 14:05:43","version":"1.0.0.4\/a","dnevnik_summ":"20,50","arhiva_summ":"0","mod":"1","sync":"0","syncing":"","toMail":"[e-mail]","licExpire":null,"teamviewer":""}]

这是我用来将 JSON 设置为数据表的 VB.net 代码：

Dim webClient As New System.Net.WebClient
Dim result As String = webClient.DownloadString(http://www.something.com)
Dim json As String = result
Dim table As DataTable = JsonConvert.DeserializeObject(Of DataTable)(json)

标签： phpjsonvb.net