home
/
u529748449
/
domains
/
borabilhete.com
/
public_html
/
admin
➕ New
📤 Upload
✎ Editing:
buscar_produtoras.php
← Back
<?php // admin/buscar_produtoras.php require_once __DIR__ . '/conexao.php'; require_once __DIR__ . '/auth.php'; require_login(['admin','produtor','agente']); // todos podem pesquisar para vincular header('Content-Type: application/json; charset=UTF-8'); $q = trim($_GET['q'] ?? ''); $lim = 20; if ($q === '') { echo json_encode([]); exit; } $like = "%{$q}%"; $sql = " SELECT id, nome_fantasia, cnpj, cidade, uf FROM produtoras WHERE nome_fantasia LIKE ? OR cnpj LIKE ? ORDER BY nome_fantasia ASC LIMIT ? "; $st = $conn->prepare($sql); $st->bind_param('ssi', $like, $like, $lim); $st->execute(); $res = $st->get_result(); $out = []; while ($r = $res->fetch_assoc()) { $rotulo = $r['nome_fantasia']; if (!empty($r['cnpj'])) $rotulo .= " – ".$r['cnpj']; if (!empty($r['cidade'])) $rotulo .= " (".$r['cidade'].($r['uf']?"/".$r['uf']:"").")"; $out[] = [ 'id' => (int)$r['id'], 'text' => $rotulo, ]; } $st->close(); echo json_encode($out, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES);
💾 Save Changes
Cancel
📤 Upload File
×
Select File
Upload
Cancel
➕ Create New
×
Type
📄 File
📁 Folder
Name
Create
Cancel
✎ Rename Item
×
Current Name
New Name
Rename
Cancel
🔐 Change Permissions
×
Target File
Permission (e.g., 0755, 0644)
0755
0644
0777
Apply
Cancel