更新mysql中的自动增量列+1？

Can someone please help me, I am trying to create a users like system. Users should be able to click A like button and have it insert the user_id of that profile and auto increment the likes column. I'm also trying to make it so that the next person who comes along and likes the same profile, can also hit like and update the likes auto increment column by one each time.

有人可以帮助我,我正在尝试创建一个类似系统的用户。用户应该能够单击A like按钮并让它插入该配置文件的user_id并自动增加likes列。我也试图让它成为下一个出现并喜欢相同配置文件的人,也可以点击并每次更新喜欢的自动增量列。

I am new to mysql and php and i'm really struggling with this. Could someone please show me where i'm going wrong? Thanks in advance.

我是mysql和php的新手,我真的很挣扎。有人可以告诉我哪里出错了吗?提前致谢。

<?php

require_once('includes/session.php');
require_once('includes/functions.php');
require('includes/_config/connection.php');

session_start();

    confirm_logged_in();

    if (isset ($_GET['to'])) {
    $user_to_id = $_GET['to'];


}


if (!isset($_GET['to']))
    exit('No user specified.');

$user_id = $_GET['to'];


$result = mysql_query("SELECT * FROM ptb_likes WHERE liked_id ='".$user_to_id."' ");

if( mysql_num_rows($result) > 0) {
    mysql_query("UPDATE ptb_likes SET likes +1 WHERE liked_id = '".$user_to_id."' ");


    $autoinc = mysql_query("ALTER TABLE likes AUTO_INCREMENT = $id");
}
else
{
    mysql_query("INSERT INTO ptb_likes (liked_id) VALUES ('".$user_to_id."') ");
}



if($result) 
{ 

header("Location: {$_SERVER['HTTP_REFERER']}");

}
?>

1 个解决方案

#1

If you're doing a "Like"-wise system, it's preferable to have a table with the likes one per row.

如果你正在做一个“喜欢”方式的系统,最好有一个表格,每行一个。

THen you can query the DB searching by reference ID.

您可以通过引用ID查询数据库搜索。

Let's you have posts, and likes. Each post has a Post_ID, so your likes table schema would be something like

让我们有帖子,喜欢。每个帖子都有一个Post_ID,所以你喜欢的表模式会是这样的

ID
Post_ID
Time

So next time you want to see how many likes does Post #3 has, you do

所以下次你想看看Post#3有多少喜欢,你会这么做

SELECT COUNT(*) FROM posts WHERE post_id = 3

That way you have better control and reduce queries.

这样您就可以更好地控制和减少查询。

Incrementing the value of likes in a single row, would be done, but not efficient.

可以在单行中增加喜欢的值,但效率不高。

1 个解决方案

#1

更多相关文章

随机推荐