Tag Archives: data table

AppML Acronyms Hierarchy Tutorial

Yesterday’s AppML Acronyms Tutorial works in an HTML table by appml-repeating table cell content elements via an array. What happens if your JSON contains arrays within arrays, like our Acronym data’s “vars” members … [{“sf”: “BHP”, “lfs”: [{“lf”: “benign prostatic hyperplasia”, “freq”: 12, “since”: 1992, “vars”: [{“lf”: “benign prostatic hyperplasia”, “freq”: 8, “since”: 1992}, {“lf”: “Human benign hyperplastic prostate”, “freq”: 2, “since”: 1994}, {“lf”: “Benign prostatic hyperplasia”, “freq”: 1, “since”: 1995}, {“lf”: “benign prostate hyperplasia”, “freq”: 1, “since”: 1995}]}, {“lf”: … Continue reading →

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

MySql Database on Database Join Tutorial

Why might you want to join two tables from different databases of the same type, that being MySql, today? We can think of … synchronizing two data sources represented by those two database tables, perhaps one updated, one yet to be updated reports that compare databases, or show trends, or show differences its a lot like synchronizing, but database backup system may want to do this We use this technique for WordPress keeping blog postings with the same (posting) ID … Continue reading →

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

SQL for Flat Files Supervisory Tutorial

Though we could add many more web applications that use our Flat Files SQL Engine (in a child HTML iframe element scenario) we’re feeling a bit “onions of the 4th dimension” about all this, and we think we can encase all of this work within the “bowels” of one supervisory web application, and we are ready to do that now that we have more than one “parent” player of Flat File SQL Engine work. How so? Well, we know that … Continue reading →

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

SQL for Flat Files Data Type Tutorial

Do you recall a statement in this blog posting thread’s “primer” tutorial as per … data type “smarts” … we’re keeping it really “everything ends up as a string” … doh … simple, for now, with our flat file data system design … well, today, we continue on the quest to add data type intelligence to our web application to improve on that “Primer” tutorial scenario. How, continue? Well, in a previous blog we had the functionality … when using … Continue reading →

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

SQL for Flat Files Database Tutorial

We’ve spoken about “data permanence” before, when we presented PHP Themed Supervision Sixth Genericization Tutorial Can the Javascript client side of the web application world “save” anything? Sort of, if you want to consider HTTP Cookies, and lots and lots of websites do this, as you probably know if you use the web to shop for things. A server side language like PHP (or ASP.Net) can make this arrangement more permanent, because, as you probably know, you can clear the … Continue reading →

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

SQL for Flat Files Poll Tutorial

We venture further down the route of interfacing web applications to our Flat File SQL Engine. The first interfacing web application we started out on, to the “proof of concept” level yesterday, when we presented SQL for Flat Files DDL Tutorial, we’ve extended in its scope. Interfacing can be a rewarding programming exercise for a few reasons … modularization of code can be a good way to go and with interfacing you tend to compartmentalize functionality into components, which can … Continue reading →

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

SQL for Flat Files DDL Tutorial

Welcome to the tutorial title that changes the least but with a big change to direction with our Flat File SQL Engine thinking because today’s SQL DDL focussed work opens our Flat File SQL Engine up to ‘outside’ use. That ‘outside’ is only web applications from the www.rjmprogramming.com.au domain, and this is deliberate. Remember when we said, in an earlier blog posting on this thread whose last offering was SQL for Flat Files DML Tutorial? DDL functionality is hidden from … Continue reading →

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

SQL for Flat Files DML Tutorial

Continuing on with our “Flat File SQL Engine” project today, building on yesterday’s SQL for Flat Files Primer Tutorial we can summarize the emphasis of today’s work by … relenting on those DML flat file data table data content restrictions, talked about yesterday saying, then … we are going to disallow ~ and ` and Comma (ie. “,”) and | from being allowed in “data values” above, period … well, the “period” turned out to be 18 hours … chortle, … Continue reading →

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