Stratnova/debug-faq.php at main · Quadwinner/Stratnova · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?php
include 'includes/database.php';

echo "<h2>FAQ Debug Information</h2>";

// Check service_sections table
echo "<h3>Service Sections:</h3>";
$sql = "SELECT * FROM service_sections WHERE section_type = 'cards'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Section ID: " . $row['id'] . ", Service ID: " . $row['service_id'] . ", Title: " . $row['title'] . "<br>";
    }
} else {
    echo "No service sections found<br>";
}

// Check service_section_cards table
echo "<h3>Service Section Cards:</h3>";
$sql = "SELECT * FROM service_section_cards";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Card ID: " . $row['id'] . ", Section ID: " . $row['section_id'] . ", Title: " . $row['title'] . "<br>";
    }
} else {
    echo "No service section cards found<br>";
}

// Check service_technologies table
echo "<h3>Service Technologies:</h3>";
$sql = "SELECT * FROM service_technologies LIMIT 10";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Tech ID: " . $row['id'] . ", Service ID: " . $row['service_id'] . ", Title: " . $row['title'] . "<br>";
    }
} else {
    echo "No service technologies found<br>";
}

// Check services table
echo "<h3>Services:</h3>";
$sql = "SELECT id, name FROM services WHERE status = 'active' LIMIT 5";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Service ID: " . $row['id'] . ", Name: " . $row['name'] . "<br>";
    }
} else {
    echo "No active services found<br>";
}
?>