Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

The work of mySql base depends on the number of lines(d) in it? (Statistics)

M
magpie QA Engineer last edited by

We need to make the website statistics. I think when the page is downloaded, add a line to the table (stat) with data (id, ip, user, url, session, date). This is all attached to a ready project (2500-3400 hours a day). So there's a total of 33,000 entries per day, 90,000 in a month. Is the database going to last longer?
And there may be recommendations on how to make statistics on the other. "right."♪ ♪ ♪ Imagine my Russians.
Reply Quote 0
1 Reply Last reply
K
kalena last edited by

Google Analytics (high GA) is a free service provided by Google to provide detailed statistics on visitors ' websites. The statistic is on the Google server, the user only postes the JS code on his website.
http://www.google.com/analytics/
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

A

Work with mysql c#
Software Programming • mysql c sharp • • Avante

2

0
Votes

2
Posts

0
Views

O

For the C# language, there is a mass of different ORMs to facilitate interaction with the OBD: https://docs.microsoft.com/en-us/ef/ https://nhibernate.info/ https://dapper-plus.net//?gclid=Cj0KCQiAiNnuBRD3ARIsAM8KmltENli8g2O8jj1bntXG8MsuHzcMLSnSWXQw1qoioon5aGZtJWcF_XkaAv30EALw_wcB There are also different conjectors to connect to MySQL/MariaDBThe dapper has a ready realization. https://dapper.phnx47.net/
A

Does not work if there is no line in the table
Software Programming • php mysql • • Amritpal

2

0
Votes

2
Posts

0
Views

S

Try this:<?php $stmt5 = $pdo->query("SELECT * FROM bp WHERE id=:bp LIMIT 1"); $stmt5->execute(['bp' => $row['bp']]); $row5 = $stmt5->fetch(); if (!empty($row5['name']) && $row5['id']>0) { echo "<option selected value='".$row5['id']."'>".$row5['name']."</option>"; } else { echo "<option selected value='0'>--</option>"; } ?> We should also read about the requests made.
Transform the line [a,b,[c,d] into the standard JSON species [a,"b,[c,"d]?
Software Programming • c++ json qt c++11 paraser • • morde

2

0
Votes

2
Posts

0
Views

S

Replace every comma and every square bracket with the same symbol, but circumscribed. Remove two quotes in a row. Remove the original and final quote.
S

There's a list, there's lines and numbers of how I can remove the numbers with filter(s)
Software Programming • python python 3.x • • shizuka

2

0
Votes

2
Posts

0
Views

It would be good to read the documentation for the function. filternot trying to guess her methods.a = [1,'2',3,'4',5,'6',7,'89'] z = list(filter(lambda x: not isinstance(x, int), a)) print(z) # ['2', '4', '6', '89']
A

Recover entered URL
Software Programming • php • • Anderson

2

0
Votes

2
Posts

0
Views

S

You can try: $url_browser = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; //aqui executa o processo de login... header('Location: ' .$url_browser);
B

Abractic synthetic tree
Software Programming • php paracer • • Burma

2

0
Votes

2
Posts

0
Views

E

Try it. http://www.antlr.org/download.html It's good to build a tree, convenient API, works with several popular programming languages (Java, C#, Python 2/3, JavaScript, Go, C++, Swift).
C

Joining three tables with null values in SQL
SQL, Database Testing • mysql join • • Cleofas

2

0
Votes

2
Posts

0
Views

R

Try to use explicit join. It seems that MySQL has some issue referencing the implicit cross join. select b.id, u.id, rating from books as b join users as u on 1=1 left join ratings on u.id = userid and b.id = bookid
S

Select next row only if different from current row
SQL, Database Testing • mysql • • simrah

2

0
Votes

2
Posts

0
Views

You need to join the table to itself. One instance of the table to find the values of the "current" row and the second to look for the first row that the values differ. Since the date parameter may not exist in the table, we also need a subquery (derived table, named c) to find the previous row that holds the values for the "current" date: SELECT s.* FROM ( SELECT start_date, breakfast, lunch, snack, dinner FROM times WHERE start_date c.start_date AND (s.breakfast, s.lunch, s.snack, s.dinner) <> (c.breakfast, c.lunch, c.snack, c.dinner) ORDER BY s.start_date ASC LIMIT 1 ; Tested at SQLfiddle. This part: (s.breakfast, s.lunch, s.snack, s.dinner) <> (c.breakfast, c.lunch, c.snack, c.dinner) is just a compact way to write: ( s.breakfast <> c.breakfast OR s.lunch <> c.lunch OR s.snack <> c.snack OR s.dinner <> c.dinner ) I assumed that the four time columns are not nullable. If they are nullable, the above expression would need to be more complicated.
How do you translate the dual system into the eighth computing system without a basic function?
Software Programming • php algorithm computation systems • • irl

2

0
Votes

2
Posts

0
Views

Z

https://ru.stackoverflow.com/questions/37683/%D0%BA%D0%B0%D0%BA-%D0%BF%D0%B5%D1%80%D0%B5%D0%B2%D0%B5%D1%81%D1%82%D0%B8-%D0%B4%D0%B2%D0%BE%D0%B8%D1%87%D0%BD%D1%83%D1%8E-%D1%81%D0%B8%D1%81%D1%82%D0%B5%D0%BC%D1%83-%D0%B2-%D0%B4%D0%B5%D1%81%D1%8F%D1%82%D0%B8%D1%87%D0%BD%D1%83%D1%8E-%D1%81%D0%B8%D1%81%D1%82%D0%B5%D0%BC%D1%83-%D1%81%D1%87%D0%B8%D1%81%D0%BB%D0%B5%D0%BD%D0%B8%D1%8F-%D0%B1%D0%B5%D0%B7-%D0%B1%D0%B0%D0%B7%D0%BE%D0%B2%D1%8B%D1%85-%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8 Let's not count again. 1001(8) is 513(10). function myoctdec($oct) { $n = 1; $dec = 0; $oct = (string)$oct; for ($i = strlen($oct)-1; $i >= 0; $i--) { $dec = $dec + ( (int)$oct{$i} * $n ); $n = $n * 8; } return $dec; } I changed my answer from there. You could have.I'll add it here. Adjustly works with systems 2-10, but perhaps not the best solution in terms of productivity. UPD after skip + support up to base 32function myconvert($num, $from = 10, $to = 10) { $sym = array( '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V' ); $val = array_flip($sym); $n = 1; $result = ''; $f = strtoupper((string)$num); for ($i = strlen($f)-1; $i >= 0; $i--) { $result = $result + ( $val[$f{$i}] * $n ); $n = $n * $from; } if ($to == 10) return $result; $result2 = ''; while ($result > 0) { $result2 = $sym[($result % $to)].$result2; $result = floor($result / $to); } return $result2; } echo myconvert(1001, 2, 8); // 11
Remove the duplicate lines, leave only one line and calculate the number
Software Programming • mysql • • inna

2

0
Votes

2
Posts

0
Views

A

select min(id) as id, postId, userId, sum(rank) as rank from Rank group by postId, userId To change the data in the table based on these conditions, two requests must be made, first change the Rank in the first notes:update Rank A inner join (select min(id) as id,userId, postId,sum(rank) as rank from Rank group by userId, postId) B on A.id=B.id set A.rank=B.rank After which, delete the extra records:delete D.* from Rank D inner join( select id from Rank A where exists(select 1 from Rank B where B.postId=A.postId and B.userId=A.userId and B.id<A.id) ) B on D.id=B.id
J

How do you translate the number with the decimal system to the number with the base of 3?
Software Programming • python • • jonetta

2

0
Votes

2
Posts

0
Views

can be written in a form9^18 + 3^54 – 9 = 3^27 + 3^54 - 3^2 = 3^2 * (3^52 + 3^25 - 1) that is the number3^2 * (0t100000000000000000000000000100000000000000000000000000 - 1) multiplying 3^2 Make a left shift to two grades zero.a subtraction of 1 of 0The author can himself deduct this one and calculate how much the two can do.P. S.and if you have to do it on the python, the calculation of the appropriate level is the iteration of the next team.digit = value % 3 value //= 3
C

How to delete a line to match the number of lines to perform matrix calculation in MATLAB
Software Programming • array • • charlenef

2

0
Votes

2
Posts

0
Views

C

You can only take a part of the matrix.[Am, An] = size(A); [Bm, Bn] = size(B); if Am > Bm A = A(1:Bm, :); elseif Am < Bm B = B(1:Am, :); end
K

How to show a msj coming from another page's php code?
Software Programming • javascript php ajax • • kalyn

2

0
Votes

2
Posts

0
Views

A

We have our two files, the file a.php which is our view and the file b.php which is the logic of the server.Suppose in your file a.php you have the following content directly in some part of your file:window.onload = ()=>{ const button = document.getElementById("enviar"); const form = document.getElementById("formEnviarDatos"); const nombre = document.getElementsByName("nombre")[0]; const edad = document.getElementsByName("edad")[0]; button.addEventListener("click", e =>{ //Prevenimos que nos lleve al archivo b.php e.preventDefault(); //Obtenemos lo que el usuario puso en los input y lo añadimos a data //Que sera enviada por ajax al archivo b.php const dataToSend = new FormData(); dataToSend.append("nombre", nombre.value); dataToSend.append("edad", edad.value); //Creamos una nueva peticion ajax: const ajax = new XMLHttpRequest(); //Cuando b.php nos devuelva una respuesta la usamos en a.php ajax.onload = ()=>{ const responseData = JSON.parse(ajax.response); alert(responseData.msg); } ajax.onerror = ()=>{ alert("Ha ocurrido un error en la peticion!"); } //Abrimos la peticion hacia b.php y la enviamos. ajax.open("POST", form.action); ajax.send(dataToSend); }); }<form action = "b.php" id = "formEnviarDatos"> <input type = "text" name = "nombre" placeholder = "nombre"><br> <label for = "edad">edad: </label><input type = "number" name = "edad" value = "0"><br> <button id = "enviar">Enviar!</button> </form>This form should be analyzed very well, for example in the action of the form b.php which is the file that is responsible for processing your data, and in javascript we extract the contents of the action attribute in order to send data through ajax through a peticion POST towards the file b.php.in b.php you would have:<?php /* Obtenemos los valores enviados por POST aquí en este archivo, estos son los campos que yo decidí usar para obtener en este archivo sin embargo tu puedes mandar hacia aca cualquier otro tipo de info y se recibe de esta manera puesto que usamos POST, de lo contrario debes usar GET, si enviaste los datos por GET. */ $nombre = $_POST["nombre"]; $edad = $_POST["edad"]; //Esto sera enviado devuelta como respuesta a tu archivo a.php en ajax //cuando se ejecute la funcion onload (se ejecuta automaticamente al enviar) //la peticion ajax desde a.php $response; $message; //Haces los procesos usuales de mirar si en la base de datos //existe o no ya un rol igual, supongamos que tu ya guardaste esta //info en una variable: $existe = true; //si existe enviamos un contenido, si no enviamos otro, por supuesto deberas //usar la variable $Rol que ya poseias en tu codigo original. if($existe){ $message = "El Rol " . $Rol . " ya existe"; }else{ $message = "Rol añadido con exito!"; } //Esto es lo que realmente se encargara de enviarte una respuesta como json //hacia el archivo a.php como respuesta de ajax. echo json_encode(["msg" => $message]); ?> In case you are not familiar with the format json, this you should consult in a separate question, since this topic is very extensive, in fact I have an answer about the format JSONif you wish to see it attach the answer in the comments.
O

First authorisation phpmyadmin
Software Programming • php phpmyadmin • • Oba22

2

0
Votes

2
Posts

0
Views

E

I need a logic and password from MySQL.
How does a group work by MySQL?
Software Programming • mysql sql group by • • morde

2

0
Votes

2
Posts

0
Views

In the sample after group by Not one of the original lines. At the exit, the aggregate is the sum of the data in the right cut. To the columns you clearly did not use any group functions (such as sum()I'm going to use the first-time function. Only MySQL and only when the power is off. ONLY_FULL_GROUP_BY♪ In the rest of the DSB, a request in which at least one column, which is not into the group by, has forgotten to use a group function, will make a mistake.How does it work? group by You can put it in an exel. Write the data on the leaf, scorch the fields to be in. group by♪ Refrigerated subcontracted data in any case where the value in the next line in the columns specified in group by different from the previous values - insert a new line, copy the column values group byand put in the other formulas like СУММ() The cells of the group under which the outcome is subsumed. Outcome group by - that's what they're all about. The DSB is working around the same algorithm - first sorts, then adds the same records.I'll add the MySQL. He's all too free to do it. Try to clearly use group functions to all columns to understand exactly what would be in them, because the first one is not standardized and can change from the version to the version, depending on the physical location of the CD records and the implementation plan.

The work of mySql base depends on the number of lines(d) in it? (Statistics)

Suggested Topics

Work with mysql c# Software Programming • mysql c sharp • • Avante

Does not work if there is no line in the table Software Programming • php mysql • • Amritpal

Transform the line [a,b,[c,d] into the standard JSON species [a,"b,[c,"d]? Software Programming • c++ json qt c++11 paraser • • morde

There's a list, there's lines and numbers of how I can remove the numbers with filter(s) Software Programming • python python 3.x • • shizuka

Recover entered URL Software Programming • php • • Anderson

Abractic synthetic tree Software Programming • php paracer • • Burma

Joining three tables with null values in SQL SQL, Database Testing • mysql join • • Cleofas

Select next row only if different from current row SQL, Database Testing • mysql • • simrah

How do you translate the dual system into the eighth computing system without a basic function? Software Programming • php algorithm computation systems • • irl

Remove the duplicate lines, leave only one line and calculate the number Software Programming • mysql • • inna

How do you translate the number with the decimal system to the number with the base of 3? Software Programming • python • • jonetta

How to delete a line to match the number of lines to perform matrix calculation in MATLAB Software Programming • array • • charlenef

How to show a msj coming from another page's php code? Software Programming • javascript php ajax • • kalyn

First authorisation phpmyadmin Software Programming • php phpmyadmin • • Oba22

How does a group work by MySQL? Software Programming • mysql sql group by • • morde

Work with mysql c#
Software Programming • mysql c sharp • • Avante

Does not work if there is no line in the table
Software Programming • php mysql • • Amritpal

Transform the line [a,b,[c,d] into the standard JSON species [a,"b,[c,"d]?
Software Programming • c++ json qt c++11 paraser • • morde

There's a list, there's lines and numbers of how I can remove the numbers with filter(s)
Software Programming • python python 3.x • • shizuka

Recover entered URL
Software Programming • php • • Anderson

Abractic synthetic tree
Software Programming • php paracer • • Burma

Joining three tables with null values in SQL
SQL, Database Testing • mysql join • • Cleofas

Select next row only if different from current row
SQL, Database Testing • mysql • • simrah

How do you translate the dual system into the eighth computing system without a basic function?
Software Programming • php algorithm computation systems • • irl

Remove the duplicate lines, leave only one line and calculate the number
Software Programming • mysql • • inna

How do you translate the number with the decimal system to the number with the base of 3?
Software Programming • python • • jonetta

How to delete a line to match the number of lines to perform matrix calculation in MATLAB
Software Programming • array • • charlenef

How to show a msj coming from another page's php code?
Software Programming • javascript php ajax • • kalyn

First authorisation phpmyadmin
Software Programming • php phpmyadmin • • Oba22

How does a group work by MySQL?
Software Programming • mysql sql group by • • morde