开发者

inserting checkbox values to database

I have a php form with some textbox and checkboxes which is connected to a database I want to enter all the details into the database from the form.All the textbox values are getting entered except the checkbox values.I have a single column in my table for entering the checkbox values and the column name is URLI开发者_如何学CD.I want to enter all the selected checkbox(URLID)values to that single column only ,separated by commas.I have attached the codings used.can anyone find the error and correct me? NOTE: (The URLID values in the form is brought from the previous php page.those codings are also included.need not care about it)

URLID[]:
<BR><?php
$query  = "SELECT URLID FROM webmeasurements";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
    $URLID  = $row[0];


   echo "<input type=\"checkbox\" name=\"checkbox_URLID[]\" value=\"$row[0]\" />$row[0]<br />"; 
   $checkbox_values = implode(',', $_POST['checkbox_URLID[]']); 

} 


?> 


$URLID='';
if(isset($_POST['URLID']))
{
 foreach ($_POST['URLID'] as $statename)
 {
   $URLID=implode(',',$statename)
  }
}
$q="insert into table (URLID) values ($URLID)";


You really should separate your model from the view. It's 2011, not 2004 ;o

if (isset($_POST['checkbox_URLID']))
{
    // Notice the lack of '[]' here.
    $checkbox_values = implode(',', $_POST['checkbox_URLID']); 
}

$URLIDs = array();
while($row = mysql_fetch_row($result))
{
    $URLIDs[]  = $row[0];
}

foreach ($URLIDs as $id)
{
?>
    <input type="checkbox" name="checkbox_URLID[]" value="<?php echo $id; ?>" /><?php echo $id; ?><br />
<?php
 }
?>
<input type="submit"/>
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜