Search Question

Hi Jerry,

So for your first issue, you want to make it so that when a selection is made from "event_keyword", "event_sub_category_keyword" is populated only with the subcategories of the selected "event_keyword". Is that right?

If so, there are a couple of options. First, you can use jquery to update "event_sub_category_keyword", being triggered on the onchange event of "event_category". This is probably the most typical technique.

The other option would be to hide the second select box and have the onchange event of the first select box submit the form to itself and get all the sub category records. This solution is a little more awkward.

Either way, you won't be able to use the getListOptions() function to get your sub categories. Assuming that the section being used for "event" and "event_sub_category" in your master_subscription_pages section is a category menu, you can use the 'rootCategoryNum' option of getCategories to return only the sub categories of a given category number. For example:



list($subCategories, ) = getCategories(array(
'tableName' => 'category',
'rootCategoryNum' => "'".intval(@$_REQUEST['event_keyword'])."'",
));

You would then use $subCategories to populated your second select box.

For the second issue, probably the best option would be to just have a "Reset" button that just links back to the current page. You don't want to do an actual page refresh, because this will simply re-submit your form and execute your query again.

Hope this helps get you started.

Hi Jason,

Thanks for looking at this.

The reset button idea worked.

For the other, jquery seems logical but I must admit I don't even know where to start.

Could you (or someone who has done this) offer an example of the code required to apply the concept to my situation?

Thanks,

Jerry Kornbluth

Hi Jerry,

Here is a really simple example from a project I recently did that may help you get started. I had 2 select boxes: 1 for make, and 1 for model. So the model list was dependent on the make list.

Here was the HTML:

<td width="123">
<select name="make" id="make" class="effect" onchange="updateModel();">
<option value = "">Select Make</option>
<option value = "">All Makes</option>
<?php foreach (mysql_select('makes') as $make): ?>
<option value = "<?php echo $make['num'];?>" ><?php echo $make['make'];?></option>
<?php endforeach ?>
</select>
</td>

<td width="96">
<select name="model" class="effect" id="model">
<option value = "" selected="selected">All Models</option>
</select>
</td>

So when the page first loads, the model list is empty. The onchange event of the make list calls a jquery function called "updateModel()". This is stored in the attached .js file. This function makes a jquery call to an updateModel.php page (attached) that loads the models associated with the selected make.

Hope this helps get you started

Thank you Jason.

Looks like this weekend's project.

Jerry

Hi Jerry,

The first thing I noticed on your page is that there is a jquery error when you select a make. You need to include a version of jquery in the head section before the updateModel.js file. Something like this:


<script type = "text/javascript" src = "cmsAdmin/3rdParty/jquery/jquery1.4.1.js"></script>

<script src="../Scripts/updateModel.js"></script>

Also all of the code that populates the models select box should be contained in the .php file (updateModel.php in this case) that is called by the jquery function.

Hope this helps

Hi Jason,

Well, adding the jquery call helped, but I’m still lost, more confused then ever, and after I get this to work I still have no idea how to make this search work for a single multi-record table.

When I remove the:
$where = "TRUE";
if (@$_REQUEST['make']) {
$where = "make = '".intval(@$_REQUEST['make'])."'";
}

$models = mysql_select('models', $where);
from my viewer page, which is what I think you meant, I get an:

Undefined variable: models in /hsphere/local/home/gkornblu/qartguide.com/2-level-search5.php on line 44

Warning: Invalid argument supplied for foreach() in /hsphere/local/home/gkornblu/qartguide.com/2-level-search5.php on line 44

and no values in the “models” search box, except for the options “select model” and “all models”.

I’ve moved the .js to the same directory as the other files, tried adding load records calls to updateModel.php, and tried everything else I can think of, but I haven’t been able to figure out what should be a simple issue.

Any suggestions, code corrections?

Thanks,

Jerry Kornbluth

Here’s the present viewer code...

Top:
<?php

require_once("cmsAdmin/lib/viewer_functions.php");

// load records
list($modelsRecords, $modelsMetaData) = getRecords(array(
'tableName' => 'models',
));

// load records
list($makesRecords, $makesMetaData) = getRecords(array(
'tableName' => 'makes',
));

?>
Head:
<script type = "text/javascript" src = "cmsAdmin/3rdParty/jquery/jquery1.4.1.js"></script>
<script src="updateModel.js"></script>

Body:
<table>
<tr>
<td >
<form> <select name="make" class="effect" id="make" onChange="updateModel();">
<option value = "">Select Make</option>
<option value = "">All Makes</option>
<?php foreach (mysql_select('makes') as $make): ?>
<option value = "<?php echo $make['make'];?>" ><?php echo $make['make'];?></option>
<?php endforeach ?>
</select>

<br /><br />

<select name="model" class="effect" id="model">
<option value = "">Select Model</option>
<option value = "">All Models</option>
<?php foreach ($models as $model): ?>
<option value = "<?php echo $model['model'];?>"><?php echo $model['model'];?></option>
<?php endforeach ?>
</select>
<br /><br />
<input type="submit" name="submit" value="Search" >
</form>

<FORM ACTION="">
<br /><br />
<INPUT TYPE="submit" VALUE="Cancel Filters">
</FORM>
</td>
</tr>
<tr>
<td>
<br />
<?php foreach ($modelsRecords as $record): ?>
<?php echo $record['text'] ?><br />
<?php endforeach ?>
<hr />
<?php foreach ($makesRecords as $record): ?>
<?php echo $record['text'] ?><br />
<?php endforeach ?>
</td>
</tr>
</table>

Hi Jerry,

Your actually getting close.

The errors are coming from your foreach loop that is "populating" your model select field. Since you took out the query, there is no $models variable to use anymore.

The most common approach is to not populate your select field in the viewer page at all. This seems counter-intuitive, but the reason is when your viewer page loads, there no make has been selected. And if no make has been selected, there is no list of related models to put into the box. Therefore we leave it empty.

The page updateModel.php, which is called by the jquery function when the make select field is changed, replaces all the HTML that is currently on the page with a duplicate that has actually been populated. That's why there is another select field being output in updateModel.php.

Hope this starts to make sense. Once you wrap your mind around it, it does start to get easier

Thanks jason,

Yes it is counter-intuitive:


Are you suggesting that I remove the code:
select name="model" class="effect" id="model">
<option value = "">Select Model</option>
<option value = "">All Models</option>
<?php foreach ($models as $model): ?>
<option value = "<?php echo $model['model'];?>"><?php echo $model['model'];?></option>
<?php endforeach ?>
</select>
<br /><br />

in the viewer?

Would I still need the get records and load records calls in updateModel.php or should those go also?

Jerry Kornbluth