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();