<?php
    $dbhost = 'localhost';
    $dbuser = 'dbuser';
    $dbpass = 'dbpass';
    $dbname = 'dbname';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Errorconnecting to mysql');
mysql_select_db($dbname);

header("Content-Type: application/json");


if (isset($_GET['id'])){
    $ID = mysql_real_escape_string($_GET['id']);
    if(!ctype_digit($ID) ){
        exit('[{"error":"no id passed"}]');
    }
} else exit('[{"error":"no id passed"}]');


$sql = "SELECT * FROM patrick WHERE ID = '{$ID}'";
$query = mysql_query($sql) or die();

$num_rows = mysql_num_rows($result);

if(($num_rows) == 0) {
    echo '[{"error":"Er is helaas geen artiekel gevonden"}]';
} else {



    $str = "";

    while($row = mysql_fetch_assoc($result)){
            //print_r($row);

            $onderzoek = mysql_real_escape_string($row['onderzoek']);
            $informatie = mysql_real_escape_string($row['informatie']);
            $nieuws =  mysql_real_escape_string($row['nieuws']);

            $str .= '{"onderzoek":"'.$onderzoek.'","informatie":"'.$informatie.'","nieuws":"'.$nieuws.'"},';

    }

    $str = $str = substr($str,0,-1);

    echo $str;
    //mysql_close($con);
}
?>