i have 2 tables material :
- id :int, - name : varchar(255), - providers_id : int (foreign key)
and table providers :
- id_provider: int, - code_providers : varchar(200)
i have data in table providers :
1,provider1 2,provider2 3,provider3
and have page addmaterial.php :
<div class="form-group" id="textboxdiv1"> <label>providers</label> <select class="form-control"> <option value='-1'>choose provider</option> <?php $stmt2 = $db->prepare("select * providers"); $stmt2->execute(); while($row2 = $stmt2->fetch()){ echo "<option value='".$row2["id_provider"]."'>".$row2["code_provider"]."</option>"; } ?> </select> </div> <div>add</div> <div>update</div> <div>delete</div>
- i display div add when choose provider 1
- i display div update when choose provider 2
- i display div update when choose provider 3
html:
<select class="form-control" id="chooseprovider"> ... <div id="add">add</div> <div id="update">update</div> <div>delete</div>
js:
$("#chooseprovider").change(function(){ if($(this).val()=="1"){ $("#add").show(); $("#update").hide(); } else if($(this).val()=="2" || $(this).val()=="3"){ $("#update").show(); $("#add").hide(); } });
Comments
Post a Comment