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);
return $db;
}
function show_app()
{
$db_name="workshop";
$linkdb=open_db($db_name);
$q_ws="select id, giv_name,fam_name, institution, country,cale_pdf,date_reg,time_reg,app_public from reg_stiinte 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[8]==1){
echo "
|
$i |
|
".stripslashes($row_q_ws[1]).' '.stripslashes($row_q_ws[2]).', '.stripslashes($row_q_ws[6]).' '.stripslashes($row_q_ws[7])." |
|
|
|
".stripslashes($row_q_ws[3]).', '.stripslashes($row_q_ws[4])." |
|
|
|
Submitted application |
";
$i=$i+1;
}
}
mysql_close($linkdb);
}
function show_aapp()
{
$db_name="workshop";
$linkdb=open_db($db_name);
$q_ws="select id, giv_name,fam_name,institution,country,accept_app from reg_stiinte where accept_app=1 order by fam_name asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
echo "
|
$i |
|
".stripslashes($row_q_ws[1]).' '.stripslashes($row_q_ws[2])." |
|
|
|
".stripslashes($row_q_ws[3]).', '.stripslashes($row_q_ws[4])." |
";
$i=$i+1;
}
mysql_close($linkdb);
}
?>
STIINTE
|
Copyright
©2007 by GPSM, COSPAR |