Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // index.php
- //bd:local2 tabla 'tipomuestra' https://pastebin.com/ANAFmpxn
- <!DOCTYPE html>
- <?php
- $conn = new mysqli('localhost', 'root', '12345678', 'local2') or die(mysqli_error());
- ?>
- <html lang = "eng">
- <head>
- <meta charset = "UTF-8" />
- <link rel = "stylesheet" type = "text/css" href = "css/bootstrap.css" />
- </head>
- <body>
- <nav class = "navbar navbar-default">
- <div class = "container-fluid">
- <a class = "navbar-brand" href = "localhost">Sour</a>
- </div>
- </nav>
- <div class = "container-fluid">
- <div class = "row">
- <div class = "col-md-3"></div>
- <div class = "col-md-6 well">
- <h4 class = "text-primary">Dependecia Select Option MySQLi y PHP / jQuery</h4>
- <hr style = "border-top: 1px dotted #8c8b8b;"/>
- <form class = "form-inline">
- <div class = "form-group">
- <label>tipo Group:</label>
- <select id = "group" class = "form-control" name = "animal-groupl" required = "required">
- <option value = "">Tipo</option>
- <?php
- $g_animal = $conn->prepare("SELECT * FROM `tipomuestra` GROUP BY `tipo`");
- if($g_animal->execute()){
- $g_result = $g_animal->get_result();
- }
- while($f_ganimal = $g_result->fetch_array()){
- ?>
- <option value = "<?php echo $f_ganimal['tipo']?>"><?php echo $f_ganimal['tipo']?></option>
- <?php
- }
- $conn->close();
- ?>
- </select>
- </div>
- <div class = "form-group">
- <label>Animal:</label>
- <select id = "animal" name = "animal" class = "form-control" disabled = "disabled" required = "required">
- <option value = "">tipo_muestra</option>
- </select>
- </div>
- <div class = "form-group">
- <label>Animal2:</label>
- <select id = "animal2" name = "animal2" class = "form-control" disabled = "disabled" required = "required">
- <option value = "">tipo_descripcion</option>
- </select>
- </div>
- </form>
- </div>
- </div>
- </div>
- </body>
- <script src = "js/jquery-3.1.1.js"></script>
- <script type = "text/javascript">
- $(document).ready(function(){
- $('#group').on('change', function(){
- if($('#group').val() == ""){
- $('#animal').empty();
- $('<option value = "">Tipo_Muestra1</option>').appendTo('#animal');
- $('#animal').attr('disabled', 'disabled');
- }else{
- $('#animal').removeAttr('disabled', 'disabled');
- $('#animal').load('animal_get.php?tipo=' + $('#group').val());
- }
- });
- });
- </script>
- <!--
- <script type = "text/javascript">
- $(document).ready(function(){
- $('#group').on('change', function(){
- if($('#group').val() == ""){
- $('#animal2').empty();
- $('<option value = "">Tipo_descripcionz</option>').appendTo('#animal2');
- $('#animal2').attr('disabled', 'disabled');
- }else{
- $('#animal2').removeAttr('disabled', 'disabled');
- $('#animal2').load('animal_get2.php?descripcion=' + $('#group').val());
- }
- });
- });
- </script>
- -->
- </html>
- //animal_get.php
- <?php
- $conn = new mysqli('localhost', 'root', '12345678', 'local2') or die(mysqli_error());
- $animal = $conn->prepare("SELECT tipomuestra FROM `tipomuestra` WHERE `tipo` = '$_REQUEST[tipo]' GROUP BY tipomuestra") or die(mysqli_error());
- echo '<option value = "">Tipo_Muestra</option>';
- if($animal->execute()){
- $a_result = $animal->get_result();
- }
- while($f_animal = $a_result->fetch_array()){
- echo '<option value = "'.$f_animal['tipomuestra'].'">'.$f_animal['tipomuestra'].'</option>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement