数字计数器。 时间用户登录

Question

MY HOME PAGE

$val="SELECT Visit FROM signup WHERE Name = '$myusername'";
            $rlt = mysqli_query($conn,$val);
      $rw= mysqli_fetch_array($rlt,MYSQLI_ASSOC);
  $_SESSION['login_user'] = $myusername;
          $inc=++$rw["Visit"];
      $valnew="UPDATE table signup set Visit =$inc where Name=$myusername "
  mysqli_query($conn,$valnew); 
      $_SESSION['query'] = $inc; 

After login Page

$check = $_SESSION['query'];
   echo "You are visiting this page".$check." times";

motive: - when the user logged in, will able to see his no. of visits.

problem: update query is not working, that's why always echo 1-time visit.

Answer 1

Your update query is wrong, First test your query on localhost phpmyadmin and then try to integrate it in your code.

change

UPDATE table signup set Visit =$inc where Name=$myusername 

to

UPDATE signup set Visit =$inc where Name='$myusername';