Connect ( $config['db']['server'], $config['db']['username'], $config['db']['password'], $config['db']['dbname'] );
}
function validaConexion($origen, $verbose = false) {
global $connection;
$result = $connection->Execute('select 1');
if ($result == null || $result->EOF) {
if ($verbose) {
echo date('Y-m-d H:i:s') . ': ['.$origen.'] validaConexion: result=';
print_r($result);
}
iniciarConexion($verbose);
}
}
function iniciarConexionVUS($verbose = false) {
global $connectionVUS, $config;
if ($verbose)
echo date('Y-m-d H:i:s') . ': Restarting conexion to APPLICANTS Database.'."\n";
$connectionVUS = NewADOConnection ( $config['db1']['driver'] );
$connectionVUS->Connect ( $config['db1']['server'], $config['db1']['username'], $config['db1']['password'], $config['db1']['dbname'] );
}
function iniciarConexionINS($verbose = false) {
global $connectionINS, $config;
// if ($verbose)
// echo date('Y-m-d H:i:s') . ': Restarting conexion to INSPECTORS Database.'."\n";
// $connectionINS = NewADOConnection ( $config['db2']['driver'] );
// $connectionINS->Connect ( $config['db2']['server'], $config['db2']['username'], $config['db2']['password'], $config['db2']['dbname'] );
}
iniciarConexion();
function creacombo($sql1, $cod) {
global $connection;
echo $sql;
$result = $connection->Execute ( $sql1 );
if (! $result->EOF) {
while (!$result->EOF) {
list ( $valor, $descripcion ) = $result->fields;
/*
if ($valor == $cod) {
echo "";
} else {
*/
echo "";
//}
$result->MoveNext();
}
} else {
echo "";
}
}
function clean_string($string) {
$string = trim($string);
$search = array ('/á/', '/é/', '/í/', '/ó/', '/ú/', '/ñ/');
$replace = array ('á','é','í','ó','ú','ñ');
$string = preg_replace ($search, $replace, $string);
return $string;
}
function dirt_string($string) {
$search = array ('/á/', '/é/', '/í/', '/ó/', '/ú/', '/ñ/');
$replace = array ('á','é','í','ó','ú','ñ');
$string = preg_replace ($search, $replace, $string);
return $string;
}
?>