<?php

header('content-type: application/json; charset=utf-8');


$success = 'true';

$message = "Загруженные данные";



$connectString = 'host=localhost dbname=stocks_db user=postgres password=95161617';

$link = pg_connect($connectString);

if (!$link) {

    $success = 'false';

    $message = "Ошибка соединения";

} else {
    $sql = "select *, open - last as change from stocks";

    if( !$result = pg_query($link, $sql) ) {

        $success = 'false';

        $message = "Ошибка выполнения запроса;

    };

    $rows = array();

    while($r = pg_fetch_assoc($result)) {


        switch ($r['split']) {
            case 't': $r['split']=true;
                break;
            case 'f': $r['split']=false;
                break;
        }
        $rows[] = $r;


    }

}

print "{"success":$success,"message":"$message","data":";

print json_encode($rows);

print "}";
?>