Php website -- 2

[login to view URL]

you will see in above link

Basic Website Interaction part

What we need is someone to adjust this php file to show a Button Start and Stop

so someone will click to Start button and script will count random verses that is stored in Db and it will show the verse when user click Stop , and script should use this math when clicked start until user clicks stop by 3 , 7 and 70 changing between the scriptures when clicked start ,

so when clicked stopped it will show the Verse of the day ( wherever the script stops at that time )

you can see it on GITHUB (bible_databases)

Verse ID System:

Each verse is accessed by a unique key, the combination of the BOOK+CHAPTER+VERSE id.

Example:

Genesis 1:1 (Genesis chapter 1, verse 1) = 01001001 (01 001 001)

Exodus 2:3 (Exodus chapter 2, verse 3) = 02002003 (02 002 003)

The verse-id system is used for faster, simplified queries. For instance:

01001001 - 02001005 would capture all verses between Genesis 1:1 through Exodus 1:5.

Written simply:

SELECT * FROM bible.t_asv WHERE id BETWEEN 01001001 AND 02001005

Coordinating Tables

There is also a number-to-book key (key_english table), a cross-reference list (cross_reference table), and a bible key containing meta information about the included translations (bible_version_key table). See below SQL table layout. These tables work together providing you a great basis for a bible-reading and cross-referencing app. In addition, each book is marked with a particular genre, mapping in the number-to-genre key (key_genre_english table) and common abbreviations for each book can be looked up in the abbreviations list (key_abbreviations_english table).

While its expected that your programs would use the verse-id system, book #, chapter #, and verse # columns have been included in the bible versions tables.

A Valuable Cross-Reference Table

A very special and valuable addition to these databases is the extensive cross-reference table. It was created from the project at [login to view URL] See .txt version included from [login to view URL] website. Its extremely useful in bible study for discovering related scriptures. For any given verse, you simply query vid (verse id), and a list of rows will be returned. Each of those rows has a rank (r) for relevance, start-verse (sv), and end verse (ev) if there is one.

Basic Web Interaction

The web folder contains two php files. Edit the first few lines of [login to view URL] to match your server's settings. Place these in a folder on your webserver.

The references search box can be multiple comma separated values. (i.e. John 3:16, Rom 3:23, 1 Jn 1:9, Romans 10:9-10) You can also directly link to a verse by altering the URI: [http://localhost/[login to view URL] 3:16, Rom 3:23, 1 Jn 1:9, Romans 10:9-10](http://localhost/[login to view URL] 3:16, Rom 3:23, 1 Jn 1:9, Romans 10:9-10)

PHP JavaScript MySQL HTML

项目ID： #28134564

关于项目