PHP function refresh page after execute (Go back to div)

Question

I have got 2 pages:

Fun.php
Class.fun.php

In class.fun.php I got functions, for example, select posts/upvote post/downvote post.

In Fun.php I'm displaying all posts (Like facebook posts) : Image

When I upvote/downvote post, it calls function in class.fun.php and refreshes page, but goes back to top. : Image

But I want page to stay or go back to same post, where I clicked upvote , so I could scroll forward.

My Upvote function:

public function upvotePost(){
    try
    {

        if(isset($_SESSION['user_session'])){
            $user_id = $_SESSION['user_session'];

            $stmt = $this->runQuery("SELECT * FROM users WHERE id=:id");
            $stmt->execute(array(":id"=>$user_id));

            $myRow=$stmt->fetch(PDO::FETCH_ASSOC);

        }

        $id = $_GET['image_id'];                    
        $user_id = $myRow['id'];

        $stmt2 = $this->conn->prepare("SELECT count(*) FROM fun_post_upvotes WHERE image_id=('$id') AND user_id=('$user_id')");
        $stmt2->execute();
        $result2 = $stmt2->fetchColumn();

        if($result2 == 0){

            $stmt3 = $this->conn->prepare("INSERT INTO fun_post_upvotes (image_id,user_id) VALUES(:image_id,:user_id)");

            $stmt3->bindparam(":image_id", $id);
            $stmt3->bindparam(":user_id", $user_id);

            $stmt3->execute();  

            $stmt4 = $this->conn->prepare("SELECT * FROM fun_posts WHERE id=('$id')");
            $stmt4->execute();
            $result4 = $stmt4->fetchAll();

            foreach($result4 as $post){
                $newUpvotes = $post['upvotes']+1;

                $stmt5 = $this->conn->prepare("UPDATE fun_posts SET upvotes=$newUpvotes WHERE id=('$id')");                                                                                         
                $stmt5->execute();

                $_SESSION["result"]='You have succesfully liked this post!';

            }
            }else{

            $_SESSION["error"]='You have already liked this post!';

            }

            $stmt6 = $this->conn->prepare("SELECT count(*) FROM fun_post_downvotes WHERE image_id=('$id') AND user_id=('$user_id')");
            $stmt6->execute();
            $result6 = $stmt6->fetchColumn();

            if($result6 > 0){
                $stmt7 = $this->conn->prepare("DELETE FROM fun_post_downvotes WHERE image_id=('$id') AND user_id=('$user_id')");
                $stmt7->execute();

                $stmt8 = $this->conn->prepare("SELECT * FROM fun_posts WHERE id=('$id')");
                $stmt8->execute();
                $result8 = $stmt8->fetchAll();

                foreach($result8 as $post){

                    $newDownvotes = $post['downvotes'] - 1;

                    $stmt9 = $this->conn->prepare("UPDATE fun_posts SET downvotes=$newDownvotes WHERE id=('$id')");                                                                                         
                    $stmt9->execute();

                }
            }
    }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }               
}

What you are looking for is Ajax.

Joey Ezekiel
– Joey Ezekiel

2017-07-05 12:06:43 +00:00
Commented Jul 5, 2017 at 12:06 — Joey Ezekiel
– Joey Ezekiel, Commented Jul 5, 2017 at 12:06
Use Ajax and don't set # in anchor tag if you are using.

Jaydeep Mor
– Jaydeep Mor

2017-07-05 12:27:40 +00:00
Commented Jul 5, 2017 at 12:27 — Jaydeep Mor
– Jaydeep Mor, Commented Jul 5, 2017 at 12:27

score 1 · Accepted Answer · 2017-07-06 11:07:48Z

1

Take a look at HTML anchors for a very simple solution, assuming you are using a hyperlink for voting. You would need the container of each post to have it's own unique ID attribute, which you then refer to in your upvote/downvote href attribute, creating an anchor which the browser will jump to. See https://www.w3schools.com/html/html_links.asp For example -

<div id="post_1">
    Post content is here
    <a href="yoururl.com/posts#post_1">UPVOTE</a>
    <a href="yoururl.com/posts#post_1">DOWNVOTE</a>
</div>
<div id="post_2">
    Post content is here
    <a href="yoururl.com/posts#post_2">UPVOTE</a>
    <a href="yoururl.com/posts#post_2">DOWNVOTE</a>
</div>

Alternatively look into using javascript ajax to post the data without reloading the page and therefore no need to scroll at all. See https://www.w3schools.com/xml/ajax_intro.asp for an introduction, or check out a JS library like jQuery.

edited Jul 6, 2017 at 11:07

answered Jul 5, 2017 at 12:26

user6344480

Sign up to request clarification or add additional context in comments.

2 Comments

Crelix Over a year ago

Thanks, I have already take a look on this. But there's problem. I made a div, like in example. But it won't go to div. Even if i write url and id with hand.

user6344480 Over a year ago

@crelix18 Won't be able to help with your situation specifcally without seeing an example of your code. Just make sure each post references itself in the voting links (each post should be unique), I edited my answer to show a second post/links.

Collectives™ on Stack Overflow

PHP function refresh page after execute (Go back to div)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related