Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/get_vehicle_data.php
Назад
<?php require_once('includes/connection.php'); if (isset($_GET['vehicle_id'])) { $vehicle_id = intval($_GET['vehicle_id']); $response = []; // Fetch vehicle details $stmt = $conn->prepare("SELECT vehicle_capacity, vehicle_insurance_validy FROM vehicle_master WHERE id = ?"); $stmt->bind_param("i", $vehicle_id); $stmt->execute(); $stmt->bind_result($capacity, $insurance); $stmt->fetch(); $response['vehicle_capacity'] = $capacity; $response['vehicle_insurance_validy'] = $insurance; $stmt->close(); // Fetch brokers $brokers = []; $broker_stmt = $conn->prepare("SELECT transporter_name FROM broker_master WHERE vehicle_id = ? AND status = 1"); $broker_stmt->bind_param("i", $vehicle_id); $broker_stmt->execute(); $broker_result = $broker_stmt->get_result(); while ($row = $broker_result->fetch_assoc()) { $brokers[] = $row; } $response['brokers'] = $brokers; $broker_stmt->close(); header('Content-Type: application/json'); echo json_encode($response); }
| ver. 1.4 |
Github
|
.
| PHP 8.1.32 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка