- 收藏功能如何实现?
是在数据库添加一个字段,如本表中typical,1为被收藏,0为未收藏
- 如何编程实现--点击图标为收藏,再次点击图标为未收藏
const searchUpdateViolations = (violations_id, callback) => {
const sqlUpdate = `
UPDATE violations
SET typical = 1 - typical -- 如果typical原本为1,则变为0;原本为0,则变为1
WHERE violations_id = ?
`;
connection.query(sqlUpdate, [violations_id], (updateError, results) => {
if (updateError) {
callback(updateError, null);
} else {
callback(null, { success: true, message: 'Typical status updated successfully' });
}
});
};