Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
RegistroEquipos2
/
backend
/
telefono
:
lineadisponible.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: GET, POST, OPTIONS'); $host = '192.200.100.40'; $db = 'sistemas'; $user = 'SANMARINO'; $pass = 'sanmarino2021*'; $charset = 'utf8mb4'; try { $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $pdo = new PDO($dsn, $user, $pass, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, ]); // Obtener líneas con estado 'disponible' $sql = "SELECT id, numero, plan_datos, operador FROM inventario_lineas WHERE estado = 'disponible' ORDER BY numero"; $stmt = $pdo->query($sql); $lineas = $stmt->fetchAll(PDO::FETCH_ASSOC); echo json_encode([ 'status' => 'success', 'data' => $lineas ]); } catch (PDOException $e) { echo json_encode([ 'status' => 'error', 'mensaje' => 'Error en base de datos: ' . $e->getMessage() ]); }