REQUIRES Stacks5.1+ or StacksPro and the Foundation6 framework.

SEE GALLERY SCREEN SHOTS

Video here by StacksWeaver

F62SQLite ver.1.0.9 Instructions
  1. Add a Ajax Request Action to your F6 form.
  2. Set the URL to: F62SQLite.php.

  3. Settings

  4. Set the Data Path in this stack. (from the website root)
    Example: /admin/data/
  5. Set the Database Name.
  6. Set the Table Name for the form data.
  7. Set the File(s) Destination. This can be either a table name or a folder path from Doccument_Root if saving to a folder.
    This and all file settings are only used if you are allowing uploading of files with the form data.
  8. Set the File Operations.
    • Store Files in Tables: When checked files are stored directly in a table set in the Destination field above.
      When NOT checked the file(s) will be stored in a folder set in the Destination field.
    • Multiple Files: Check this if you have the f6 File Upload set to allow Multiple File Selections.
  9. Single File Options
    • Set Url in Table. Note: this is only active if Not Storing files in a table AND Not Storing Multiple files.
  10. Multi-File Options
    • Comma List writes a comma seperated list of urls in the filename column of the form table. NOTE: this is only active if NOT storing files in a table.
    • id in File Table: This writes the Form table Row id to the File Table row. NOTE: This is only active when storing file(s) to a table.
  11. Trailing Field Removal: Set the number of field NOT to pass in the data. Starting at the end and going backwards to ward the first form field.
  12. Turn on Logging: This creates a detailed log file in the page folder. Helpful when trouble shooting issues. 

Notes

If the database does Not exist it will be automatically created. If the Form table does not exist it will be automatically created from the form structure. An auto incrementing id field will be added. If storing files in a seperate table, that table will be auto created if it does not exist as well. If saving files to a folder the folder will be created if it does not exist. 

Reserved Field Names:The following names can not ber used for form fields: filename, file


F62SQLiteUpdate Instructions

Note:You will call this page passing the row id of the record you wish to update as a url parameter. EX: https://Yoursite.com/Yourpage/?id=7

  1. Settings

  2. Set the Data Path in this stack. (from the website root)
    Example: /admin/data/
  3. Set the Database Name.
  4. Set the Table Name for the form data.
  5. Set the Remove columns. This is a comma seperated list of columns you do not wish to create a form field for.
  6. Turn on Logging: This creates a detailed log file in the page folder. Helpful when trouble shooting issues. 

Notes

This is not intended to update any columns that hold binary data (BLOB). If you have a column holding binary data you should add it to the remove list.