<?
//set variables for connecting to mysql

$myhostname = "192.168.1.39";
$myusername = "root";
$mypassword = "090407";
$mydbname = "mit";
$mytablename = "timerec";

//set variables for connecting to mssql

//$mshostname = "192.168.1.7";
//$msusername = "root";
//$mspassword = "123456";
//$msdbname = "PhanthongHRM";
//$mstablename = "[dbo].[Mstimerec]";


$serverName = "192.168.1.7"; //serverName\instanceName
	$connectionInfo = array( "Database"=>"PhanthongHRM", "UID"=>"root", "PWD"=>"123456", "CharacterSet" => "UTF-8");
	$conn = sqlsrv_connect( $serverName, $connectionInfo);
	if( $conn ) {
				
	}else{
		 //echo "Connection could not be established.<br />";
		 die("Connection could not be established");
	}

//connect to mysql server, select database and delete contents

mysql_pconnect($myhostname,$myusername,$mypassword) OR DIE("MySQL Database connection failed.");

mysql_select_db($mydbname) or DIE("MySQL DB unavailable");

//connect to mssql server and select database

//mssql_pconnect($mshostname,$msusername,$mspassword) OR DIE("MSSQL Database connection failed.");

//mssql_select_db($msdbName) or DIE("MSSQL DB unavailable");

//$sql_delete = "DELETE FROM paul WHERE id>=0";

//mysql_query($sql_delete);
//query to get required fields from finesse

$mysql_out = "SELECT * FROM timerec";

//run the query on the timerec database

$query = mysql_query($mysql_out);

printf("<table border=1 width=100%%>");
//loop to get each row from mysql

	while ($line = mysql_fetch_array($query)) {
//print results in html table

	echo "<tr><td>",$line["hn"];
	echo "</td><td>",$line["date"];
	echo "</td><td>",$line["vcode"];
	echo "</td><td>",$line["type"];
	echo "</td></tr>";

	//$hn_out = $line["hn"];
	//$date_out = $line["date"];
	//$vcode_out = $line["vcode"];
	//$type_out = $line["type"];


//connect to mssql server, select db and insert row

	//mssql_pconnect($mshostname,$msusername,$mspassword) OR DIE("MsSQL Database connection failed during loop.");

	//mssql_select_db($msdbname) or DIE("MsSQL DB unavailable during loop.");

	//$sql_in = "INSERT INTO $mstablename (mshn,msdate,msvcode,mstype) VALUES ('$hn_out','$date_out','$vcode_out','$type_out')";
	//$sql_in = "INSERT INTO dbo.[Mstimerec] ([mshn],[msdate],[msvcode],[mstype]) VALUES ('$hn_out','$date_out','$vcode_out','type_out')";

	//mssql_query($sql_in);
//reconnect to mysql server

	//mysql_pconnect($myhostname,$myusername,$mypassword) OR DIE("MySQL Database connection failed during loop.");

	//mysql_select_db($msdbName) or DIE("MySQL DB unavailable during loop.");
} //close loop
printf("</table>");
?>