PHP implementation of the check-in function of the method Example analysis _php tips

This article mainly introduces PHPThe method of realizing check-in function is analyzed with the example form. PHPOperation implementation based on database and time judgment PHPCheck-in function of the relevant skills, the need for friends can refer to the next

In this paper, we describe the method of PHP implementing check-in function. Share to everyone for your reference, as follows:

First of all, I built two tables in the database, one is the user's integration table, one is the check-in status table, which is used to record the user's number of points and first-to-state

In the User Registration status table We have a field, last_sign_time, that is, the last check-in time, each time you can check in to compare this time with the current time if the difference is 0 days, then the registration is today (this check-in is 24 hours can only sign in once, That is, two check-in time is 24 hours or more. If it is equal to one day, you can sign in today, if the 2 days and above indicate the missing sign.

Through the judge of timestamp, update the state table in time, and when can check-in, the User integration table is operated, that is, update the user points.

The specific code is as follows:

<?php$user_id=@$_request[' user_id '];//function: Calculates the difference between two timestamp seconds//$begin _time start timestamp//$end _time end timestamp function Timediff ($begin _time, $end _time)     {if ($begin _time < $end _time) {$starttime = $begin _time;   $endtime = $end _time;     }else{$starttime = $end _time;   $endtime = $begin _time;   }//calculates the number of days $timediff = $endtime-$starttime;   $days = Intval ($timediff/86400);   Count hours $remain = $timediff% 86400;   $hours = intval ($remain/3600);   Calculates the number of minutes $remain = $remain% 3600;   $mins = Intval ($remain/60);   Calculates the number of seconds $secs = $remain% 60;   $res = Array ("Day" and "$days", "hour" + $hours, "min" = = $mins, "SEC" and "$secs"); return $res;} function Upuserscore ($current _total_day) {$user _id=@$_request[' user_id '];//reads the INI file for database configuration information $ary =parse_ini_file ('  Db.ini ');  $db _login_name=base64_decode ($ary [' db_login_name ']);  $db _login_password=base64_decode ($ary [' Db_login_password ']);  $db _host=base64_decode ($ary [' db_host ']); $db _name=base64_decode ($ary [' db_name ']);//LINK Database $scorelink =mysqli_coNnect ($db _host, $db _login_name, $db _login_password); mysqli_select_db ($scorelink, $db _name); Select the database//Check the table if there is a user has the update data is not inserted data $scoreq = "SELECT * from User_score WHERE user_id= $user _id";    SQL INSERT statement mysqli_query ($scorelink, "SET NAMES UTF8"); $rs = Mysqli_query ($scorelink, $scoreq); Gets the DataSet if (! $rs) {exit (Json_encode (' status ' = ' success ', ' Code ' = ' 1 ', ' Error ' =>mysqli_error ($scoreli    NK)));       if (Mysqli_num_rows ($rs)) {//the user has data to update their points $total _score= "";      while ($row = Mysqli_fetch_row ($rs)) {$total _score= $row [4]; } $scoreusdateq = "UPDATE user_score SET user_total_score = ' 98 ' WHERE user_id= $user _id;";      Update Mysqli_query ($scorelink, "SET NAMES UTF8"); $ustaters = Mysqli_query ($scorelink, $scoreusdateq);        Get the DataSet if ($ustaters ==1) {exit (Json_encode (' status ' = ' success ', ' code ' = ' 100 ')));      Mysqli_close ($scorelink);//close connection exit (); }else{exit (Json_encode (' status ' = ' SucceSS ", ' Code ' =" 1 ")));      Mysqli_close ($scorelink);//close connection exit ();  }}else{//inserts its integration information without the user data $SCOREINSERTQ = "INSERT into User_score (User_id,user_total_score) VALUES ($user _id,10)";      SQL INSERT statement mysqli_query ($scorelink, "SET NAMES UTF8"); $rs = Mysqli_query ($scorelink, $SCOREINSERTQ); Gets the DataSet if (! $rs) {exit (Json_encode (' status ' = ' success ', ' Code ' = ' 1 ', ' Error ' =>mysqli_error ($sco      relink)));      } if (Strpos ($q, "select") = = = False) {exit (Json_encode (' status ' = ' success ', ' code ' = ' 100 ')));  } mysqli_close ($scorelink);//close connection}}//INI file reading database configuration information $ary =parse_ini_file (' Db.ini ');  $db _login_name=base64_decode ($ary [' db_login_name ']);  $db _login_password=base64_decode ($ary [' Db_login_password ']);  $db _host=base64_decode ($ary [' db_host ']); $db _name=base64_decode ($ary [' db_name ']);//Link Database $link =mysqli_connect ($db _host, $db _login_name, $db _login_password ); mysqli_select_db ($link, $db _name); Select a database//check the sign-in table forIf the user has the update data, then insert the data $q = "SELECT * from User_signin WHERE user_id= $user _id";    SQL INSERT statement mysqli_query ($link, "SET NAMES UTF8"); $rs = Mysqli_query ($link, $q); Gets the DataSet if (! $rs) {exit (Json_encode (' status ' = ' success ', ' Code ' = ' 1 ', ' Error ' =>mysqli_error ($link)))    );      if (Mysqli_num_rows ($rs)) {//the user has data to update their check-in information $last _time= "";       $total _day= ""; while ($row = Mysqli_fetch_row ($rs)) {$last _time= $row [4]. "      <br/> ";    $total _day= $row [5];      }//According to the last check-in time and the check-in time to make a comparison to determine if there is a missing sign and today is registered $current _total_day=intval ($total _day) +1;      $current _day=time ();    $ary = Timediff ($last _time, $current _day);        if ($ary [day]==0] {//Sign in Exit today (Json_encode (' status ' = ' success ', ' Code ' = ' 5 '));    Mysqli_close ($link);//close connection exit (); }else if ($ary [day]==1) {//no missing $usdateq = "UPDATE user_signin SET last_sign_time= ' $current _day ', total_day= ' $current _t Otal_day ' WHERE user_id= $user _id; "; Update Mysqli_query ($link, "SET NAMES UTF8 "); $ustaters = Mysqli_query ($link, $usdateq);          Gets the dataset if ($ustaters ==1) {upuserscore ($current _total_day);        Exit (Json_encode (' status ' = ' success ', ' code ' = ' 100 '));      Mysqli_close ($link);//close connection exit ();           }else{exit (Json_encode (' status ' = ' success ', ' Code ' = ' 1 '));      Mysqli_close ($link);//close connection exit (); }}else{//missed $usdateq = "UPDATE user_signin SET last_sign_time= ' $current _day ', Total_day=1 WHERE user_id= $user _id;" ;    Update Mysqli_query ($link, "SET NAMES UTF8"); $ustaters = Mysqli_query ($link, $usdateq);        Gets the dataset if ($ustaters ==1) {upuserscore ($current _total_day);      Exit (Json_encode (' status ' = ' success ', ' code ' = ' 100 '));    Mysqli_close ($link);//close connection exit ();       }else{exit (Json_encode (' status ' = ' success ', ' Code ' = ' 1 '));    Mysqli_close ($link);//close connection exit ();    }}}else{//Insert $current _day=time () without the user record; $insertq= "INSERT into User_signin (user_id,last_sign_time,total_day) VALUES ($user _id, ' $current _day ', 1)";    SQL INSERT statement mysqli_query ($link, "SET NAMES UTF8"); $insertrs = Mysqli_query ($link, $INSERTQ);      Get data Set if (Strpos ($insertrs, "select") = = = False) {//Access data successfully upuserscore (' 1 ');      Exit (Json_encode (' status ' = ' success ', ' code ' = ' 100 ')); }} mysqli_close ($link);//close Connection?>