$db_host="mysql.server";
$db_user="ejadmin";
$db_pass="ejadminbt456";
$db_name="ej";
$db = new mysqli($db_host, $db_user, $db_pass, $db_name);
function GetCategoryName($catid)
{
switch($catid)
{
case 1:
return 'Eureka - Computer Sci. & Engg.';
case 2:
return 'Eureka - Electronics Engg.';
case 3:
return 'Eureka - Chemical Engg.';
case 4:
return 'Eureka - Civil Engg.';
case 5:
return 'Eureka - Biotechnology Engg.';
case 6:
return 'Eureka - Information Technology';
case 7:
return 'Eureka - Mechanical Engg.';
case 8:
return 'Jidnyasa';
case 9:
return 'Survivor';
}
}
function GetUserRegIDFromRegID($regid)
{
$db_host="mysql.server";
$db_user="ejadmin";
$db_pass="ejadminbt456";
$db_name="ej";
$db = new mysqli($db_host, $db_user, $db_pass, $db_name);
$res = $db->query(“select * from registrants where regid={$regid}”);
$arr = $res->fetch_assoc();
$res->close();
$prepend = ”;
$cat = $arr['category'];
switch($cat)
{
case 1:
$prepend = ‘ESO’;
break;
case 2:
$prepend = ‘ESP’;
break;
case 3:
$prepend = ‘EVI’;
break;
case 4:
$prepend = ‘ECO’;
break;
case 5:
$prepend = ‘EBI’;
break;
case 6:
$prepend = ‘ETE’;
break;
case 7:
$prepend = ‘EPE’;
break;
case 8:
$prepend = ‘JID’;
break;
case 9:
$prepend = ‘SUR’;
break;
}
$usrid = $prepend . $regid;
return $usrid;
}

function GetRegIDFromUserRegID($usrid)
{
return substr($usrid, 3);
}

?>

Important Information

• Two hard copies of your entire paper(any format of your choice)
• One soft copy of your presentation.
• Photo and ID proof.
• Please bring your receipt
• Event Date: 20th March
• Registration Time: 9:00am
• Project: Send your requirements mentioning department on following ID, jidnyasa2k11@tkietwarana.org

Eureka

Softcom – Computer Science & Engg.

$res = $db->query(“select * from registrants where selected=1 and category=1″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Spectrum – Electronics Engg.

$res = $db->query(“select * from registrants where selected=1 and category=2″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Visiochem – Chemical Engg.

$res = $db->query(“select * from registrants where selected=1 and category=3″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Constrofest – Civil Engg.

$res = $db->query(“select * from registrants where selected=1 and category=4″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Biotrans – Biotech. Engg.

$res = $db->query(“select * from registrants where selected=1 and category=5″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Technovision – Information Technology

$res = $db->query(“select * from registrants where selected=1 and category=6″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Perspecto-Mech – Mechanical Engg.

$res = $db->query(“select * from registrants where selected=1 and category=7″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>

Jidnyasa

function GetDepNameFromID($id)
{
switch($id){
case 1:
return 'Computer Sci. & Engg.';
case 2:
return 'Electronics Engg.';
case 3:
return 'Chemical Engg.';
case 4:
return 'Civil Engg.';
case 5:
return 'Biotechnology Engg.';
case 6:
return 'Information Technology';
case 7:
return 'Mechanical Engg.';

}
}
$res = $db->query(“select * from registrants where selected=1 and category=8″);
while($arr = $res->fetch_assoc())
{
echo ‘

‘;
}
?>