i have a multiple checkbox of options1,options2,options3,options4.i want to do when i add options1,options2,options3 it will shows on the database.and when i will go to my edit page it will shows that the options1,options2And options3 are already checked.how can i do this?please anybody help me .my code is below
body portion
<body>
<form name=”name” method=”post” id=”f1″ action=”insertpage.php”>
<fieldset><legend align=”center”>Page Information</legend>
Page Title:<input type=”text” name=”pagetitle” />
<br />
page Description:<textarea name=”pagedescription”></textarea>
<br />
Keywords:<input type=”text” name=”keywords”><br />
Content:<textarea name=”content”></textarea><br />
<INPUT NAME=”options” TYPE=”CHECKBOX” value=”1″>
Option 1<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”2″>
Option 2<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”3″>
Option 3<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”4″>
Option 4<BR>
<input type=”submit” value=”Add” id=”f1″ name=”submit”>
</fieldset>
</form>
</body>
insert page
<?php
include ‘config.php’;
//require_once ‘includes/sessions.php’;
$pt=$_REQUEST[‘pagetitle’];
$md=$
$mk=$_REQUEST[‘keywords’];
$mc=$
$chk=$_REQUEST[‘options’];
$sql=”insert into `page`page_title`meta_des`meta_keywords`meta_content`checkbox1
$r=mysql_query($sql) or die (“Couldn’t select” . mysql_error());
?>
edit page
<?php
$id=$_REQUEST[‘id’];
$pt=$
$md=$_REQUEST[‘pagedescription’];
$mk=$
$mc=$_REQUEST[‘content’];
$chk=$
$sql=”update `page`page_title`meta_des`meta_keywords`meta_content`checkbox1`page_id
$r=mysql_query($sql)or die (“Couldn’t select” . mysql_error());
header(“location:page1.php?id=<?php echo $id;?>”);
?>
<?php
session_start();
//require_once ‘includes/sessions.php’;
include ‘config.php’;
$id=$_REQUEST[‘id’];
$query=”select * from `page
$result=mysql_query($query) or die (“Couldn’t select” . mysql_error());
$row=mysql_fetch_array($result);
?>
editview page
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “
<html xmlns=”
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
<title>Untitled Document</title>
</head>
<body>
<form name=”name” method=”post” id=”f1″ action=”page2.php?id=<?php echo $id;?>”>
<fieldset><legend align=”center”>Page Information</legend>
Page Title:<input type=”text” name=”pagetitle” value=”<?php echo $row[‘page_title’];?>” />
<br />
page Description:<textarea name=”pagedescription” ><?php echo $row[‘meta_des’];?></textarea>
<br />
Keywords:<input type=”text” name=”keywords” value=”<?php echo $row[‘meta_keywords’];?>”/><br />
Content:<textarea name=”content”><?php echo $row[‘meta_content’];?></textarea><br />
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”<?php echo $row[‘checkbox’];?>”>
Option 1<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”<?php echo $row[‘checkbox’];?>”>
Option 2<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”<?php echo $row[‘checkbox’];?>”>
Option 3<BR>
<INPUT NAME=”options” TYPE=”CHECKBOX” VALUE=”<?php echo $row[‘checkbox’];?>”>
Option 4<BR>
<input type=”submit” value=”Update” id=”f1″ name=”submit”>
</fieldset>
</form>
</body>