App-Helper

WHAT IS THIS?
=============
NanoWiki is a documentation tool with a small footprint, extreme containment, and maximum portability, even when segments are isolated from a comprehensive constellation. Each element is as self-sustained as possible.
Unlike most content managers, this documentation tool tries to embed as much content as possible into one file, not link resources, like images and/or supportive documents. Therefore these binary files are converted to text, using base64-conversion, then included into the content via straight HTML. The syntax for images, documents, and links is provided as templates, along with explanations and samples.

HOW DOES IT WORK?
=================
CHANGE THE MAIN TITLE...
of the documentation, by double-clicking on it.

ADD ARTICLES...
as needed, bring them into the right order, and save the whole page through the button in the upper left.

EDIT ARTICLES...
by double-clicking them. Then edit and save the whole page (again) with the button in the upper left. Get new images and documents posted, using the conversion tool in the [ADD] section.

NO FONT-SIZE, BOLD, ITALIC, TABLES - NOTHING???
Nope. Enjoy your own HTML-skills, almost everything is supported (but stay away from </textarea> and JavaScript). This is intended to be as simple and bare-bones as possible.
Templates for images and links (to files and pages) are included. Use CAPITALIZATION, +++ additional characters +++, and indentation for emphasis and organization. Worked for decades on a typewriter, works here too.

AND NO 'UNDO...'
In the text-box, right-click and choose UNDO, or press [CTRL]+[Z] / [CTRL]+[Y] for UNDO / REDO.
If you messed up completely, deleted something, open the original you should overwrite after editing in a separate window and get the content from there (open the editor with a double-click).
If you broke the system somehow, do not overwrite the previous version, simply re-load the page, and start over. If you overwrote the original already, get a backup.
MAKE AND KEEP BACKUPS, they compress nicely and fast. Disciplin, people, this is meant to be small, simple, fast, portable, and independent, not fool or vilain proof.

AND NO LOGIN/SECURITY...
Not needed, only you (or your people) have write access to the files. You can write anything on a paper copy, doesn't change the original, neither other people's copies.

HOW DO I SHARE MY DOCUMENTATION?
================================
Give others read access e.g. by posting the wiki on a web server or on a file-sharing platform, like Dropbox or Google Drive. Just find out how to "make file publicly accessible".
Web servers or fully addressible platforms are (only) required to provide cross-linked multi-topic documentation sites instead of single documentation pages.
Here is a handy notes file handler, extract directly into directory with documentation notes on a PHP-enabled web server.

ENJOY! - or improve...

Table Name:

NOTE: EXCLUDE RECORD ID COLUMNS (table PKs -and - FKs)

Datatypes:

INSERT

-ready-

UPDATE

-ready-

More Code Stuff:
// GENERAL TABLE DELETE FUNCTION - CALL 'DELETERECORD([TABLE NAME],[PRIMARY KEY COLUMN NAME],[RECORD ID])' function deleteRecord($table,$index_field,$index_id) { if(($table) && ($index_id) && ($index_field)){ DB::delete($table, $index_field."=%s", $index_field); } } // GENERAL RECORD-EXISTS PROBE FUNCTION - CALL 'RECORDPROBE([TABLE NAME],[PRIMARY KEY COLUMN NAME],[RECORD ID])', RETURNS ARRAY IF RECORD EXISTS function recordProbe($table,$index_field,$index_id){ return DB::queryFirstRow("SELECT * FROM ".$table." WHERE ".$index_field."=%s", $index_id); } // SINGLE FILE UPLOAD $filename=basename($_FILES['Photo']['name']); $file_error=false; // validation flag // validate file type $valid_mimes= array("image/jpeg","image/jpg","image/png"); //allowed mime types if(in_array($_FILES['Photo']['type'],$valid_mimes)=== false){ echo "Image " . $filename ." not allowed, please choose a valid image format (.jpg or .png).<br />"; $file_error=true; } // limit file size to 5MB if($_FILES['Photo']['size'] > 5242880) { echo "Image " . $filename ." must be less than 5 MB<br />"; $file_error=true; } // set upload directory, add date stamp to filename, to avoid overwriting $filePath = "uploads/images/"; $filePath = $filePath . date('Y-m-d-h-i-s-A') . ' - ' . $filename; // if no error, copy file from PHP-temp storage to server, create database entry if(!$file_error){ if(move_uploaded_file($file_tmp, $filePath)) { // *** DATABASE INSERT QUERY FOR FILES HERE *** } else { echo "There was an error uploading document " . $filename . "<br />"; } } // MULTI FILE UPLOAD for($x=0;$x<count($_FILES['Document']['name']);$x++){ // loop through all documents uploaded $filename=basename($_FILES['Document']['name'][$x]); $file_error=false; // validation flag // validate file type $valid_mimes= array("application/pdf","application/vnd.openxmlformats-officedocument.wordprocessingml.document","application/msword","text/plain"); //allowed mime types if(in_array($_FILES['Document']['type'][$x],$valid_mimes)=== false){ echo "Document type on " . $filename . " not allowed, please choose a valid file format (.pdf, .doc, .docx, or .txt).<br /"; $file_error=true; } // limit file size to 5MB if($_FILES['Document']['size'][$x] > 5242880) { echo "Document " . $filename . " must be less than 5 MB<br />"; $file_error=true; } // set upload directory, add date stamp to filename, to avoid overwriting $filePath = "uploads/documents/"; $filePath = $filePath . date('Y-m-d-h-i-s-A') . ' - ' . $filename; // if no error, copy file from PHP-temp storage to server, create database entry if(!$file_error){ if(move_uploaded_file($_FILES['Document']['tmp_name'][$x], $filePath)) { // *** DATABASE INSERT QUERY FOR FILES HERE *** } else { echo "There was an error uploading document " . $filename . "<br />"; } } } // COMMON PREFILL TEMPLATES - VIEW / EDIT TEXT LINE: <input type="text" name="xxxxx" placeholder="xxxxx" value="<?php echo $data['-table-'][0]['-column-']; ?>"> TEXT BOX: <textarea name="xxxxx""><?php echo $data['address'][$x]['notes']; ?>[/textarea] DATE: <input type="text" name="xxxxx" placeholder="MM/DD/YYYY" value="<?php echo str_replace('01/01/1970','',date('m/d/Y',strtotime($data['-table-'][0]['-column-']))); ?>"> DROPDOWN: <input type="hidden" name="xxxxx" value="<?php echo $data['-table-'][0]['-column-']; ?>"> CHECKBOX: <input type="checkbox" tabindex="0" class="hidden" name="xxxxx" <?php echo (str_replace('F','',$data['-table-'][0]['-column-'])) ? 'checked="checked"' : '' ; ?>> MULTI-FIELD SUBMISSION <?php if (count($data['-table-'])){ for($x=0;$x<count($data['-table-']);$x++){ ?> <input type="hidden" name="['-table-']_id[]" value="<?php echo $data['-table-'][$x]['-record_id-']; ?>" /> ... <input type="text" name="xxxxx[]" value="<?php echo $data['-table-'][$x]['-column-']; ?>"> ... <?php } } ?>

-ready-