Tag Archives: geographicals

Australian Postcode Place Nearby Tutorial

Back in “the where of life” web application wooooooorrrrrllllldd it’s all fine and good to know “crowfly distances” as we did in Australian Postcode Place Distances Map Chart Tutorial but that level of mathematics is not everybody’s cup of tea. … Continue reading

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , | Leave a comment

MySql Polygon Spatial Relations via Image Map Tutorial

It’s “tomorrow” as per … Continuing the theme of PHP using MySql databases and dealing with Spatial functionality of MySql Stored Procedures Geometry Tutorial, today we establish some PHP to add into a MySql database table as POLYGON data type … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Polygon Insert via Image Map Tutorial

Continuing the theme of PHP using MySql databases and dealing with Spatial functionality of MySql Stored Procedures Geometry Tutorial, today we establish some PHP to add into a MySql database table as POLYGON data type data, the HTML area coords … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures Geometry Tutorial

We’re back from rjmprogramming.com.au domain thoughts at MySql Stored Procedures User Grant Tutorial back to thinking more about where MySql is at these days regarding General Geometry Property Functions. This series of functions applicable with MySql SQL DML or “Stored … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures User Grant Tutorial

Yesterday’s MySql Stored Procedures Spatial Tutorial was fully functional for what we wanted to cover on our local MAMP Apache/PHP/MySql web server featuring … PHP 7 … and … mysqli_connect() via 5.7.23 – MySQL … but to offer any version … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures Spatial Tutorial

Back when we wrote MySql Stored Procedures Primer Tutorial we wrote it more or less to use … PHP 5 and its … mysql_connect() … MySql database connection logic, but today we have a dual (even trial) purpose in mind … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , | Leave a comment

Google Places API Autocomplete Proof of Concept Primer Tutorial

Huge “where of life” concept ahead! Yes, we are trialling the great Google Places API, specifically a proof of concept use of autocomplete logic checking keyboard entered places letter by letter. Cute, huh? As you can imagine, “incumbency” is big … Continue reading

Posted in eLearning, Tutorials | Tagged , , , , , , , , , , , , , , | Leave a comment

Australian Postcode Place Distances Map Chart Tutorial

Yesterday’s “where of life” themed Australian Postcode Place Distances Primer Tutorial lacked something … anyone, anyone? … yes, Anaximander … a map … and you’d like to swap my horse for one … well okay, there’s one called Ed out … Continue reading

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment