Brigidine Rowing - Sunday Morning

Small numbers today bolstered by some ringins.  We had the two French exchange students that are staying at Thallon st plus Michaela & her boyfriend.  As we had exactly 9 and so many inexperienced, we thought we would take out an eight. 

2019 SEQ School State Rowing Championships

Firstly google have forgotten about customers
https://www.publicalbum.org/blog/embedding-google-photos-image

I am at the South East Queensland Schools Championships.
Kenmore and Brigidine row with centenary Rowing Club.
We only have 4 girls from Brigidine - Caitlin, Jessie, Anabelle &Jemma.
There are about double this from Kenmore.

This year, in my opinion, Rowing Queensland (RQ) have hanged the rules to favour the large private schools.  The traditional rowing schools.  They have done two things I disagree with.  Firstly they have decided to engage directly with the schools and secondly they have required each school to pay a $330 affiliation fee.

So a school with 1 rower has to pay $330 for that rower to row and a school with 100 rowers effective pays $3.30 per rower.  And the schools with lareg programs are guess what the big established private schools.

Now consider the "engage with Rowing Queensland" side of it.RQ wish to "engage" directly with the schools.  BUT they forget that many of the schools simply don't want to "engage".  State schools for example are hardly likely to want to "engage" with anyone.  A private school might but they have to first see that there is a benefit to the school and their students.  At the practical level where I am the effect is that because I am not "THE rowing coordinator" they wont send me any of the paperwork that they send to the school.  The school does not have a paid Coordinator so the paperwork just moves along.  maybe.

I have heard several stories of schools who feel that the whole thing si just too hard. 

For us at Centenary it's made for a ton of extra work.  Once upon a time, all we had to do was get the principal to sign a piece of paper stating that the kids could represnet the school.  Now we have to do that except RQ sends the paper to the school and does not tell us.  So no one knows to advocate for it to be signed.  Then RQ sends the invoice to the school.  Where it can languish because the school does not know what it is for and we don't know it was sent.  Then the school pays it and invoices us the rowing club.  Then we pay the school.  Then we do what we used to do in the past.  Divide it by the number of kids and add a towing, boat maintenance and insurance fee and then issue invoices to the kids participating.

I wonder if any other peak bodies make it so dam hard.

The weather was near perfect.
Warm.  Very little wind.

Jemma and Caitlin on their way out.  They got a bronze medal for the GR10 double.

Jemma won her GR9 single heat by a very ling way.  Here her friend Caitlyn smiles for the camera.

Marcus Graduates LAW

Tuesday night we went to witness, support and cheer Marcus as he graduated with a Bachelor of Law.

I went to Thallon st and got changed.  Megan and I drove to Brigidine in Megan's car and picked up Jemma.  We continued to UQ.  Megan dropped Jemma and I near Mayne Hall.  Jemma was in her sports uniform and wanted to change into something more formal.  Megan went to park the car and Jemma went and changed in the Law library toilets.  We managed to meet up with Marcus & Sophie and shortly thereafter Chris and Dan appeared having parked at Toowong rowing club.  It too a while for Megan to join us but eventually we were all together and the photos began.  Then we traped across to the UQ centre.

MRP MySQL v PDO

XAMPP on my laptop is now running PHP V7.3.3
The old procedural API commands have been removed from PHP.  The jargon word is depricated.
My MRP system is full of the procedural calls.

QUESTION 1 - PDO or MySQLi
Reading a few web sites
https://websitebeaver.com/php-pdo-vs-mysqli
https://www.w3schools.com/php/php_mysql_connect.asp
"Both are object-oriented, but MySQLi also offers a procedural API."
So I will use MySQLi

CHANGES

OLD	NEW  note the i's
.	.
.	.
mysql_fetch_array($result, MYSQL_ASSOC);	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
.	.
mysql_query($query)	$dB = $GLOBALS['db']; mysqli_query($dB , $query)
.	.
.	.
.	.
.	.

$result = @mysql_pconnect("localhost", "user", "pass");
$result = mysqli_connect($host, $username, $password);

// https://stackoverflow.com/questions/22834458/deprecated-mysql-pconnect
// UPDATE: As pconnects have nearly no benefit,
// you should replace mysql_pconnect with mysql_connect in your scripts anyway.
if (!function_exists("mysql_pconnect"))
{
    function mysql_pconnect($host, $username, $password)
        {
        //return mysqli_connect("p:".$host, $username, $password);
        return mysqli_connect($host, $username, $password);
        }
}.

mysql_select_db ( string $database_name [, resource $link_identifier = NULL ] ) : bool

@mysql_select_db("db name")
mysqli_select_db ( $result , $dbname ) 

So it looks like the old way, the "link" was optional


Selects the default database to be used when performing queries against the database connection.
https://www.php.net/manual/en/mysqli.select-db.php

mysqli_select_db ( mysqli $link , string $dbname ) : bool

The link is the identifier returned by mysqli_connect
so I need

mysqli_select_db ( $result , $dbname ) 

mysql_query()

mysql_query ( string $query [, resource $link_identifier = NULL ] ) : mixed

mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] ) : mixed

mysql_num_fields()
mysqli_num_fields($result)

mysql_fetch_array($result, MYSQL_ASSOC);
Note: MYSQL_ASSOC does not exist in PHP7

mysqli_fetch_assoc ( mysqli_result $result ) : array

mysql_insert_id

mysqli_insert_id ( mysqli $link ) : mixed

$urn = mysqli_insert_id($dB);