OS_lab4_codeAndSites

<?php
 //  Configure DB Parameters
$dbconnection = pg_connect("host=localhost user=test-user dbname=test_db password=test-user");


$query1 = 'SELECT * FROM test_tb';
$result1 = pg_query($query1) or die('Query failed: ' . pg_last_error());
// Вывод результатов в HTML

$query2 = 'SELECT * FROM test_tb WHERE mark > 3';
$result2 = pg_query($query2) or die('Query failed: ' . pg_last_error());

$query3 = 'SELECT * FROM test_tb WHERE mark <= 3';
$result3 = pg_query($query3) or die('Query failed: ' . pg_last_error());

printQueryAndResult($query1, $result1);
printQueryAndResult($query2, $result2);
printQueryAndResult($query3, $result3);



function printQueryAndResult($query, $result){
	echo $query;
	echo "<table>\n";
	while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
    	echo "\t<tr>\n";
    	foreach ($line as $col_value) {
        	echo "\t\t<td>$col_value</td>\n";
    	}
    echo "\t</tr>\n";

}
	echo "</table>\n";
   	echo "<br>";
}
?>

//sites
https://www.dmosk.ru/miniinstruktions.php?mini=nginx-centos-install
https://stackoverflow.com/questions/8140863/unable-to-connect-to-postgresql-server-could-not-connect-to-server-permission
https://varunver.wordpress.com/2016/06/03/centos-7-install-php-and-postgres/