//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$first
$prev
$nav
$next
$last
