Travancore Devaswom Board ยป FEEDBACK

FEEDBACK

[php]

$con=mysql_connect(‘localhost’,'mysqluser’,'tspl678′);
$cn_db=mysql_select_db(‘sabarimala_acc’,$con);
function getBrowser()
{
$u_agent = $_SERVER['HTTP_USER_AGENT'];
$bname = ‘Unknown’;
$platform = ‘Unknown’;
$version= “”;

//First get the platform?
if (preg_match(‘/linux/i’, $u_agent)) {
$platform = ‘linux’;
}
elseif (preg_match(‘/macintosh|mac os x/i’, $u_agent)) {
$platform = ‘mac’;
}
elseif (preg_match(‘/windows|win32/i’, $u_agent)) {
$platform = ‘windows’;
}

// Next get the name of the useragent yes seperately and for good reason
if(preg_match(‘/MSIE/i’,$u_agent) && !preg_match(‘/Opera/i’,$u_agent))
{
$bname = ‘Internet Explorer’;
$ub = “MSIE”;
}
elseif(preg_match(‘/Firefox/i’,$u_agent))
{
$bname = ‘Mozilla Firefox’;
$ub = “Firefox”;
}
elseif(preg_match(‘/Chrome/i’,$u_agent))
{
$bname = ‘Google Chrome’;
$ub = “Chrome”;
}
elseif(preg_match(‘/Safari/i’,$u_agent))
{
$bname = ‘Apple Safari’;
$ub = “Safari”;
}
elseif(preg_match(‘/Opera/i’,$u_agent))
{
$bname = ‘Opera’;
$ub = “Opera”;
}
elseif(preg_match(‘/Netscape/i’,$u_agent))
{
$bname = ‘Netscape’;
$ub = “Netscape”;
}

// finally get the correct version number
$known = array(‘Version’, $ub, ‘other’);
$pattern = ‘#(?‘ . join(‘|’, $known) .
‘)[/ ]+(?[0-9.|a-zA-Z.]*)#’;
if (!preg_match_all($pattern, $u_agent, $matches)) {
// we have no matching number just continue
}

// see how many we have
$i = count($matches['browser']);
if ($i != 1) {
//we will have two since we are not using ‘other’ argument yet
//see if version is before or after the name
if (strripos($u_agent,”Version”) < strripos($u_agent,$ub)){
$version= $matches['version'][0];
}
else {
$version= $matches['version'][1];
}
}
else {
$version= $matches['version'][0];
}

// check if we have a number
if ($version==null || $version=="") {$version="?";}

return array(
'userAgent' => $u_agent,
‘name’ => $bname,
‘version’ => $version,
‘platform’ => $platform,
‘pattern’ => $pattern
);
}
$ua=getBrowser();
if (isset($_POST['submit_feed'] )){

$browser=$ua['name'];
$version=$ua['version'];
$platform=$ua['platform'];
$user_agent=$ua['userAgent'];

$ip_add= $_SERVER['REMOTE_ADDR'];

$name=$_POST['contact'];
$email_id=$_POST['email'];
$comment=$_POST['cmt'];
$c_date= date(‘Y-m-d H:i:s’);
$status=0;
$qry=”INSERT INTO `feedback`(`ip_add`, `name`, `email_id`, `comment`, `c_date`, `browser`, `version`, `platform`, `user_agent`, `status`) VALUES (‘$ip_add’,'$name’,'$email_id’,'$comment’,now(),’$browser’,'$version’,'$platform’,'$user_agent’,0)”;

$dn=mysql_query($qry,$con);
if($dn==1)
{
echo “

Thanks for your valuable feedback.
“;
}
}
[/php]

Contact Name
Email ID
Comments