Dynamic Mysql query & passing multiple values through `GET`

Question

I have a basic form that has several checkboxes. When a checkbox is checked it will append the value to a url for an ajax call. After I pass these values to mypage.php?item1=1&item2=2&item3=3, I am using GET[‘item’] to retrieve and store these values in order to use in an SQL query. The complexity of this problem is the amount of values passed may vary since it is based on checkboxes. For example, you can pass 1 value or pass all three values. My question is: How can I make this dynamic that would work with the sql query? If more than one value is passed, then the query would require in the WHERE clause an AND for the additional items.

<script>
$('#submitForm').click(function() {
    var url = "'www.mysite.com/mypage.php";
    if ($("#checkbox_form").serialize().length > 0) {
        url += "?" + $("#checkbox_form").serialize();     
    }
    $.getJSON(url)
});
</script>
<form name="checkbox_form" id="checkbox_form">
    <input type="checkbox" value="1" id="item1" name="val1" />
    <input type="checkbox" value="2" id="item2" name="val2" />
    <input type="checkbox" value="3" id="item3" name="val3" />
    <input type="submit" id="submitForm" value="Submit Form" />
<form>

mypage.php?item1=1&item2=2

$item = $_GET['item#']; 

$sql_query = "SELECT info From Products Where :item# AND item#";
$sql_prepare = $db_con->prepare($sql_query);
if (!$sql_prepare->execute(array(':item#' => $item)))
//rest of code

Your WHERE clause seems wrong.

Bart Friederichs
– Bart Friederichs

2014-01-29 07:47:04 +00:00
Commented Jan 29, 2014 at 7:47 — Bart Friederichs
– Bart Friederichs, Commented Jan 29, 2014 at 7:47

Ashraf Samhouri · Accepted Answer · 2014-01-29 08:32:03Z

1

First of all, you need to create an array of inputs instead of "val1", "val2".

Just give every input a name of val[x] like val[1] , val[2] and so on. Or you can just let it a new array element: val[].

Then, you need to handle this with a PHP foreach before building the query, something like:

$sql_query = "SELECT info From Products";

$conditions = array();

if (isset($_GET['val']) && is_array($_GET['val'])) {
    $vals = $_GET['val'];
    foreach ($vals as $key => $val) {
        $conditions[] = '`field'. $key .'` = '. $val;
        // You should change the conditions the way you want, I'm not sure about what you want here.
    }
}

if (count($conditions) > 0) {
    $sql_query .= ' where '. implode(' and ', $conditions);
}

And you are done!

UPDATE

As discussed in the comments, this is the condition you are looking for:

    foreach ($vals as $val) {
        $conditions[] = '`item_id` = '. $val;
    }

Moreover, don't forget that you need OR not AND in this context. So, edit this line as well:

    $sql_query .= ' where '. implode(' or ', $conditions);

edited Jan 29, 2014 at 8:32

answered Jan 29, 2014 at 7:48

Ashraf Samhouri

4083 silver badges8 bronze badges

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

14 Comments

Code_Ed_Student Over a year ago

Alright, trying this right now. I had the same scenario with a project of mine.

user1434156 Over a year ago

So the name would be like: <input type="checkbox" value="1" id="val[1]" name="val[1]" />?

Ashraf Samhouri Over a year ago

Exactly. if you don't need the "id" in Javascript, just eliminate it, it won't convert to a Javascript array!

user1434156 Over a year ago

okay passing the values but because i am using [] in the url it looks like this www.mysite.com/mypage.php?val%5B4%5D=1? That shouldnt be a problem right?

user1434156 Over a year ago

haha ok, In my condition i am comparing val[] to item_id and it is showing error: Unknown column 'item_id2' in 'where clause''

|

Collectives™ on Stack Overflow

Dynamic Mysql query & passing multiple values through `GET`

1 Answer 1

14 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

14 Comments

Your Answer

Sign up or log in

Post as a guest

Related