[RESOLVED] is this possible?

[kender]

is it possible to code this, so that ARRAY will be a value of 1 through 15 ? (the value/name of the checkbox)

i have checkboxes with categories where
name is 1 value is 1,
name is 2 value is 2,
name is 3 value is 3,
name is 4 value is 4 and so on... so i need to insert into the table 1 / 3 / 7 / 12 if those are checked, but i dont want to write a different insert statement for each value.. i need to loop it basically 15 times

("INSERT INTO list VALUES('$next_id','$_POST[**ARRAY**]','$_POST[item_title]')") or die(mysql_error());

[mrhappiness]

depends on how you named the checkboxes

<input type="checkbox" value="1" name="check[]" />
<input type="checkbox" value="2" name="check[]" />
<input type="checkbox" value="3" name="check[]" />
<input type="checkbox" value="4" name="check[]" />

$checked = count($_POST['check']);
for ($i = 0; $i < $checked; $i++)
  echo 'You checked #'.$_POST['check'][$i].'<br />';

[kender]

while trying to put insert it into my sql table, my result that posted was not 7 entries, but 1 entry with array as the entry

[mrhappiness]

than you did something wrong 🙂

look at my code and compare it to yours
i guess you missed the additional [$i] below $_POST['the name of your field in the form without []']

if it doesn't work please post your code and the corresponding lines of your form

[kender]

this

<input type=\"checkbox\" name=\"".$cat_id."\" value=\"check[]\" /> $cat_title <br />

posts the info into this

$checked = count($_POST['check']); 
for ($i = 0; $i < $checked; $i++) 
$query .= mysql_query 
("INSERT INTO list VALUES('$next_id','$_POST[check][$i]','$_POST[item_title]')") or die(mysql_error());

[mrhappiness]

why don't you use $cat_id as value and check[] as name like i did?

[kender]

did both.. didnt change back before posting

[mrhappiness]

change it back so that name="check[]"

select some checkboxes and in your php do

echo '<pre>';
print_r($_POST);
echo '<pre>';

please post the results of this

[kender]

neither way posts to the database

whole page code below

<?
include_once("Subs.php");
global $settings;

if ($_POST['item_title'] == "")
	fatal_error("The item title is required.  Please go back and try again. <br /><br />&#171; <a href='javascript:history.back(1)'>Back</a>",1);
if ($_POST['item_desc'] == "")
	fatal_error("The item description is required.  Please go back and try again. <br /><br />&#171; <a href='javascript:history.back(1)'>Back</a>",1);

$_POST['item_title'] = addslashes($_POST['item_title']);
$_POST['item_desc'] = addslashes($_POST['item_desc']);

$slq = 'SELECT max(id) as current_id FROM items'; 
$id_result  = mysql_query($slq); 
$id_row = mysql_fetch_array( $id_result ); 
$next_id = $id_row['current_id'] + 1;

$query = mysql_query
("INSERT INTO items VALUES('','$_POST[item_title]','$_POST[item_price]','$_POST[item_desc]')") or die(mysql_error());

$checked = count($_POST['check']); 
for ($i = 0; $i < $checked; $i++) 
$query .= mysql_query 
("INSERT INTO list  VALUES('$next_id','$_POST[check][$i]','$_POST[item_title]')") or die(mysql_error());

$get_cats = "select id, cat_title from categories";
$get_cats_res = mysql_query($get_cats) or die(mysql_error());
if (mysql_num_rows($get_cats_res) < 1) 
	{
		$display_cats = "<p><i>Sorry, no categories set up.</i></p>";
	} else {
		while ($categories = mysql_fetch_array($get_cats_res))
		{
			$cat_id = $categories[id];
			$cat_title = stripslashes($categories[cat_title]);
			$display_cats .= "<input type=\"checkbox\" name=\"check[]\" value=\"".$cat_id."\" /> $cat_title <br />";
		}
	}

echo "Your new item has been entered successfully...<br /><br />Enter another item?";
?>

<table align="center" cols="2" border="0" width="380" cellpadding="0" cellspacing="0">
<form action="additem.php" method="post" "enctype="multipart/form-data>
	<tr>
		<td valign="center" align="right" class="me" width="160">
			<br />Item Title: &nbsp; 
		</td>
		<td valign="center" width="220" class="me">
			<br /><input type="text" size="25" align="right" name="item_title">
		</td>
	</tr>
	<tr>
		<td valign="center" align="center" colspan="2" class="me">
			<br />Item Description: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
			<br /><textarea cols="40" rows="5" name="item_desc"></textarea>
		</td>
	</tr>
	<tr>
		<td></td>
		<td class="me"> <? echo $display_cats; ?>
			<br><input type="submit" value="Submit"> &nbsp; <input type="reset" value="Reset"></form>
		</td>
	</tr>
</table>

<?

if($_GET['action'] == "delete"){doDelete();}
else
{
$display_block = "<br /><center><hr width=\"300\">Current existing items.<hr width=\"300\"><br /><br /></center><br /><hr align=\"left\" width=\"600\" />";
$get_items = "select id, item_title, item_desc from items order by item_title";
$get_items_res = mysql_query($get_items) or die(mysql_error());

if (mysql_num_rows($get_items_res) < 1) 
	{
		$display_block = "<p><i>Sorry, no items to browse.</i></p>";
	} else {
		while ($items = mysql_fetch_array($get_items_res))
		{
			$item_id = $items[id];
			$item_title = stripslashes($items[item_title]);
			$item_price = stripslashes($items[item_price]);
			$item_desc = stripslashes($items[item_desc]);
			$display_block .= "<table><tr valign=\"top\"><td rowspan=\"3\"><a href=\"./../images/gif/".$item_title.".gif\" target=\"_new\">
<img src=\"./../images/jpg/".$item_title.".jpg\" width=\"100\" height=\"100\" border=\"0\"></a></td>
<td class=\"me\" width=\"200\"><b>$item_title</b></td><td class=\"me\" width=\"200\" align=\"right\">
<a href=\"./addaitem.php?action=delete&ID=$item_id\">Delete</a></td></tr>
<tr valign=\"top\"><td class=\"me\" colspan=\"2\">$item_desc </td></tr><tr valign=\"bottom\">
<td class=\"me\">Categories: $categories</td></tr></table><hr align=\"left\" width=\"600\" />";

	}
}

echo $display_block;
}

function doDelete(){ 
	$query = mysql_query("DELETE FROM items WHERE ID='$_GET[ID]'") or die(mysql_error());
	$query .= mysql_query("DELETE FROM list WHERE ID='$_GET[ID]'") or die(mysql_error());
	header("Location: ./addaitem.php");
}

exit;

?>

[mrhappiness]

Originally posted by mrhappiness
select some checkboxes and in your php do

echo '<pre>';
print_r($_POST);
echo '<pre>';

please post the results of this [/B]

i'm waiting 🙂

[kender]

Array
(
[item_title] => fa
[item_desc] => fqwfg
[check] => Array
(
[0] => 5
[1] => 3
[2] => 2
)

)

[kender]

Array 

is what enters into my database
only once per submit, no matter how many checkmarks i check

[mrhappiness]

mysql_query 
("INSERT INTO list   VALUES('$next_id','".$_POST['check'][$i]."','$_POST[item
_title]')") or die(mysql_error());

try this

btw: to insert numeric values you don't need to enclose them in '

why do you store the result of the insert in $query?

[kender]

Array
(
    [item_title] => asdf
    [item_desc] => fasd
    [check] => Array
        (
            [0] => 1
            [1] => 5
            [2] => 3
            [3] => 2
        )

)

posted to my database was
15 - 1 - asdf
(id# of the item, correct - 1 of 4 checked items - and name, correct)

[kender]

Originally posted by mrhappiness
why do you store the result of the insert in $query?

didnt know i didnt have to? im still new to php

[mrhappiness]

change

$checked = count($_POST['check']);

to

echo $checked = count($_POST['check']);

what does it give?
how many entries does php find?

[kender]

with the echo this is what i got

4
Array
(
    [item_title] => qwer
    [item_desc] => qwer
    [check] => Array
        (
            [0] => 1
            [1] => 5
            [2] => 3
            [3] => 2
        )

)

the 4 was added

and the value added to the database was "1" if you were curious

[mrhappiness]

$checked = count($_POST['check']); 
for ($i = 0; $i < $checked; $i++) 
{
  $sql = 'INSERT INTO list
    VALUES('.$next_id.', '.$_POST[check][$i].", '".$_POST['item
_title']."')";
  echo $sql.'<br />';
}

do you get all insert statements?

[kender]

it says

INSERT INTO list VALUES(18, 1, 'qqqq')
INSERT INTO list VALUES(18, 5, 'qqqq')
INSERT INTO list VALUES(18, 3, 'qqqq')
INSERT INTO list VALUES(18, 2, 'qqqq')

but my database doesnt have these values

[mrhappiness]

Originally posted by kender
but my database doesnt have these values

i did'nt have any mysql_query in my code

put

mysql_query($sql) or die(mysql_error());

below

echo $sql.'<br />'; 

(inside the loop of course 🙂)