<?php
require 'db.php';
$has_corrupted = false;

$res = $conn->query("SELECT product_id, product_name FROM products");
if ($res) {
    while($row = $res->fetch_assoc()){
        if (strpos($row['product_name'], 'เธ') !== false || strpos($row['product_name'], 'เน') !== false) {
            echo "Corrupted product: " . $row['product_name'] . "\n";
            $has_corrupted = true;
        }
    }
}

$res = $conn->query("SELECT category_id, category_name FROM categories");
if ($res) {
    while($row = $res->fetch_assoc()){
        if (strpos($row['category_name'], 'เธ') !== false || strpos($row['category_name'], 'เน') !== false) {
            echo "Corrupted category: " . $row['category_name'] . "\n";
            $has_corrupted = true;
        }
    }
}

if (!$has_corrupted) {
    echo "No corrupted strings found in database!\n";
}