Today I learned

[Weedpacket]

dalecosp
Not to mention how I found it. See, some of them were long-running to begin with, so the fact they were taking a long time to complete wasn't itself odd. The process was:

"Low disk space? Why? How?" [a couple of minutes later] "What's with all these 150GB logfiles here?"

Still, another thing I learned was that I really do need to clean up around here. Anyone interested in a bunch of Indiana University Computer Science Department Technical Reports circa 1978?

[NogDog]

w00t! Class of '78! (OMG I'm old.)

[Weedpacket]

...that C.O.D. means Collect On Delivery.
The thing being collected being the payment.
The form of the payment being unspecified.

That might just show how often I deal with anything "COD"; I guess back in the day cash was the only way it could be collected.

[NogDog]

TIL: PDOStatement implements Traversable. In theory I should be able to clean things up a little bit with a foreach($stmt as $row) instead of the while($row = $stmt->fetch()) sort of thing I've always done, I think.

Yeah, not earth-shaking -- just surprised I never knew this after using PDO on a pretty much daily basis for 7+ years now. 🙂

[cluelessPHP]

Today I learnt the importance of rest, the highlands are breathe taking

[cluelessPHP]

Today I learnt

<p id="geo"></p>

<script>

var x = document.getElementById("geo");

function getLocation() {
  if (navigator.geolocation) {
    navigator.geolocation.watchPosition(showPosition);
  } else { 
    x.innerHTML = "Geolocation is not supported by this browser.";
  }
}
    

function showPosition(position) {
    x.innerHTML="Latitude: " + position.coords.latitude + 
    "<br>Longitude: " + position.coords.longitude;
}
</script>

This first draft of a site is going to be so badly done lol

[dalecosp]

That's nice. FWIW, I wouldn't use 'x' ... too much chance of collision in the global/window scope.

I spent part of yesterday trying to figure out how to make a rough duplicate of a PHP class in JavaScript.

It's not done yet, to say the least ...

[cluelessPHP]

Well I'll admit I don't fully understand it yet but I learned this today..

SELECT postcode, town,
       lat, lon, distance
  FROM (
 SELECT z.postcode,
        z.town,
        z.lat, z.lon,
        p.radius,
        p.distance_unit
                 * DEGREES(ACOS(COS(RADIANS(p.latpoint))
                 * COS(RADIANS(z.lat))
                 * COS(RADIANS(p.longpoint - z.lon))
                 + SIN(RADIANS(p.latpoint))
                 * SIN(RADIANS(z.lat)))) AS distance
  FROM shopAddress AS z
  JOIN (  

        SELECT  57.11149510000001  AS latpoint,  -3.157924900000012 AS longpoint,
                50.0 AS radius,      111.045 AS distance_unit
    ) AS p ON 1=1
  WHERE z.lat
     BETWEEN p.latpoint  - (p.radius / p.distance_unit)
         AND p.latpoint  + (p.radius / p.distance_unit)
    AND z.lon
     BETWEEN p.longpoint - (p.radius / (p.distance_unit * COS(RADIANS(p.latpoint))))
         AND p.longpoint + (p.radius / (p.distance_unit * COS(RADIANS(p.latpoint))))
 ) AS d
 WHERE distance <= radius
 ORDER BY distance
 

[NogDog]

cluelessPHP

Heh...I was just playing around with this a few days ago in a very preliminary look into a tool we're thinking of building (that I doubt will be in PHP, but it's still what I think in):

$miles = rad2deg(
  acos(
    sin(deg2rad($loc['from']['lat'])) * sin(deg2rad($loc['to']['lat'])) +
    cos(deg2rad( $loc['from']['lat'])) * cos(deg2rad($loc['to']['lat'])) *
    cos(deg2rad($loc['from']['long'] - $loc['to']['long']))
  )
) * 60 * 1.1515;

[cluelessPHP]

NogDog I'd prefer miles too, I don't get KM but that's what the tutorial was in

[Weedpacket]

...that the OED does not include the word "refactor".

[Weedpacket]

Weedpacket

...TIL that now it does define refactor. I wonder if it's because I pointed it out to them?

[cluelessPHP]

Today I learned when using geolocation to find something in a 10 mile radius, it's best not to use something over 100 miles away from current location..

[cluelessPHP]

Today I learned/finally sat down? And learnt how do make this actually work

RewriteEngine On
RewriteCond %{HTTPS} !=on
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301,NE] 

[dalecosp]

Well, that's good. HTTPS is where it's at these days.

Have you heard of LetsEncrypt?

[cluelessPHP]

dalecosp It's a new one to me

[cluelessPHP]

dalecosp I use it now, it was my thing I learnt today

[dalecosp]

http://www.commitstrip.com/en/2016/06/13/the-end-of-an-expensive-era/

[cluelessPHP]

Today I learned it's probably a good idea to back your code up a few times (ideally three)

[laserlight]

cluelessPHP don't you use a version control system?

[cluelessPHP]

Today I learnt there are two LA's in the US and apparently not everyone from there can understand me

Someone with a completely straight face asked me if I was speaking Gaelic at first

[cluelessPHP]

laserlight I really should in saying that I haven't been using comments either, currently I'm just debugging on my live server

[dalecosp]

laserlight

Is a VCS really a good substitute for a backup in your opinion? It has bearing on a question I've been asked here.