How to select values on mysql database for each value from checkbox array

Question

I'm trying to make a bulk action. I have checkboxes,

<input type="checkbox" name="check_id[]" value="1">
<input type="checkbox" name="check_id[]" value="2">
<input type="checkbox" name="check_id[]" value="3">

I wanted to select values from mysql table for each selected checkboxes then use my function to delete data based on the fetched values. I tried,

for( $i = 0; $i < count( $_POST['check_id'] ); $i++ ) {
  $manufacturers_id = prepare_input($_POST['check_id'][$i]);
  $manufacturer_query = mysql_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$manufacturers_id . "'");
  $manufacturer = mysql_fetch_array($manufacturer_query);

  delete_image(DIR_IMAGES . $manufacturer['manufacturers_image']);
}

The problem is that, there is no fetched mysql values based on $_POST['check_id'] even though im sure that i have manufacturers_image where is manufacturers_id is either 1,2 or 3.

Is there a correct way to accomplish this?

What does prepare_input function do? try echo $_POST['check_id'][$i] before that function to check if you're receiving values — Oras
– Oras, Commented Aug 18, 2012 at 12:01
@Hamurabi there is receiving values.. like array([0] => 1).. its just mysql_escape_string.. — Ken
– Ken, Commented Aug 18, 2012 at 12:30
@Ken then do the following, echo the query to check if it is the right query. ex: echo "select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$manufacturers_id ."'"; — Oras
– Oras, Commented Aug 18, 2012 at 12:35

Oras · Accepted Answer · 2012-08-18 12:58:00Z

1

Change this line

$manufacturer = mysql_fetch_array($manufacturer_query);

to

$manufacturer = mysql_fetch_assoc($manufacturer_query);

answered Aug 18, 2012 at 12:58

Oras

1,0961 gold badge12 silver badges22 bronze badges

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

Comments

Mihai Iorga · Accepted Answer · 2012-08-18 11:59:48Z

0

It is returning an array ... you use while() or you fetch first image

delete_image(DIR_IMAGES . $manufacturer[0]['manufacturers_image']);

answered Aug 18, 2012 at 11:59

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Collectives™ on Stack Overflow

How to select values on mysql database for each value from checkbox array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related