Closed. This question needs details or clarity. It is not currently accepting answers.
Want to improve this question? Add details and clarify the problem by editing this post.
Closed 5 years ago.
UPDATED
Have now got this far with this and think I am getting stuck right at the end!! I have now got both menus being processed by "process.php" and am outputting my queries back into index.php.
process.php
<?php
$menu1 = $_POST["menu1"];
$menu2 = $_POST["menu2"];
if($menu1 == 0) {
$sql = "SELECT * FROM Language WHERE ID = " . $menu2;
} else if($menu1 == 1) {
$sql = "SELECT * FROM Mathematics WHERE ID = " . $menu2;
} else if($menu1 == 2) {
$sql = "SELECT * FROM Culture WHERE ID = " . $menu2;
}
echo $sql;
?>index.php
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js'></script>
<script type='text/javascript'>
$(window).load(function(){
var data = {
Language: ["","Noun Game","Phonetic Noun Box"],
Mathematics: ["","Number Rods","Sandpaper Numerals"],
Culture: ["","Concept of Time-Clock"]
}
// populate menu1
for (var i in data) {
$('#menu1').append('<option>' + i + '</option>');
}
// populate menu2 based on menu1 value
$('#menu1').change(function() {
var key = $(this).val();
$('#menu2').empty();
for (var i in data[key]) {
$('#menu2').append('<option>' + data[key][i] + '</option>');
}
}).trigger('change');
});//]]>
</script>
</head>
<body>
<form id="form" action="process.php" method="post">
<select id="menu1" name="menu1"></select>
<select id="menu2" name="menu2"></select>
<input id="submit" type="submit" value="ENTER" />
</form>
<div id="resultsContainer"></div>
<script>
$(document).ready(function(){
//alert('jQuery loaded');
$('#form').submit(function(event){
event.preventDefault;
menu1value = $('#menu1')[0].selectedIndex;
menu2value = $('#menu2')[0].selectedIndex;
$.post('process.php',{menu1:menu1value,menu2:menu2value}).done(function(data){
alert(data);
})
return false;
})
})
</script>
</body>
</html>Now I just need to output queries in a table on index.php. Think this will be just about looping through the output but I'm not sure... any help please.
</div>
