<?php $project_name=mysql_query("select main_unit_id,project_name from main_unit"); ?> <select name="project" id="project" tabindex="1"> <option value=''>--Select Project --</option> <?php while($rows=mysql_fetch_array($project_name)) { ?> <option value="<?php echo $rows['main_unit_id']; ?>"><?php echo $rows["project_name"]; ?></option> <?php } ?> ?> <select> <div id="activity"></div>
<script src="js/jquery-1.9.0.min.js"></script> <script language="javascript"> $(document).ready(function(){ $("select#project").change(function(){ var main_unit_id = $("select#project option:selected").attr('value'); $("#activity").html( "" ); if (main_unit_id.length > 0 ) { alert(main_unit_id); $.ajax({ type: "POST", url: "fetch_activity.php", data: "main_unit_id="+main_unit_id, cache: false, success: function(html) { $("#activity").html(html); } }); } }); }); </script>
<?php include "conn/conn.php"; $main_unit_id = trim(mysql_escape_string($_POST["main_unit_id"])); $sql = SELECT activity_id, activity_name FROM activities WHERE main_unit_id = '".$main_unit_id."'"; $count = mysqli_num_rows( mysqli_query($con, $sql) ); if ($count > 0 ) { $query = mysqli_query($con, $sql); ?> <label> <select name="activity" id="activity"> <option value="">Please Activity</option> <?php while ($rs = mysqli_fetch_array($query, MYSQLI_ASSOC)) { ?> <option value="<?php echo $rs["activity_id"]; ?>"><?php echo $rs["activity_name"]; ?></option> <?php } ?> </select> </label> <?php } ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)