PHP - Trying To Build A Drop-down Menu That Appears On Mouse-over.

Instead of breaking down and actually learning how to use ajax, I'm thinking about trying to do something so I don't need a page refresh every time, and the filtered data is nearly instant. I just use the session array var, and build a new array from the rows that meet the conditions.

I'm thinking of loading a two dimensional array into a session var, then use some input buttons, and use the post vars to filter the array based on a set of predefined conditions. ie status = 0, status = 1. It's a fairly small number of conditions applied to two different fields.

So, I need to access specific fields within a row, and essentially create a new array either including or excluding that row depending on whether it met the condition.

I'm struggling on several parts.
1. not sure how to build the array so that I can access specific fields, then not sure how to access those fields.
Do I do this..... to build the array? ....
Code: [Select]
while($row = mysql_fetch_assoc($result)){
   $array[] = array($row['field1'], $row['field2']);
}


I was thinking about using a foreach and is_array() to get to each row...
Code: [Select]
foreach($array as $key => $value){
   if(is_array){
      foreach($value as $k => $v){
         if($v[0] == 1){  //stuck here $v[0] is not a field, it's the first char of the string. not sure how to access a field
            $new_array[] = $value;  //stuck here. I need to put the whole row back into the array if the condition was true. seems like I would have to use the field selectors and rebuild the array.
         }
      }
  }

}


What would you do? Open to any ideas.

helo
i a newbie in php. i need some help regarding my system. i want my data from database to display in drop down menu form.anyone have idea how to do that? i really need some help. i have search all over and couldn't find any solution. any suggestions would be helpful 

Hi, i wonder whether someone may be able to help me please.

I am using a combination of PHP and AJAX to create two drop down menus on a HTML form. The data is being pulled from a mySQL database with the options available in the second drop down dependent on the value selected in the first.

The initial drop down menu called 'detectors' and the behaviours for the second drop down menu, 'searchheads' are created with the following AJAX code:

Code: [Select]
Function AjaxFunction(detectorid)
            {
            var httpxml;
            try
            {
            // Firefox, Opera 8.0+, Safari
            httpxml=new XMLHttpRequest();
            }
            catch (e)
            {
            // Internet Explorer
            try
            {
            httpxml=new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch (e)
            {
            try
            {
            httpxml=new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch (e)
            {
            alert("Your browser does not support AJAX!");
            return false;
            }
            }
            }
            function stateck()
            {
            if(httpxml.readyState==4)
            {
           
            var myarray=eval(httpxml.responseText);
            // Before adding new we must remove previously loaded elements
            for(j=document.addfindstolocation.searchheads.options.length-1;j>=0;j--)
            {
            document.addfindstolocation.searchheads.remove(j);
            }
           
           
            for (i=0;i<myarray.length;i++)
            {
            var optn = document.createElement("OPTION");
            optn.text = myarray[i];
            optn.value = myarray[i];
            document.addfindstolocation.searchheads.options.add(optn);
           
            }
            }
            }
            var url="searchheaddetails.php";
            url=url+"?detectorid="+detectorid;
            url=url+"&sid="+Math.random();
            httpxml.onreadystatechange=stateck;
            httpxml.open("GET",url,true);
            httpxml.send(null);
            }
The following code is the file 'searchheaddetails.php' (as highlighted above) which populates the second drop down menu.

Code: [Select]
<?
$detectorid=$_GET['detectorid'];
require "config.php";
$q=mysql_query("SELECT * FROM searchheads WHERE detectorid='$detectorid' ORDER BY 'searchheadname' ASC");
echo mysql_error();
$myarray=array();
$str="";
while($nt=mysql_fetch_array($q)){
$str=$str . "\"$nt[searchheadname]\",";
}
$str=substr($str,0,(strLen($str)-1)); // Removing the last char , from the string
echo "new Array($str)";

?> 
And this is the section of my form that pulls together the two drop down menus.

Code: [Select]
<form name="addfindstolocation" method="post" id="addfindstolocation">
<div align="left">
                                        <select name=detectors id="detectorid" onchange="AjaxFunction(this.value);">
                                            <option value=''>Select One</option>
                                            <?
                                            require "phpfile.php";// connection to database
                                            $q=mysql_query("SELECT * from detectors WHERE userid='1'ORDER BY 'detectorname' ASC");
                                            while($n=mysql_fetch_array($q)){
                                            echo "<option value=$n[detectorid]>$n[detectorname]</option>";
                                            }
                                           
                                            ?>
                                      </select>
                                    </div>
                                </div>
                                <p align="left">
                                    <label></label>
                                    <label>Search Head Used</label></p>
                                <div>
                                    <div align="left">
                                        <select name=searchheads id="searchheadid">
                                        </select>
                                    </div>
The drop down menus work fine, but I'm having a little difficulty with the data that is being saved. For the 'detectors' drop down menu the data being saved upon a selection being made is the 'id' pertient to the relevant detector e.g. 'Detector1' is selected and the 'id' value of '1' is saved which is exactly what I want. However when it comes to the second drop down menu, the value saved is the text value that the user selects, rather than the 'id'. e.g. 'Deep Search Head ' rather than an 'id' of '1'. Could someone perhaps tell me please what I need to change so that the 'id' value is saved rather than the text value.

If it helps, the coding is taken from the following http://www.plus2net.com/php_tutorial/ajax_drop_down_list.php.

Many thanks and kind regards.

Chris

Hi, i know this is probably very basic but i have been banging my head and looking for tuts.

i have built a mysql php dropdown menu.

all displays fine. now, how do i get the menu to actualy take me to a new url?

the new url should be       www.mysite.com/"menu selection"



Code: [Select]
<?

include_once 'includes/db.php';

$result = mysql_query("select * from crimerate WHERE DISTRICT = 'Limpopo'", $con);

if (!$result) {
    die('Invalid query: ' . mysql_error());

}


$options="";

while ($row=mysql_fetch_array($result)) {

    $id=$row["id"];
    $crime=$row["CRIME"];
    $options.="<OPTION VALUE=\"$id\">$crime</option>";
}
?>


<SELECT NAME=crime>
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT>

Hi i currenlty have adrop box filled with companies so the user can select which company they woudl like services from but the default is currently 0 and is to selecvt all firms but im unsure how to do this.

Current code: Code: [Select]
<td>Taxi Firm</td><td> <select name="taxifirm">
<option value="0" selected>All Taxi Firms</option>
<?php
 $sql = mysql_query("SELECT * FROM taxi_Firms"); 
while($row = mysql_fetch_array($sql)){
$uid = $row["Firm_ID"];
$username = $row["Firm_Name"]; 
echo '<option value="'.$uid.'">'.$username.'</option>' ;

}
?>

amny help is welcomed

thanx