$dblink = mysql_pconnect("mrl.isr.uc.pt", "mrlpublicaccess", "jpoeadoro135");
if (!$dblink) {
die('Impossível ligar à base de dados: ' . mysql_error() . "\n");
}
else{
//selecciona a base de dados
$db_selected = mysql_select_db('mrl');
if (!$db_selected) {
echo 'Base de dados inexistente: ' . mysql_error() . "\n";
}
}
$pre = 'http://paloma.isr.uc.pt/mrl/?w=';
$query = "select Ptype.name as ptname,
Projects.logo,
Projects.name,
ProjectArea.name as pjarea,
sponsors,
timespan,
link,
poster,
prospect,
active,
description
from Projects, Ptype, ProjectArea
where Projects.ptype = Ptype.ID
and Projects.area = ProjectArea.ID and Projects.ID =".$_GET['ID'];
$result = mysql_query($query)
or die ("Couldn't execute query.");
$num_rows = mysql_num_rows($result);
if ($num_rows) {
echo "
";
while ( $row = mysql_fetch_array($result)){
extract($row);
echo "";
if($logo)
echo " | ";
else
echo "
";
echo("");
echo " $name |
";
echo "Project Type: $ptname |
";
echo "Research Field: $pjarea |
";
if (strlen($sponsors) > 2 ) echo "Sponsors: $sponsors |
";
if (strlen($timespan) > 2 ) echo "Time span: $timespan |
";
if (strlen($link) > 2) echo "
Webpage |
";
if($poster){
echo "";
}
if($prospect){
echo "";
}
echo " Description: $description |
";
}
echo "
";
}
//********************************* Projects *****************************************
$query = "select pj.ID, a.projectb, pjb.name, pjb.logo
from Projects pj,
(select pa.ID, propro.projecta, propro.projectb
from Projects pa, propro
where pa.ID = propro.projecta
union
select pa.ID, propro.projectb, propro.projecta
from Projects pa, propro
where pa.ID = propro.projectb
) a, Projects pjb
where a.ID = pj.ID
and pj.ID = a.projecta
and pjb.ID = a.projectb
and pj.ID= ".$_GET['ID']."
order by pj.ID";
$result = mysql_query($query)
or die ("Couldn’t execute query.
$query
".mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows) echo("Related Projects
");
echo("");
while ( $row = mysql_fetch_array($result)){
extract($row);
echo "";
if($logo){
echo "";
echo " | ";
}
else{
echo "";
echo " | ";
}
echo "";
echo "".$name." |
";
// echo("".$name."
");
}
echo("
");
//********************************* People *****************************************
// this part was written by pedrotrindade@isr.uc.pt - 15/Nov/2011
$query = "select * from mrl.peopro left join mrl.People on mrl.peopro.people = mrl.People.ID
where mrl.peopro.project=".$_GET['ID']."
and peopro.active = 1 and peopro.public = 1
order by mrl.People.ID";
$result = mysql_query($query)
or die ("Couldn't execute query.
$query
".mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows) echo("Related People
");
echo("");
while ( $row = mysql_fetch_array($result)){
extract($row);
echo "";
if($photo){
echo "";
echo " | ";
}
else{
echo "";
echo " | ";
}
echo "";
echo "".$name." |
";
}
echo("
");
// *** END of PEOPLE
mysql_close($dblink);
include 'config.php';
include 'opendb.php';
?>