<?php
header('Content-Type: application/json');
$servername = "utb-mysql.du.se";
$username = "db30";
$password = "FJJAcyMU";
$dbname = "db30";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully ";


$sql = "SELECT artnr, produktnamn, kategori, pris FROM h14joavi_IK2019";
$r = mysqli_query($conn, $sql);

$result = array();

while($row = mysqli_fetch_array($r)){
    array_push($result,array(
        'artnr'=>$row['artnr'],
        'produktnamn'=>$row['produktnamn'],
        'kategori'=>$row['kategori'],
        'pris'=>$row['pris']

    ));
}

echo json_encode(array('result'=>$result),JSON_PRETTY_PRINT);


mysqli_close($conn);
?>