SQL 每个用户仅存储 1 个请求，忽略其他请求

不知何故，我的MySQL数据库只为每个用户存储一次请求。

我计划为我的网站创建一个票务系统，我已经创建了表格并创建了一个表单和一个 php 类，如下所示。

如果我想在彼此后面创建 2 个不同的票证，它只会存储第一张票，而不会存储第二张票证。

已提交表单的屏幕截图

SQL代码：

CREATE TABLE IF NOT EXISTS `Comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) NOT NULL,
  `comment_creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `Conversation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` varchar(30) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `conversation_creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ticket_id` (`ticket_id`,`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `Tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `ticket_id` varchar(30) NOT NULL,
  `ticket_question` varchar(255) NOT NULL,
  `ticket_status` tinyint(1) NOT NULL DEFAULT '1',
  `ticket_subject` varchar(50) NOT NULL,
  `ticket_creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ticket_id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

Php 类：

<?php
    class ticket_create extends database {
        // Ticket class constructor storing the class variables 
        function __construct($username, $email, $ticket_id, $ticket_subject, $ticket_question){
            $this->username = $username;
            $this->email = $email;
            $this->ticket_id = $ticket_id;
            $this->ticket_subject = $ticket_subject;
            $this->ticket_question = $ticket_question;
        }
        // Function to add the ticket to the database
        function create_ticket(){
            $this->connect();
            $this->execute_query("INSERT INTO Tickets (username, email, ticket_id, ticket_subject, ticket_question) VALUES ('" . $this->username . "', '" . $this->email . "', '" . $this->ticket_id . "', '" . $this->ticket_subject . "', '" . $this->ticket_question . "')");
        }
        // Function to handle the class and execute their functions
        function class_handler(){
            $this->create_ticket();
            return 'The ticket: ' . $this->ticket_id . ' was successfull created.';
        }
    }
?>

调用 php 类：

<?php
    if(!empty($_POST)){
        require_once('../handling/ticket_create.php');
        $ticket_question = $_POST['ticket_question'];
        $create_ticket = new ticket_create($user->username, $user->email, md5(uniqid($user->username, true)), $ticket_question);
        $ticket_response = $create_ticket->class_handler();
        echo $ticket_response;
    }
?>

我如何让它工作，每张票都会被存储？