Tag Archives: SQL

WordPress Is Mentioned By Posting Order Tutorial

We are revisiting the WordPress Blog “Is Mentioned By” functionality talked about at WordPress Is Mentioned By Posting Thread Tutorial for a few reasons … the order of blog postings that could end up on dropdowns as a result of … Continue reading

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

Python MySql Connector Blob Tutorial

No, Nala, we can’t see The Blob for the 743rd time today. But we can discuss “blob” in terms of MySql database file storage. It’s that, or a bath?! Okay, that’s settled, so make yourself comfortable with your favourite bone … Continue reading

Posted in eLearning, Not Categorised, Operating System, 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

Python MySql Connector Primer Tutorial

In the past we’ve teamed Python (server side language) up with the MySql (database) via a python module called MySQLdb when we presented Python MySql Circle and Point DataTable Primer Tutorial below. Then, we shared the Mac OS X MAMP … Continue reading

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