current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise
up vote 0 down vote favorite

This question already has an answer here:

I have a page where a user can select multiple check boxes and then submit the form, on the next page it displays what they checked with more details. but my query is not working. how can i pass the checkbox data to the mysql query to get the rest of the data.

this is my query:

$c=$_POST['select'];

$result=mysqli_query($con, 'SELECT * FROM item WHERE item_number IN ("'.implode('","', $c).'")');

echo "<table border='1'>
<tr>
<th>item name</th>
<th>item number</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
  echo "<tr>";
  echo "<td>" . $row['item_name'] . "</td>";
  echo "<td>" . $row['item_number'] . "</td>";
  echo "</tr>";
 }
  echo "</table>";


mysqli_close($con);

when running the query i get this error:

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

it returns no results but if i echo the query and copy paste into mysql i get the results, but when running from PHP i get only the error.

any help would be greatly appreciated

share|improve this question

marked as duplicate by Jocelyn, hjpotter92, Roman C, Stony, Neil Apr 18 '13 at 10:25

This question was marked as an exact duplicate of an existing question.
    
why it's not working? what's the error you get from the db or from the webserver? – STT LCU Apr 17 '13 at 13:07
1  
What is $c? Also, you should really be protecting your database by running all the values through mysqli_real_escape_string() – Seth Apr 17 '13 at 13:07
    
change implode('","', $c) to implode(',', $c) – Tamil Selvan Apr 17 '13 at 13:08
    
try to echo $c do you get a value if you get a value your question is answerd – Sven B Apr 17 '13 at 13:08
1  
Do a var_dump($c); to help in debugging propuses – Ivo Pereira Apr 17 '13 at 13:10
up vote 0 down vote

Updated version of your code to put out an error message on the query if there is one. Also sanitises the input

<?php
if (is_array($_POST['select']))
{
    $c = array_map('array_map_callback', $_POST['select']);

    $result = mysqli_query($con, 'SELECT item_name, item_number FROM item WHERE item_number IN ("'.implode('","', $c).'")') OR die(mysqli_error($con));

    echo "<table border='1'>
    <tr>
    <th>item name</th>
    <th>item number</th>
    </tr>";
    while($row = mysqli_fetch_array($result))
    {
        echo "<tr>";
        echo "<td>" . $row['item_name'] . "</td>";
        echo "<td>" . $row['item_number'] . "</td>";
        echo "</tr>";
    }
    echo "</table>";
    mysqli_close($con);
}
else
{
    echo "No items selected";
}

function array_map_callback($a)
{
  global $con;
  return mysqli_real_escape_string($con, $a);
}

?>

Hopefully this should put out the message of what is wrong with the query.

share|improve this answer
up vote -4 down vote

$c does not seems to be PHP Array, so it can not be imploded here

share|improve this answer
1  
"if i echo the ("'.implode('","', $c).'") i get the values" – Andrew Lindemulder Apr 17 '13 at 13:12
    
what kind of data type do you get from $_POST['select'] - valid PHP array or sting? – Ilya Apr 17 '13 at 13:14
    
yup, it prints all of my values selected from the form if i echo it. – Andrew Lindemulder Apr 17 '13 at 13:16

Not the answer you're looking for? Browse other questions tagged or ask your own question.