bible_to_sql.php
Summary:
Fixed all errors, mainly due to getting whole chapters (It previously tried to get BETWEEN verses 001 and 009, which returns and error).
Major changes:
Default values for verse and endverse are now strings, as they should be.
Previously, getting whole chapters (Eg: Psalm 23) did not work. Fixed this by using >= and < instead of BETWEEN in SQL query. Since < is used, added one to end verse. Default values for verse and endverse (001 and 999) are used when whole chapter is selected.
Used !isset(var) instead of !var, which returns error.
Formatting changes:
Using tabs, not sure what original is meant to be as it had a mix of tabs and spaces.
Added space after commas for consistency.
Minor formatting changes.
index.php
Major changes:
Added dropdown list for selecting bible versions (gets versions from database).
Added UTF-8 support, to support special characters from other languages. (Need to change CHARSET=latin1 to CHARSET=utf8 for the MySQL Tables for foreign bibles though).
Removed redundant init() for stmt.
Removed duplicate form below.
Formatting changes:
Same as bible_to_sql.php, and added appropriate tab indentations.
bible_to_sql.php Summary: Fixed all errors, mainly due to getting whole chapters (It previously tried to get BETWEEN verses 001 and 009, which returns and error).
Major changes:
verseandendverseare now strings, as they should be.>=and<instead of BETWEEN in SQL query. Since<is used, added one to end verse. Default values forverseandendverse(001 and 999) are used when whole chapter is selected.!isset(var)instead of!var, which returns error.Formatting changes:
index.php Major changes:
CHARSET=latin1toCHARSET=utf8for the MySQL Tables for foreign bibles though).Formatting changes:
bible_to_sql.php, and added appropriate tab indentations.