Today I learned

[NogDog]

cluelessPHP Not sure why my brain is expecting a ? or :schema.answer there

We use Postgres's "schemas" to separate each client's data -- functionally similar to having them each in their own database, except they're not. 🙂 That query was actually extracted from the PHP code that builds the query (and simplified and anonymized here), so $schema would actually be replaced with the relevant schema name for the client being processed, e.g FROM client_foo.review r, and then processed with $pdo->prepare().

[cluelessPHP]

Today I learned Sean Connery died

[dalecosp]

cluelessPHP
This saddened me a bit. Watched "You Only Live Twice" and "Thunderball" this weekend in his honor. Wish I had a copy of "Robin and Marian", the chemistry he had with Audrey Hepburn was amazing. And I might be a fan indeed as I don't even hate Zardoz TOO much.

Finally, pretty good compilation of the early Bond themes: https://youtu.be/J4jdUhxOz0M

[NogDog]

dalecosp

Zardoz is fun if not taken seriously. 🙂

"The Man Who Would Be King" is pretty darned good. He and Michael Caine make a great pair in it.

[cluelessPHP]

dalecosp I watched Highlander

[Weedpacket]

dalecosp
I still like his turn in "The Name of the Rose".

[sneakyimp]

Today I learned that I'm not the only person who has seen Zardoz. That movie is awesomely crap-tastic. https://www.youtube.com/watch?v=AfuK_KJTRyg

[dalecosp]

"The gun is good" --- family motto. ;-)

[sneakyimp]

dalecosp you might not like what else ol' Zardoz has to say...

https://www.youtube.com/watch?v=bWeyUTBkTss

[dalecosp]

sneakyimp you might not like what else ol' Zardoz has to say...

You sound like my wife 😆

Remember, at the end Connery comes to find out that part ain't true after all ... 😄

[sneakyimp]

TIL that the film 'Lawrence of Arabia' had its world premiere 10 years closer to the start of the Great War than to the current day.

[sneakyimp]

dalecosp and Rampling, for all her modern foibles, was something to behold.

[sneakyimp]

TIL that returning false works if you declare return type int:

function foo() : int {
        return false;
}
var_dump(foo());

the result:

int(0)

but returning NULL from an int function throws an exception:

function foo() : int {
        return null;
}
var_dump(foo());

the result:

PHP Fatal error:  Uncaught TypeError: Return value of foo() must be of the type integer, null returned in /tmp/a.php:3
Stack trace:
#0 /tmp/a.php(5): foo()
#1 {main}
  thrown in /tmp/a.php on line 3

[Weedpacket]

sneakyimp

You'll also get that if you try to return a non-numeric string (a numeric string would be recast).

Also, attempting to return anything other than an int fail if you declare(strict_types=1);.

Returning null is hazardous, and equivalent to returning nothing at all (return null; is identical in meaning to return;; if a function is supposed to return a value, return; looks wrong). If for some reason you do want nulls hanging around, you can declare the possibility as function foo(): ?int.

[cluelessPHP]

Today I learned Mira Furlan is dead, this year sucks let's go to 2022

[sneakyimp]

TIL that the U.S. Government website for reporting online crime does not work:

 curl -v https://www.ic3.gov/complaint/default.aspx
*   Trying 65.201.175.169:443...
* TCP_NODELAY set
*   Trying 2600:803:c20::3:16:443...
* TCP_NODELAY set
* Immediate connect fail for 2600:803:c20::3:16: Network is unreachable
*   Trying 2600:803:c20::3:15:443...
* TCP_NODELAY set
* Immediate connect fail for 2600:803:c20::3:15: Network is unreachable
*   Trying 2600:803:c20::3:16:443...
* TCP_NODELAY set
* Immediate connect fail for 2600:803:c20::3:16: Network is unreachable
*   Trying 2600:803:c20::3:15:443...
* TCP_NODELAY set
* Immediate connect fail for 2600:803:c20::3:15: Network is unreachable

[jjgupta915]

Today I learned PHP filters. I really enjoy the PHP language while I am learning it.

[NogDog]

TIL (thanks to sneakyimp) that you can do...

16:16 $ /usr/bin/php -a
Interactive shell

php > $😊 = 'happy';
php > echo $😊;
happy
php >

[sneakyimp]

you can define emoji classes and namespaces, too:

class 😊 {
  public static function ☹️(){
    echo "🎭\n";
  }
}
😊::☹️();

[NogDog]

sneakyimp -- There can be a new variant of PHP "code golf" now. 🙂

[Weedpacket]

sneakyimp

TIL (not really today, but it came up again today) that a nonbreaking space is a valid character that can be used in identifiers.

<?php
$fo = 42;
$fo = 17;
echo $fo ;

Outputs 42 because of course that's $fo  in the first and third positions, but only $fo in the middle.

And it's also valid in constants as well (strictly speaking, almost all strings are valid as constant names, but most of them can't be used without wrapping them in constant()):

<?php
define(' ', 42);
function foo() { return ;}
echo foo();

Edit: Hey; still got the error message but the thread got bumped to the top of the list!