May 3, 2012

how to form select query by range

Question by bonny

hello i have a search engine for my site. i have two selection fields. i would like to give an example:

input_a: 3
input_b: 5

so the queries should look like:

if ( ($input_a == true) && ($input_b == false) ){
        $filter_orders[] = " `col` LIKE '%$input_a%' ";
    if ( ($input_a == false) && ($input_b == true) ){
        $filter_orders[] = " `col` LIKE '%$input_b%' ";
    if ( ($input_a == true) && ($input_b == true) ){
        $filter_orders[] = " `col`= `col`>='%$input_a%' AND `col` = `col`<='%$input_b%' ";

now the problem is, that i dont know, if the last query is incorrect or not. the logic behind that will be that in case of my example the range between 3 and 5 should be found.

so 1,2 [3,4,5] 6,7,8…

if there is someone who could help me out i really would appreciate.

thanks a lot.

Answer by Starx

NO, sadly that is everything but correct. It should be something like this.

$filter_orders[] = " `col`>='%$input_a%' AND `col`<='%$input_b%' ";
April 2, 2012

Use jQuery select() to select contents of a div

Question by Conor Higgins

Is it possible to use or adapt jQuery’s .select() to set a selection range on the entire contents of a div?

I have a div which has a series of labels, inputs, select objects and a couple of other UI elements. I have found code on a separate StackOverflow post with some code hosted on jsFiddle:

Can this be adapted to select the value of inputs also? Or how would you suggest I go about this?


Edit: More info

I know how to get the value of inputs using jQuery, that is easy, I also know how to select he values of independent elements using .select().

In my div I have a series of different element types including inputs, labels, selects, etc. I need an overall selection of all elements. The jsFiddle link I added earlier shows how to set the range of a div and select the text of elements like p tags etc. What I need is to set the range of the div’s contents and when I hit ctrl+c or cmd+c it copies the values of the inputs as well as the labels.

So to summarise, using .val and .select won’t work for this I don’t think. I need to combine the above in some way but not sure exactly how this will be accomplished. Any ideas?

Answer by techfoobar

Check this fiddle:

Basically the trick is to introduce a hidden text node whose content will be included in the selection when copied.

Answer by Starx

If you want to select the input elements together with every thing.

Here is a jQuery mixed, JS solution

function selectElement(element) {
    if (window.getSelection) {
        var sel = window.getSelection();
        var range = document.createRange();
    } else if (document.selection) {
        var textRange = document.body.createTextRange();

selectElement($("div")[0]); //Select the div
$("input").trigger("select");  //select the inputs



Please fill the form - I will response as fast as I can!