Ok the redirecting works for a while and stops saying:
The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
* This problem can sometimes be caused by disabling or refusing to accept cookies.
<?php
ob_start();
header("Content-Type: text/html; charset=utf-8");
error_reporting(E_ALL);
ini_set('display_errors', true);
set_time_limit(480);
// Database connection file
require_once("dbconnection.php");
//require_once("logininfo.php");
if($group !== "Administrator"){
//header("Location: " . $baseURL);
}
$getBook = mysql_real_escape_string($_GET["book"]);
$getChapter = mysql_real_escape_string($_GET["chapter"]);
// Create table
$sql = "CREATE TABLE IF NOT EXISTS ".$dbTable7."(
id MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
book int(3),
book_title_eng mediumtext,
book_title mediumtext,
chapter int(3),
verse int(3),
text_data longtext)";
//collect the newly created fields to insert values within
mysql_query($sql,$con);
$sql = "SHOW FIELDS FROM ".$dbTable7;
$result = mysql_query($sql) or die(mysql_error());
$fields = array();
while ($row = mysql_fetch_array($result)){
$fields[]= $row['Field'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Interlinear - Page <?php echo $_GET["page"];?></title>
<style>
.hebrew{
color: green;
}
</style>
</head>
<body>
<?php
// when the page url shows no results
if($getBook=="" or $getChapter==""){
$getBook=1;
$getChapter=1;
}
//mysql_query($sql,$con);
$sql = "SELECT DISTINCT book_title FROM ".$dbTable3." WHERE book='".$getBook."' AND chapter='".$getChapter."' ORDER BY id ASC";
$result = mysql_query($sql) or die(mysql_error());
//echo $sql;
while($row = mysql_fetch_array($result)){
$book_title = $row["book_title"];
$file = file_get_contents("http://wlc.hebrewtanakh.com/".strtolower($book_title)."/".$getChapter.".htm");
preg_match_all("#<div.*>(.+)</div#Ui", $file, $innerDIV);
/***************************************************begin hebrew title chapter*******************************************************/
// between the two a tags
$replace_final_a_tag = str_replace("</a> ", "</a><li style=\"font-weight: bold;\"><span style=\"color: red;\">", $innerDIV[1][1]);
$replace_beginning_a_tag = str_replace(" <a", "</span></li><a", $replace_final_a_tag);
//search for space in span
preg_match_all("#<span.*>(.+)</span#Ui", $replace_beginning_a_tag, $space);
//print_r($space);
$book_and_title_heb = explode(" ", $space[1][0]);
$chapter=$book_and_title_heb[1];
$book_title_heb=$book_and_title_heb[0];
/***************************************************end hebrew title chapter*********************************************************/
/***************************************************begin english title chapter******************************************************/
preg_match_all("#<a.*>(.+)</a#Ui", $innerDIV[1][2], $a);
/***************************************************end english title chapter********************************************************/
// all <div>s with a style
preg_match_all('/<div style="direction:rtl">(.*)<\/div>/si', $file, $matches);
$add_span_beginning = str_replace(" ", "\n<span>", $matches[0][0]);
$add_span_end = str_replace("<span class=\"reftext\">", "</span>
<span class=\"reftext\">", $add_span_beginning);
$replace_close_span = str_replace("<div style=\"direction:rtl\"></span>", "<div style=\"direction:rtl\">", $add_span_end);
$replace_close_p = str_replace("<p></div>", "</span></div>", $replace_close_span);
$replace_open_p = str_replace("<p>
</span>
", "</span>", $replace_close_p);
$bring_up_close_span = str_replace("
</span>
", "</span>
", $replace_open_p);
preg_match_all("#<span.*>(.+)</span#Ui", $bring_up_close_span, $hebrew);
//print_r($hebrew[1]);
//The hebrew is every odd number of the array
$link = Array();
$text_data = Array();
for($i=0; $i<count($hebrew[1]); $i++){
if(($i % 2) == 0){
preg_match_all("#<b.*>(.+)</b#Ui", $hebrew[1][$i], $link[]);
}else{
$text_data[] = $hebrew[1][$i];
}
}
//print_r($text_data);
mysql_query($sql,$con);
$verse = Array();
$num=count($link)-1;
for($i=0; $i<$num; $i++){
$verse[]=$link[$i][1][0];
}
for($i=0; $i<$num; $i++){
$values = Array($id, $getBook, $book_title_heb, $book_title, $chapter, $verse[$i], $text_data[$i]);
//print_r($values);
$sql = "INSERT INTO ".$dbTable7." (";
$num2 = count($fields)-1;
for($j=0; $j<count($fields); $j++){
$sql .=$fields[$j];
if($j<$num2){
$sql .=", ";
}
}
$sql .=") VALUES ('";
$num2 = count($values)-1;
for($j=0; $j<count($values); $j++){
$sql .=$values[$j];
if($j<$num2){
$sql .="', '";
}
}
$sql .="')";
echo "<span style=\"color: red;\">".$sql."</span><br />\n";
//$result = mysql_query($sql) or die(mysql_error());
$result = mysql_query($sql);
}
} //closes the while loop
?>
<table>
<tr>
<?php
////print_r($fields);
for($th=0; $th<count($fields); $th++){
echo "<th style=\"border: 1px solid black;\">";
echo $fields[$th];
echo "</th>\n";
}
?>
<th style="border: 1px solid black;">
New Columnname:
<input type="text" name="columnname" value="" />
New Columntype:
<input type="text" name="columntype" value="" />
</th>
</tr>
<?php
mysql_query($sql2,$con);
$sql2 = "SELECT * FROM ".$dbTable7;
$result2 = mysql_query($sql2) or die(mysql_error());
//echo $sql;
while ($row2 = mysql_fetch_array($result2)){
?>
<tr>
<?php
for($td=0; $td<count($fields); $td++){
echo "<td style=\"border: 1px solid black;\">";
echo $row2[$fields[$td]];
echo "</td>\n";
}
//echo count($row);
?>
<td style="border: 1px solid black;">
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
$addBook = $getBook+1;
$addChapter = $getChapter+1;
mysql_query($sql,$con);
$sql = "SELECT COUNT(DISTINCT chapter) as count FROM ".$dbTable3." WHERE book='".$getBook."'";
extract(mysql_fetch_assoc(mysql_query($sql)));
//echo $sql;
echo $count; //amount of verses in the chapter
if($getBook<67){
if($addChapter>$count){
$goto = "HTTP://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']."?book=".$addBook."&chapter=1";
}else{
$goto = "HTTP://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']."?book=".$getBook."&chapter=".$addChapter;
}
}
mysql_close($con);
header("Location: ".$goto);
?>
I see duplicate entries.