function putRoomsToDatabase(&$arr, $rcount)
{
$path_to_hostconfig = $_SERVER['DOCUMENT_ROOT'] . "/php/hostconfig.php";
include_once $path_to_hostconfig;
$path_to_cdbconn = $_SERVER["DOCUMENT_ROOT"] . "/php/CDBConn.php";
include_once $path_to_cdbconn;
$my_conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", FALSE);
$my_conn->connect();
for ($i = 1; $i <= $rcount; $i++) {
$nazv = "nazv" . $i;
$room_info[$i] .= "<br><br>Room name: " . $arr[$nazv];
$type_id = "type" . $i;
$q_select = "SELECT room_type_name FROM room_type WHERE room_type_id = '" . $arr[$type_id] . "'";
$my_conn->run_query($q_select);
$line = pg_fetch_array($my_conn->getResult());
$type_name = "type_name" . $i;
$arr[$type_name] = $line[0];
$room_info[$i] .= "<br><br>Category of room: " . $arr[$type_name];
$capacity = "capacity" . $i;
$room_info[$i] .= "<br><br>Capacity of the room: " . $arr[$capacity];
//$q_insert = "INSERT INTO room (room_name, room_type_id, bed_count) VALUES('".$arr[$nazv]."',".$arr[$type_id].",".$arr[$capacity].")";
//$my_conn->run_insert($q_insert);
}
$my_conn->close();
return $room_info;
}
<?php
$path_to_hostconfig = $_SERVER["DOCUMENT_ROOT"] . "/php/hostconfig.php";
$path_to_cdbconn = $_SERVER["DOCUMENT_ROOT"] . "/php/CDBConn.php";
include_once $path_to_hostconfig;
include_once $path_to_cdbconn;
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123");
$conn->connect();
$sql = "SELECT * FROM room_types";
$conn->run_query($sql);
$data = array();
/*while ($line = pg_fetch_array($conn->getResult()))
{
// echo $arr["room_type_id"].$arr["room_type_name"]."<br>";
$data[$line["room_type_id"]] = $line["room_type_name"];
}
foreach($data as $id => $name)
{
echo $id.$name."<br>";
}*/
while ($line = pg_fetch_row($conn->getResult())) {
$data[] = $line;
}
echo json_encode($data);
$conn->close();
