How can i fetch data at dropdown from two tables display in one table in PHP using ajax

Question

This is code of my Table in PHP. I want to fetch other details from different 2 tables using AJAX in PHP. i am using mysql.I want to show details in table when i select any value from dropdown. Help me please.. I tried so much time but i am not success.

My code is given below.

    <td>
    <?php
    $query = "select * from table_name  order by name ASC ";
    $result= mysql_query($query);
    echo '<select name="id">';
    echo '<option value="">---Select Employee---</option>';
    while ($row=mysql_fetch_array($result))
        {
    ?>
<option value="<?php echo $row['id']; ?>"> <?php echo  ucfirst($row['name']); ?></option>                               
    <?php
         }
         echo "</select>";
    ?>
</td>

look at api.jquery.com/jquery.ajax. You will definately find out. It's not so hard as you expect. — atomaprchya
– atomaprchya, Commented Jun 5, 2014 at 5:52
What is condition or relation between two tables? and how do you want to show data from two tables? — Bhavesh Patel
– Bhavesh Patel, Commented Jul 15, 2017 at 7:09

Reporter · Accepted Answer · 2014-08-26 09:40:57Z

0

If you want to fetch your selected value from dropdown. then this will help you.

<?php
   $sql= "select * from table_name";
   $res=mysql_query($sql);
   while($row=mysql_fetch_array($res))
   {
?>
     <select name="xyz">
       <option value=""> --- Select ---</option>
<?php
       $sql2="select * from table_name"; 
       $res2=mysql_query($sql2);
       while($row2=mysql_fetch_array($res2))
       {
         if($row2['column_name']==$row['column_name'])
         {
           $selected='selected="selected"';
         } else {
           $selected='';
         }  
?>
          <option value="<?php echo $row2['column_name']; ?>" 
            <?php echo $selected; ?>><?php echo $row2['column_name'] ?>
          </option>
<?php
       }
?>
    </select>
<?php
  }
?>

I think it may help you

edited Aug 26, 2014 at 9:40

Reporter

3,9345 gold badges36 silver badges50 bronze badges

answered Aug 26, 2014 at 9:21

Bhavesh Patel

1251 gold badge2 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can i fetch data at dropdown from two tables display in one table in PHP using ajax

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related