PHP click count with mysqli

Question

I want to make a program what will count clicks after click button.

I have this code but it don't work. I use mysqli to connect to database and I use query to insert value to database and query to select from database.

<html>
    <head>
        <meta charset="UTF-8">
            <title>Click</title>
    </head>
    <body>
        <form action="#" method="post">
            <input type="submit" name="click" value="Klikni mě">
            <br>
            <?php
            if(isset($_POST["click"])){
                $connection=new mysqli("hidden","hidden","hidden","hidden");
                if($connection == false){
                    die("Sorry jako");
                }
                $query="INSERT INTO klik (klikcount) VALUES ('$klik')";
                if($connection->query($query) == false){
                    die("Promiň");
                }
                $sql="SELECT klikcount FROM klik";
                $result=$connection->query($sql);
                if($result->num_rows>0){
                    while($row=$result->fetch_assoc()){
                        echo $row["klikcount"];
                    }
                }
                $klik=$klik+1;
            }
            ?>
        </form>
    </body>
</html>

thanks.

Any errors? What "dont work"?

Jay Blanchard
– Jay Blanchard

2018-10-22 17:46:07 +00:00
Commented Oct 22, 2018 at 17:46 — Jay Blanchard
– Jay Blanchard, Commented Oct 22, 2018 at 17:46
$klik is not defined before you attempt to insert it.

Qirel
– Qirel

2018-10-22 17:46:10 +00:00
Commented Oct 22, 2018 at 17:46 — Qirel
– Qirel, Commented Oct 22, 2018 at 17:46

julianstark999 · Accepted Answer · 2018-10-23 06:08:01Z

I try solve your code and I made some changes.

Change position of "$klik = $klik+1;"
Add another SELECT

My new code:

<html>
    <head>
        <meta charset="UTF-8">
        <title>Click</title>
    </head>
    <body>
        <form action="#" method="post">
            <input type="submit" name="click" value="Klikni mě">
            <br>
            <?php
            if(isset($_POST["click"])) {
                $connection = new mysqli("hidden","hidden","hidden","hidden");

                if($connection == false) {
                    die("Sorry jako");
                }

                $sql="SELECT klikcount FROM klik";
                $result=$connection->query($sql);

                if($result->num_rows > 0) {
                    while($row = $result->fetch_assoc()){
                        $klik = $row["klikcount"];
                    }
                }

                $klik = $klik+1;
                $query = "INSERT INTO klik (klikcount) VALUES ('$klik')";

                if($connection->query($query) == false) {
                    die("Promiň");
                }

                $sql = "SELECT klikcount FROM klik";
                $result = $connection->query($sql);

                if($result->num_rows > 0) {
                    while($row = $result->fetch_assoc()) {
                        echo $row["klikcount"];
                    }
                }
            }
            ?>
        </form>
    </body>
</html>

Collectives™ on Stack Overflow

PHP click count with mysqli

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related