First compare `phpBible_greek_lexicon` & `lexicon_greek`
then
`phpBible_hebrew_lexicon` & `lexicon_hebrew`
then compare to strongscsv
take every single character
//`lexicon_greek` & phpBible_greek_lexicon matched
//`lexicon_hebrew` & phpBible_hebrew_lexicon matched
SELECT * FROM `phpBible_hebrew_lexicon`
Showing rows 0 - 24 (8675 total, Query took 0.0003 seconds.)
SELECT * FROM `lexicon_hebrew` **************************
Showing rows 0 - 24 (9289 total, Query took 0.0003 seconds.)
SELECT * FROM `phpBible_greek_lexicon` *******************
Showing rows 0 - 24 (5624 total, Query took 0.0008 seconds.)
SELECT * FROM `lexicon_greek`
Showing rows 0 - 24 (5524 total, Query took 0.0006 seconds.)
//have to set or time out & run outta memory.
ini_set("memory_limit", "8192M");
ini_set("max_execution_time", "300");
//So we load up the `lexicon_greek` & `strongscsv` into a string
//$master_string = all greek words from the `lexicon_greek` & `strongscsv`
$masterarray=array();
if($create)
{
$masterarray=mbStringToArray($master_string);
$masterarray = array_unique($masterarray);
sort($masterarray);
$t_json=json_encode($masterarray);
$filej='';
file_put_contents($filej, $t_json);
$filecsv='';
$out = fopen($filecsv, 'w');
fputcsv($out, $masterarray);
fclose($out);
}
function mbStringToArray ($string) {
$strlen = mb_strlen($string);
while ($strlen) {
$array[] = mb_substr($string,0,1,"UTF-8");
$string = mb_substr($string,1,$strlen,"UTF-8");
$strlen = mb_strlen($string);
}
return $array;
}
see https://www.recyclethebible.org/mysql/StrongsLIT/all/readme.php