y6?axƻ]$Y6gO䮠'>;YPMJ8I0P^X8aj"YA]n.dpw^8"&-) H/l<?bIVfT4Gv)#8"r.v"-% 4qyUPrY8FP("d]jA4e$(A-wI^;6sglsJ6?B"TF(ʶ^#>qQI^ZNAsqɾ:3u`{:Wl n+{HKi(K\" 42;e9ٖ~y6\2KȘ  jJH87]':6"Y[BүZa!X)I&M|X?ِ$3L?#bck+˕ušoUME V*@kf:z~TҹrHгKOBYL8FP("d]jA4e>S'Z&G٭"|֘%#5Xe)4)M.)f\ +5Hd`;ʯ[4F{OmPr$Qz .(^f3b{I*;i{ZN6R-*-[s#敱6cčK99̰`̵a} HAO`=pDrY+`_%z{[oDK1ZH[1k ʦ୊HE.|D,[z͔x[nQ${ˣY h@TpcS?@Yw6}zkP,6J ΐT kT61Qo ֱhUaq03`Fʇ>B2Ds:dL0̪oM Ne0hQi'UȌ1caXp|x &Z6(Xlj1+l\ZCU^&S3w堩w=礥2pqV,#6,by*ǣ1Tm]zC̴yWbz w)_@Dl$Du1R7c E6_Xv??Qӕ)4KJNwvMjC0}m>|9Mַ65~M,!B=}pB=`vYj̞mhښ# oKQn1K2}Og 4ЌDZFD>bp 3 ;7d;EbLj|:|ԃYP[85 VOkO?.]5Har&m)ChyMHhMa@+Qʘ{;=$9/aipzjd7&GSl?:Zvmn3 *O;)Xli'׽d%l l,$M|ctE)NhǢq#?I$wJk)!Uti~?(~R^ћwӨLQXs+A"`| 0ӣΐWb&e>abta_ҭ &B`lo߰f1ڱț&VQnغ-߮3se(N%7-y8g_? lS;2)>&Z꿳/V8.Cn ]îzQ|x &Z6Dgi&hW!&ב&pOaPZ7 HI ή~ڃ\.@$ca+Mɭ,~bfs=%5jبyxO_u]䎾jKE{mٔ7@vF(ޮg 7 0|EaNjBh $s>ϥEg(cΊ^.َ}Bj,6h'w'"f'3m[>)!cx ٬ S] Da}Mi~ƥ *J Xr,݄ܹ맯et˔#=5,Ȟ*mC\h S)>[[pɌNRsH]l8R򊉼"1@ ƴXO=PP[>ckH<:]a{ɲp:ZWbv"Sj),DRL1B pEM+ӓ}c˄ (-!9Nt>;!ȝZ'#\(v9J^@prepare($query); $result->bind_param('s', $_GET['CustomerID']); $result->execute(); /* bind result variables */ $result->bind_result($CustomerID, $ShipCity, $OrderID, $OrderDate, $ShipName, $ShipAddress, $ShipCountry); /* fetch values */ while ($result->fetch()) { $orders[] = array( 'CustomerID' => $CustomerID, 'ShipCity' => $ShipCity, 'OrderID' => $OrderID, 'OrderDate' => $OrderDate, 'ShipName' => $ShipName, 'ShipAddress' => $ShipAddress, 'ShipCountry' => $ShipCountry ); } echo json_encode($orders); /* close statement */ $result->close(); return; } // get data and store in a json array $query = "SELECT CustomerID, CompanyName FROM Customers"; $result = $mysqli->prepare($query); $result->execute(); /* bind result variables */ $result->bind_result($CustomerID, $CompanyName); /* fetch values */ while ($result->fetch()) { $customers[] = array( 'CustomerID' => $CustomerID, 'CompanyName' => $CompanyName ); } echo json_encode($customers); $result->close(); /* close connection */ $mysqli->close(); -->