Grazie Ho letto e provato e funziona ho fatto cosi le critiche sono bene accette
codice:
<?php
$cn = new COM("ADODB.Connection") or die("Cannot start ADO");
$cn->Open("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Jet OLEDB:Database Password=gmpa;Data Source=C:\Users\Paolo\Dropbox\Programmazione\c#\dati.mdb;");
$response = array();
// = mysql_query( "SELECT * FROM TempMAGXLS")or die(mysql_error());
$query= ("SELECT * FROM TempMAGXLS ");
$result = $cn->Execute($query);
// check for empty result
if (!$result->EOF) {
// looping through all results
// products node
$response["products"] = array();
while (!$result->EOF) {
// temp user array
$product = array();
$product["Codice"] = $result ->Fields[0]->value;
$product["Descrizione"] = $result ->Fields[1]->value;
$product["PrezzoCo"] = $result ->Fields[5]->value;
$product["PrezzoPu"] = $result ->Fields[6]->value;
$result ->MoveNext();
// push single product into final response array
array_push($response["products"], $product);
}
// success
$response["success"] = 1;
// echoing JSON response
echo json_encode($response);
} else {
// no products found
$response["success"] = 0;
$response["message"] = "No products found";
// echo no users JSON
echo json_encode($response);
}
?>