0

I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database will be:

ID  Attribute  Amenities
1     A          Aa
2     B          Bb

Code for this part is

<form class="form-horizontal" role="form" action="admin_insert_attribute.php" enctype="multipart/form-data" method="post">    
    <div class="form-group">
        <label class="col-lg-3 control-label">Amenities:</label>
            <div class="col-lg-8">    
                <?php
                    $con=mysqli_connect("abc","abc","abc","abc");
                    // Check connection
                    if (mysqli_connect_errno()) 
                    {
                    echo "Failed to connect to MySQL: " . mysqli_connect_error();
                    }

                    $result = mysqli_query($con,"SELECT amenities FROM amenities");
                    echo "<select name='amenities'>";
                    while($row = mysqli_fetch_array($result)) 
                    {
                    echo "<option value='" . $row['amenities'] . "'>" . $row['amenities'] . "</option>";
                    }   
                    echo "</select>";   
                    mysqli_close($con);
                ?>  
            </div>
    </div>    
    <div class="form-group">
        <label class="col-lg-3 control-label">Attribute:</label>
            <div class="col-lg-8">
                <input class="form-control" name="attribute" value="" type="" required>
            </div>
    </div>

    <div class="form-group">
        <label class="col-lg-3 control-label"></label>
            <div class="submit">
             <input class="btn btn-primary" value="Save " type="submit" name="submit">    
            </div>  
    </div>
</form>

Now I wish that when an amenity is selected from the dropdown menu all the attribute under that specific amenity should also get displayed on the same page in a tabular form. Code for entering and displaying the attribute is done on the same page.

Problem is that i am able to add the attributes but they are not getting displayed on the screen. Code that i used for displaying is

<?php
    $con=mysqli_connect("abc","abc","abc","abc");
    // Check connection
    if (mysqli_connect_errno()) 
        {
            echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }

    $result = mysqli_query($con,"SELECT * FROM attributes  WHERE amenities = '".$amenities."'");
    echo "<table class='table table-striped table-bordered table-hover'>
        <thead>
            <tr>
                <th>ID</th>
                <th>Attribute</th>
            </tr>
        </thead>";

    while($row = mysqli_fetch_array($result)) 
        {
            echo "<tbody data-link='row' class='rowlink'>";
            echo "<tr>";
            echo "<td>" . $row['id'] . "</td>";
            echo "<td>" . $row['attribute'] . "</td>";      
            echo "</tr>";
            echo "</tbody>";    
        }
    echo "</table>";
    mysqli_close($con);
?>
2
Contributors
1
Reply
8
Views
2 Years
Discussion Span
Last Post by pritaeas
0

they are not getting displayed on the screen

Where is the javascript code that is adding the output of the script to your page?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.