<?php

include('db_core.php');
include('station_info.php');

function sourceName($src,$conn) {
        $results=exec_query_table("select * from station_info where station_key='$src';",$conn);
       foreach ($results as $result){
                $result['name'];
        }
        return $result['name'];
}

 function destName($dest,$conn) {
        $results=exec_query_table("select * from station_info where station_key=$dest;",$conn);
       foreach ($results as $result){
                $result['name'];
        }
        return $result['name'];
}

function changeSrc($source,$destination,$src_nm,$dest_nm,$conn)
{
	$results=exec_query_table("select * from bus_info where src=$source and dest=$destination;",$conn);

	foreach($results as $result)
	{
$result['src']=$src_nm;
$result['dest']=$dest_nm;
		print $result['bus_no'].$result['seats'].$result['src'].$result['dest'].$result['fare'].$result['seat_style'].$result['bus_type'].$result['seats'].$result['arrival_time'].$result['dep_time'].$result['halt_service_date'].$result['halt_duration'].$result['vendor_name'];
				print "<br>";
	}

}
$conn=connectToDb('localhost','decib1iu_root','123','decib1iu_inktat');

if($_GET['source'] && $_GET['dest'])
{
$src= sourceName($_GET['source'],$conn);
$dest= destName($_GET['dest'],$conn);
changeSrc($_GET['source'],$_GET['dest'],$src,$dest,$conn);
		mysql_close($conn);
        return 0;
}

?>