Jump to content

Adding to a field


CanMan2004

Recommended Posts

Hi all

I have a question about updating data in a field in my sql database. Basically im storing numbers in a field called "items", they are stored as comma seperated values, so for example;

22, 34, 65,

Currently I have to manually enter this, but I want to be able to add values to that field or remove values by using html tick boxes, the html code I made looks like;

[code]<form action="" method="post">
Item 1
<input type="checkbox" name="item" value="1">
<br>
Item 2
<input type="checkbox" name="item" value="2">
<br>
Item 3
<input type="checkbox" name="item" value="3">
</form>[/code]

So basically if the value;

2,4,5

appears in the database, I want to be able to add a number to that sequence or remove a number by ticking or unticking the html tick boxe. An example would be if the field contained;

1,3,4,

and I ticked the box with the value '2' then it would look like;

1,2,3,4

if I then unticked box value '3', it would edit the field to;

1,2,4

The sql code I use to insert the value currently is

[code]<?
session_start();
$sql ="UPDATE pics SET item='".$_POST['item']."' WHERE id = '".$_POST['idnum']."'";
@mysql_query($sql, $connection) or die(mysql_error());
exit;
?>[/code]

Is this possible? I think it is by using explode.

Any help or pointers would be very helpful.

Thanks in advance

Dave
Link to comment
Share on other sites

My guess on this one would be an array

[code]
$max = 5;
For ($i=1; $i <= $max; $i++) {
if ($item[$i] == '1') {
echo "<input type='checkbox' name='item' value='".$item[$i]."' checked>".$i;
} else {
echo "<input type='checkbox' name='item' value='".$item[$i]."'>".$i;
}
}
[/code]

$max being the max number of Options this sample I am using 5 as the max

$item[] array would hold the value for the field example 0,1,1,1,0
in this array it would not create the array as you have stated 1,2,4 this style would create that string as 1,1,0,1,0

1 meaning checked
0 meaning unchecked

and within your loop you would see whether its checked or unchecked and very record entered in the DB would hold the same 5 values in this field but it would be 0 or 1 and not the number to display checked.


Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.