<?php
include 'pass.php';
define("DB_host", $host);
define("DB_name", $dbname);
define("DB_username", $username);
define("DB_pass", $pass);
define("DB_port", $port);
if (isset($_POST['func'])) {
if ($_POST['func'] == 'getNodes') {
getNodes();
} else {
if ($_POST['func'] == 'getEdges') {
getEdges();
}
}
}
function connect()
{
return pg_connect("host=" . DB_host . " dbname=" . DB_name . " user="******" password="******" port=" . DB_port) or die('Could not connect: ' . pg_last_error());
}
function close($result, $dbconn)
{
pg_free_result($result);
pg_close();
}
function getNodes()
{
$conn = connect();
$query = 'SELECT * FROM node';
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
//. substr($rows['name_team'], -5, 2) ;
//$json['source'] = uniqid();
$json['selected'] = 'false';
$json['interaction'] = $coulor;
$data['data'] = $json;
array_push($nodes, $data);
}
//$nodes['nodes'] = $tmp;
//var_dump($nodes);
return $nodes;
}
$allNodes = array_merge(getNode($infoEquip), getNode($infoProf), getNode($infoPublication), getNode($infoLabo), getNode($infoUniv));
//var_dump($allNodes);
$nodes['nodes'] = $allNodes;
//var_dump(getEdges($infoProfPublication));
$allEdges = array_merge(getEdges($infoProfTeam), getEdges($infoProfPublication), getEdges($infoEquipLabo), getEdges($infoLaboUniv));
$edges['edges'] = $allEdges;
//getEdges($infoProfTeam);
$allData = array_merge($nodes, $edges);
//var_dump($allData);
$elements['elements'] = $allData;
//var_dump($elements);
//echo "<br>";
//echo "<br>";
//echo "<br>";
//$file = fopen('dataRead.json', 'w');
//fwrite($file, json_encode($elements));
//fclose($file);
echo json_encode($elements);
//http://www.kodingmadesimple.com/2015/01/convert-mysql-to-json-using-php.html
?>
