connect_error){ die("Database Connection Failed"); } if(isset($_POST['create_ticket'])){ $ticket_id = rand(1000,9999); $distributor_name = $_POST['distributor_name']; $vehicle_model = $_POST['vehicle_model']; $vehicle_number = $_POST['vehicle_number']; $customer_name = $_POST['customer_name']; $customer_phone = $_POST['customer_phone']; $category = $_POST['category']; $priority = $_POST['priority']; $subject = $_POST['subject']; $description = $_POST['description']; $query = "INSERT INTO tickets (ticket_id,distributor_name,vehicle_model,vehicle_number,customer_name,customer_phone,category,priority_level,subject,description,status) VALUES ('$ticket_id','$distributor_name','$vehicle_model','$vehicle_number','$customer_name','$customer_phone','$category','$priority','$subject','$description','Open')"; mysqli_query($conn,$query); echo ""; } $tickets = mysqli_query($conn,"SELECT * FROM tickets ORDER BY id DESC"); ?> Nexora Support

Nexora Support System

Professional Distributor Support Ticket Portal

Create Support Ticket

All Support Tickets

Ticket ID	Distributor	Vehicle	Customer	Status	Priority	Date