exec("CREATE TABLE IF NOT EXISTS {$table_name}( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title TEXT, url TEXT, type TEXT, filepath TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )"); // Check if filepath column exists, if not add it $tableInfo = $db->query("PRAGMA table_info({$table_name})"); $hasFilepath = false; while ($column = $tableInfo->fetchArray(SQLITE3_ASSOC)) { if ($column['name'] === 'filepath') { $hasFilepath = true; break; } } if (!$hasFilepath) { $db->exec("ALTER TABLE {$table_name} ADD COLUMN filepath TEXT"); } // Directory for uploads $upload_dir = 'public/qrcodes/'; if (!file_exists($upload_dir)) { mkdir($upload_dir, 0755, true); } // Handle QR code generation if (isset($_POST['generate_qr'])) { $phone_number = $_POST['phone_number']; // Validate phone number if (!preg_match('/^[0-9]+$/', $phone_number)) { $error = "Número de telefone inválido. Use apenas números."; } else { // Format the WhatsApp URL $whatsapp_url = "https://wa.me/" . $phone_number; // Generate QR code using an external API $qr_content = file_get_contents("https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=" . urlencode($whatsapp_url)); if ($qr_content) { // Define file path - sempre com o nome qr.png $filename = 'qr.png'; $filepath = $upload_dir . $filename; // Save QR code image if (file_put_contents($filepath, $qr_content)) { // Delete previous generated QR codes from database $db->exec("DELETE FROM {$table_name} WHERE type = 'generated'"); // Insert into database $stmt = $db->prepare("INSERT INTO {$table_name}(title, url, type, filepath) VALUES(:title, :url, :type, :filepath)"); if ($stmt) { $stmt->bindValue(':title', 'WhatsApp QR Code', SQLITE3_TEXT); $stmt->bindValue(':url', $whatsapp_url, SQLITE3_TEXT); $stmt->bindValue(':type', 'generated', SQLITE3_TEXT); $stmt->bindValue(':filepath', $filepath, SQLITE3_TEXT); if ($stmt->execute()) { $success = "QR Code gerado com sucesso!"; } else { $error = "Erro ao salvar no banco de dados."; } } else { $error = "Erro ao preparar a declaração SQL."; } } else { $error = 'Erro: Falha ao salvar a imagem do QR Code.'; } } else { $error = 'Erro: Falha ao gerar o QR Code.'; } } } // Handle image upload if (isset($_POST['upload_qr'])) { if (isset($_FILES['qr_image']) && $_FILES['qr_image']['error'] === UPLOAD_ERR_OK) { $file = $_FILES['qr_image']; // Validate file type - apenas PNG $allowed_types = ['image/png']; $file_info = finfo_open(FILEINFO_MIME_TYPE); $mime_type = finfo_file($file_info, $file['tmp_name']); finfo_close($file_info); // Validate file extension $ext = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION)); if (!in_array($mime_type, $allowed_types) || $ext !== 'png') { $error = 'Erro: Apenas arquivos PNG são permitidos.'; } else { // Define file name - sempre com o nome qr.png $filename = 'qr.png'; $filepath = $upload_dir . $filename; // Delete any existing qr.png file if (file_exists($filepath)) { unlink($filepath); } // Move uploaded file if (move_uploaded_file($file['tmp_name'], $filepath)) { // Delete previous uploaded QR codes from database $db->exec("DELETE FROM {$table_name} WHERE type = 'uploaded'"); // Insert into database $stmt = $db->prepare("INSERT INTO {$table_name}(title, url, type, filepath) VALUES(:title, :url, :type, :filepath)"); if ($stmt) { $stmt->bindValue(':title', 'QR Code Carregado', SQLITE3_TEXT); $stmt->bindValue(':url', $filepath, SQLITE3_TEXT); $stmt->bindValue(':type', 'uploaded', SQLITE3_TEXT); $stmt->bindValue(':filepath', $filepath, SQLITE3_TEXT); if ($stmt->execute()) { $success = 'QR Code carregado com sucesso!'; } else { $error = "Erro ao salvar no banco de dados."; // Clean up file if DB insert failed if (file_exists($filepath)) { unlink($filepath); } } } else { $error = "Erro ao preparar a declaração SQL."; if (file_exists($filepath)) { unlink($filepath); } } } else { $error = 'Erro: Falha ao mover o arquivo.'; } } } else { $error = 'Erro: Nenhum arquivo enviado ou erro no upload.'; } } // Delete QR code if (isset($_GET['delete'])) { $id = (int)$_GET['delete']; // Get QR code info $res = $db->query("SELECT * FROM {$table_name} WHERE id = $id"); if ($row = $res->fetchArray()) { // Delete the file if it exists if (!empty($row['filepath']) && file_exists($row['filepath'])) { unlink($row['filepath']); } // Delete from database $db->exec("DELETE FROM {$table_name} WHERE id = $id"); $success = "QR Code excluído com sucesso!"; } header("Location: {$base_file}"); exit(); } include ('includes/studiolivheaderecode.php'); // Get current QR codes $generated_qr = null; $uploaded_qr = null; $res = $db->query("SELECT * FROM {$table_name} ORDER BY created_at DESC"); while ($row = $res->fetchArray()) { if ($row['type'] === 'generated' && !$generated_qr) { $generated_qr = $row; } elseif ($row['type'] === 'uploaded' && !$uploaded_qr) { $uploaded_qr = $row; } } ?>

Gerenciamento de QR Code

QR Codes Atuais

0)): ?>
QR Code Disponível

Criado:

Link: WhatsApp

0): ?>

Arquivo: qr.png

Excluir
QR Code Carregado

Carregado:

Origem: Upload

Excluir
0) || ($uploaded_qr && !empty($uploaded_qr['filepath']) && file_exists($uploaded_qr['filepath'])))): ?>
Nenhum QR Code disponível. Gere ou carregue um QR Code.

Selecionar Ação

Escolha como deseja adicionar um QR Code:

🔗
Gerar QR Code

Crie um QR Code a partir de um número de celular.

🖼️
Carregar QR Code

Faça upload de uma imagem PNG do seu QR Code.