populating 3 listboxes

Discussion in 'PHP' started by gilgalbiblewheel, Dec 21, 2007.

0
  1. #1
    I was converting old asp files to php.

    But I'm stuck at this point.

    I'm looking for a triple combo listboxes where one has "book" the other "chapter" and the third "verse". The book is populated by a database table. Once book is selected then chapter is populated and then verse.

    Any tutorial related to this?
     
    gilgalbiblewheel, Dec 21, 2007 IP
  2. gilgalbiblewheel

    gilgalbiblewheel Well-Known Member

    Messages:
    435
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #2
    I'm converting ASP to PHP:
    <?php
/*'Option Explicit*/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title>Read the King James Bible</title>
		<script language="JavaScript" type="text/javascript">
		<!--
			function go(action) {
			
			// set variables pointing to the two forms we need
			var theForm = document.forms["myForm"];
			var otherForm = window.parent.document.forms["myForm"];
			
			// construct the "search" part of the URL from all the elements
			var query = "?Book=" + theForm.Book.options[theForm.Book.selectedIndex].value;
			query += "&Chapter=" + theForm.Chapter.options[theForm.Chapter.selectedIndex].value;
			
			// test to see if a verse has been selected, if not we won't pass the values
			if( theForm.verse.selectedIndex != -1 ) {
				for( var i=0; i < theForm.verse.options.length; i++ ) {
					if( theForm.verse.options[i].selected ) {
						query += "&Verse=" + theForm.verse.options[i].value;
					}
				}
			}
			
			query += "&Keyword=" + escape(otherForm.Keyword.value);
			query += "&Keywordb=" + escape(otherForm.Keywordb.value);
			query += "&Keywordc=" + escape(otherForm.Keywordc.value);
			query += "&Keywordd=" + escape(otherForm.Keywordd.value);
			query += "&Keyworde=" + escape(otherForm.Keyworde.value);
			query += "&Keywordf=" + escape(otherForm.Keywordf.value);
			query += "&";
			
			// either redirect this page or the child frame depending on which select was changed
			if(action == "refresh") {
				location.href = "showbook.php" + query;
			} else {
				ifrVerse.location.href = "showverse.php" + query;
			}
			
			}
		//-->
		</script>
	</head>
	<body>
		<?php
/*
			Dim Book
			Dim Chapter
			Dim Verse

			Dim DSNName
			Dim Conn
			Dim RS
			Dim SQL1
		
			Dim Keyword
		*/
?>
		<table border="0" bgcolor="#FFFCDC">
			<td>
				<form name="myForm" action="showverse.php" method="get" target="ifrVerse">
					<table border="0" bgcolor="#FFFCDC">
						<tr>
							<th align="center" color="white">
						</tr>
						 <tr>
						 	<th colspan="1" align="center">book</th>
						 	<th colspan="1" align="center">chapter</th>
						 </tr>
						<tr>
							<td>
								 <?php
								     require_once('mysql.php');
									 

/*
								'This function checks to see that numerical values are valid
								 Function ValidateInt(SomeInt)
										  if IsNumeric(SomeInt) = False or SomeInt = "" then
											 SomeInt = 1
										  end if
								
								 ValidateInt = SomeInt
								 End Function
							
							
								'Setting up search variables
				
								Book        = ValidateInt(request("book"))
								Chapter     = ValidateInt(request("Chapter"))
								Verse       = request("Verse")
								*/
?>
					
								
								<?php

?>
					
					<input type="hidden" name="Keyword" value="" />
					<input type="hidden" name="Keywordb" value="" />
					<input type="hidden" name="Keywordc" value="" />
					<input type="hidden" name="Keywordd" value="" />
					<input type="hidden" name="Keyworde" value="" />
					<input type="hidden" name="Keywordf" value="" />
					
<?php								
					/*
					<a name="bcv"><select name="Book" size="5" style="width:150px;" onChange="go('refresh');" 

></a> */
?>
										<?php
									$result = mysql_query("SELECT DISTINCT book_title, book FROM bible");
									
									echo "<a name='bcv'><select name='Book' size='5' style='width:150px;' onChange=\"go('refresh');\"></a>"."\n";
									while($row = mysql_fetch_array($result))
									  {
									  
									  echo "<option value='" . $row['book'] . "'>";
									  echo $row['book_title'];
									  echo "</option>"."\n";
									  
									  }
									echo "</select>";
									//mysql_close($con);
										
/*
										Do until RS.eof
											*/
?>
											<?php
/*<option if int(book) = int(RS("Book")) then response.write "selected" end if
 value="
=RS("Book")
?>">=RS("Book_Title")</option>
											RS.movenext
											if RS.eof then
												exit do
											end if
										loop
										

										</select>
								

								RS.Close
								*/
?>
							</td>
							<td colspan="1" align="center">
								<?php
/*
								'This SQL statement creates a list of books
								SQL1 = "Select DISTINCT(Chapter), Book FROM Bible WHERE Book = " & Book & " ORDER BY Chapter ASC"
								rs.Open sql1,conn, 1
									*/
?>
<?php
/*									<select name="Chapter" size="5" style="width:75px;" onChange="go('refresh');" 'onchange="go2();">*/
?>


									<?php
									$result = mysql_query("SELECT DISTINCT chapter, book FROM bible WHERE book = " . $row['book'] . "");
									
									echo "<select name='Chapter' size='5' style='width:150px;' onChange=\"go('refresh');\">"."\n";
									while($row = mysql_fetch_array($result))
									  {
									  
									  echo "<option value='" . $row['chapter'] . "'>";
									  echo $row['chapter'];
									  echo "</option>"."\n";
									  
									  }
									echo "</select>";
									mysql_close($con);									
									
/*
									Do until RS.eof
										*/
?>
										<option <?php
/*if int(Chapter) = int(rs("Chapter")) then response.write "selected" end if*/
?> value="<?php
/*=RS("Chapter")*/
?>"><?php
/*=RS("Chapter")*/
?></option>
										
										<?php
/*
										rs.movenext
										if rs.eof then
											exit do
										end if
									Loop
									*/
?>
									</select>
    PHP:
    I'm getting this error:
     
    gilgalbiblewheel, Dec 21, 2007 IP