function updateDatabase() { global $labConfigId, $DB_HOST, $DB_USER, $DB_PASS; $country = strtolower(LabConfig::getUserCountry($labConfigId)); $saved_db = DbUtil::switchToCountry($country); $currentDir = getcwd(); $mainBlisDir = substr($currentDir, $length, strpos($currentDir, "htdocs")); //$blisLabBackupFilePath = "\"".$mainBlisDir.$backup_folder."\blis_".$lab_config_id."\blis_".$lab_config_id."_backup.sql\""; $sqlFilePath = "\"" . $mainBlisDir . "htdocs\\export\\temp.sql\""; $mysqlExePath = "\"" . $mainBlisDir . "server\\mysql\\bin\\mysql.exe\""; $dbname = "blis_" . $country; $command = $mysqlExePath . " -h {$DB_HOST} -P 7188 -u {$DB_USER} -p{$DB_PASS} {$dbname} < {$sqlFilePath}"; $command = "C: &" . $command; //the C: is a useless command to prevent the original command from failing because of having more than 2 double quotes echo $command; system($command, $return_var); if ($return_var == 0) { echo "true"; } else { echo "false"; } DbUtil::switchRestore($saved_db); }
public static function checkNameExists($name, $country) { # Checks if the given patient name (or similar match) already exists $saved_db = DbUtil::switchToCountry($country); $query_string = "SELECT COUNT(patient_id) AS val FROM patient WHERE name LIKE '%{$name}%'"; $resultset = query_associative_one($query_string); DbUtil::switchRestore($saved_db); if ($resultset == null || $resultset['val'] == 0) { return false; } else { return true; } }
<?php include "../includes/db_lib.php"; include "../includes/script_elems.php"; $patientId = $_REQUEST['pid']; $type = $_REQUEST['type']; $script_elems = new ScriptElems(); $script_elems->enableTableSorter(); $script_elems->enableJQueryForm(); if ($type == 'national') { $user = get_user_by_id($_SESSION['user_id']); $country = strtolower($user->country); $saved_db = DbUtil::switchToCountry($country); $patient = Patient::getById($patientId); DbUtil::switchRestore($saved_db); $lab_config = LabConfig::getById($_SESSION['lab_config_id']); ?> <table class='hor-minimalist-b' <?php if ($width != "") { echo " style='width:" . $width . "px;' "; } ?> > <tbody> <tr> <td><u><?php echo LangUtil::$generalTerms['NAME']; ?> </u></td> <td><?php echo $patient->getName();