在我的网站上,我希望允许用户收藏帖子。登录的用户被定向到一个显示所有帖子的页面,在每个帖子下我都放置了一个指向收藏夹的超链接。我希望文本从最喜欢变为最喜欢,反之亦然。我怎么做?
HTML 和 PHP
<?php
session_start();
require_once('connection.php');
mysql_select_db($database_connection, $connection);
$query_favorite = "SELECT username, post_id FROM favorite";
$favorite = mysql_query($query_favorite, $connection) or die(mysql_error());
$row_favorite = mysql_fetch_assoc($favorite);
$totalRows_favorite = mysql_num_rows($favorite);
?>
<a href="#" class="favourite">Favourite</a>
我的数据库中的表
CREATE TABLE `user` (
`username` varchar(45) NOT NULL,
`email` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
`profilepic` varchar(50) DEFAULT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `post` (
`post_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`dato` date NOT NULL,
`category` varchar(100) NOT NULL,
`description` varchar(500) NOT NULL,
`text` longtext NOT NULL,
PRIMARY KEY (`post_id`),
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8
CREATE TABLE `favorite` (
`username` varchar(45) NOT NULL,
`post_id` int(11) NOT NULL,
PRIMARY KEY (`username`,`post_id`),
KEY `fk_favorite_post1_idx` (`post_id`),
CONSTRAINT `fk_favorite_user` FOREIGN KEY (`username`) REFERENCES `user` (`username`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_favorite_post1` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8