PHP file for Importing Excel data
One of the first large procedures I wrote, worked and reworked, but you can still see some novice in there.
​
Making heavy use of functions, both embedded and in an import library, this .php page identifies where its server is, loads a HTML page, checks for data, then within a large IF/THEN, analyzes and pre-processes data, performs some validation, inserts into the database, does some logging, and confirms all transactions.
Subset of a PHP library
Something to note. Within -->
"function get_form_specs($formname)" is the reference to external
"function get_form_input_details()", then following that call you can follow the extraction of useful metadata about the referenced HTML page.
​
This is metadata of a raw, proper HTML5 page, is used with functions and user or database sourced data, to generate a totally clean HTML page with data properly integrated as part of the page, including drop downs.
​
I'm sure there are tools to do something similar, but none were available nor known to me at the time I wrote this set of procedures/functions to process HTML5 with PHP.
Samples of my Work
Shell script code invoking SQL api
Another occasional-use example. This time I'm not sure exactly what I was doing.
I do know it had to do with merging WA State Secretary of State's business licensing information with 'like' data from the Department of Licensing.
NOT a clean match.
​
This simply shows some CASE usage, looping control variable manipulation, DB I/O, and a string translation.
​
No shell functions shown here.
I make a practice of collecting good functions and code that I write and find.