Case study: feedback system

Derek Bridge

Department of Computer Science,
University College Cork

Case study: feedback system

Aims:

Feedback system requirements

MySQL database for feedback system

CREATE TABLE comments_table (
   id INT NOT NULL AUTO_INCREMENT,
   url VARCHAR(255) NOT NULL,
   username VARCHAR(255) NOT NULL,
   timestamp TIMESTAMP(14),
   subject VARCHAR(255) NOT NULL,
   message TEXT NOT NULL,
   inreplytoid INT,
   PRIMARY KEY (id)
);

Notes on the database for feedback system

Offering a comment facility on every web page

Notes on enter.php

Notes on dbconnect.php

Three more scripts

A problem with store.php

A problem with store.php