//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
No comments:
Post a Comment