如何创建一个表单，向数据库添加条目并通过电子邮件发送指向该条目的链接

Question

I am creating a feedback form (email & feedback text fields),which adds an entry to a Feedback Table. An auto-incremented FeedbackID is generated once the form is submitted and entry is added to the DB. Upon submission of the form, an email is also sent to the email. How do i add a link in the email pointing to that specific feedback.(ex: http://localhost/site/feedback.php?id= ) Feedback ID is only generated in the DB once entry is added to the database.

Answer 1

Your database will generate an ID on entering, and you can extract that ID in code, then insert it into your email; so assuming you are using mysqli:

$lastID = $mysqli->insert_id

mysqli insert id documentation

or PDO:

$lastId = $dbh->lastInsertId();

PDO last insert id documentation

or codeigniter (just saw you had tagged this)

$lastId = $this->db->insert_id();

CI Database helpers documentation