intip.in/sparqlauto

<?php
include( 'library/csc_pdo.php' );
$db = new CsC_PDO( $db_user, $db_pass, $dbname );

$isi = "
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix ex: <http://example.com/filariasis.csv> .

ex:provinsi a rdfs:Class .
ex:penyakit a rdfs:Class .


ex:nama_provinsi a rdf:Property .
ex:nama_provinsi rdfs:domain ex:provinsi .
ex:nama_provinsi rdfs:range xsd:string .

ex:pemberian_asi_2013 a rdf:Property .
ex:pemberian_asi_2013 rdfs:domain ex:penyakit .
ex:pemberian_asi_2013 rdfs:range xsd:float .

ex:terjangkit a rdf:Property .
ex:terjangkit rdfs:domain ex:penyakit .
ex:terjangkit rdfs:range xsd:integer .

ex:penderita_balita_u1 a rdf:Property .
ex:penderita_balita_u1 rdfs:domain ex:penyakit .
ex:penderita_balita_u1 rdfs:range xsd:integer .

ex:penderita_balita_1to4 a rdf:Property .
ex:penderita_balita_1to4 rdfs:domain ex:penyakit .
ex:penderita_balita_1to4 rdfs:range xsd:integer .

";

$f = $db->r( 'bro', '*', 'GROUP BY nama_provinsi' );
foreach ( $f as $r ) {
    $prov = $r['nama_provinsi'];
    $provs = str_replace( ' ', '_', $r['nama_provinsi'] );
    $asi = str_replace( ',', '.', $r['pemberian_asi'] );
    $isi .= "
ex:$provs a ex:provinsi .
ex:$provs ex:nama_provinsi \"$prov\" .
ex:$provs ex:pemberian_asi_2013 $asi .
    ";
}

$f = $db->r( 'bro', '*' );
foreach ( $f as $r ) {
    $prov = $r['nama_provinsi'];
    $provs = str_replace( ' ', '_', $r['nama_provinsi'] );
    $isi .= "
ex:$provs ex:terjangkit ex:pneumonia_ringan_" . $provs . "_2012 .
ex:pneumonia_ringan_" . $provs . "_2012 ex:penderita_balita_u1 354 .
ex:pneumonia_ringan_" . $provs . "_2012 ex:penderita_balita_1to4 1316 .

ex:$provs ex:terjangkit ex:pneumonia_berat_" . $provs . "_2012 .
ex:pneumonia_berat_" . $provs . "_2012 ex:penderita_balita_u1 25 .
ex:pneumonia_berat_" . $provs . "_2012 ex:penderita_balita_1to4 23 .
";
}

echo $isi;