close();
} else {
$db = new SQLite3($dbFile);
if (!$db) {
die("Database connection failed: " . $db->lastErrorMsg());
}
}
$query = "SELECT id, projectname, clientprogress, clientid FROM projects";
$result = $db->query($query);
$trackingNumberbase64String = isset($_GET['project-id']) ? $_GET['project-id'] : 'No tracking number provided';
$trackingNumber = base64_decode($trackingNumberbase64String);
// "";
//echo "";
$projectName = "";
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$projectId = $row['id'];
$formattedprojectId = ($projectId < 10) ? "0$projectId" : "$projectId";
$dataParts = explode('«', $row['clientprogress'] );
$projectstartdate = $dataParts[0];
$projectstartyear = substr($projectstartdate, 0, 4);
$projectnumber = $projectstartyear . $formattedprojectId;
if ($projectnumber == $trackingNumber) {
$projectNameUpdate = $row['projectname'];
$projectNameUpdate = str_replace('-LBR', '&', $projectNameUpdate);
$projectName = $projectNameUpdate;
$projectid = $row['id'];
$projectProgressUpdate = $row['clientprogress'];
$projectProgressUpdate = str_replace('-LBR', '&', $projectProgressUpdate);
$projectprogress = $projectProgressUpdate;
$clientid = base64_encode($row['clientid']);
// echo
}
}
?>
Project Tracking
Project Name:
$projectName";
?>
Completion Status: