feat: implement issue #6

Resolves luca/thetool#6
Closes #6

public/api/health.php

@@ -1,50 +1,61 @@
 <?php
 /**
- * Health Check Endpoint
- * Returns application health status and database connectivity
+ * Health check endpoint for thetool
+ * Returns database table count for monitoring purposes
  */
 
-header('Content-Type: application/json');
+// Bootstrap the application
+if(file_exists("../../config/config.php")) {
+    require("../../config/config.php");
+} else {
+    header("Content-Type: application/json");
+    http_response_code(500);
+    echo json_encode(["status" => "error", "message" => "Configuration not found"]);
+    exit;
+}
 
-$health = [
-    'status' => 'ok',
-    'timestamp' => time()
-];
+// Define FronkDB constants if not already defined
+if(!defined('FRONKDB_SQLDEBUG')) {
+    define('FRONKDB_SQLDEBUG', false);
+}
 
-// Check database connection
-$dbConnected = false;
-$dbError = null;
+// Load required classes
+require_once(LIBDIR."autoloader/autoloader.php");
+require_once(LIBDIR."mvcfronk/mfLog/mfLoghandler.php");
+require_once(LIBDIR."FronkDB/FronkDB.php");
+
+// Get database table count
+$tableCount = 0;
+$db = null;
 
 try {
-    $conn = @mysqli_connect(
-        'aide-mariadb',
-        'aide',
-        'aide',
-        'thetool_s13'
+    $db = new FronkDB(
+        FRONKDB_DBHOST,
+        FRONKDB_DBUSER,
+        FRONKDB_DBPASS,
+        FRONKDB_DBNAME
     );
 
-    if ($conn) {
-        $dbConnected = true;
-        mysqli_close($conn);
+    // Query to get table count
+    $result = $db->query("SELECT COUNT(*) as count FROM information_schema.tables WHERE table_schema = '".FRONKDB_DBNAME."'");
+
+    if($result) {
+        $row = mysqli_fetch_assoc($result);
+        if($row) {
+            $tableCount = (int)$row['count'];
+        }
     }
-} catch (Exception $e) {
-    $dbError = $e->getMessage();
+} catch(Exception $e) {
+    header("Content-Type: application/json");
+    http_response_code(500);
+    echo json_encode(["status" => "error", "message" => "Database error: " . $e->getMessage()]);
+    exit;
 }
 
-if ($dbConnected) {
-    $health['db'] = true;
-} else {
-    $health['db'] = false;
-    if ($dbError) {
-        $health['db_error'] = $dbError;
-    }
-}
-
-// Set HTTP status code
-if ($health['db']) {
-    http_response_code(200);
-} else {
-    http_response_code(503); // Service Unavailable
-}
-
-echo json_encode($health);
+// Return JSON response
+header("Content-Type: application/json");
+http_response_code(200);
+echo json_encode([
+    "status" => "ok",
+    "tables" => $tableCount
+]);