PHP DB Microsoft Json

[Nio74]

Ciao a tutti sto tentando di fare uno script php in modo che la mia app legga i dati di un DB Microsoft Access ho preso come esempio questo script:

<?php 
/*
 * Following code will list all the products
 */
 
// array for JSON response
$response = array();
 
// include db connect class
require_once __DIR__ . '/db_connect.php';
 
// connecting to db
$db = new DB_CONNECT();
 
// get all products from products table
$result = mysql_query("SELECT *FROM products") or die(mysql_error());
 
// check for empty result
if (mysql_num_rows($result) > 0) {
    // looping through all results
    // products node
    $response["products"] = array();
 
    while ($row = mysql_fetch_array($result)) {
        // temp user array
        $product = array();
        $product["pid"] = $row["pid"];
        $product["name"] = $row["name"];
        $product["price"] = $row["price"];
        $product["created_at"] = $row["created_at"];
        $product["updated_at"] = $row["updated_at"];
 
        // 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);
}
?>

Pero non posso usare Mysql con DB Access sto facendo delle prove ma non riesco a capire come fare il controllo per vedere se il risultato è superiore a zero,e a fare il ciclo wile,in pratica non so come sostituire mysql_num_rows e mysql_fetch_array Aiuto

QUESTO é il mio 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();
//$result =  mysql_query( "SELECT * FROM  TempMAGXLS")or die(mysql_error());
$result = "SELECT * FROM  TempMAGXLS ";


 // check for empty result
if (mysql_num_rows($result) > 0) {
    // looping through all results
    // products node
    $response["products"] = array();
 
    while ($row = mysql_fetch_array($result)) {
        // temp user array
        $product = array();
        $product["Codice"] = $row["Codice"];
        $product["Descrizione"] = $row["descrizione"];
        $product["PrezzoCo"] = $row["PrezzoCo"];
        $product["PrezzoPu"] = $row["PrezzoPu"];
        
        // 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);
}


?>

[clasku]

Se apri una connessione su access non puoi mica usare le funzioni MySQL per fare query e gestire i recordset...

[Nio74]

Secondo voi potrebbe funzionare così? Non riesco a provare sono in ospedale fino a stasera

<?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();
//$result =  mysql_query( "SELECT * FROM  TempMAGXLS")or die(mysql_error());
$result->open = ("SELECT * FROM  TempMAGXLS ");


 // check for empty result
if (!$result->EOF) {
    // looping through all results
    // products node
    $response["products"] = array();
 
    while ($row = $result->EOF == FALSE) {
        // temp user array
        $product = array();
        $product["Codice"] = $row["Codice"];
        $product["Descrizione"] = $row["descrizione"];
        $product["PrezzoCo"] = $row["PrezzoCo"];
        $product["PrezzoPu"] = $row["PrezzoPu"];
        
        // 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);

}
?>

[clasku]

no, ti mancano un po' di passaggi
leggi qui http://www.html.it/articoli/php-e-microsoft-access-1/ (pagina 7)

[Nio74]

Grazie Ho letto e provato e funziona ho fatto cosi le critiche sono bene accette

<?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);
}


?>