//general to open database connections and tables
	include("config.php");
	include("functions.php");

	$conn=&open_connection($db_params);
	session_start();
	






 //general to open database connections and tables
	define("HTTP_SERVER","http://" . $_SERVER['HTTP_HOST']."/travels/" );
	define("SCRIPT_FILE",(isset($_SERVER['PHP_SELF']) ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME']));
	$db_params=array();
	$db_params["server"]="localhost";
	$db_params["username"]="root";
	$db_params["password"]="";
	$db_params["database"]="working_capital";





	//general functions used in all php files
	
	// to create connection to work on database
	
	function &open_connection($db_params){
		 $link = mysql_connect($db_params["server"], $db_params["username"], $db_params["password"]);		//connect
		//$link = mysql_connect('localhost', 'root', '');		//connect
		
		if ($link){
			 mysql_select_db($db_params["database"]); //select database
			//mysql_select_db('travels_invoice'); //select database
			return $link;
		}
	}
	
	function close_connection($db_conn){
		return mysql_close($db_conn);
	}
	
	//execute db query
	function execute($query,$db_conn){
		$result = mysql_query($query, $db_conn) or error($query, mysql_errno(), mysql_error());
		return $result;
	}
	
	//display error
	function error($query, $errno, $error) { 
		
	}
	
	//fetch row from tables
	function fetch_row($resource,$type=MYSQL_ASSOC){ //MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH.
		return mysql_fetch_array($resource,$type);
	}
	
	
	function num_rows($resource){
		return mysql_num_rows($resource);
	}
	
	function redirect($url){
	    header('Location: ' . $url);
		exit();
	}
	
	//execute indert/update query
	function update_data($table, $data,$link,$action = 'insert', $parameters = '') 
	{
		reset($data);
		if ($action == 'insert') {
		  $query = 'insert into ' . $table . ' (';
		  while (list($columns, ) = each($data)) {
			$query .= $columns . ', ';
		  }
		  $query = substr($query, 0, -2) . ') values (';
		  reset($data);
		  while (list(, $value) = each($data)) {
			switch ((string)$value) {
			  case 'now()':
				$query .= 'now(), ';
				break;
			  case 'curdate()':
				$query .= 'curdate(), ';
				break;
			  case 'null':
				$query .= 'null, ';
				break;
			  default:
				$query .= '\'' . db_input($value) . '\', ';
				break;
			}
		  }
		  $query = substr($query, 0, -2) . ')';
		} elseif ($action == 'update') {
		  $query = 'update ' . $table . ' set ';
		  while (list($columns, $value) = each($data)) {
			switch ((string)$value) {
			  case 'now()':
				$query .= $columns . ' = now(), ';
				break;
			 case 'curdate()':
				$query .= $columns .' = curdate(), ';
				break;	
			  case 'null':
				$query .= $columns .= ' = null, ';
				break;
			  default:
				$query .= $columns . ' = \'' . db_input($value) . '\', ';
				break;
			}
		  }
		  $query = substr($query, 0, -2) . ' where ' . $parameters;
	}
	//echo $query;
	return execute($query, $link);
	}
  
 	//return inserted id 
 	function insert_id($conn)
	{
		return mysql_insert_id($conn);
	}
	
	function db_output($string) 
	{
		return htmlspecialchars($string);
	}
	
	//formatting  input
	function db_input($string) 
	{
		return addslashes($string);
	}
	
	function db_prepare_input($string) {
		if (is_string($string)) {
		  return trim(stripslashes($string));
		} elseif (is_array($string)) {
		  reset($string);
		  while (list($key, $value) = each($string)) {
			$string[$key] = db_prepare_input($value);
		  }
		  return $string;
		} else {
		  return $string;
		}
	}
	
	
	function dblookup($query,$link){
		$result=execute($query,$link);
		$row=fetch_row($result,MYSQL_NUM);
		mysql_free_result($result);
		return $row[0];
	}
	
	function is_value($value) {
		if (is_array($value)) {
		  if (sizeof($value) > 0) {
			return true;
		  } else {
			return false;
		  }
		} else {
		  if ( (is_string($value) || is_int($value)) && ($value != '') && ($value != 'NULL') && (strlen(trim($value)) > 0)) {
			return true;
		  } else {
			return false;
		  }
		}
	  }
		
	function html_image($src,$width="",$height="",$alt="",$parameters="")
	{
		$image = '$page

"; } else { $nav .= "

$page

"; } } */ if ($pageNum > 1) { $page = $pageNum - 1; $prev = "Prev | "; $first = " First | "; } else { //$page = $pageNum + 1; $prev = 'Prev | '; $first = 'First | '; } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = "Next | "; $next = "Next | "; $last = "Last"; } else { $next = "Next | "; $last = "Last"; } return "

$first

$prev

$nav

$next

$last

"; }