function open_db($name_db)
{
$db=mysql_connect("localhost","costel", "costel1879");
if(!$db){
echo "Error -- Cannot connect to database";
exit;
}
mysql_select_db($name_db);
//echo "ok opendb";
return $db;
}
function show_abstr_for_reg($id_registration)
{
$uploaddir = '/gpsm/ws_ro/cw19/doc/abstracts/';
$db_name="cw18";
$linkdb=open_db($db_name);
$q_ws="select title, authors, afil, file, id_abstr from abstract where id_reg=$id_registration and del=0 order by date asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
echo "
";
while($row_q_ws=mysql_fetch_row($rq_ws)){
//if($row_q_ws[5]==0 && $row_q_ws[1]){
$link_abstr=$uploaddir.$row_q_ws[3];
if ($row_q_ws[3]){
echo "".stripslashes($row_q_ws[0])." |
";
}else{
echo "".stripslashes($row_q_ws[0])." |
";
}
echo "$row_q_ws[1] |
$row_q_ws[2] |
|
";
$i=$i+1;
//}
}
echo " |
";
mysql_close($linkdb);
}
function show_abstr_all()
{
//$uploaddir = '/gpsm/ws_ro/cw19/doc/abstracts/';
$db_name="cw18";
$linkdb=open_db($db_name);
$q_ws="select id from reg_clws where accept=0 order by data asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
//if($row_q_ws[5]==0 && $row_q_ws[1]){
//echo $row_q_ws[0];
show_abstr_for_reg($row_q_ws[0]);
$i=$i+1;
//}
}
mysql_close($linkdb);
}
function show_reg()
{
$db_name="cw18";
$linkdb=open_db($db_name);
$q_ws="select id, first_name, last_name, institute, country, accept from reg_clws order by last_name asc" ;
//echo $q_ws;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
if($row_q_ws[5]==0 && $row_q_ws[1]){
$link_abstr=$uploaddir.$row_q_ws[4];
//echo $link_abstr;
echo "
|
|
".stripslashes($row_q_ws[1])." ".stripslashes($row_q_ws[2])." |
|
|
$row_q_ws[3], $row_q_ws[4] |
";
$i=$i+1;
}
}
mysql_close($linkdb);
}
function show_app_student()
{
$db_name="cw18";
$linkdb=open_db($db_name);
$q_ws="select id, name, institution, file from young order by date_app asc" ;
//echo $q_ws;
$uploaddir = '/gpsm/ws_ro/cw19/doc/student/';
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
//if($row_q_ws[5]==0 && $row_q_ws[1]){
$link_abstr=$uploaddir.$row_q_ws[3];
//echo $link_abstr;
echo "";
$i=$i+1;
//}
}
mysql_close($linkdb);
}
function show_pres()
{
$db_name="workshop";
$linkdb=open_db($db_name);
$q_ws="select id_reg, title, afil,prez_author,prez_src, pres_yn from ws_ro_07 order by date_reg asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
if($row_q_ws[5]==0 && $row_q_ws[1]){
echo "";
$i=$i+1;
}
//$i=$i+1;
}
mysql_close($linkdb);
}
?>
19th Cluster Workshop
|
|
|
19th Cluster Workshop |
Poiana Brasov, Romania, 18-21 May 2010 |
|
|
|
|