Sto provando ad utilizzare questa classe, ho copiato pari pari dalla documentazione un esempio
ma non mi da nessun risultato ne nessun errore
Codice PHP:
$metabasedir = '/u/lavori/nbo/sito/client/class/metabase';
ini_set("include_path", ini_get("include_path").":$metabasedir");
require("class/metabase/metabase_interface.php");
require("class/metabase/metabase_database.php");
$dsn=array(
"Type"=>"mysql",
"IncludePath"=>$metabasedir,
"Host"=>"",
"User"=>"root",
"Password"=>"sdfsegft",
"Persistent"=>1,
"DecimalPlaces"=>2
);
$dbname="plyocity_admin";
# Setup the database connection
$error=MetabaseSetupDatabaseObject($dsn,&$db);
if($error!="") {
echo "Error while setting database access instance: $error";
exit;
} else {
//MetabaseSetDatabase($db,$dbname);
$db->SetDatabase($dbname);
}
$query = "SELECT f_name, l_name from athlete LIMIT 5,20;";
$result= $db->Query($query);
if ($db->GetColumnNames($result, $cn) AND $db->FetchResultAll($result, &$all)) {
// Iterate through the results
foreach ($all as $rsNames) {
print $rsNames[ $cn['l_name'] ] . ", " . $rsNames[ $cn['f_name'] ] . "
";
}
} else {
$error=$db->Error;
print_r($error);
}
?>