Here you will find an app that can map cross references and subjects at the same time, in a couple of ways. This relies on user created scriptural cross reference data, and you'll need to create your own additional JSON files, or extend the ones in this project.
Currently flare uses only public domain bible translations:
- American Standard-ASV1901 (ASV)
- Bible in Basic English (BBE)
- Darby English Bible (DARBY)
- King James Version (KJV)
- Webster's Bible (WBT)
- World English Bible (WEB)
- Young's Literal Translation (YLT)
- / (HTML)
- index.html is the latest chart being developed, the data is only demo data and not fully fledged out.
- Jesus-in-the-old-testament.html (HTML) this uses the hierarchical edge bundling chart (hierarchical many to many relationships) which is great for subject mapping and for presentations. A copy of this page can host different chart data by modifying the JSON file name near the end of the document.
- /assets/css/ (CSS)
- flare.css contains:
- Flare specific CSS for both HTML pages
- Dashboard style mods (near the end of the document)
- style.css contains dashboard specific CSS.
- components.css contains dashboard specific CSS
- flare.css contains:
- /assets/js/ (JavaScript)
- flare.js contains:
- flare-biblestudy.js contains:
- D3.js v3 Hierarchical Edge Bundling Chart functionality
- REGEX functions for identifying bible verses on the page
- AJAX for returning HTML on ajax.php upon making an HTTP GET request.
- functions.js contains primarily dashboard functionality, but the end of the file also has document ready javascript used by both HTML pages.
- /assets/json/ (JSON)
- para.json contains demo data used for cross references in index.html. This is the one you can modify for your own cross reference threads.
- flare-OldTestamentJesus1.json contains demo data for cross references and subject mapping in . They are called from their respective pages.
- kjv.json contains bible stats based on data from the King James translation.
- /assets/database/ (PHP/MySQL)
- ajax.php uses HTTP GET parameters to wrap specified scriptures in HTML. Creates a Librarian object, prepares statements, and specifies the translation to query. un-comment the error checking statements (don't move them) to troubleshoot
- bible_to_sql_service.php Librarian extends Servant. Only upon successful preparation of a statement can Librarian query the database. use the construct function in Servant to specify host, user, password, and database. **Both classes contain extra functions for testing
At a bare minimum, you will need to know some basic JSON know how to create new cross reference content. Feel free to use the additional JSON files at http://flare.hispattern.com for a launching point.
JavaScript, jQuery, JSON are the primary technologies used, with HTML and CSS for layout and styling. However AJAX, PHP, and MySQL are also involved. I'd be excited to have a contributor to the project!
- You'll need a WAMP, LAMP, or other web server (I'm running Apache2 with a localhost setup in Linux for development)
- ≥MySQL 5.7 installed
- ≥PHP 7.2 installed
- mysqli/mysqlnd enabled. Ubuntu how-to
- Complete the Bible Database Setup
- Clone the repo:
git clone https://github.com/donaldmilligan/flare-bible-study.git, or downloadwget https://github.com/donaldmilligan/flare-bible-study/archive/master.zipand unzip to your localhost path.
Use phpMyAdmin or MySQL statements to accomplish these tasks.
Notes: the default database name in bible_to_sql_service.php is bible_db, and I will assume that's the name in the instructions.
Create a database, localhost db user, password, and set user rights for the db
import the all_translations.sql file into the db you created
An easy way to do this is use phpMyAdmin.
- Login to phpMyAdmin
- Create a database named bible_db
- Create a user named 'bible'@'localhost' (or name it whatever you want for that matter. Just modify the Servant class construct function accordingly in bible_to_sql_service.php.
- Edit privileges for your user using the database option, and grant all data and structure privileges for bible_db.
- Select bible_db, then use the Import tab to import the /sql/all_translations.sql file into bible_db.
- Go modify the Servant class construct function in bible_to_sql_service.php to match your host, user, password, and database configuration.
- You're done. Not displaying scriptures? Use the Troubleshooting Errors if you know what you're doing.
In this method, you'll accomplish the tasks using the command line.
- First login with your root account.
mysql -u root -p
- Create a localhost user: for example, with the name bible (replace YOURPASSWORDHERE with your own, but keep the hyphens):
CREATE USER 'bible'@'localhost' IDENTIFIED BY 'YOURPASSWORDHERE';
- Create a database named bible_db:
CREATE DATABASE bible_db;
- Grant just enough privileges for the user bible to manage the database:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON bible_db.* TO 'bible'@'localhost';
- In Linux (or with MobaXterm in Windows), navigate to the /sql/ folder, or open a terminal there, and use this command to import all_translations.sql into bible_db. You will be prompted for your root mysql password
mysql -u root -p bible_db < all_translations.sql
-
Make sure you modify the Servant class construct function in bible_to_sql_service.php to match your host, user, password, and database configuration.
-
You're done. Not displaying scriptures? Use the Troubleshooting Errors if you know what you're doing.
This will enable php to return error messages that show what is happening, Un-comment the logging statements in ajax.php, so the top of the file looks like this:
<?php ini_set('display_errors', 1);/// for debugging error_reporting(E_ALL);/// for debugging
Reload your page and use the error messages displayed by AJAX to correct them, or to reference when asking for help. The error messages will be displayed where the scriptures should be on each page.
- More well thought out JSON cross reference data, and subjects
- Minor Ui improvements like toggling the arrow when tapping off of the side-bar on small screens
- Create similar editing interface to create JSON files with the visual aid. they are currently programmed one line at a time.
- Get out of the demo stage for JSON data - I've created the cross referencing in para.json and flare-OldTestamentJesus1.json on my own.
- Convert the project using Vue Native for mobile
- Convert to using JSON or SQLite bible databases for use in Android
Flare is based on features from these projects:
- (Scriptures) PHP and MySQL from my PHP7 complient fork of scrollmapper/bible_databases
- (SQL Databases) The SQL bible databases, also available in my PHP7 complient fork of scrollmapper/bible_databases
- (Charts) D3.js Data Visualization library https://github.com/d3/d3
- A D3.js v4 Arc Chart. Bible Viz History: the bible chapter lengths were first visualized in a colaboration between Carnegie Mellon professor Chris Harrison and Lutheren pastor Christoph Römhild.
- The Flare arc chart (flare.js) used in index.html is based on https://github.com/danielgtaylor/bibviz/blob/master/web/contents/scripts/main.js
- Other resources: https://observablehq.com/@d3/arc-diagram and https://www.d3-graph-gallery.com/arc
- A D3.js v3 Hierarchical Edge Bundling chart from https://observablehq.com/@d3/hierarchical-edge-bundling
- A D3.js v4 Arc Chart. Bible Viz History: the bible chapter lengths were first visualized in a colaboration between Carnegie Mellon professor Chris Harrison and Lutheren pastor Christoph Römhild.
- (REGEX) jQuery Biblify a very robust way to find verses on a page, and originally built to replace the text with links to pages with the scritpures using AJAX.
- (Dashboard Styles and Functionality) Flare uses a modified version of the Stisla dashboard theme
Flare is under the MIT License