$length ? substr($value, 0, max(0, $length - 1)) . '…' : $value; } function ensure_contact_requests_table(PDO $pdo): void { $pdo->exec(<<<'SQL' CREATE TABLE IF NOT EXISTS contact_requests ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(120) NOT NULL, email VARCHAR(190) NOT NULL, company VARCHAR(150) NULL, project_type VARCHAR(80) NULL, budget VARCHAR(80) NULL, message TEXT NOT NULL, status VARCHAR(30) NOT NULL DEFAULT 'new', source_url VARCHAR(255) NULL, ip_address VARCHAR(45) NULL, user_agent VARCHAR(255) NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci SQL); }