NOTES:
to get the data.
use node/javascript and this project:
[login to view URL]
Use the apis in that project which is open source and free. Read the data for the KJV/Strong references
shortcode for outputting bible with links to strong and mouseouver popup with strong info
parse file create and insert into mysql DB KJV_Strong
// table structure
id (autoincrement)
Volume (varchar 255)
bookNumber int
bookName (varchar 255)
chapter int
verse int
table 2
strong References another project (DONE ALREADY)
table 3 (many-many relationship between strong references and verses)
verse_strong_map
idVerse, idStrong
KEY DELIVERABLES:
SQL script to create the tables: NOTE: there MUST be indexes on each column in table 1, and proper FK constraints must be applied on table 3
database php API: (basic insert and selects ...) : place these in separate DB_Bible class with static methods
Basic functions needed ; MUST be included in the php functions
all functions needed (used in the project) to insert data, retrieve data
In particular:
upsert a row (update or create if it does not exist) a row into the main table, should also have as last parameter an optional array of strongReferenceIds
upsert an idVerse /idStong combination (should accept array parameter for both so that we can upsert many in one call
if the array is not null we insert the corresponding rows into verse_strong_map
TEST PAGE
a test page must be provided which demonstrates that it works (a simple wordpress page, we do not need an admin page, the page is only for validating the project, will not be used, so can be as simple as possible with no particular styling, just readable). we should be able to test each of the functions provided separately (be able to manually insert entries, select entries, delete entries)
the test page must be implemented by a shortcode
[abr_test_strong_db]
In other words, I place this shortcode on any test page and I am able to test the database functions
NO fancy css styling needed, just a few key css classes (prefix classes with abr_
the outermost div should have the css class abr_strong_reference and id abr_strong_reference
only very basic styling is needed for testing, and readability, I will provide final styling. these should be provided in a separate .css file
//
MUST have a public website, for testing I shoud not have to install anything on my side (only for final validation)
all code in a separate PHP class with static functions
Final project needs to look a bit like (for all chapters of the bible, this is one chapter)
I only need the main bible chapter verses and links to the strong references
[login to view URL]
3 Milestones of 100$
1. apis to read data from [login to view URL]
IMPORTANT: read the install instructions carefully: in particular for Windows (section on the bottom), install requires:
npm install node-sword-interface --arch=ia32
javascript functions to read strong and output sql to create data tables
2. apis to read/write from the datables
3. short code with working demo
Hey!,
I’ve carefully checked your requirements and really interested in this parse sqlite3 database insert into mariaDB job. I’m full stack wordpress developer working at large-scale apps as a lead developer with U.S. and European teams.
I’m offering best quality and highest performance at lowest price.
I can complete your project on time and your will experience great satisfaction with me.
I’m well versed in php,wordpress,bootstrap,mysql html/css as well as javascript and jquery.
I have rich experienced in MySQL, JavaScript, PHP and Node.js.
For more information about me, please refer to my portfolios.
I’m ready to discuss your project and start immediately.
Looking forward to hearing you back and discussing all details..
Thanks
Mohammad Farhan Atif
Hello, there! How are you!
I am a web expert.
I've read your explanation carefully. I'm confident with your project. I can work right now. Please contact to me.
Looking forward to hearing from you. Thank you.
Hello!
I'm senior website developer.
I deliver high quality/low price and you get amazing satisfaction!
I promise to do a great job on your project!
No Stress!
Thanks,
Joseluis
Hello Shelby P.,
Hi Shelby P., We went through your project description and it seems like our team is a great fit for this job.
We are an expert team which have many years of experience on PHP, JavaScript, MySQL, Node.js
Lets connect in chat so that We discuss further.
Thank You
Hi Client.
Very glad to bid your project because my skills are matched in your project very well.
I am very familiar with PHP, Node.js, JavaScript, MYSQL and so on.
As a senior Web Developer and Designer with over 7 years experiences, I have worked lots of jobs like this.
So I can complete your project in a short time perfectly and provide the best satisfaction to you through this project.
I am pleasure if i might have a chance to talk with you via chat.
I can start to work right now so please give me chance to serve for you.
Thanks for reading my bid and giving your precious time.