'; print_r ( $_POST ); print_r ( $_GET ); echo "
"; $db = new orodb(); if( isset( $_POST['reflist'] ) ) { $sql = ''; if( isset( $_POST['Book'] ) ) { $sql = 'INSERT INTO reference (book_num, chapter_num, verse_num) ' . 'VALUES ( "' . $_POST['Book'] . '", "' . $_POST['Chapter'] . '", "' . $_POST['Verse'] . '" );'; echo $db->modifyDb($sql); $sql = 'SELECT r_num FROM reference WHERE book_num = "' . $_POST['Book'] . '" AND chapter_num = "' . $_POST['Chapter'] . '" AND verse_num = "' . $_POST['Verse'] . '";'; $ret = $db->selectDb($sql); if( $ret > 0 ) { $rowData = $db->fetchDb( 0 ); $r_num = $rowData['r_num']; } } else if( isset( $_POST['r_num'] ) ) { $r_num = $_POST['r_num']; } if( isset( $r_num ) ) { $sql = 'DELETE FROM reference_link WHERE r_num = "' . $r_num . '";'; $db->modifyDb($sql); foreach( $_POST['reflist'] as $rt_num ) { $sqlInsert .= ', ( "' . $rt_num . '", "' . $r_num . '" )'; } $sql = 'INSERT INTO reference_link (rt_num, r_num) VALUES ' . substr( $sqlInsert, 2 ) . ';'; $db->modifyDb($sql); } } if( isset( $_POST['edit'] ) ) { echo "
\n"; if( isset($_POST['Book']) ) { echo ''; $refTxt = getReferenceText($_POST['Book'], $_POST['Chapter'], $_POST['Verse']); echo $refTxt; echo "\n\n
\n"; } if( isset($_POST['Book']) ) { $sql = 'SELECT r_num FROM reference WHERE book_num = "' . $_POST['Book'] . '" AND chapter_num = "' . $_POST['Chapter'] . '" AND verse_num = "' . $_POST['Verse'] . '";'; $ret = $db->selectDb($sql); if( $ret > 0 ) { $rowData = $db->fetchDb( 0 ); $r_num = $rowData['r_num']; } $book_num = $_POST['Book']; echo 'Entries Index: ' . $book_num; $sql = 'SELECT rt.rt_num AS rt_num, ' . 'rt.topic_name AS text, ' . 'rl.r_num AS r_num ' . 'FROM reference_topic AS rt ' . 'LEFT JOIN reference_link AS rl ' . 'ON (rl.rt_num = rt.rt_num AND rl.r_num = "' . $r_num . '");'; $ret = $db->selectDb($sql); if( $ret > 0 ) { $rowData = $db->fetchDb( 0 ); $rt_num = $rowData['rt_num']; } } echo '

'; if( isset( $r_num ) ) { unset( $r_num ); } echo ''; echo ''; echo ''; for( $i = 0; $i < $ret; $i++ ) { $selected = ''; $rowData = $db->fetchDb( $i ); if( $rowData['r_num'] != NULL ) { $r_num = $rowData['r_num']; $selected = 'checked'; } printf("\n", $rowData['rt_num'], $selected, $rowData['text']); if( (($i+1)%4) == 0 ) { echo ''; } } echo ''; echo ''; echo ''; echo '

Available Reference Topics
%s
Please select topics for this reference.

'; if( isset($r_num) ) { echo ''; } else if( isset($_POST['Book']) ) { echo ' '; } } else { echo ''; echo ''; echo ''; echo '\n"); printf( "\n" ); printf( "\n" ); echo ''; echo ''; printf( '' ); echo ' '; echo '

Select a Reference to Edit Related Topics
Book Name	Chapter	Verse
'; foreach( $bookNamesArray as $bookNum=>$bookName ) { printf(" %s\n", $bookNum, $bookName); } printf( "	:

'; } echo "\n"; echo ''; ?>