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).

Distance between two points in km

emran

I get from the goo angle of the LatLng point coordinates, in the same form, there's a table on the server with many lines with lat, lon. We need to select only those within a 10-km radius of the designated point.

SELECT *FROM us WHERE ...

What's the condition to There's an algorithm on the php, but I need to do it by mysql means.

function haversineGreatCircleDistance(
  $latitudeFrom, $longitudeFrom, $latitudeTo, $longitudeTo, $earthRadius = 6371000)
{
  // convert from degrees to radians
  $latFrom = deg2rad($latitudeFrom);
  $lonFrom = deg2rad($longitudeFrom);
  $latTo = deg2rad($latitudeTo);
  $lonTo = deg2rad($longitudeTo);
$latDelta = $latTo - $latFrom;

$lonDelta = $lonTo - $lonFrom;
$angle = 2 * asin(sqrt(pow(sin($latDelta / 2), 2) +

cos($latFrom) * cos($latTo) * pow(sin($lonDelta / 2), 2)));

return $angle * $earthRadius;

}

Alberto

I found it. If anyone needs it, it's miles away.

 SELECT uid, ( 6371 * acos( cos( radians(50.280848) ) * cos( radians( lat ) ) * cos( radians( lon ) - radians(30.445011) ) + sin( radians(50.280848) ) * sin( radians( lat ) ) ) ) AS distance 
FROM users HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

mysql 49766

2
Posts

0
Views

Suggested Topics

A

User erroneously added to the OBD by POST
Software Programming • javascript php mysql post • • authera

2

0
Votes

2
Posts

0
Views

J

(xx that for the library )) the most likely change does not come into force from the not closing of the compound, try to close the banal R:close (may roll)) or find alternative solutions in the dock. If I were you, I'd delete the whole library and write my code. I can help you if you need to. As an alternative solution, a reset of the page may be added.<scrip> $(document).ready(function(){ var myflag = 0; $("#add_user").click(function() { if(myflag > 0)return false; myflag++; var name = document.getElementById("name").value; var phone = document.getElementById("phone").value; var profession = document.getElementById("profession").value; var cabinet = document.getElementById("cabinet").value; var department = document.getElementById("department").value; var location = document.getElementById("location").value; $.post( "adminTools.php", { name: name, phone: phone, profession: profession, cabinet: cabinet, department: department, location: location }, onAjaxSuccess ); function onAjaxSuccess(data) { console.log(data); if (data == "400") { $("#add_answer").html("Ошибка создания"); myflag--; } else if (data == "200") { alert("Пользователь успешно создан"); window.location.href=window.location.href; } } }); }); </scrip>
O

Grouping and summarizing data from two unique field tables
Software Programming • mysql sql • • Oba22

2

0
Votes

2
Posts

0
Views

K

SELECT rowTimestamp,campaignCity,SUM(rowSpendMoney) rSM FROM campaingsTransactions cT LEFT JOIN campaingsDescription cD on cT.rowCampaignID=cd.rowCampaignID GROUP BY rowTimestamp,campaignCity; Something like that.
Z

Two monitors for two applications in Ubuntu 14.04
Software Programming • no tags • • zymir

2

0
Votes

2
Posts

0
Views

K

It's very difficult without a special iron and a special soft to that iron. Anyway, at that point, maybe a year ago, my colleague copied this question and told me. The essence is to build memory of the displays inside the videotape. Called it. https://ru.wikipedia.org/wiki/Extended_display_identification_data And because of co-operability, there's only Quadro and FirePro. Maybe there's something in Wayland that's been written down (or already dranked) but old systems are bad.
A

Find the most remote of the mean value
Software Programming • mysql • • Avante

2

0
Votes

2
Posts

0
Views

R

In the table:CREATE TABLE testtable(number INTEGER NOT NULL); Such a request shall be made:SELECT * FROM testtable WHERE number = (SELECT MAX(ABS(number - (SELECT AVG(number) FROM testtable))) + (SELECT avg(number) FROM testtable) FROM testtable); Works only with positive numbers
G

filling a table by triggering multiple tables on insert
SQL, Database Testing • mysql trigger insert • • gionna

2

0
Votes

2
Posts

0
Views

N

The trigger code you just displayed in your question needs to be manually defined on each table you intend to copy from. For tables x, y and z the answer to your question is: CREATE TRIGGER some_name AFTER INSERT ON `x` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name); CREATE TRIGGER some_name AFTER INSERT ON `y` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name); CREATE TRIGGER some_name AFTER INSERT ON `z` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name); I suggest you make table m use MyISAM to prevent all potential deadlocks. UPDATE 2013-10-15 19:39 EDT First, define the table m like this: CREATE TABLE m ( id int(11) not null auto_increment, //PK name varchar(100) null, something_else varchar(100) default 'not important', primary key (id), unique key (name) ) ENGINE = MyISAM; Then, make the trigger like this: CREATE TRIGGER some_name AFTER INSERT ON `x` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name) ON DUPLICATE KEY UPDATE SET something_else = 'new thing' ; I would suggest that make something_else have the date and time as well CREATE TRIGGER some_name AFTER INSERT ON `x` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name) ON DUPLICATE KEY UPDATE SET something_else = CONCAT('new thing ',NOW()); ; and maybe the table where the insert came from CREATE TRIGGER some_name AFTER INSERT ON `x` FOR EACH ROW INSERT INTO m (name) VALUES (NEW.name) ON DUPLICATE KEY UPDATE SET something_else = CONCAT('new thing from x : ',NOW()); ; Give it a Try !!!
R

About the output of the Levenstein distance (edit distance / edit chart) and the shortest route in the graph
Software Programming • python algorithm python3 data struc languageture graph theory • • rosemadder

2

0
Votes

2
Posts

0
Views

G

Revenstein distances can be assigned different costs for each editing operation. The output of the library seems to be a revenstein distance when the cost 1 is assigned to insert, delete, and replace. The graph is the revenstein distance when the cost 1 and the cost 2 are assigned to the insertion and removal (or if there is no subst tion operation, delete and insertion).
Z

Algorithm for faster route calculation between two points in parallel Cartesian layers (3D)
Software Programming • algorithm • • zymir

2

0
Votes

2
Posts

0
Views

In a very simple way, connecting the floors through an edge, creating a kind of three-dimensional graph seems to me the most suitable solution.The algorithm, however, should be customized according to certain conditions. For example, the setting for the disabled would put an infinite cost on the stairs and other roads without accessibility so that they were never selected. The question of avoiding elevators at peak times could be another configuration by the user. Already an option of "walking at most X floors" would be a little more laborious, requiring to store an additional state for each route.And for the thing to work well in practice, it would be ideal to have average lift waiting time metrics at every time.The general idea is that the weights of each edge, that is, of walking each stretch, would have to based on a dynamic function that considered the user settings and also traffic information of that stretch.However, depending on the amount of nodes and the load of use of the system, this may be ineffective. In this case, it would be possible to define sub-optimal routes, for example, pre-calculating for each floor at shortest distance between a certain point and the nearest ladder or elevator, then joining this information to select a global.Anyway, these are some ideas. They do not respond conclusively or mathematically to the question (and are too big for comments), but I hope they can generate new ideas that increase their current solution.
S

PHP How to remove the element from the page after sending the form
Software Programming • php mysql ajax request • • shizuka

2

0
Votes

2
Posts

0
Views

A

DOM is only possible with JS. PHP generates the code on the server's side, so we need to reload the page. But sending the data to the server needs an axe.This is an example of JS.function showForm() { document.querySelector('#form').style.display='block'; document.querySelector('#button').style.display='none'; } function hideForm() { document.querySelector('#form').style.display='none'; document.querySelector('#button').style.display='block'; }form{ margin-bottom: 2rem; }<form method="POST" onsubmit="hideForm();return false" id="form"> <div>Your information</div> <button name="sent" type="submit">Sent</button> </form> <button onclick="showForm()" id="button" style="display: none">show form</div>
R

Delete everything except the smallest per day
Software Programming • php mysql • • rielyn

2

0
Votes

2
Posts

0
Views

A

I don't know about performing it, but sql will delete all prices that are not the lowest price of each product in days less than today. Some where should improve the performance. DELETE `precos` FROM `precos` left join ( SELECT max(id) id from precos inner join ( SELECT date(Data) d, Prod pid, min(Preco) p FROM `precos` WHERE 1 group by date(Data), Prod ) mp on date(precos.data) = mp.d and precos.Prod = mp.pid and mp.p = precos.Preco group by date(Data), Prod ) save_data on save_data.id = precos.id where save_data.id is null and date(Data) < CURDATE(); I recommend not running in production before some hahaha tests. Good luck
upload mysql data to select multiple php
Software Programming • php mysql select • • Analeea

2

0
Votes

2
Posts

0
Views

F

Try using the operators ?: with function in_array to check if there is a markingExample: $prod = $conexion->query("SELECT * FROM procesos WHERE id_cl = '$id_us' AND estado = 'S' "); if ($prod->num_rows > 0) { echo "<select name='procesos[]' id='multi' style='width: 100%;' class='select2 select2-multiple' multiple='multiple' data-placeholder='SELECCIONE TAREAS' >"; while ($row = $prod->fetch_array()) { echo '<option '.((in_array(strtolower(utf8_encode($row['id'])), $tareas))?"selected":"").' value="'.$row['id'].'">'.strtoupper(utf8_encode($row['nombre'])).'</option>'; } echo '</select>'; }
Transform two data lists into a graph with two parallel lines
Software Programming • python matplotlib graphic language • • Mystic

2

0
Votes

2
Posts

0
Views

T

You can use the library matplotlib to plot the chart, see only:import matplotlib.pyplot as plt def obterProgresso( linha ): p = [ 0 ] x = 0 for i in linha: if i == 0: x-=1 else: x+=1 p.append(x) return p; Linha1 = [1,1,1,0,1,0,1] Linha2 = [0,0,0,0,1,1,1] Prog1 = obterProgresso( Linha1 ) Prog2 = obterProgresso( Linha2 ) print "Linha1 = ", Prog1 print "Linha2 = ", Prog2 plt.plot( Prog1, 'bo' ); plt.plot( Prog1, 'k--', color='blue' ); plt.plot( Prog2, 'ro' ); plt.plot( Prog2, 'k--', color='red' ); plt.grid(True) plt.xlabel("Tempo") plt.ylabel("Progresso") plt.show() Output: Progressions:Linha1 = [0, 1, 2, 3, 2, 3, 2, 3] Linha2 = [0, -1, -2, -3, -4, -3, -2, -1]
Bash script, crate and import sample database
SQL, Database Testing • mysql • • carriann

2

0
Votes

2
Posts

0
Views

D

I have da_admin and password stored in my.cnf file. cat /usr/local/directadmin/conf/mysql.conf | grep ... Typo? More importantly, you should not need to provide the password argument when invoking mysql. The whole point of putting the credentials into a file in the first place is that they must not appear (as arguments) on the mysql command line, where they are visible to anyone on the machine that can run a ps command! You should add these entries into a separate configuration file, expressly for this purpose, and use the [--defaults-extra-file][1] option to tell mysql to "read" this file when it is started: $ cat XYZ.cnf [mysql] user=da_admin password=P@$$w0rd Then #4 mysql --defaults-extra-file=XYZ.cnf $wpconfigdbuser < mydb.sql Note: No username argument and definitely no password arguments appear in this command line. Both are read from the specified file.
C

Get distance between two declared points in a struct
Software Programming • c language data struc languagetures • • charlenef

2

0
Votes

2
Posts

0
Views

I'm not sure if I fully understand your query, but so I can conclude your problem is how to assign values to the struct variables. The assignment would be more or less like this:void main() { struct Tpunto p1, p2; p1.x = val_1_x // asignar valor para el punto1 en x p1.y = val_1_y // asignar valor para el punto1 en y p2.x = val_2_x // asignar valor para el punto2 en x p2.y = val_2_y // asignar valor para el punto2 en y //.. resto del código luego de la asignación } Also, as they mention in one of the comments, the function that calculates distance should change it to return a value float. There should be something as follows:float distancia_puntos(struct Tpunto punto1, struct Tpunto punto2) { return sqrt((pow(punto2.x-punto1.x, 2))+(pow(punto2.y-punto1.y, 2))); } Then this and stored the desired values in the struct, your algorithms should give more coherent values.Greetings
mysql query gets slower with increasing page number
SQL, Database Testing • mysql mariadb • • irl

2

0
Votes

2
Posts

0
Views

when you're using the "limit 48 offset 7776" mysql need to scan all rows(48+7776), along with offset number increase, mysql need to scan more and more rows for "Next page" To improve this, try: select ... from ... where id > 7776 limit 48 or try: select ... from ... where id between 7776 and 7824
B

How can I create a conditional with two conditions of two different variables in one?
Software Programming • python python 3.x numpy func languagetional progr • • baileigh

2

0
Votes

2
Posts

0
Views

first you have to remember that in Python there are no arraysunless you're working with numpy and variable X it's kind of numpy.array, second lists don't have a method apply() only DataFrames And you're not working with one. Finally your expression lambda is wrong, including X[:,0] (I don't know why you're doing that.) For your problem we will solve it using the function map() together with a lambda expression, to access each element we will use the syntax X[0],X[1] to access the first and second element correspondingly.the operation map() will return a list with the values obtained according to the last lambda expressionFrom what I see you compare with t, so if you say it should be greater than 0.5 and less than 0.3 t=[0.5,0.3]t = [0.5,0.3] #pondra 0 si el primer valor es menor que 0.5 el segundo es mayor 0.3, de lo contrario 1 y_new = map(lambda x: 0 if x[0]<0.5 and x[1]>0.3 else 1, X) #es lo mismo que #y_new = map(lambda x: 0 if x[0]<t[0] and x[1]>t[1] else 1, X) #para ver sus elementos lo convertimos a lista y_new = list(y_new) #imprimimos print(y_new) Dando as a result[1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0] In a comment you said it was a Numpy.array(), in this case also works the lambda expression import numpy as np X = np.array([[0.5 , 0.65], [0.75, 0.34], [0.37, 0.5 ], [0.57, 0.74], [1. , 0.69], [0.1 , 0.61], [0.04, 0.36], [0.56, 0.45], [0.46, 0.01], [0.46, 0.97], [0.26, 0.83], [0.47, 0.01], [0.34, 1. ], [0.85, 0.41], [0. , 0.72], [0.66, 0.08], [0.3 , 0.19], [0.71, 0. ], [0.3 , 0.77], [0.17, 0.96]]) y_new = map(lambda x: 0 if x[0]<0.5 and x[1]>0.3 else 1, X) #es lo mismo que #y_new = map(lambda x: 0 if x[0]<t[0] and x[1]>t[1] else 1, X) y_new = list(y_new) print(y_new) Departure[1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 0, 0] If you want to get the value Boolean we can do it by transforming it with function bool(), this by means of a list compressiony_new = [bool(val) for val in y_new] print(y_new) Departure[True, True, False, True, True, False, False, True, True, False, False, True, False, True, False, True, True, True, False, False] And as I said in a comment you can deny that.y_new = [not bool(val) for val in y_new] print(y_new) Departure[False, False, True, False, False, True, True, False, False, True, True, False, True, False, True, False, False, False, True, True]

Distance between two points in km

Suggested Topics

User erroneously added to the OBD by POST Software Programming • javascript php mysql post • • authera

Grouping and summarizing data from two unique field tables Software Programming • mysql sql • • Oba22

Two monitors for two applications in Ubuntu 14.04 Software Programming • no tags • • zymir

Find the most remote of the mean value Software Programming • mysql • • Avante

filling a table by triggering multiple tables on insert SQL, Database Testing • mysql trigger insert • • gionna

About the output of the Levenstein distance (edit distance / edit chart) and the shortest route in the graph Software Programming • python algorithm python3 data struc languageture graph theory • • rosemadder

Algorithm for faster route calculation between two points in parallel Cartesian layers (3D) Software Programming • algorithm • • zymir

PHP How to remove the element from the page after sending the form Software Programming • php mysql ajax request • • shizuka

Delete everything except the smallest per day Software Programming • php mysql • • rielyn

upload mysql data to select multiple php Software Programming • php mysql select • • Analeea

Transform two data lists into a graph with two parallel lines Software Programming • python matplotlib graphic language • • Mystic

Bash script, crate and import sample database SQL, Database Testing • mysql • • carriann

Get distance between two declared points in a struct Software Programming • c language data struc languagetures • • charlenef

mysql query gets slower with increasing page number SQL, Database Testing • mysql mariadb • • irl

How can I create a conditional with two conditions of two different variables in one? Software Programming • python python 3.x numpy func languagetional progr • • baileigh

User erroneously added to the OBD by POST
Software Programming • javascript php mysql post • • authera

Grouping and summarizing data from two unique field tables
Software Programming • mysql sql • • Oba22

Two monitors for two applications in Ubuntu 14.04
Software Programming • no tags • • zymir

Find the most remote of the mean value
Software Programming • mysql • • Avante

filling a table by triggering multiple tables on insert
SQL, Database Testing • mysql trigger insert • • gionna

About the output of the Levenstein distance (edit distance / edit chart) and the shortest route in the graph
Software Programming • python algorithm python3 data struc languageture graph theory • • rosemadder

Algorithm for faster route calculation between two points in parallel Cartesian layers (3D)
Software Programming • algorithm • • zymir

PHP How to remove the element from the page after sending the form
Software Programming • php mysql ajax request • • shizuka

Delete everything except the smallest per day
Software Programming • php mysql • • rielyn

upload mysql data to select multiple php
Software Programming • php mysql select • • Analeea

Transform two data lists into a graph with two parallel lines
Software Programming • python matplotlib graphic language • • Mystic

Bash script, crate and import sample database
SQL, Database Testing • mysql • • carriann

Get distance between two declared points in a struct
Software Programming • c language data struc languagetures • • charlenef

mysql query gets slower with increasing page number
SQL, Database Testing • mysql mariadb • • irl

How can I create a conditional with two conditions of two different variables in one?
Software Programming • python python 3.x numpy func languagetional progr • • baileigh