the application situation is like this.
you need to record your daily winning streak or losing streak. You need to re-zero and recalculate whenever you win or lose.
uses MYSQL but doesn"t know how to design the table segment. Ask for help
the application situation is like this.
you need to record your daily winning streak or losing streak. You need to re-zero and recalculate whenever you win or lose.
uses MYSQL but doesn"t know how to design the table segment. Ask for help
this and daily check-in is a business logic
1) A user id
2) the number of times of a winning or losing streak
3) an latest status (win or lose)
4) time
problem solving
it is best to create a separate table, for example, call the winscount, field: id, userid, wins, time
look up the previous winscount record based on whether the game is won or not. If wins is less than 0, it is a losing streak, and a winning streak greater than 0.
the latest winscount record after a victory with a wins greater than 0 means a winning streak. If the latest winscount record with a wins greater than 0 after the defeat of wins+1,
, the winning streak is interrupted, a new record with a wins of-1 is created.
if the latest winscount record wins is less than 0 after a failure, if the wins-1, is greater than 0, the failure sequence is interrupted, and a new winscount record wins=1 is created
wins you can split it into two fields, one number and one indicating victory or defeat.
this is an idea, which can be used for reference, and the details can be optimized and perfected. Another advantage of this design is that it can trace the historical record, such as the highest winning streak of the year, the highest winning streak of the quarter.
aside, I don't think the winning streak should be limited on a day-to-day basis.
you can use a field to record the number of games in a row, and a field to record the time of victory / defeat, and then the program first determines that if one day has passed, the number of games in a row is set to 0, and then determines that if you win, the number of games in a row is + 1, and if you lose, you can clear 0; add a table to store the record of victory or defeat.
there should be a user list, user challenge (or competition) record table, and then record the winning streak. Think about the specific fields of the record table.
try redis?
K (uid "Mark user) + V (bool record") Storage record;
every time the result is generated, in addition to updating the field data in mysql, the value in redis is added to one, the winning game returns to zero, and the negative field returns to zero, and vice versa.
then persist the data at the end of each day.
in order to facilitate development, we plan to create a LNMP environment based on docker, which makes it much more convenient to change computers or unify the team s development environment. choreographed a docker-compose.yaml file with nginx, php-fp...
external network access domain name: https: api.baidu.com internal network domain name: http: local.baidu.com this domain name is inaccessible outside the network! It is 127.0.0.1 pointed to by a private network address. I use nginx reverse proxy ...
description: a regular match is given to the content of an input box, and the matching content is the product activation code. looks like this: "0C31-0B81-BB32-3094-0C31-0B81-BB32-3094 " Code: $( -sharplicenseCode ).keyup(function () { le...
I configured the MIME type of the file with the amr suffix in the apache configuration as application ms-download, Why it is a garbled page when opening a file in amr format using window.open in chrome, while a file in amr format can be successfully dow...
what does the code circled in the following picture mean? ...
rewrite rules: RewriteRule (.*) (.*) (.*) index .html index.php?p=$1&c=$2&a=$3 [QSA] access Home Blog blog index.html?page=2 can access index.php?p=Home&c=Blog&c=blog&page=2 normally but when the original link is index.php?p=Home&c=Blog&a...
$selectTip = $pdo->query("SELECT * FROM `tips_rate` WHERE `tip_id` = ".$row[ id ]." " ); $selecttotal = mysqli_num_rows($selectTip); $rate = $pdo->query("SELEC...
the following is the back-end code I think $username= is a randomly generated string in the output, so write $username=$number; like this, but this is an execution error, how to do it? For advice, thank you <?php $username=$_POST[ username ]; $nu...
adopt a reward of 10 yuan, 1045 Access denied for user root @ localhost (using password:NO) recently, when I was at the front end of my self-study, I came into contact with a little bit of database. This happened when I made a new connection on ...
the original domain name of our company s website has expired. I want to change it to another domain name. How can I change it? The website is developed using Aliyun s Yunmeng. ...
post table is the article table, the primary key is id tag table is the tag table, the primary key is id post_tag is the intermediate mapping table, and the field is post_id,tag_id now I want to select tag 1 to find out that all the tags and article...
what happens when you get a list of followers through access_token after getting access_token and show that this operation cannot be performed? $url = "https: api.weixin.qq.com cgi-bin token?grant_type=client_credential&appid=$appid&secre...
In apache,event mode, 8 processes are started. Set to perform 10000 automatic recreations. On the next day, there were only two hundred and three processes. is this the number of processes that apache thinks there are not enough tasks and automaticall...
$first is the data read by the database as shown in figure : read through the database can not change the line, directly written in the code can break the line, solve =! ...
as shown in the figure, the generated url does not have a domain name. Where do I need to configure it? ...
there is an h5 page embedded in the encapsulated APP. After the function of issuing an order, how can I get the user s id to add the address and place the order ...
1. Background of the problem: recently, it has been almost exclusively said on php7, that only php7 compiled with GCC 4.8 will open Global Register for opline and execute_data . 2. Question description: Q: what is 1Global Register for opline and e...
the query data is printed to see that _ id is objectID,. If it is directly converted to json,_id, it will be empty. Can you change objectID to string, and then to json? ...
$result= array(); foreach ($infos as $key => $info) { $result[$info[ time ]][] = $info;}; $results=array_slice($result,0,255); in this code, I want to use array_slice to remove the key value of $result, but I don t use . ...
stateful fields are often saved in the database, which are represented by numbers: 0-> fail reject 1-> success pass and so on, I want to convert 0 or 1 into Chinese characters in the obtained results, is there any good way to quickly complete t...